on 09-27-2007 6:47 PM
Hi All,
I am posting IDOC->XI->JDBC, approx 5000 Idocs.
But few messages are giving following error in XI-_SXMB_MONI
Can any one guide me what is the cause of error? I check whole Idoc data I am not able to see bad character? can any once guide me what are the bad character in XML to post data in oracle? so that i can search in XML and how to avoide this error.
"com.sap.aii.af.ra.ms.api.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'HRP1001' (structure 'INSERT_PAD34'): java.sql.SQLException: ORA-00911: invalid character"
Ok i found <PROZT>0.00 #</PROZT> data in one field which is giving problem.
Can any one suggest me how can i replace this type of characters with blank in XI during mapping?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply Raj,
I checked in some idocs its coming like <PROZT>0.00</PROZT>
and in some idocs its coming like <PROZT>0.00 #</PROZT> .
I am talking about following IDOC.<ZRMD_A06> -> <E1PLOGI SEGMENT="1">-> <E1PITYP SEGMENT="1"> -> <E1PAD34 SEGMENT="1"> -><PROZT>0.00 #</PROZT>.
Can we remove this # during message mapping in XI??
Regards
> I am talking about following IDOC.<ZRMD_A06> ->
> <E1PLOGI SEGMENT="1">-> <E1PITYP SEGMENT="1"> ->
> <E1PAD34 SEGMENT="1"> -><PROZT>0.00 #</PROZT>.
> Can we remove this # during message mapping in XI??
sure you can remove it using Replace function or by writing UDF.
as I am seing # is last character..<b>so remove # with " " (single space) and then use the TRIM fucntion.</b>
Thanks
Farooq.
*<b>Rewards points if you find it useful*</b>
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.