Invalid SID value for date field

[Former Member]

I am doing a "Delta Init" load data of data from R/3 into BI. When the R/3 data comes into the ODS I am getting Invalid Sid Values "20000000" error for one of the date fields. The error message gives a record number. I go into the PSA and bring up the record and the date fields looks OK.

I deleted all of the requests and changed the load to a full load with error handling for 1,000 errors. The full load runs but I get the same Invalid SID error on the date field.

1. I would have thought the full load with error handling would have bypassed the errors and loaded only the good data. Was I wrong?

2. Is there any way to find the invalid record in the PSA and fix it and then process the data into the ODS?

Any suggestions would be appreciated.

Recards,

Mike...

[Former Member]

Thanks to everyone who responded.

After a lot of looking at data we found that the one of the date fields coming from our R/3 system contained an invalid date (value was 20709171). The invalid date was making its way all the way to the PSA and into the ODS. When it tried activate the ODS and create a SID for that invalid date is when I got the error.

Thanks again for all your help.

Mike...