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.
SAP Knowledge Base Article - Preview