How to empty the cube and re-intialize the data load.

[Former Member]

Dear All,

I've the following data flow in my BW7 env.

From Oracle DB, a full load into a BW ODS and then a delta load into BW CUBE.

The full load from Oracle DB to ODS contains weekly data (sort of delta filtering put in place at the source)

Coz of some biz reason, i needed to delete the last few delta request from cube and the corresponding load requests from ODS.

Instead of marking the delta request red and then delete. I deleted the delta request while green thus disturbing my delta load from cube.

Now as i understand, I need to empty the cube, reset the initialization from ODS to cube and then start the delta.

While trying to empy the cube, the system goes into hang mode and data is not deleted (even after 2 hrs)

Even deletion of a single request is not worklng.

I'm not sure whether my above actions of deleting the request (when green) has resulted in some locks at system level.

How do i find this.

The Basis guy says, things are normal with no unnecessary locks.

How do i delete the data.

The ODS has around 7m records.

Regards,

Nagendra.

[Former Member · Accepted solution]

Hi Nagendra

Pls chk if any job is running on your name in SM50 ...

and if the object is locked in transaction sm12

May this will help'

Nandita

[Former Member]

Hi,

Check this thread.

/thread/274048 [original link is broken]

Regarding starting a new delta process, you need to delete the earlier init , for this goto scheduler in the menu of the infopackage and select Initialization Options for the source system and delete that init. now you can start the new delta.

Regards,

Rk.

[Former Member]

Dear All,

Thanks for the responses, have awarded appropriate points. However, the problem still continues...

I was able to delete the data from the cube. But when i try to re-load the data from ODS to CUBE (intialization or full load), the data is loaded into PSA but after 30% of data into cube (added records), the request turns to red.

The BWCCMS screen for tablespace shows.

PSAPSR3 95% used

PSAPSR3700 92% used

Could someone give some literature on the various table usage.

Where all can i have a look for the above pbm.

Regards,

Nagendra.

[former_member779991]

HI,

Please check the table space size from DB02 transaction.

Regards,

Reena

[Former Member]

Am closing the thread, as the problem was resolved.

Instead of loading the complete data set from ODS to CUBE in one shot, i loaded it in parts and then did a intialization with no data transfer and set the delta mode correctly.

Thanks for the replies.

Regards,

Nagendra.

[Former Member]

Hi,

Try the tcode RS12 or SM12 to see if there is any locks with cube.