PE error 2.048: Column store error: alterPlanningSession

[former_member381836]

Hi, experts,

I'm getting the following error when executing a Fox Planning Function:

This message is from Analysis for Office, but I get the same error if I try to execute it via TCODE RSPLAN.

If I try to execute it with trace, then I get no error when trying to use it.

I read that it could be that direct planning was being done on an ADSO, but I checked my code and that is not the case, my 0INFOPROV values are those of an InfoCube in the recording sentences of the code.

The code handles a large amount of information, but I do not know if that could be, given that, when executed with trace, it runs without any problem.

The aggregation level which contains my planninf function is on top of a HCPR, which, in turn, has an ADSO and an InfoCube.

Our BW version is 7.5

I would appreciate anyhelp or any pointers you may give me.

Thank you so much!

[former_member381836]

Hi everyone, we already solved this. Turns out we had an Internal Table in which one of the fields' name was the same as one of our local variables, so apparently that is not allowed. We solved it simply by changing the names of the fields of the internal table, in case anyone ever runs into the same mistake.

[RafkeMagic]

As Gregor said, this means your planning function does not run (well) on HANA, but has no issue over ABAP. Depending on your SP level, the following program may be very usefull: RSPLS_PLANNING_ON_HDB_ANALYSIS.

When we were back on BW7.5 SP05 this was not usefull at all, but after upgrading to SP11 it has proven to be very valuable in finding out why certain planning functions are not running (well) over HANA. However, we find occasional bugs when running planning functions over HANA... so if you don't find anything "strange" in the output of the program ànd after checking note 1694205 (as suggested by Gregor), don't hesitate to open an incident at SAP.

[former_member596358]

Hi Nidia,

best to check the error codes directly on HANA with eclipse/Studio.

HANA Modeling perspective: Right click on Systems->Config and monitoring->Open admin. there check tab diagnosis files. And look for the latest errors. Probably in indexserver_alert_...

Cheers Jonas

[gregor_dieckmann]

Hi,

'PE error 2048' does not contain much information, please check note 1694205 for more information how to collect information about PAK error messages.

Remark:

To run a function in RSPLAN in trace mode means to run this in ABAP and not in PAK.

Regards,

Gregor