Symptom
While accessing a proxy table and the ASE is configured for "functionality group" or "streamlined dynamic SQL" and a recompilation occurs, the following errors can be seen
-
Msg 137, Level 15, State 2:
Server 'remote_ASE', Procedure 'trigger_1', Line 3:
Must declare variable '@p1'.Command has been aborted.
Also any of the variations of the 5605 error
- Msg 5605, Level 16, State 1:
Server 'local_ASE', Line 1:
Prepare transaction RPC to the remote server 'remote_ASE' failed. Transaction key '3905000002000000fc0a067d0200'. Return status -2 -
Msg 5605, Level 16, State 1:
Server 'local_ASE', Procedure 'tr1', Line 9:
Save transaction RPC to the remote server 'remote_ASE' failed. Transaction key 'a2f70900120000002d91267c0600'. Return status -6. -
Msg 5605, Level 16, State 1:
Server 'local_ASE', Procedure 'tr1', Line 13:
Rollback transaction RPC to the remote server 'remote_ASE' failed. Transaction key 'a2f70900120000002d91267c0600'. Return status -7.
Read more...
Environment
This problem can be found in the following releases
- SAP Adaptive Server Enterprise (ASE)
- 15.7 SP130, SP132, SP133, SP134, SP135
- 16.0 SP01, SP01 PL01, SP01 PL02
Product
Keywords
CIS, proxy, 779787 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem
About this page
This 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.