2086044 - SUM upgrade produces SQL Error 563 and 225 - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2086044 - SUM upgrade produces SQL Error 563 and 225 - SAP ASE

Symptom

  • the SUM upgrade fails at severe errors that occur in phase <phasename>
  • ASE produces SQL error 563 and 225 when querying table <tablename>
  • A 225 error
    "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization"
  • BE***LOG BY4=> sql error 563    performing SEL on table <tablename>                        
    BE***LOG BY0=> [ASE Error SQL225][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization
    BE[ASE Error SQL563:3C000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is already another cursor with the name '<cursor>' at the nesting level '0'.
    BE[ASE Error SQL563:3C000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is already another cursor with the name '<cursor>' at the nesting level '0'.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - Microsoft Windows NT
  • Microsoft Windows NT

Product

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

Keywords

Error 225, Msg 225, Msg 563, Error 563, SQL, SUM, CR769886, CR#769886, 769886 , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.