IBM Support

After upgrading my WebReports web page gives me an HTTP 500 Error

Technote (troubleshooting)


Problem(Abstract)

An HTTP 500 error occurs because of the use of SQL Authentication and the remote database login credentials.

Resolving the problem

The WebReports database is on a remote database server. This error occurs because of the use of SQL Authentication and the remote database login credentials.
Note: It is best to use NT Authentication.
The SQL Auth entries in the registry are invalid or were removed.


To correct this error, check and validate or re-add the registry entries.

For additional details about remote database configuration and settings see the Remote Database Guide:
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/Tivoli%20Endpoint%20Manager/page/Remote%20Database%20Guide

TEM Web Reports Server Service
The TEM Web Reports Server service is responsible for handling Web Reports user communication with the database. The service puts data into and pulls data out of the BESReporting database. If this component is broken you will not be able to load the Web Reports login page.

SQL Authentication
Set the following registry keys on the TEM Server:

[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\FillAggregateDB]
String Value: "Username" = "<SQL Account Username>"

[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\FillAggregateDB]
String Value: "Password" = "<SQL Account Password>"

Configure the LocalBESReportingServer DSN to use SQL authentication instead of NT authentication and set its default database to be the BESReporting database.

Restart the TEM Web Reports Server service.

Historical Number

1710

Document information

More support for: IBM BigFix family

Software version: 8.0.584.0

Operating system(s): Platform Independent

Reference #: 1506232

Modified date: 08 September 2011


Translate this page: