Trouble moving data from ODS to Cube after a 7.0 upgrade

[Former Member]

Folks, we're experiencing a small challenge in my organization. We're upgrading from BW 3.1 to BI 7.0. SAP hosting has told us that the technical upgrade is complete and so our functional team has started work.

We load the invoice item extract, 2LIS_13_VCITM, into an ODS and then promote it from there into a cube. However, when we run the process chain now it fails with the error message <b>"Cannot generate data package for the request in its current state"</b>

To fix this I created a transformation between the ODS and cube and a DTP to facilitate the load. This time we received a different error, <b>"0TARGET_QTY is not compounded"</b>.

Just for the heck of it I removed the mapping of 0TARGET_QTY to see if I could get the load to work at all. Again it bombed and gave me the 0TARGET_QTY error message (which I found bizarre as that object isn't even mapped).

So I'm looking for some advice here about what I'm doing wrong. Any advice?

[Former Member · Accepted solution]

reactivate the ODS, transformation and DTP again and reschedule the load. There isnt a OSS note on this issue. reactivating the ODS will help solve the compounding issue.

[Former Member]

All, just wanted to update this thread after we resolved our situation.

It turns out that this was a tablespace error which was occuring when the cube was trying to create indices. Apparently they are now created in temp space and not enough was extended. BI couldn't figure out what was happening with itself so it just kicked out some random errors. Weird.

[Former Member]

I tried the reactivations of everything, but that hasn't seemed to fix anything. It is interesting to note two items.

1. When reactivating the ODS I get 2 warnings. The first is <b>"The object name is not allowed to be empty".</b> The second is <b>"The dictionary deletion module could not delete all objects"</b>

2. I notice that the data load activities seem to still be running (checking sm50) long after the load has returned an error. Is that normal?

[Former Member]

Check Short Dumps... it may give you any Clue.

Nagesh Ganisetti.

• Assign points if it helps.