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

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
14.12.2017 12:23:35

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:

 [6005]{734415}[693/-1] 2017-12-14 11:33:45.285536 i TraceContext TraceContext.cpp(00960) : UserName=xxx, ApplicationUserName=xxx, ApplicationName=xxx, ApplicationSource=/xxx.xsjs?, ClientIp=xxx, StatementHash=7375f729badb21e0edca06a242a3a689

[6005]{734415}[693/-1] 2017-12-14 11:33:45.285511 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

[6005]{734415}[693/-1] 2017-12-14 11:33:45.285554 e Executor PlanExecutor.cpp(00872) : -- returns for planxxx
[6005]{734415}[693/-1] 2017-12-14 11:33:45.285563 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)
[6005]{734415}[693/-1] 2017-12-14 11:33:45.285576 e Executor PlanExecutor.cpp(00872) : pop1, 11:33:12.258 +33.026, cpu 20327864800, xxx, RowPlanOperator, rc 2048, search table error: [2629] executor: plan terminated internally after being inactive for too long
[6005]{734415}[693/-1] 2017-12-14 11:33:45.285593 e Executor PlanExecutor.cpp(00872) : Total: 11:33:12.234 to 11:33:45.285 +33.051
[6005]{734415}[693/-1] 2017-12-14 11:33:45.285598 e Executor PlanExecutor.cpp(00872) : sizes a 0 c 0
[6005]{734415}[693/-1] 2017-12-14 11:33:45.285601 e Executor PlanExecutor.cpp(00872) : -- end executor returns
[6005]{734415}[693/-1] 2017-12-14 11:33:45.285603 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

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.