Receiver CC JDBC error when calling an adapter

[Former Member]

Hi experts,

I have the next situation I hope you can help me. 

I´m working in a new installation of SAP PI 7.31 EHP1 and I have an error in a communication channel receiver JDBC.

I try to insert in a DB2 data base. But the system throws the next error.

Unable to execute statement for table or stored procedure. 'MQSI.TL_PRODIC_ENV' (Structure 'Statement_TL_PRODIC_ENV') due to com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001, SQLERRMC=Error when calling an adapter by using the communication cha, DRIVER=4.13.80

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MQSI.TL_PRODIC_ENV' (structure 'Statement_TL_PRODIC_ENV'): com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001, SQLERRMC=Error when calling an adapter by using the communication cha, DRIVER=4.13.80

I don´t know if the problem is a Driver of the data base or the adapter.

Thanks In Advance

Regards

[Former Member]

Hello everybody

Thanks for your support.

All your answers helped me.

The problem was in a Data Base. The IT team said me that they have a permition problem.

Regards

[gagandeep_batra]

Hi Monroy,

Error " SqlDataException" looks like some data problem check with that.

Also try to execute same procedure with same data direct on database.

Regards,

GAgandeep

[Former Member]

Hello!

Besides, looks like something with the stored procedure itself (either the values being sent or the data types declared), according to the -443 exception:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2F...

BR,

Lucas Santos

[zameerf]

Hi Francisco,

I guess you have to cross check your JDBC structure used in mapping.

Did you follow as per the SAP Help?

Can you share your structure screenshot?

[baskar_gopalakrishnan2]

>I don´t know if the problem is a Driver of the data base or the adapter.

The error does not show that it's driver issue.

[Former Member]

Hello!

1. Can you run manually the stored procedure on the database?

2. Try setting the logSQLStatement debug parameter on the receiver channel (OSS note #801367). This will log the executed/generated query on the defaultTrace.trc file.

3. Are regular queries (no stored proc.) on receiver JDBC channel working?

BR,

Lucas Santos

[Former Member]

Hi Lucas,

Thanks fot your support.

I solved the problem.

I don´t try to insert in all the tables that I want to insert direct on data base. I only test in one table.

Regards