ODS activation error

[Former Member]

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.

[former_member202718 · Accepted solution]

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

[prakashjasti · Accepted solution]

Hi,

Please set a filter on date field in excel and check for the date similar to 2014-12-2.

Regards,

Prakash.

[Former Member · Accepted solution]

I tried to search for the invalid chars but couldn't find it in the flat file..

[RamanKorrapati]

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

[KodandaPani_KV]

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.

[Former Member]

Thanks. The log file only contains below info:

Value '2014-12-2托' (hex. '32003000310034002D00310032002D0032005862') of characteristic A_INVDTT contains invalid characters

Message no. BRAIN060

Diagnosis

Only the following standard characters are valid in characteristic values by default:

!"%&''()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ.

Furthermore, characteristic values that only consist of the character # or that begin with ! are not valid.

You are trying to load the invalid characteristic value 1. (hexidecimal representation 32003000310034002D00310032002D0032005862).

Procedure for System Administration

Try to change the invalid characters to valid characters.

If you want values that contain invalid characters to be admitted into the system, make the appropriate setting in BW Customizing. Refer to the documentation describing the requirements for special characters and the possible consequences.

For more information on the problems involved with valid and invalid characters, click here.

--- AND ---

Message Text

Value '2014-12-2托' (hex. '32003000310034002D00310032002D0032005862') of characteristic A_INVDTT contains invalid characters

Technical Data

Message type__________ E (Error)

Message class_________ BRAIN (Messages: BRAIN)

Message number________ 060

Message variable 1____ 2014-12-2托

Message variable 2____ A_INVDTT

Message variable 3____ 32003000310034002D00310032002D0032005862

Message variable 4____

Message Attributes

Level of detail_______ 4 (Level of detail 4)

Problem class_________

Sort criterion________

Number________________ 1

It never mention which line item or record. Where exactly can I see this details in BW 7.0?

[former_member202718]

Hi Daren,

Can you load only ONE Record to test where the Error is....With the Correct date Format.

The 80K can be loaded Later.

rgds

SVU

[former_member199945]

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.

[prakashjasti]

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.

[KodandaPani_KV]

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.