Delta

[Former Member]

Hi all

Delta is failed when extracting the data from ODS to CUBE. 339 from 339 records..its a shortdump.

RAISE_EXCEPTION.

The system is not allowing me to repeat the delta.

how to deal with this.

REgards

Shetty

[former_member181964]

Hi,

Delete the request in cube and come to ODS -> Manage there in datamart layer it is having check symble,so click on that check symble and delete it(untile unless you delete it, ODS doesn't know you are loading once again the same data) and then load again.

Thanks

Surendra

[Former Member]

Hi

Do the following steps.

1. Delete the request from the Cube

2. Make the request as red in the monitor.

3. Go to the manage of the ODS and go to the Request tab in that make the Data mart status of the request to init(you have to do this).

4. Run inofpackage again

Hope this Helps.

Rgds,

RAvindra

[Former Member]

Hi, It will allow for delta from ods to cube..follow the ravindra steps...uncheck the request in the ods before loading the data to cube.

regs,

mahantesh

[Former Member]

Hi all

thanks for the informative input from everyone. As Mr ravindra gave a clear steps about how to load the failed delta b/w datamarts. i just have a small doubt in point no 3. <i>Go to the manage of the ODS and go to the Request tab in that make the Data mart status of the request to init(you have to do this).</i>. if i delete the status of the data mart does it mean that i am doing from the scratch. i mean the init again or jsut loading the failed request from the source to target.

Regards

Shetty

[Former Member]

Go to SM50 and delete the process corresponig to job

. now repeat the delta.

Thanks

prakash

[edwin_harpino]

hi,

check more detail error (transaction st22, sm21)

try to use reconstruct ? (tab 'reconstruction')