Timeout During Enhanced report

[shocko]

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?

[shocko]

Typically I forgot to attach the screenshot.

Note:Sensitive info removed

[shocko]

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?

[shocko]

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.

[shocko]

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.

[shocko · Accepted solution]

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.

[aurllk]

worked for me!!! thak's