SAP Knowledge Base Article - Preview

2284618 - Error 7941 when sp_optgoal 'save' runs in compatibility mode - SAP ASE

Symptom

  • Running sp_optgoal "save" to generate a user defined optgoal fails with Error 7941 State 10:

Msg 7941, Level 16, State 10:
Server 'ASE', Procedure 'sp_optgoal', Line 156:
Couldn't find table .

  • when "compatibility mode" is enabled.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 ESD2 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE) 15.7 ESD2 and higher
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE) 16.0

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

user-defined, optimizer, kernel,  CR796088,  CR#796088,  796088 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

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.