JDBC receiver channel error

[Former Member]

Hi All,

We are facing the error in receiver jdbc channel stating as

"Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CSSV.AIT016_CRM_CSS_STG' (structure 'StatementName'): com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=FULL_NAME, DRIVER=3.51.90"

Any inputs are welocme.

Regards,

Sabitha.

[former_member463616]

Hi,

Your structure is might not be corrent.

Please see the following steps, you should follow, while creating structure.

MT_Structure

--->Statement

-

---

>dbTableName

action

table

--->access

Regards,

Rajesh

[Former Member]

Hi,

The structure was the same as mentioned.

[Former Member]

Hi,

Can you please post the target payload in the SXMB_MONI.

So that some1 here will check and update if any..

Babu

[Former Member]

The target payload is having so many fields.

My target payload structure is in the below format

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_******** xmlns:ns0="*********">

<StatementName>

<dbTableName action="INSERT">

<table>CSSV.AIT016_CRM_CSS_STG</table>

<access>

<field1>abc</field1>

<field2>def</field2>

..

..

..</access>

<access>

<field1></field1>

<field2></field2>

.....

</access>

<access><field1></field1>

<field2></field2>

.....

</access>

</dbTableName>

</StatementName>

</ns0:MT_************>

[Former Member]

Hi,

Are you sure that the table name is CSSV.AIT016_CRM_CSS_STG? Please check once again.

Can you login to a client of this DB2 Server u have mentioned in CC, and execute a SQL statement using a simple insert into

the same table. And correspondingly change the mapping again.

Also check if you have Insert access to the table.

So once you are able to insert a record using the SQL normal query from any client , you can also insert from the XML structure.

Babu

[Former Member]

Getting new error in receiver JDBC channel .

SQLCODE=-803, SQLSTATE=23505, SQLERRMC=AIT016I1;0000001303, DRIVER=3.51.90

[former_member208856]

The structure created by you for Receiver JDBC Communication is not correct.

The error is for StatementName.

Please create correct structure for Statement.

[former_member200962]

check the JDBC structure generated by the mapping...if you provide the same here then may be someone will be able to help you.