Issues transporting changes to an infoobject

[Former Member]

Hi Experts

I'm working with PM data model.. Model is developed and deployed to production.

A request was made to change the description of 1 attribute of object Equipment

This were the changes made in developement, that were sucessfull

ZABC - description ABC -> changed description to DDD, activated object sucessfuly

0EQUIPMENT, tab attributes -> changed the description of attribute ZABC from descriprion ABC to descriprition DDD. Activated successfuly

Runned my master data process chain, and my transactional data process chain. All went well

I've transported my transport order that included this changes into quality and I got the following error

Text Table /BI0/TEQUIPMENT contains data: Characteristic 0EQUIPMENT cannot be activated

If i managed to activate obejct in dev with no problem, why do i have this error with the activation of that object?

Can anyone provide any help

Many thanks

Joana

[esjewett · Accepted solution]

Since this is a question about BW, it belongs in the BW space (called SAP Netweaver Business Warehouse) and not the Data Warehousing space. I've moved the thread, but please use the SAP Netweaver Business Warehouse space for these types of questions in the future.

Regards,

Ethan

(moderator)

[Former Member · Accepted solution]

Hi All

What would be the issues of deleting MD table (T) using SE14.. I have read a few threads that point out to issues with SID duplication..

I have just chekcked that table that is mentioned in the error (/BI0/TEQUIPMENT) and it only contains texts..

Since I have only changed the description of one of the navigationall attributes, i can't understand this error..

Anyways, i just want to make sure i get it right in Quality.. because I will have to move this into Production (i.e, perform the same steps), and need to  be sure...

Many thanks for your help

Joana

[Former Member · Accepted solution]

I have already tried do perform adjustment in SE14, and reiport the order, and i have the same error

Also, i've tried to activate object through program RSDG_IOBJ_ACTIVATE, and failed due to the fact that i have data in T table

Also i can not undo my change because in QUA if i look at the inactive 0EQUIPEMNT object, i see that the text of the nav attribute was changed

Can anyone provide any help?

Many thanks

Joana

[Former Member · Accepted solution]

You could use the 'repair infoobject' option of RSD1.  But I'm not sure if text tables get checked.

If all else fails, I'm afraid the only thing that's left is to empty the table.

[Former Member · Accepted solution]

Hi All

I've continued to look at this issue, and i have some additional info.

The object used is 0EQUIPEMENT. On BC this object has texts as time dependent and the text transfer rules reflect that.

On our previous developement for PM data model (the initial one), we have changes this object and transfer rule, so that texts are no longer time dependent.

At that time, all was ok, and transports & loadings were done both in qua and production, sucessfully.

Now, comparing both objects and transfer rules in dev and in qua, in quality object and rules have text as time dependent.

This is why i have the issue transporting and activating the object, because the structure of the texts table is different in quality

The strange thing is that:

- Obejct and transfer rule in production are the same as in DEV (texts not time dependent)

- Object and transfer rule in qua have not been changed manually (i.e, only transported from dev)

- no additional order was transfered to qua and not to prd.

I have checked the activation dates of the objects in qua and they are the same as the day the orders were transported..

Has anybody ever had this issue?

Anyway, i have created a transport order from dev, with object and transfer rule, and will tranport it to qua to see if it solves the problem.

Any other ideas?

Many thanks

Joana

[Former Member · Accepted solution]

Well that's certainly the cause, and very strange too.  I'm thinking of direct changes in the QA system, but the activation dates are the same...

I wouldn't lose too much time figuring out the cause, transport the whole setup in the correct form to fix it.

When you see the issue reappear on another infoobject, then it's time to dig deeper IMO.

[Former Member · Accepted solution]

Hi 2X U

Initailly i also thoughtit might be direct changes in quality... but after looking at the dates realize it can't be.

I've transported object & text transfer rule.. I got the same erros regarding the table /BI0/TEQUIPMENT...

Looking at rule, its ok now (it does not mention date to and date from)..

I assume the error i get, that does not allow me to activate equipent, is due to teh fact that i have done text loadings in the past, and therefore table /bi0/Tequipment contains data and contains fields dateto and date from..

I have tried to actiavte and adjust data (with option save data) - in SE14, and afterwards tried to activate object, but still got the same error

My concern is that if i delete data in SE14, i have some sort of issue with sids

When you sau transport the whole setup in the correct form to fix it, exactly what do you mean? What needs to be transported?

Many thanks

Joana

[Former Member · Accepted solution]

What I meant with the whole setup is the infoobject itself, and the transfer rules,... for the text datasource.

Now about your table: if you do adjust & save, that won't help.  If you remove time dependency, the table itself is changed.  Columns are removed.  And as long as there's data in your table they can't be removed.

Deleting records from a text table is no big deal.  The SID's are stored in the SID tables.

Just make sure you don't delete the table definition itself but only the content.

[Former Member · Accepted solution]

Hi all

Problem solved.

I've used option activate and adjust with data deletion from SE14, and afterwards imported order with object and transfer rules.

I've just loaded it and its fine.

Many thank for your help

Joana

[anshu_lilhori]

Hi,,

Refer the below thread.

http://scn.sap.com/thread/2068235

Issue is you have data in that object thats why its giving transport error.Either you can delete all the data but be very careful regarding this.

May be you can activate that object with the help of program given.Give a try to this in QA systen first then apply the same to PRD.

Regards,

AL

[former_member182343]

HI Faria,

Need to adjust Text master data table.

Go to SE14 - Give table name- select Save & Adjust.

Then re import the same request again to QA.

Also activate 0EQUIPMENT properly.

- RVC

[Former Member]

Hi viljay

I have a few questions about the solution you re giving:

- Even if i manage to activate table in quality through SE14, and re-import the same order, will i need to do this in production?

I am asking because i have almosto no access in production, so I was wondering if there would be a way to solve this in Dev or Qua and tranport it.. if there is no other way, i will ask the help desk team to perform this task

- when you say activate the obejct properly, what do you mean? In dev it was properly actiavted, and i had no issue... should i be activating it again in dev and import that order as well?

Many thanks

Joaan

[former_member182343]

Hi,

Do this activity in prod. Get authoriasation from BASIS team or ask then to do same activity and transport same transport request to prod.

- rvc

[Former Member]

Hi Viljay

I'm still transporting it to QUA

I've done the following steps

- BW QUA went to SE14, selected table /BI0/TEQUIPMENT which is 0EQUIPMENT text table indicated in Object. Selected Edit

- Processing type: Direct

- Option: activate and adjust database with Save data selected

- Re-imported my transport order

I still got the same error.

Was this the option i should be selecting?

Thanks

Joana

[former_member199691]

I dont understand why you are getting error regarding text table. As per my understanding, you have just changed the description of an attribute which should be fine without any adjustment to T or P tables.

Please make sure that struture of text tables same in development and QUA.

If it is not same, make the necessary adjustments.

If it is same, you can try following program in QUA to activate the info object RSDG_IOBJ_ACTIVATE

Regards,

Gaurav