SAP Knowledge Base Article - Preview

2934175 - Error 2780 and SQL 30037 Invalid value - SAP ASE for Business Suite

Symptom

  • SAP work process terminates on systems running on SAP ASE database
  • SM21 and the corresponding work process developer trace report the error:

    ERROR: -1 in function ExeNormalModify (execute) [line 33189]C (30037) [HY000] [SAP][ASE ODBC Driver]Invalid value.

    Database error text: "SQL message: [ASE Error SQL30062:HY000][SAP][ASE ODBC Driver]Invalid character conversion.
    [ASE Error SQL30002:1ZZ00][SAP][ASE ODBC Driver]Internal Error"



  • Corresponding error in the ASE errorlog is:

Error: 2780, Severity: 20, State: 1 maxlen (2) is less than length (98)

  • Error 2780 is accompanied by a stacktrace referencing the functions:

exc__raise
exc_raise
mk_constant
bconst
tdsrecv_params
tdsrecv__paramfmt_params
tdsrecv__xoltp_setup
tdsrecv__dynexec_xoltp
tdsrecv__dynexec
tdsrecv_dynamic

  • dbcc checktable (executed via isql directly on the database) on the referenced table is clean - it does not report any errors


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise SDK 16.0

Keywords

30037, SQL 30037, "Invalid value", 2780, SQL30062, SQL30002, ST22, "short dumps" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.