SOI UI getting huge delay in starting instead of quick (approx 2 mins)

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

SOI UI was delayed in starting instead of quick (approx 2 mins) .

and found the ERROR in soi manager log as below

 INFO [ServletInit] ?.?(?) - Found xxx groups.

 INFO [ServletInit] ?.?(?) - Found yyy users.

 INFO [ServletInit] ?.?(?) - PersistentStorageWrapper has not initialized properly.

 INFO [ServletInit] ?.?(?) - Manager initialization failed [count=1]. Will try again after 15 seconds.

 INFO [ServletInit] ?.?(?) - PersistentStorageWrapper has not initialized properly.

 [ServletInit] ?.?(?) - Manager initialization failed [count=2]. Will try again after 15 seconds.

Environment

Version of SOI is 4.2 with patch SO09444 /cu3

Cause

Database issue.

Resolution

> run registry downloader> to check registry is correct or not >this is ok.

>user-mgt.xml and registry.xml both are fine. 

> after checking the SOI manager log in details > we found lots of data base query connection timeout messages  and  few other data based related issues.

> Database side ran some query to verify the health but they never returned with value  so their DB health is not good > Basically  customer has too much data in alert history and alerts

so they have clean up them to make soi fully functional after taking back up.

> For now their DBA has re-started the database (SQLServer ) service and soi ui Is working faster as expected .