Skip to Content
Former Member
Jan 10, 2008 at 04:40 AM

Invalid SID value for date field


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.