SAP Knowledge Base Article - Preview

2248390 - SQL30046 disconnect errors due to timeslice errors in prepprev - RSTSODSREQUEST on SAP BW on ASE systems

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

SAP enhancement package 1 for SAP NetWeaver 7.0

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.