jdbc error

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

hi

check this thread with similar issue

regards

kummari

[former_member238007]

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