Question Re: CMP process error in Technology Q&A

CMP process error

Former Member — Fri, 20 Mar 2009 09:57:52 GMT

Hello all,

A process chain failed while loading data to infosource LEI_CREDIT through a customized extractor.

The error mentioned was "CMP problem occurred in characteristic [0CUST_COMPC] Customer for InfoProvider 0FIAR_C02.

The details are:

Diagnosis

Characteristic [0CUST_COMPC]Customer of the MultiProvider is not

supplied with data from InfoProvider 0FIAR_C02; this means it is not

identified. However, [0CUST_COMPC]Customer is compounded to 0COMP_CODE

and 0COMP_CODE is identified with characteristic 0COMP_CODE for

InfoProvider 0FIAR_C02.

In this case, there is a compounding or CMP problem with

[0CUST_COMPC]Customer in the MultiProvider for InfoProvider 0FIAR_C02.

Processing characteristics with CMP problems in the data manager is very

complicated and can have a negative impact on performance. The data

manager cannot use SIDs for these characteristics (at least not in the

corresponding InfoProvider) because the initial SID = 0 for

[0CUST_COMPC]Customer is not the same as the initial compound key for

0COMP_CODE [0CUST_COMPC]Customer (that is, when actual values are posted

in 0FIAR_C02 for 0COMP_CODE).

For this reason, hierarchies for [0CUST_COMPC]Customer must often be

read at leaf level; also, it is not possible to use hierarchy aggregates

for [0CUST_COMPC]Customer or for the remaining InfoProviders.

When do we encounter such errors and whats the root cause for this. The process chain never gave this error in the past.

Please help.

Regards,

K P

Re: CMP process error

Former Member — Fri, 20 Mar 2009 10:20:20 GMT

Seems like a compounding infoobject was missed or thevalue for the compounding infoobject value us blank...

Re: CMP process error

Former Member — Fri, 20 Mar 2009 10:24:59 GMT

Hi,

We had this problem while query execution. No idea as such during data load.

Chk this note :Note 1045683 - Compounding problem in MultiProvider (CMP problem).

Regards

Re: CMP process error

Former Member — Fri, 20 Mar 2009 11:06:56 GMT

Hello,

The compounding Chs. is 0COMP_CODE, which is a key field in the multiprovider as well as underlying Infocubes. So its not possible to miss it or keep it blank.

What might be the other reason??

This error never occurred for this proces chain .

Thanks,

Regards,

Re: CMP process error

Former Member — Fri, 20 Mar 2009 11:44:07 GMT

Was any change applied to any of these infoobjects before this error started coming up ?

Re: CMP process error

Former Member — Fri, 20 Mar 2009 12:04:36 GMT

Hello,

There was no change done to any of the objects.

Today the process chain got executed successfully.

What might be the issue?

Regards,

Re: CMP process error

virenp_devi — Fri, 20 Mar 2009 14:06:14 GMT

Hi,

I know this issue. This is kind of wierd in case of BI 7.0 We never used to face this till package 8. SAP is just trying to highlight to us that as 0COMP_CODE is compounded with 0CUST_COMPC and as 0com_code is supplied with data from one infoprovider and the compounded char is not from same provider, you will have blank coming for 0CUST_COMPC object from that provider.

This happens occasionally. We tried to find Snotes but no success. This gets resolved after few days. I suggest you to raise OSS as this seems like SAP program error.

In our case we used get error in development environment but was fine in production.

Hope this helps.

Regards.

Viren