topic ERROR: Internal DA software error detected in SAS Programming

ERROR: Internal DA software error detected

vemulakk1 — Wed, 26 Sep 2018 06:14:36 GMT

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.

Re: ERROR: Internal DA software error detected

ChrisNZ — Wed, 26 Sep 2018 06:24:56 GMT

1. Are you using SPDS?

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

Re: ERROR: Internal DA software error detected

vemulakk1 — Mon, 01 Oct 2018 05:02:18 GMT

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

2. take a backup and delete and recreate.

Any suggestions.

Thanks in advance.

Re: ERROR: Internal DA software error detected

ChrisNZ — Mon, 01 Oct 2018 21:01:22 GMT

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.

Re: ERROR: Internal DA software error detected

vemulakk1 — Wed, 03 Oct 2018 11:13:29 GMT

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.

Re: ERROR: Internal DA software error detected

ChrisNZ — Wed, 03 Oct 2018 21:30:35 GMT

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.