Hi All,
I am getting below ERROR while read/access a table.
ERROR: PROC SQL runtime error for operation=sqxsrc.
ERROR: An error has occurred.
ERROR: Internal DA software error detected.
Please help me.
Thanks in Advance.
1. Are you using SPDS?
2. Have you searched the web? This error is explained. Try and report please.
Hi,
I am using SPDS.
Please see this link http://support.sas.com/kb/51/810.html
As per the information in the above link it says : Not able to access/read the table as it might be locked or concurrent updates are taking place from another client.
But table is not being used at all.I am planning to do :
1. repair dataset
or
2. take a backup and delete and recreate.
Any suggestions.
Thanks in advance.
1. Do you have access to the SPDS logs? Nothing there?
2. I presume your version is older than what the link describes and is patched?
3. Is it only this one table that yields that message?
SPDS is unhappy about something and that prevents it giving you read access to that table.
Hi Chris,
I do not have access to SPDS logs and may be the link describes the older version. This is the only table that yields message.
I reckon your next stop is the SPDS admins.
That's probably the first thing SAS tech support will ask you to look at too, though you can always ask in case they have new internal usage notes about this issue.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.