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.