Tech Tip: The validation of the Report Server connection failed. This could  be due to the Report Server being offline

Document created by PFagan Employee on Aug 8, 2014Last modified by Melissa Potvin on Sep 5, 2014
Version 4Show Document
  • View in full screen mode

When validating the Report Server connection parameters in the UI admin Report Configuration page, the message can occur

"The validation of the Report Server connection failed. This could  be due to the Report Server being offline"

 

After clicking "OK" the message

"Error: Configuration was not saved due to a database connection failure." is displayed.

 

The Report Configuration parameters are stored in the AdminConfiguration table in the SAMStore.

 

To check if the parameters entered in the "Report Configuration" UI Admin page have been correctly updated in the

AdminConfiguration SQL table, the SQL query below can be run

 

 

SELECT * from [SAMStore].[dbo].[AdminConfiguration] where ConfType like

'Report'

 

If the parameters are correctly listed and the reports can be accessed, the validation message is probably

cosmetic.

 

It may be occurring because of a corrupt/badly compiled version of the loadjsonReportService.jsp file.

 

Run the steps below and check if they resolve the validation error message

 

- stop the UI service

- delete the folders below

..\SamUI\work

..\SamUI\temp

- start the UI service

Attachments

    Outcomes