SAP Knowledge Base Article - Preview

2514404 - Error SQL30149 reported on SM21 during data loads

Symptom

  • SM21 is reporting SQL30149 errors when Process Chains are running:

dd.mm.yyyy 23:36:41 ZAAFHVMSPP20_MBP_20 BTC 027 100 ALEREMOTE @SR\Qinformation@ BY0 > [ASE Error SQL30149:HYT00][SAP][ASE ODBC Driver]The command
dd.mm.yyyy 23:36:41 ZAAFHVMSPP20_MBP_20 BTC 027 100 ALEREMOTE @SR\Qinformation@ BY0 > has timed out.
dd.mm.yyyy 23:36:45 ZAAFHVMSPP20_MBP_20 BTC 027 100 ALEREMOTE @5C\Qvery high priority@ AB0 Runtime error "DBSQL_SQL_ERROR" occurred.
dd.mm.yyyy 23:36:46 ZAAFHVMSPP20_MBP_20 BTC 027 100 ALEREMOTE @SR\Qinformation@ AB1 > Short dump "170730 233645 ZAAFHVMSPP20_MBP_20 ALEREMOTE" created.
dd.mm.yyyy 23:36:46 ZAAFHVMSPP20_MBP_20 BTC 027 100 ALEREMOTE @5C\Qvery high priority@ D01 Transaction Canceled 00 671 ( DBSQL_SQL_ERROR 20170730233645ZAAFHVMSPP20_MBP_20 ALEREMOTE 100 )

  • From the related developper work process you can see such similar messages:

C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 5693]
C (30149) [HYT00] [SAP][ASE ODBC Driver]The command has timed out.
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 5693]
C (30086) [HY008] [SAP][ASE ODBC Driver]Operation Canceled.
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 5693]
C (30016) [08S01] [SAP][ASE ODBC Driver]Bad TDS response stream received from server. MSG token ex
C pected.
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 5693]
C (30274) [08S01] [SAP][ASE ODBC Driver]Error setting up connection
C Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=xxxxx;port=nnnn;uid=SAPSR3;db=XXX;pwd=xxxxxxxxxxx;Tex
C
B ***LOG BY4=> sql error 30149 performing UPD on table RSDCOBPROTSTMPL [dbdbslst 4638]
B ***LOG BY0=> [ASE Error SQL30149:HYT00][SAP][ASE ODBC Driver]The command has timed out. [dbdbslst 4638]
B dumping DbDbslStatement ...

  • ST22 dump is generated but the impacted program/class won't be always the same.
  • SM37 process chain log output will end with messages:

Internal session terminated with a runtime error DBSQL_SQL_ERROR (see ST22) 00 671 A
Job cancelled 00 518 A

  • Last version of DBSL and ASE/ODBC is installed.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem

About this page

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

Search for additional results

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