Skip to Content
avatar image
Former Member

status of KBA2462416

Greetings experts,

Loks like we are having the problem described in KBA2462416 - Error 11060 "This statement has exceeded the maximum number of recompilations" with nested views and procedures

(our current production is SP02 PL05 HF2).

I was happy to see in the KBA that it is fixed in (info from KBA):

SAP CR 807528 is fixed in:

  • SAP ASE 15.7 SP140
  • SAP ASE 16.0 SP02 PL07
  • SAP ASE 16.0 SP03 PL03

But, reading the release notes from 16.0 SP02 PL07, I could not find this fix.

Please, is this fix present in SP02 PL07? Any info when will there a fix?

Best wishes,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 28, 2017 at 10:16 PM

    Hi Edison,

    Some time after KBA 2462416 was published a problem was found with the fix for CR 807528 and the code changes for it were backed out, so it wasn't included in 16.0 SP02 PL07 as planned.
    Engineering is reworking the problem under a new CR, 811850. A proposed fix is being reviewed and may possibly make it into the 16.0 SP02 PL08 release. I will update the KBA.

    -bret

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Edison,

      As this issue is hitting you hard, I recommend you open an incident with support (if you don't already have one) to request that a 1-off ebf be generated for you as soon as the CR is fixed so you don't have to wait for the next PL rollup release (which could be months later, we are currently only releasing about 2-3 rollups a year).

      Cheers,
      -bret