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 Adaptive Server Enterprise , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.