Date Conversion Error

[Former Member]

Hi,

I am trying to load data from R3 to DSO. Its loading successfully. At the time of activation, its failing because of SID error. The error message is "Error when assigning SID: Action VAL_SID_CONVERT table 0STAT_DATE ".

Value '01 0102' of characteristic 0DATE is not a number with 000008 spaces.

I tried finding it in PSA, but its not allowing me to find. Please suggest me some cleansing routine.

Thanks..

[Former Member]

- goto to table RSTSODS.

- search with the field ODSNAME = "<datasource>_*" the name of the PSA-table.

(* is the name of the source system. You find them in the table RSBASIDOC in field TSPREFIX).

- in the table <ODSNAME_TECH> you can search in the field STAT_DATE the string '01 0102'.

- probably in the monitor you can see the failed datapackage and the dataset number. So you can filter the psa-table with these information.

Sven

[Former Member]

Click on the "Logs for DSO Request Processing"

Select the Data Package containing the "RED" Error Light. Please take note of its Data Package Number, Value and Error Message.

Drill down into the architecture hierarchy and select the Data Source concerned.

Right-click on the Data Source and select the "Display" Option.

On the Masthead (that's the upper portion of the window), locate your "Manage PSA" button. Click on it or use "Contol + Shift + F6."

Once you are presented with your PSA Request Log please take note of your PSA number. Its usually /BIC/B00….

Highlight the PSA Request and select "PSA Maintenance" below or select F5.

Once you are presented with your PSA Maintenance Screen, select the "Filter Option" on the bottom portion of the screen.

Enter the Data Pakage Number and select the field which erroneous data was posted. Enter the value in this field. Once you are taken to the PSA Presentation window, you can select the record line and field that you want to edit and correct. Select the "Pencil" button to initiate changes. Please dont forget to save. Once you are done with this, you can reload already.

Please dont forget to assign points if it helps you. Cheers!

[Former Member]

Check the details tab of the monitor screen. It should tell you which data packet and which record is throwing this error. Then go to the PSA table and fix the issue. Hope this helps!

[Former Member]

I can see from your error msg that you have a record or records with invalid date ( blank space in date column)

Since you say that this is from R?3, can you check the data in RSA3. Also, better to correct the erroneous records in the source and try reload.

Ravi Thothadri

[Former Member]

There are 13 Million records in the source..its very hard to find the particular record.I think some cleansing routine will be better. Can you help me with some cleansing routine on data fields.

Thanks..