Activating 0CUSTOMER

[Former Member]

Hi all,

New to BW. I am working with Data extraction. Transfered 0CUSTOMER from R/3 and installed in Business content. When i try to activate the infoobject using /nrsd1, I get the following error:

1) The Master Data Table /BI0/PCUSTOMER must be converted incompatibly with an activation of characteristic 0CUSTOMER (changes to the key in the table). Table /BI0/PCUSTOMER contains data. Parts of this data were lost in the conversion.

2) The SID Table /BI0/SCUSTOMER must be converted incompatibly with an activation of characteristic 0CUSTOMER (changes to the key in the table). Table /BI0/SCUSTOMER contains data. Parts of this data were lost in the conversion.

Please Help

Thanks,

Prabhu

[former_member188975]

Hi Prabhu,

Did you try to change 0CUSTOMER after loading data into it...like changing the length ? The system will not let you make such changes if there is data. If you really need to chnage 0CUSTOMER, delete the master data first and then change. Again, if the InfoObject is present in a cube or ODS and the trnsaction data has been loaded, you cannot delete InfoObject data that is being used in the cube/ODS...you will need to remove entries from here first.

Hope this helps...

[Former Member]

Hi Bhanu Gupta,

I didnt load data stil. I just installed in B.C and then tried to activate it using /nrsd1 so that i can load master data. Is this procedure wrong. The infoobject is not used anywhere.

Thanks,

[Former Member]

Prabhu,

Before you installed the 0CUSTOMER InfoObject, it was already installed by someone else and data was loaded.

I do not know why you installed it again when an active version was already existing. Usually when an active version exists in ths system, you need to compare that to the business content version to see if any changes were made to that and should be very careful when installing again, otherwise valuable changes to the object will be lost.

Now, the solution you have to make that work properly is to delete all the master data and activate it again.

If you still have problems, you need to delete the data from the cubes where this Infoobject is used, then continue with your activation.

Good Luck

Gova

[Former Member]

I was told that when I try to replicate data sources in Source Systems, if there is -ve sign then it means it doesnot have any transfer rules associated to it and hence i have to activate it again. There was -ve sign beside 0CUSTOMER in the Source systems and that made me install it in business content and then try to active using /nrsd1.

IF I am wrong please give the exact procdure. Appreciate your help.

Thanks,

[former_member188975]

ok...so you were in RSA1 > Source Systems and you saw -ve against 0CUSTOMER..this could be either 0CUSTOMER_ATTR or 0CUSTOMER_TEXT (or HIER). Generally speaking, this means that the data source has not been assigned.

So in RSA1, click on InfoSources and search for 0CUSTOMER > Right click and select Assign DataSource. First you need to fill in your R/3 source system name and then select the data source. Then what you need to activate is the "transfer rules"; not the InfoObject itself.

Post back if you still have a problem.