Short dump while reconstructing request in ODS

[Sujai]

Hi

I had loaded a request into a few ODS, but later found i had to do some changes to the PSA manually, so i deleted the request from all the ODS and modified the records in the PSA.

Now when i try reconstruction it gives a short dump in one of the ODS with message "Exception condition "NOT_EXIST" raised. ".

Data from this ODS was further loaded to a few other targets as delta and while deleting the request it gave a message saying the delta will be deactivated, I said Ok and the request was deleted.

I was able to reconstruct the request in all the other ODS and cubes without any issues.

what could be the problem???

Regards

Sujai

[former_member790646]

Hi Sujai,

you should have faced this error while deleting the request from the ODS itself, saying that delta has been loaded from the ODS to other data targets and those requests (in the data targets) need to be deleted first and then the delta management setting needs to be reset in the ODS.

Now since you have deactivated the delta and reconstructed the request in the ODS, can you check whether the earlier loads from this ODS are still available in the data targets (it should not be); then you can update the delta from this ODS to the other data targets.

hope this helps.

Manish

[Sujai]

Hi Manish,

I just checked the other ODS.. it has a request that was coming from my ODS but I am not sure if its the correct request. Should i delete the request and then try reconstructing in the originial ods??

I have another question though, the delta was automatically reset when i tried deleting the request from the original ods, how do i set the delta for the other ODS now???

Regards

Sujai

[virenp_devi]

Hi,

Is delta between ODS to ODS reset or PSA to DSO?

In first case (ods to ods) simply do initi w/o data transfer it will set the data mart (delta).

If it is the second case you have lost the delta completely. You have to Intialise the datasource completely again.

Let em know if you need more info.

Regards,

Viren

[Sujai]

Hi

I am doing PSA to ODS. The data is available in PSA. the reconstruction went thru fine in the other targets. but when i try it in the ODS that i want it goes for a dump. This is where the error occurs.. shown in the dump..

 select * from rsreqicods into table l_t_rsreqicods where    
        tabname = i_dta and                                  
        typ     = 'I' and                                    
        odssid  = i_odssid.                                  
 if sy-subrc <> 0.                                           
   raise not_exist. -----> Error in this line                                     
   exit.                                                     
 endif.      

Regards

Sujai

[Sujai]

any updates on this issue???

I now tried a load to the ODS and got a short dump.

Sujai

[Sujai]

solved the problem

used note : 637505

user program RSBDELTAREPAIR in BI 7.0

SE16 >> RSBODSLOG >> <ODSOBJECT> >> sort descending on REQUID

session 2: SE16 >> RSBODSLOGSTATE >> <ODSOBJECT> >> <ACTIVE> will have the last active req. number of the ods <PROCESSED_ALL> and <PROCESSED_ONE> fields should be 0 or have the highest number of REQUID from RSBODSLOG.

Use FM RSBO_PROCESSEDONE_SET / RSBO_PROCESSEDALL_SET

to set Processsed_One / Processed_all field to 0.

Issue Resolved.

Sujai