Error : SAP DBTech JDBC: [2048]: column store error: search table error: [34051] Error during plan execution.

[Former Member]

Hello All,

While trying to check the data preview on a calculation view, we are facing the error message "“Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [34051] Error during plan execution”. This calculation view is part of Smart Business cockpit . We are now in the latest SP7 Version 72 (1.00.72)

Need your help guys ..!

[Former Member]

Pradeep,

As suggested by Krishna, can you give more information on error by looking into your indexserver file under diagnosis tab of administration console.That will help in understanding error.

Sometimes, if your have done changes in your model, it doesn't get reflected in your model because model is not activated properly. You can reactivate it & check.

In case it doesn't works please post detailed error message to figure it out.

Regards,

Kulwinder

[Former Member]

Hello Kulwinder, Krishna,

Thanks for your inputs !

Below is the detailed message from the trace file.

-----------------------------------------------------------------------------------------------------------------------------------------------------

ApplicationSource=csns.modeler.datapreview.providers.ResultSetDelegationDataProvider.<init>(ResultSetDelegationDataProvider.java:109);csns.modeler.actions.DataPreviewDelegationAction.getDataProvider(DataPreviewDelegationAction.java:256);csns.modeler.actions.DataPreviewDelegationAction.run(DataPreviewDelegationAction.java:230);csns.modeler.actions.DataPreviewDelegationAction.run(DataPreviewDelegationAction.java:126);csns.modeler.command.handlers.DataPreviewHandler.execute(DataPreviewHandler.java:52);org.eclipse.core.commands

[7131]{300980}[79/-1] 2014-03-19 13:12:23.104229 e ceOptimizer      ceOptUtils.cpp(01056) : OptimizerUtils::resolveMappingsInQueryEntries: predicate QueryEntry is not valid (value2)

ApplicationSource=getJDBCConnection(ConnectionUtil.java:127);getJDBCConnection(ConnectionUtil.java:94);<init>(ResultSetDelegationDataProvider.java:101);getDataProvider(DataPreviewDelegationAction.java:244);run(DataPreviewDelegationAction.java:205);run(DataPreviewDelegationAction.java:99);execute(DataPreviewHandler.java:51);execute(E4HandlerProxy.java:76);execute(MethodRequestor.java:56);invokeUsingClass(InjectorImpl.java:231);invoke(InjectorImpl.java:212);invoke(ContextInjectionFactory.java:131);executeHandler(HandlerServic

[7145]{301066}[82/-1] 2014-03-19 13:53:09.748030 e cePlanExec       cePlanExecutor.cpp(05529) : Failed to build plan for node 'Join_LEADLDBSMOverviewBSMInfoOverviewBankStatementMonitorBalStatus' op(JOIN_OP), input node 'Proc_StatusBSMOverviewBSMInfoOverviewBankStatementMonitorBalStatus' op(PROJECTION_OP)

--------------------------------------------------------------------------------------------------------------------------------------------------

As this is delivered by SAP, We have not made any changes. However I tried to redeploy and activate which is of no use.

Regards,

Pradeep.

[former_member182302]

Hi Pradeep,

Well for me the error seems like this:

1) You have a Projection which is serving as input to your Join in the model.

2) There seems to be mismatch in the mappings between this projection and join node.

PS: Those 2 are my guesses based on the trace message you shared here.

As you were mentioning content is delivered by SAP, I think this situation is a suitable candidate for OSS message.

Regards,

Krishna Tangudu

[Former Member]

Pradeep,

Agreed with Krishna, seems to be some mismatch from your projection to Join node.

Please raise support message in case it is delivered by SAP.

Kulwinder

[former_member182302]

Hi Pradeep,

Can you have a look on the index server trace file if it has any additional information on what is missing?

As per this note: 1880274, It showed these 2 errors:

A query against a specific column view with attribute mappings in a projection node failed, due to wrong attribute names in the calculation plan.

The indexserver trace file contains the following message:

"SAP DBTech JDBC: [2048]: column store error: search table error: [34051] Error during plan execution;Failed to find source column <column_name> in itab."

Queries against calculation views may abort with the error" Failed to find column in input itab"

The indexserver trace file contains the following message:

"SAP DBTech JDBC: [2048]: column store error: search table error: [34051] Error during plan execution;Failed to find colum <column_name> in input itab"

May be we can have a look on the index server trace file and see what it suggests, And it most likely looks like a case for OSS message

Regards,

Krishna Tangudu

[former_member183734]

Hi Pradeep,

We are facing the same issue with Smart Data content (KPI Cockpits) . Let us know if you could solve this.

regards,
Deepthi