Symptom
You are running SAP BW applications on SAP ASE database.
- The BW system encounters disconnect errors with ST22 short dumps referencing SQL30046 errors:
Error Text of the Database: "[ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while writing to socket. Socket returned error code 32. Check the server to determine the status of any open transactions."
Run-time error "DBIF_REPO_SQL_ERROR" occurred
- The disconnect errors correspond to timeslice errors in the ASE errorlog, accompanied by a stacktrace referencing the functions: prepprev, apl__startscan, xsc__syslogs_setscan.
- The query referenced in the stacktrace is -- SQL Text: INSERT INTO "RSTSODSREQUEST" VALUES( ? , ? , ? ) /* R3:RTAB:0 T:RSTSODSREQUEST M:200 */
- The 'lasterror' is always = 2601, as seen in below sample log extracts:
timeslice -1001, current process infected at 0xdb00be (prepprev+0x1fe)
timeslice error: spid 123 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 1000 ticks (100000 milliseconds). It has been marked for termination.
...
SQL Text: INSERT INTO "RSTSODSREQUEST" VALUES( ? , ? , ? ) /* R3:RTAB:0 T:RSTSODSREQUEST M:200 */
lasterror = 2601 preverror = 0 transtate = 0
curcmd = 195 program = R3D011 01 comm rd ODBC
extended error information: hostname: bwp_host1 login: SAPSR3
...
prepprev
apl__startscan
startptnscan
xsc__syslogs_setscan
xls_startscan
rec_undo_session
abortcmd
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
Keywords
RSTSODSREQUEST, timeslice, SQL30046, BW, prepprev , KBA , BW-SYS-DB-SYB , BW 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.