topic Re: Timeout During Enhanced report in Server Management - Systems Insight Manager

Timeout During Enhanced report

shocko — Tue, 04 Oct 2011 17:11:01 GMT

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?

Re: Timeout During Enhanced report

shocko — Tue, 04 Oct 2011 17:12:35 GMT

Typically I forgot to attach the screenshot.

Note:Sensitive info removed

Re: Timeout During Enhanced report

shocko — Wed, 05 Oct 2011 12:52:41 GMT

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?

Re: Timeout During Enhanced report

shocko — Wed, 05 Oct 2011 12:58:03 GMT

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.

Re: Timeout During Enhanced report

shocko — Wed, 05 Oct 2011 13:43:01 GMT

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.

Re: Timeout During Enhanced report

shocko — Thu, 06 Oct 2011 19:06:59 GMT

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.

Re: Timeout During Enhanced report

aurllk — Wed, 28 May 2014 09:56:53 GMT

worked for me!!! thak's