Skip to Content
author's profile photo Former Member
Former Member

Date Conversion Error

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..

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 08:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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..

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 09:06 PM

    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!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 03:53 AM

    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!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 06:20 AM

    - 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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.