on 09-20-2010 1:33 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.