Question Re: invalid characters in Technology Q&A

invalid characters

pmoh — Fri, 18 Sep 2009 03:01:17 GMT

We're on BI7.

I have loaded the record from Flat File into PSA, no problem.

Now when I try to load the redord from PSA into InfoCube via DTP, I hits the following error:

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 Capacitor 17 &

(hexidecimal representation 436170616369746F72203137 ).

System Response

When I check the value of the record, it is as follow:

Capacitor 17

So dont see any problem with it. Please advise what is wrong and how can I solve it?

Thank you.

Edited by: lynn on Sep 18, 2009 5:03 AM

Re: invalid characters

dennis_scoville4 — Fri, 18 Sep 2009 03:12:08 GMT

Is there a space at the beginning or ending of the value? If so, it needs to be trimmed or condesned in order for it to be acceptable. SAP BW chokes on values that start with or end with a space.

Re: invalid characters

pmoh — Fri, 18 Sep 2009 03:23:36 GMT

I check, no space at all...

please help.

Re: invalid characters

dennis_scoville4 — Fri, 18 Sep 2009 03:33:32 GMT

Is the target InfoObject setup to accept lowercase letters? If not, you either have to convert to uppercase or check the 'Lowercase letters' checkbox on the General tab of the InfoObject.

Re: invalid characters

Former Member — Fri, 18 Sep 2009 04:06:57 GMT

most likely its because ur source file contain invalid characters.

I suggest u check your source file,

or actually, you can maintain ur PSA entries, eg, manage the PSA, navigate the error line, double click the line which will show you the detail, and manually change the Caxxx 17 to simple text, like "Fixed",

and load the data again to see if theres difference.

Re: invalid characters

Former Member — Fri, 18 Sep 2009 11:20:37 GMT

Possible there is a carriage return or something at the end of a line/record. You cannot always see this when you look in BI. So check your file in a editor like text-editor. There must be a sign somewhere thats not allowed.

Re: invalid characters

pmoh — Mon, 21 Sep 2009 00:11:07 GMT

But the thing is I can load this data into PSA.

Only when PSA into Data Target (via Transformation), then I hits the error.

Any other clue?

I remember long time back that someone say need to run some transaction so that system can take invalid character like "@ # $ etc". Do you know what transaction ?

Re: invalid characters

Former Member — Mon, 21 Sep 2009 01:16:47 GMT

Hi There,

Please note that even there contain invalid characters, the data can still be loaded into PSA.

Kenny

Re: invalid characters

Former Member — Mon, 21 Sep 2009 05:51:57 GMT

The transaction to tell the system to accept this characters is; RSKC

Re: invalid characters

Former Member — Mon, 21 Sep 2009 06:49:54 GMT

The PSA would accept invalid character even that is not valid in BW. You will get error only when you run DTP.

Check your Source file. Open the file in Text editor as suggested by D.H. Snellink. You would find some clue. The same happened to us once. Generally You wonu2019t notice any invalid character in PSA entry even it exists.

Ripal

Re: invalid characters

Former Member — Mon, 21 Sep 2009 08:10:28 GMT

Hi ,

As the load is flat file load. You can do the changes in that record. Then try loading it again. Or else check in RSKC

!"%&''()*+,-./:;<=>? are maintained or not.

Regards,

Rahul.

Re: invalid characters

Former Member — Mon, 21 Sep 2009 10:51:31 GMT

Hi lynn,

The Transaction is RSKC to maintain the list of permitted characteristics in BW.

If you want you can add the character in RSKC.

Also At PSA level there is no check for special characters so it will not give any error.

I would suggest to delete that filed data "Capacitor 17" in PSA and manually type "Capacitor 17", and then load it further.

Regards,

Pratap Sone

Re: invalid characters

Former Member — Mon, 21 Sep 2009 15:51:14 GMT

Hi lynn,

as written there aren't checks loading data into the psa. So this can't be the problem. What i do, if i have problems with characters: i write a small routine within the transformation and define the characters by myself which are valid or not. Any other character will be replaced by an blank:


DATA: l_d_offset LIKE sy-index.
  CONSTANTS: c_allowed(100) TYPE c value
  'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890_-/!?.ÖÜÄ'.
* Es sind nur Großbuchstaben erlaubt, also Umwandlung in Großbuchstaben.
  TRANSLATE RESULT TO UPPER CASE.
  DO 60 TIMES.
    l_d_offset = sy-index - 1.
    IF RESULT+l_d_offset(1) CO c_allowed.
*     Erlaubtes Zeichen, mache nichts
    ELSE.
*     Zeichen nicht erlaubt, ersetzen durch Leerzeichen
      RESULT+l_d_offset(1) = ' '.
    ENDIF.
  ENDDO.
  RETURNCODE = 0.

Maybe this helps.

regards,

Thomas

Re: invalid characters

pmoh — Thu, 18 Feb 2010 05:46:14 GMT

Because the text consists of upper and lower case, so you have check the LOWERCASE indicator in the infobject!!!