Skip to Content
0

ASE odbc Driver Adaptive server Enterprise Error

Sep 16, 2017 at 11:12 AM

242

avatar image

Need Small help.
I am Developer. I am posting some data in SAP. Like routine Task, Even some time while login also,. I am getting the Error.

Short Text SQL Error 590 when accessing table "ADRP" wHAT HAPPEND?

Error text of the database: [ASE ERROR SQL90] [SAP] [ASE ODBC DRIVER] [ADAPTIVE SERVER ENTERPRISE] DYNAMIC SQL ERROR - PREPARED STATEEMNT 'CO' DOES NOT EXIST.

dumpxml.xml

Can any body tell me the problem.

error1.png (17.7 kB)
eror2.png (97.5 kB)
dumpxml.xml (187.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dawn Kim
Oct 02, 2017 at 02:02 PM
0

Hi,

This sounds like an ASE issue dealing with a temp table. See KBA http://service.sap.com/sap/support/notes/2368989.

The workaround is to is to add dynamicprepare=false in the odbc connection string.

Thanks,
Dawn Kim

Share
10 |10000 characters needed characters left characters exceeded
Maria Victoria NORMAND
Oct 05, 2017 at 01:47 PM
0

Hi Bashkar,
This ST22 dump used to appear with old ASE/ODBC versions and DBSL as well. A workaround was to restart the ASE.
The suggestion is to consider to upgrade your ASE/DBCLIENT to newer ASE 15.7 release. ASE 15.7 SP30 is very old and the last SP is SP139, and minimum recommended is SP137. You may refer to SAP Note 2073343 - SYB: Release information for SAP Sybase ASE 15.7 SP13x

Also for your reference: SAP Note 2065899 - SYB: SQL error 590 after restart of SAP ASE

Kind regards,
Victoria.

Share
10 |10000 characters needed characters left characters exceeded