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