Error SAP BW Advanced DSO planning when run Querys

[former_member605329]

Dear Gurus,

We have a really important issue that we need to resolve early. We are starting to create planning ADSOs for SAP BPC inside SAP BW on HANA.

We have no problems to create all the InfoObjects and the followings ADSO.

One of them (ZPPX_A01P), is used for planning (part of the SAP BPC data model). When we created this ADSO and select the "Planning specific-properties" in BW to allow the plan...

... after that, we created the aggregation level and define querys to plan. All its OK, but if we run the Query to plan in Analysis for Office, the system doesn't run it and it shows the following error....

BICS_PROV_GET_INITIAL_STATE with the exception INVALID_DATA_PROVIDER_HANDLE

...If we run the Query in SAP BW the system shows the following error..

capture3.jpg

However, if we don't select in SAP BW the "Planning specific-properties" option in order to not allowed the plan...

The querys runs well and the system doesn't show any error.

Have u any idea to solve the problem??

In order to shows more information about the issue... we are looking for inside the system and it shows that the "Active generated load program not found"... but we don't know what we need to do.

The version of SAP BW is:

SAP_BW 750 0009 7.5 Service patch 9

Any HELP is Welcome.

Thanks for all,

Regards.

[gregor_dieckmann · Accepted solution]

Hi,

from the dump one can see that there are problems with the BW time characteristics. BW planning replicates information about BW time characteristics to HANA tables and this seems to fail in your system. This might happen because of inconsistent fiscal year variants (periods not maintained completely). The dump is hard to read (but I can see SID = 24 for 0FISCVARNT, so check table /BI0/SFISCVARNT to find the corresponding characteristics value).

Or try to run report RSR_TIME_RELATION_HDB with option 'Time characteristics (PERIV)', this may also dump because of the problem but you may get more detailed information about the problem. You can also use transaction GVAR (fiscal year variants maintenance) to check whether the fiscal year variants are ok).

Regards,

Gregor