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]

Edit PSA Data ,Try to delete the incorrect entry in PSA and if those entries are correct again manually make entries of all those records which was previously mark as error.

Some time this might works.