SAP Knowledge Base Article - Preview

2584706 - Many dumps found in ST22 with errors "SQL code: 204" "executor: plan terminated internally after being inactive for too long"

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.