Skip to Content
author's profile photo Former Member
Former Member

Full Repair Request on DataMart ODS


I have ODS 1 datamarted to ODS2. Every week delta runs on ODS1 based on TRANSDATE and subsequently those deltas are updated on to ODS2.

On second week of JAN 2008 , the delta from ODS1 to ODS2 did not tie but R3 and ODS1 ties so ODS1 is clean. Around 30k records are missing in ODS2 from ODS1 during that time frame.

" I did not find any errors in the load from ODS1 to ODS2 but I noticed some error messages for the data load from R3 to ODS1 for the same time period:

1.Deletion of request REQU_48N2ZSTS8N9E60BJ9I5YR4VD4 from data target ODS1 failed

2.Faulty status found for DataStore ODS1 (see long text)

3.Time limit exceeded. No return of the split processes

4.Process BCTL_48NEPVAZXMGKDX13U336EDA6G could not be terminated. Terminate manually

5.Activation of M records from DataStore object ODS1terminated

6.'A' and 'U' entries exist in RSODSACTREQ for request REQU_48N2ZSTS8N9E60BJ9I5YR4VD4 - termination

7.Error while setting status for DataStore ODS1 and request REQU_48N2ZSTS8N9E60BJ9I5YR4VD4

8.Process 000019 returned with errors "

monitor status is green, but these are errors found in the details tab. Still doing some research if these errors some how hampered the further data load to ODS2.

Please let me know if these errors are prevented the datamart load.

In order to fix the data in ODS2 I am thinking of selectively deleting the remaining records in ODS2 for JAN second week and doing a Full repair from ODS1 with same time selections. Please put forth your suggestions on this idea.

Points will be assigned.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 05:32 AM


    My first question would be on which perameters you have Cross checked the data between ODS1 & ODS 2 are not matching.

    If you are sure about the parameters then pls check the rest request which entered afetr the failed one in ODS1 & ODS2 so that you can make sure that the data is correct in both the ODS 1 & 2 are correct excepet that 1 failed request.

    Next if every thing is finalised you can do the selective deletion on both the ODS1 & 2 and run the Full repair request to ODS1 and then to ODS 2 to make sure that the data is recongrouped in to the targets.

    Note:- Make sure that the selection Conditions for Selective deletion is correct and the selection Condiditons for Fullrepair request are also corect.

    Best Regards,


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      You said you have found a request with errors in ODS1 if that load has not picked up all the data from Source then you have do the selective deletion.

      If that load is perfict then you need not to do the full repair to ODS1, u can directly run a repair full form ODS1 to ODS2 after the Selective deletion on ODS2.

      And as you said the selection conditions for both Selective Deletion and Repair full should be the same.

      All the best .......!!

      Best Regards,


  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2008 at 10:01 PM


    the error gives the hint that ODS1 is not properly activated..hence not all the data is partially activated in ODS1 thus ODS2 doesn't have all the records

    to recover this you can run full repair



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.