Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

Timeout During Enhanced report

SOLVED
Go to solution
shocko
Honored Contributor

Timeout During Enhanced report

Hi,

trying to run the enhanced report 'Contract and Warranty Information' and get the attached message. Any ideas? Perhaps I need to increase the SQL timeout value in some config file?

If my post was helpful please award me Kudos! or Points :)
6 REPLIES
shocko
Honored Contributor

Re: Timeout During Enhanced report

Typically I forgot to attach the screenshot.

 

Note:Sensitive info removed

If my post was helpful please award me Kudos! or Points :)
shocko
Honored Contributor

Re: Timeout During Enhanced report

Ok,

It looks like its pointing at a non-existent DB for some reason! I think this may be due to an upgrade we did earlier this year. I'm searching through all files on the SIM server to find references to this old DB. Anyone know off the top of their heads where the enhanced reports get their config from?

If my post was helpful please award me Kudos! or Points :)
shocko
Honored Contributor

Re: Timeout During Enhanced report

It's a JDBC connection so not in ODBC in Administrative Tools but i did find an old Sytem DSN in there pointing at the old DB which leads me to believe this is as a result of the upgrade.
If my post was helpful please award me Kudos! or Points :)
shocko
Honored Contributor

Re: Timeout During Enhanced report

Found a reference to the old DB under:

 

  • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\Insight_v50_0

 

Changed it to the new DB and will restart the SIM services and see what happens.

If my post was helpful please award me Kudos! or Points :)
shocko
Honored Contributor
Solution

Re: Timeout During Enhanced report

HP support solved this one for me. Here is the solution:

 

1. Open the reports.xml file at the following locations and change the timestamp.

  • <SIM Installation directory> /config/preload/6X/addfiles/reports.xml
  • <SIM Installation directory> /config/preload-plugins/6X/<plugin name>/addfiles/reports.xml
  • Enter a space at the end of each file to update the timestamp.

2. Close and save the file.

3. Go to the command prompt and execute the mxconfigrefresh command.

If my post was helpful please award me Kudos! or Points :)
aurllk
Occasional Visitor

Re: Timeout During Enhanced report

worked for me!!! thak's