SAP Knowledge Base Article - Preview

2519544 - Error 137 and 5605 when accessing a proxy table

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0

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.