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

SQL30149, 30149, error, 30086, 30016, 30274 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.