SAP Knowledge Base Article - Preview

3150099 - DUMP in RSPO1043 program and ASE Error 7114 - SAP ASE for Business Suite

Symptom

  • ST22 short dumps of type DBSQL_SQL_ERROR are received on SAP ERP systems running on SAP ASE database.
  • The dump occurs when executing the program: RSPO1043  related to the standard Job of the SAP_SPOOL_CONSISTENCY_CHECK system.
  • The error is: SQL30102 - function sequence error while accessing table: TST01
  • The corresponding error in the SAP ASE errorlog is  Error 7114:  Page xxxxx is not a valid text page, which belongs to object ID 255, database ID -339068608.
  • The failing query is: DELETE FROM "TST03" WHERE "DCLIENT" = ? AND "DNAME" = ? AND "DPART" = ? AND "DROWNO" = ? /* R3:RTAB:0 T:TST03 M:300 */
  • The ASE Error 7114 is accompanied by a stacktrace referencing the functions:

               text_handler
               get_txtpage
               deletetext
               LeDeleteOp::_LeOpNext
               LeEmitNoSndOp::_LeOpNext
               LePlanNext

  • "dbcc checktable" on TST03 also fails with Error 7114
  • Creation of a copy table of TST03 via SELECT INTO also fails with Error 7114
  • "dbcc checktable" on TST01 is clean


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (all versions) 



Product

SAP ERP 6.0

Keywords

7114, "Error 7114",  text, TST03, SQL30102, "function sequence error", RSPO1043, SAP_SPOOL_CONSISTENCY_CHECK, dumps, TST01 , KBA , BC-DB-SYB , Business Suite 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.