Problem adapter JDBC/Receiver

[Former Member]

Hello,

I am running a stored procedure with CC JDBC/Receiver, and it returned me the following error:

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_consulta_carteira_clientes' (structure 'Statement'): java.sql.SQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

Can anyone help me, CC JDBC / Receiver, does not support transactional multi processing ?

Thank you all.

Marlon

[former_member241146 · Accepted solution]

Hi Marlon.

Try to change The Transaction Level in the Communication Channel JDBC, maybe it works.

Ask to Legacy Team can change the stored procedure without CREATE TABLE command.

Regards.

Bruno

[Former Member]

You are not allowed to use CREATE TABLE command within a multi-statement transaction.

For more information and possible solution go through this link..

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/34899