What can cause a "Report Service responds with error code 500" error when viewing Birt reports?
It has been reported that when viewing the overview report or any other Birt based reports within SilkCentral Test Manager 2008 the user may be presented with the following error:
Chart Server error
URL = "http://localhost:19126/BirtServer"
Message = Report Service responds with error code 500
Upon examination of the Chart Server log file look for the following entry:
required parameter values are not set or set to incompatible data
This is referencing the connection string passed to the database.
This issue tends to occur where users have installed their own full MSSQL database. When creating a user for connecting to the database the use may not have specified a password, opting for an empty/blank password.
When setting the connection within SilkCentral Test Manager to the database all is well and a successful connection can be made with the credentials, however the connection data passed to the Brit chart server will cause this issue, ie the connection string is in the form of sa, “” …..
To resolve this issue you must specify a password for the user credential used to connect to the database.