Invalid Character problem....

[Former Member]

Hi,

I load the data to the cube.

I get some of the values as # from DB connect system.

I get the error while loading. " Invalid Characters not allowed"

I already have # in the RSKC transaction added.

What I need to do to correct this error?

Any idea.

Thanks , Jeetu

[Former Member · Accepted solution]

Hi Jeetu,

The character # has different meanings in SAP.

So try checking what that # is referring to, in your DB and then try adding it to the permitted chars and BI.

Hope this helps.

Naveen.A

[former_member345199]

Hi,

As a first option try comparing the data that came into BW with those available in Source based on document number or some key fields.

Also try Identifying incorrect records in PSA if possible.

System wont show all the incorrect records at the first time itself. You need to search the PSA table manually to find all the incorrect records.

1. First see RSMO > Details > Expand upate rules / processing tabs and you will find some of the error records.

2. Then you can go to PSA and filter using the status of records. Filter all the red requests. This may also wont show the entire incorrect records.

3. Then you can go to PSA and filter using the incorrect records based on the particular field.

4. If this also doesnt work out go to PSA and sort (not filter) the records based on the particular field with incorrect values and it will show all the records. Note down the record numbers and then edit them one by one.

If you want to confirm find the PSA table and search manually.

Also Run the report RS_ERRORLOG_EXAMPLE,By this report you can display all incorrected records of the data & you can also find whether the error occured in PSA or in TRANSFER RULES.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40890eda-1b99-2a10-2d8b-a18b9108...

Note 623391 - Incorrect instance in PSA table not found

Hope this helps.

Thanks,

JituK

[Former Member]

Identify a few of the records that have the # and ask the DB Admin or your contact on the DB to find out what is in their tables. This will tell you what characters are coming across.

They are probably greek symbols of some type or another.

Brian

[Private_Member_101989]

Hello,

Check this weblog:

Regards,

Jorge Diogo

[Former Member]

Are there any other invalid characters may be???