Error loading data from R/3

[Former Member]

Hi,

I am loading hierarhy data into BW from R/3 for InfoObject 0CS_UNIT and the following error message came up. What I do not understand here is that there is no error for all the records of format "MEXXXXMG" (where X is any numeric value) but all the records of the format "MEXXXX00" (zeroes at the end)failed. This infoObject uses alpha conversion exit. Why is it failing when there are zeroes at the end. And I am sure that there are no blank characters anywhere.

<b>SYSTEM ERROR MESSAGE</b>

Diagnosis

The technical node name for node id 00000010 is not consistent for conversion exit ALPHA , which is stored with InfoObject 0CS_UNIT .

Possible reasons for the error:

The original consistent value returned by the dataSource was changed by a conversion routine to a non-consistent conversion exit value. The DataSource returns a value that is not consistent in the conversion exit.

System response

Loading the hierarchy was terminated.

Procedure

Check whether the correct conversion exit was entered for the InfoObject. If necessary, change the conversion exit, conversion routine or the data to be extracted.

A further option is to activate automatic conversion in the transfer rules. Here, the system executes the conversion exit, making sure that the data is in the correct format.

<b>SYSTEM ERROR MESSAGE END</b>

COuld you please share your insight and experience.

Thanks

John

[GFV · Accepted solution]

We had similar problems after converting BW 2.x to 3.x, due to ALPHA Conv Exit (see Note 447341 about ...) but only with Attributes or Texts.

May one ot the field of Transf Structure is not delivered in the exected format?

I found even Note 339453, ... without mre information don't know if it's suitable to you problem.

Hope it helps

GFV

[Former Member · Accepted solution]

Gianfranco,

Thanks for the response. I have seen those OSS notes but they are not relevant to this problem, but I solved this problem by removing the alpha conversion for this infoObject.

Thanks

John

[GFV · Accepted solution]

Did you removed ALPHA from 0CS_UNIT? Be aware that modifications to BCT InfoObjects can be dangerous ... If you will use once again 0CS_UNIT for other purpouses, I mean.

With which R/3 field are you filling 0CS_UNIT? How is it referenced (Data Element)? Another solution could be operating a transformation in Transfer Rule.

Hope it helps

GFV

[Former Member · Accepted solution]

If I recall correctly 0CS_UNIT has length 18. So if you pass a value of length 8, the BW expects it to be ALPHA converted. If the object only contains numbers it isn't correctly ALPHA converted.

Some Solutions:

1. Do the ALPHA conversion in the transfer rules.

2. Reduce the length of the IObj to 8.

3. Add a letter to the front (or end) of your values.

Best regards

Dirk

[Former Member · Accepted solution]

Gianfranco and Dirk,

Thank you for your responses. I am aware of the consequences of changing the BCT objects and I was sceptical to do it at first. But, SAP suggested this in one of the notes. (Don't remember the note number, but i searched it by 0CS_UNIT). So, I decided to do it.

And Dirk, I can not add a letter to the front of values.

Thanks for your responses.

John