AAI is not coming up after applying DB patch

Products

• Automation Analytics & Intelligence

Issue/Introduction

The AAI does not come up after DB patching. The system was in initialization phase for almost several hours and the web portal started throwing an error as page not found.

 

Environment

Release : 6.x

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Cause

DB Configuration

Resolution

The query below has a bad Plan.

==================================================================

from JobRun jr left join fetch jr.parent left join fetch jr.job job left join fetch job.type left join fetch jr.predecessors where   jr.scheduler.id = :schedulerId and jr.startTimeValue >= :fromTime and jr.futureRun = false order by jr.startTimeValue, jr.endTime

==================================================================

Please ask the DBA to improve the Plan of the query above.