IP Planning Layout not being rendered with ATPM in CRM UI

[Former Member]

Hello Experts,

We've created a very simple Model wherein we've Input enabled Query on top of the Aggregation level which is on top of a Planning DSO.

This is getting rendered on CRM UI.

But when we've the following architecture:

Query->Aggregation Level->MultiProvider->Planning DSO

The Planning layout is not being rendered on CRM UI and dumps at the following piece of code:

Information on where terminated

    The termination occurred in ABAP program "CL_RSDRC_TREX_QUERY_LAYER=====CP",

     in "_GET_PARTPROVS_WITH_TREX_PART". The main program

    was "SAPMSSY1".

  11   LOOP AT l_ts_partprov ASSIGNING <l_partprov>.

   12     IF i_r_ipro->n_s_dta-cubetype = rsd_c_cubetype-hcpr

   13       AND i_r_ipro->is_execution_on_part_possible( ) = rs_c_false

   14       AND i_r_ipro->is_part_in_columnview( i_partprov = <l_partprov>-partprov ) = rs_c_true.

   15       IF rs_c_false = cl_rsdrc_trex_query_layer=>_has_partprov_trex_part(

   16                                     i_partprov   = i_r_ipro->n_infoprov

   17                                     i_th_sfc     = i_th_sfc

   18                                     i_actualdata = <l_partprov>-actualdata

   19                                     i_cubetype   = i_r_ipro->n_s_dta-cubetype ).

   20

   21         DELETE l_ts_partprov.

   22       ENDIF.

   23     ELSE.

   24       READ TABLE i_r_ipro->n_ts_part ASSIGNING <l_s_part>

   25       WITH KEY partprov = <l_partprov>-partprov.

   26

>>>>>       _map_sfc_to_part(

   28         EXPORTING

   29           i_infoprov   = <l_s_part>-infoprov

   30           i_partprov   = <l_partprov>-partprov

   31           i_th_sfc     = i_th_sfc

   32         IMPORTING

   33           e_th_sfc     = l_th_sfc ).

It would be great, if I can get some expert advice on this.

Thanks & regards,

Jomy

[Former Member]

Hi ,

Did teh issue resolved.

This normalyy happends due metadaat mismatch .

You need to clear teh share memory first in BW and thne in CRM .

Then try to login again and see if the issues is resolved.

Regards,
Amol

[Former Member]

Just to update: We've implemented the note: 2004622, after which we are not getting this dump.

But it is still not rendering the layout and giving message that Invalid Query.

After some debugging, we found that it is not recognizing the InfoProvider under that MultiProvider.

Would be glad to know, if anyone knows how can a planning layout be rendered based on ATPM when the aggregation level is on top of MultiProvider instead of Planning DSO directly.

Thanks,

Jomy

[gregor_dieckmann]

Hi Jomy,

to use an aggregation level on top a multiprovider is standard. Can you be more specific about the message you get?

Maybe the meta data of the aggregation level and/or the multiprovider are not ok; you can regenerate the meta data using report RSR_MULTIPROV_CHECK.

Regards,

Gregor

[Former Member]

Hello Gregor,

On the launch of planning layout it throws an error message:

Planning is not possible RSCRM_IMP_CORE008.

When I debugged, i got to a point wherein

particular Real Time Planning DSO is

not getting retrieved under the MultiProivder in below class.

Class: CL_RSCRM_IMP_ACTIONS_SERVICE, Method: GET_INFOPROV is not

returning the real time Info-Provider Name(i.e. Planning DSO)

underlyingthe Multiprovider.

I've also tried to run the report mentioned by you for the Multiprovider but issue still exists.

Let me know, if you have any pointers on this topic.

Thanks,

Jomy

[gregor_dieckmann]

Hi Jomy,

have you tried to execute the query in transaction RSRT? If it works there then the problem comes from the CRM layer in BW.

The CRM class you mentioned is using the shared object memory with name CL_RSCRM_IMP_SHM_AREA to get information about the InfoProvider from a technical query id; maybe this object is invalid. You can use transaction SHMM to delete this object; I hope this object will be rebuild automatically (I am no CRM expert).

Regards,

Gregor

[Former Member]

Hi Gregor,

Yes the query works fine in RSRT.

I also tried to delete this object using SHMA Tcode but the issue still there.

Looking for some more options.

Thanks,

Jomy

[gregor_dieckmann]

Hi Jomy,

please open a problem ticket on the correct CRM component.

Regards,

Gregor

[Former Member]

Hi Gregor,

Yes, created one.

Thanks,

Jomy

[Ramneek]

Hello Jomy,

Could you please also try to execute the query in the transaction RSRT_BICS?

Thank you,

Ramneek

[Former Member]

Hi Ramneek,

I'm getting data using RSRT_BICS , too.

Thanks,

Jomy

[Ramneek]

Hello Jomy,

Could you please also try by restricting the Planning DSO in the query?

Thank you,

Ramneek