Symptom
You find lots of short dumps in a short period of time in transaction ST22 such as:
Installation Errors
DBSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB
DD.MM.YYYY HH:MM:SS
SQL error "SQL code: 2048" occurred while accessing table "<table_name>"
Database error text: "SQL message: column store error: search table error:
[2629] executor: plan terminated internally after being inactive for too
long;executor: plan terminated internally after being inactive for too long"
The error can also be found in the indexserver trace:
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 i TraceContext TraceContext.cpp(00960) : UserName=xxx, ApplicationUserName=xxx, ApplicationName=xxx, ApplicationSource=/xxx.xsjs?, ClientIp=xxx, StatementHash=7375f729badb21e0edca06a242a3a689
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : plan xxxxxx failed with rc 2048; column store errorsearch table error: [2629] executor: plan terminated internally after being inactive for too long
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : -- returns for planxxx
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : search table error: [2629] executor: plan terminated internally after being inactive for too long(2048), plan: 1/2 pops: RowPlanOperator pop2(in a, out bc)
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : pop1, 00:00:00.000 +33.026, cpu 20327864800, xxx, RowPlanOperator, rc 2048, search table error: [2629] executor: plan terminated internally after being inactive for too long
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : Total: 00:00:00.000 to 00:00:00.001 +33.051
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : sizes a 0 c 0
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : -- end executor returns
[0000]{000000}}[000/0000000] 0000-00-00 00:00:00.000000 e Executor PlanExecutor.cpp(00872) : pop1 (rc 2048, search table error: [2629] executor: plan terminated internally after being inactive for too long)
Read more...
Keywords
ST22, DBSQL_SQL_ERROR, SQL code: 2048, Column store error, rc 2048 , KBA , HAN-DB , SAP HANA Database , 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.