- Getting Error 2762 when executing a remote procedure:
-- procedure on the local ASE server
create proc hc_dev_t2_issue
print ' At tier2 about to call tier3 stored procedure '
BEGIN TRAN devtest
print ' At tier2 after to call tier3 stored procedure '
COMMIT TRAN devtest
-- procedure on the ASE remote server - called by procedure in the local ASE server
create proc hc_dev_t3_issue
print ' At tier3 '
create table #test ( smt_id int )
BEGIN TRAN T3tran
insert into #test
select smt_id from testdb..smt
COMMIT TRAN T3tran
select * from #test
-- execute the procedure on the local ASE server
At tier2 about to call tier3 stored procedure
Msg 2762, Level 16, State 3:
Server 'ASE_2', Procedure 'hc_dev_t3_issue', Line 8:
The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.
Msg 208, Level 16, State 6:
Server 'ASE_2', Procedure 'hc_dev_t3_issue', Line 14:
#test not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 2.
At tier2 after to call tier3 stored procedure
Msg 5605, Level 16, State 1:
Server 'ASE_22', Procedure 'hc_dev_t2_issue', Line 14:
Prepare transaction RPC to the remote server 'T3_ASE' failed. Transaction key '000098d4000b00004ed954d80004'. Return status -128.
(return status = -6)
- The same RPC call works fine in another environment.
- SAP Adaptive Server Enterprise 12.5.x
- SAP Adaptive Server Enterprise 15.x
- SAP Adaptive Server Enterprise 16.0
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.