ODS data activation problem

[Former Member]

Dear all,

I was loading data into an ODS. During data activation, an error appeared: "Value '# ' (hex. '0023 ') of characteristic 0ALLOC_NMBR contains invalid characters." I checked and found in source system this field has the value of '#'. What confused me was that this '#' could be loaded into PSA but could not pass the activation. I have set "ALL_CAPITAL" in RSKC. Please advise. Thanks.

Jin Ming

[Former Member]

Thank you very much. I decide to write a transfer rule at infoObject level to replace '#' to other valid values.

[Former Member]

/people/sap.user72/blog/2006/07/23/invalid-characters-in-sap-bw-3x-myths-and-reality-part-2

<b>The value that only consists of the single character '#' is not allowed because the initial input is masked with '#'.</b>

Look at : OSS Note 173241 'Allowed characters in the BW System'

U can either edit PSA n load corrected records from there or u can fix that in transfer rules using a code.

Invalid chars will be loaded to PSA without any fail as PSA has d replica of data of sourcesystem without any changes and only Tranformation will process which includes the <b>Infoobjects</b> n its properties n so it fails later.