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