2514404 - Error SQL30149 reported on SM21 during data loads - SAP ASE for BS

• 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.

• 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 

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