1891033 - In which ASE version is CR 653511 fixed and does the fix require trace flag 7773 - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1891033 - In which ASE version is CR 653511 fixed and does the fix require trace flag 7773 - SAP ASE

Symptom

There are 2 CRs that reference traceflag 7773 , where one states this traceflag needs to be on and the other that it is now on by default:

  • CR 653511 states:
    If a stored procedure undergoes recompilation, and the procedure makes assumptions regarding session's state (ie session environment settings), the resulting recompiled plan can be significantly different to the original. This fix is only active when traceflag 7773 is active.
  • CR 730281 states:
    The sense of traceflag 7773 has been inverted. Use of traceflag 7773 now disables the fix for CR 653511, which is on by default

It needs to be clarified in which versions of Adaptive Server Enterprise (ASE) CR 653511 is fixed and in which versions traceflag 7773 is required to be ON.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise all versions

Keywords

trace flag, change request, fix , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.