ODS Activation failed.. Invalid characteristics

[Former Member]

Hi Gurus,

This is the error I got:

<b>Value '"TWC Cooperative Mktg Program Invoice #2397"' (hex. '2254574320436F6F7065726174697665204D6B74672050726F') of characteristic 0POSTXT contains invalid characters</b>

In RSKC, I have ALL_CAPITAL.

This is in Production.So writing a routine, deleting data ,reloading might not be a solution.

I can have these records changed in the source system.My question as this data is in BW, if I delete this data from the ODS and PSA and then have these records changed in Source system and then reload the DELTA, am I going to lose data?

If I'm not going to lose the data, I can get these records changed in the source system and then reload the data.

Any help is appreciated.

[nikhil_chowdhary2 · Accepted solution]

Hi,

I am not really sure, but you might lose records in case you delete the data from the ODS & PSA and then reload after getting the records modified in the source system.

In my opinion, a better solution would be to check the number of records having such invalid values. If there are only a few then you might consider just deleting the request from the ODS, modifying the records manually in the PSA and then reload data only from the PSA onwards and not from the source system.

[Former Member]

Hi,

check if # is added in rskc. Additionally check if in the maintenance of 0postxt the flag lower case letters is checked. If not, check it, activate the object and try activating again.

Another option is to switch off bex reporting of the ods (if it is not needed for reporting).

A third option is to add a routine for 0postxt to translate incoming text to upper case.

regards

Siggi

PS: If all this doesn't help you might think about this solution: /people/siegfried.szameitat/blog/2005/07/18/text-infoobjects-part-1

Message was edited by: Siegfried Szameitat

[edwin_harpino]

hi,

the reason is you have # in the middle of data,

you can delete the error request from ods then edit psa data to do correction, and update the request again from psa. meanwhile you do correction also in source system, so in next delta extraction no error reoccurance.

to edit psa data, after delete the request from ods, rsa1->psa->expand application component, infosource -> you will see the psa (request by request), in case you can't see the psa (if the psa old than 2 days), go to menu 'settings'->display selection for psa tree and choose date. after that right click on the request and 'edit data', in next screen find the error records and do correction then save. to update from psa, right click the psa and 'start the update immediately' or 'schedule the update'.

hope this helps.