FULL REPAIR not working after clean up of psa error records

[Former Member]

I processed a FULL REPAIR for fiscal period/year 001/2011 on 0FG_O01 to both psa and dso. It processed correctly as a FULL REPAIR. Data failed loading to the cube. I went back to the psa to correct error data, and when I updated the psa scheduler to process the corrected FULL REPAIR to dso, it processed as a FULL UPDATE.

Data has hex values that process fine to dso but fail loading to cube. Error dtp cannot work in this process. Is there a way besides of processing an error dtp, to have the FULL REPAIR process successfully to psa, dso, then cube, if records fail in cube and I manually clean the records up in the psa?

Thanks ! I appreciiate your assistance.

[srikanthbwbw]

Hi,

Can you please post the error message.

I remember once we had the same issue. DSO will not create SID's and when loaded the data into the cube, it ended with error. I dont remember exactly but when we change it in the PSA and loaded into the cube via DSO, it failed. I had to fix that in source to get it worked. We had to do that for calmonth format.

I dont think editing the hex numbers in PSA will solve the issue. We need to determing that in source and fix it. Please wait for other plps response.

Thanks

Srikanth

[Former Member]

Hi,

You can always run an Error DTP from DSO to Cube. Apart from that you can manually change your PSA records from PSA maintenance,delete old request from DSO and Cube and then run normal DTP from PSA to DSO and then to Cube.

Regards,

Appu