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]

Hi,

a) Kindly check in the CalDay SID table (/BI0/SDATE) for the entry you have in your load. If the entry is not existing, kindly take your necessary actions (adding the entry or correcting your PSA)

b) You can alternatively try checking the option of 'loading master data even if there is no master data'.

Best Regards,

Raj