on 01-07-2011 8:58 AM
We are trying to release invoice data, after loading it into the inbound layer (0ASA_DS01).
Data is successfully getting validated in the validation layer but failing while releasing.
In the process chain, step of activation of DSO (0ASA_DS00), we are getting an error, stating "hex# (2300) contains invalid characters in Infobject 0XSARDOCTXT".
Kindly help us to identify and fix the hexadecimal characters in our data load from a flat file. Our INVOICE data has millions of records, how to track and resolve this hexadecimal character in these millions of records, as we are unable to identify the character itself?
Kindly into the issue ASAP
Hi Aalap
Have you tried the special character option in RSKC "ALL_CAPITAL" or "ALL_CAPITAL_PLUS_HEX" ?
Here are some of the options I would evaluate:
1. Enhance the extractor to remove these characters.
2. Remove this field from detail layer and cube. Anyway it is a descript
ion field so I don't think it is really relevant for analysis.
3. Enhance the transformation going from Inbound to Detail, and for Doc
text do a search replace for those characters with a blank
4. Donot extract description at all
Now options 2 and 3 depending on where exactly the load fails. Option 4 can be used if you donot have data enrichment services at all.
Regards
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.