Full Repair Request on DataMart ODS

[Former Member]

Hi SDN,

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.

[Former Member]

Hi,

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,

VNK.

[Former Member]

Hello VNK,

I appreciate your suggestions.

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

Basically ODS1 is detailed level data and ODS2 summarized one.

I have checked $ values in the active tables of both ODS's during the time frame in question(Transaction date). Apparently they did not match.

I have done the same checks for remaining deltas after this faulty request and the $ values crossfoot.

" 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."

Do I still need to do selective deletion on ODS1 ?

If I am not wrong selection conditions for both selective deletion and Repair Full request must be same

thanks for the support..

[Former Member]

Hi,

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,

VNK.

[Former Member]

Hi

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

cheers,

Swapna.G

[Former Member]

Hi Swapna,

Thanks for the reply.

So you mean to say I should do selective deletion in ODS2 and bring the data again from ODS1 using Full repair request.

Please let me know.

thanks