Skip to Content
author's profile photo
Former Member

FULL REPAIR not working after clean up of psa error records

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on May 04, 2011 at 06:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2011 at 12:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded