Error loading the data into ODS - Message no. BRAIN060?

[Former Member]

Hi,

I am getting following error while load the data from flat file, data loaded successfully from flat file to PSA but I got following error while updating the data from PSA to data target:

Value '010384 javablue' (hex. '30003100300033003800340020006A0061007600610062006C') of characteristic 0PO_NUMBER contains invalid characters

Message no. BRAIN060

Diagnosis

The following standard characters are valid in characteristic values as default:

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

Characteristic values are not allowed if they only consist of the character "#" or begin with "!". If the characteristic is compounded, this also applies to each partial key.

You are trying to load the invalid characteristic value 1. (hexidecimal representation 30003100300033003800340020006A0061007600610062006C).

I am trying to load Value '010384 javablue' to "0PO_NUMBER" info object for ODS with in one row with some other data.

Any idea or any input to resolve this issue?

Thanks in advance for any input.

Steve

[Former Member · Accepted solution]

Hi Steve,

It looks like you are trying to load lower case letters into the info-object. If so then you need to make the settings in the info-object maintenance screen. Go to RSA1 -> Info-objects -> 0PO_NUMBER -> general tab -> switch on the lowercase latters checkbox.

if you are loading any invalid characters then you need to maintain the same character in transaction RSKC. go to RSKC -> check whether the character is present in RSKC, otherwise you need to maintain it there.

Hope it helps.

Thanks

Soumya

[Former Member · Accepted solution]

Thanks Soumya, I have maintained the upper case letters, but I am loading upper and lower case mixed to PO number? and it is not working. What is the solution to this? If I set lower case property to the PO number infoobject, it won't accept upper case. If I uncheck the lower case then it won't accept lower case letters. I cannot add upper and lower case letters in RSKC, because it accepts up to 72 characters, I have already have more than 60 characters (special char, numbers and 26 upper case letters).

I have already tried transfer routine but you can either convert to lower or upper but it doesn't work. we need both uper and lower case for po number, and R/3 is accepting it. why BW doesn't accept both?

Any idea what can be done?

Thanks in advance for your help.

Steve

[Former Member · Accepted solution]

Hi Steve,

Have you tried loading switching on the lower case letters ? Since you have already maintained the uppercase letters in RSKC, it will treat the upper case letters as special characters and since lower case letter property is switched on it should be allowed now.

Hope it helps

Thanks

Soumya

[Former Member · Accepted solution]

Hi Steve,

Use formula (toupper) in transformation library at transfer rules or update rules.

You can define the formulas in InfoSource --> Transfer rules or in the update rules.

Formulas enable you to do transformation without any ABAP-Coding.

Regards,

Srikanth

[maximina_barry]

I am experiencing a similar error: My error shows:

Value 'Accuratech' (hex. '41636375726174656368') of characteristic 0CUSTOMER contains inva

Error when assigning SID: Action VAL_SID_CONVERT table 0SOLD_TO

Process 001103 returned with errors

I tried the options I found, but non of them worked. After searching for this error, I finally found Value = 'Accuratech' in a different data package. How do I locate the documents that have the error? This PSA has over 52M records.

Any information is greatly appreciated.

Maximina