on 09-10-2008 12:52 PM
Hi
am getting this following error and i found this error in Message Monitoring - Adapter Enginer and the status is : System Error because of,
Unable to execute statement for table or stored procedure. 'H2454.GMDSOURCINGTREE' (Structure 'statement1') due to com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -407, SQLSTATE: 23502, SQLERRMC: PURCHASINGGROUP
Mapping is : XSLT
and please help me how to change the XSLT code if it requires to modify the SQL Statement.
Regards,
Y.Raj
Hi,
I found the solution my self here.
I checked IDX2 metadata for the IDOC which is showing only for some of the fields.
I just deleted the entry from IDX2 and let you know once the message triggered again if i get any problems later.
Regards,
Raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I got this error in production system and when i check the mapping it is XSLT.
So, here i need to give "space" instead of passing Null value in the XI interface.
How can i give this when the mapping is in XSLT.
Regards,
Raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, you can send the value blank, not sure about how can you do using xslt mapping. But check your JDBC receiver Communication channel which you are using, you will see one property
"Interpretation of Empty String values", select the value as "Empty String" and your problem will be resolved.
Thanks
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Raj,
have u checked whether the XSLT mapping it self has any errors, actually u are using a standard JDBC or calling stored procedure for set of transaction, what r the tranactions u r going to perform with the database..
elaborae the problem..
regards
Kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.