BookmarkSubscribeRSS Feed
vemulakk1
Calcite | Level 5

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.

5 REPLIES 5
ChrisNZ
Tourmaline | Level 20

1. Are you using SPDS?

2. Have you searched the web? This error is explained. Try and report please.

vemulakk1
Calcite | Level 5

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.

ChrisNZ
Tourmaline | Level 20

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.

vemulakk1
Calcite | Level 5

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.

ChrisNZ
Tourmaline | Level 20

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2675 views
  • 0 likes
  • 2 in conversation