SAP Knowledge Base Article - Preview

2791952 - Errors 7941 and 11060 (too many recompilations) when using view - SAP ASE

Symptom

  • Executing SQL statement that includes cross database procedure and views.
  • Results in Errors 7941 and 11060: 

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

Msg 11060, Level 16, State 1:
Server 'ASE', Procedure 'proc_1', Line 1:
This statement has exceeded the maximum number of recompilations (20).
This indicates an internal error. Please note the error prior to this one and contact SAP Technical Support.
(return status = -6)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR817964, CR#817964, 817964, CR818939, CR#818939, 818939, CR818897, CR#818897, 818897, renormalization , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.