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 Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.