Activation error - InternalError: dberror(PreparedStatement.execute)

[Krishna1]

Hello Experts,

Did u guys see error below like this?....Do you know what it means?

E - Exception raised from  InternalError: dberror(PreparedStatement.execute): 2048 - column store error: fail to create scenario:  [34011] Inconsistent calculation model;CalculationNode (5_111) -> inputs:Number of inputs has to be between 2 and 2 at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:2082

Thanks,

Krishna

[Former Member · Accepted solution]

This error is telling you that the calculation in question has too many input key figures for it to successfully parse.

The calculation is related to node ID 5_111. There are ways to decipher which key figure this relates to by looking through the generated node tables in hana studio, but only if you have an on premises release.

In your activation log do you have other E (error) messages? Perhaps around the middle of the logs? I believe that related error message gives you the key figure ID.

Unfortunately the solution is to break up your desired calculation into two or more calcs.

Example:

If original was:

KF1 = A * B * C

then you could break it up like:

HKF1 = A * B

KF1 = HKF1 * C

[Krishna1 · Accepted solution]

JJ,

Issue is not just with no of input KF.

Here is the issue - a KF more than 2 inputs from the same planning level when some are stored and others are calculated.

Original cal

KF 1 = KF2@PL1 (stored) + KF1 @PL1 (Stored) - KF3@PL1 (Stored) + KF4@PL3(calc)

Revise cal  where KF2@PL1 (stored) became KF2@PL1 (calc)...

In one cal, for same planning stored and calc not allowed...

How it got solved

HKF = KF2@PL1 (calc) + KF1 @PL1 (Stored) - KF3@PL1 (Stored)

KF1 = HKF + KF4@PL3(calc)

After this change, Planning area got activated....