URGENT : ERROR 18 while updating the Infocube from ODS....

[Former Member]

Hello

We got the data into BW from MS SQL. There are 19 Datasources and we used views for all. Using 19 child ODS objects we updated 3 Parent ODS Objects.

Now we have to update the 3 ODS objects data to the InfoCube. When we try to Update its giving the error

"ERROR 18 in the Update" and some hexadecimal error message in the data, but we can only find the error like IV hexavalue inbetween the words(the InfoObject data type is CHAR) and in some errors we cannot find any mistake. It is just like normal text.

What could be the problem ?

Best Regards....

Sankar Kumar

+91 98403 47141

[Former Member]

Hi Sankar,

Check whether the update rules are active for the cube. The problem seems to be in the update rules.

Also check OSS Notes - 684014, 767018 and 768911.

Bye

Dinesh

[Former Member]

Dear Sankar Kumar,

I think this is related to Invalid character issues.. or SPaces setting in RSKC..

may be you want to look at eh following post..

/people/siegfried.szameitat/blog/2005/07/18/text-infoobjects-part-1

Example:

let us say..

1. Check in RSKC for allowed characters..

2. Add a code in the update rule to restrict the texts contains..

!"%&''()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ' are allowed characters in RSKC transaction then other than the above character is 'Invalid' including the smaller case letters and will throw the hex.. error.

since this is from database system even 'NULL' datatype from there is not visble to the eyes and can cause the failure.

regards,

Hari