- 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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.