Skip to Content

ASE odbc Driver Adaptive server Enterprise Error

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 02, 2017 at 02:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 05, 2017 at 01:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded