Skip to Content
avatar image
Former Member

ODS activation error

Hi,

I loaded a flat file to ODS and it gave an error when the data is activated. However the error log file does not indicate which line item/row is giving the error. There are over 80k records in the flat file so it's impossible to go through them one by one. How do I identify the affected line item? Please see attached pic.


Thanks.

BW error.png (25.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Jan 14, 2015 at 07:01 AM

    Hi Daren,

    Check the Logs of the DSO in the Log Tab of DSO, i will point the exact line where the Error is.

    The Error clearly says its for the Object INVTTD infoobject and there is a Special Char..with some Japanese/Chinese word.

    Correct the same Load....also try to load only one Record first and check where the issue is.

    rgds

    SVU

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 07:11 AM

    Hi,

    if you are loading the through flat file if yes

    please fallow the below sugation.

    open the excel sheet with 80K records.

    select the date field -> right click -> format cell -> go custome -> give the YYYYMMDD.

    then save it and load to Bi system

    check the output.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      A_INVDTT for this infobject in general tab enable   lower case option .

      create error dtp and load data again   we will get exact  error record in error dtp.

      Thanks.

  • avatar image
    Former Member
    Jan 14, 2015 at 08:44 AM

    Hi Daren,

    First of all your flat file may contains bad data or invalid data.

    So try to change at PSA or file.

    Delete failed request from DSO.

    Go to your PSA, Find the value 2014-12-2* in field A_INVDTT by using filter pane.

    . in value 2014-12-2** After 2 you have some junk char. you need to delete it.

    Or

    at PSA try to see the data of 42 data packet. in that you may fine above value.

    once you find that value. click on that row and edit taht date value.save.

    Later reload to DSO and activate it.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 07:06 AM

    Hi,

    check the info object - A_INVDTT - data type is the DATS

    if yes please check the excel data format.

    system will allow the input YYYYMMDD

    and out put should give  - DDMMYYYY.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 07:08 AM

    Hi,

    Please check for error in your data for field A_INVDTT.

    It seems that there is an error in date 2014-12-2 and some special symbol is there.

    Regards,

    Prakash.

    Add comment
    10|10000 characters needed characters exceeded