search cancel

CA WAAE Application server has failed with "Procedure cache exhausted before a query plan could be found".

book

Article ID: 215696

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

CA WAAE Application Server has failed with below error message.

[02/11/2021 07:32:19]      CAUAJM_E_18018 Server message: Message number(722), Severity(17), State(1), Line(1), Message String: Procedure cache exhausted before a query plan could be found.

Environment

Release : 11.3.6 plus versions using SYSBASE DB

Component : CA Workload Automation AE (AutoSys)

Resolution

Its SYBASE DATABASE issue, need to increase the Procedure cache memory in SYSBASE. If it has enough memory then you may need to contact SYBASE support. App Server log is just showing the error and failing due to Sybase problem.