Difference between revisions of "Zero Reports Available"
(Created page with "PTS 5 makes use of a domain service account to run reports. If the account has been disabled or the password expired, PTS will no longer be able to access the reports with the saved credentials, and the problem manifests as there being no report documents available to select from. =Symptoms= On the reports screen, you will be able to search and filter your prescription sample but you will not be able to select a report type, and the tab will read "Reports (0)". =Cause= T...") |
(→Cause) |
||
| Line 3: | Line 3: | ||
On the reports screen, you will be able to search and filter your prescription sample but you will not be able to select a report type, and the tab will read "Reports (0)". | On the reports screen, you will be able to search and filter your prescription sample but you will not be able to select a report type, and the tab will read "Reports (0)". | ||
=Cause= | =Cause= | ||
The service account that was setup for this purpose has either been disabled or the password has expired | <ol> | ||
<li>The service account that was setup for this purpose has either been disabled, or the password has expired</li> | |||
<li>On the SSRS server, the "SQL Server Reporting Services" Windows service has been stopped, disabled, or set to manual start type</li> | |||
</ol> | |||
=Solution= | =Solution= | ||
Go to Applications Settings and verify the information in the following settings: | Go to Applications Settings and verify the information in the following settings: | ||
Revision as of 10:30, 19 January 2023
PTS 5 makes use of a domain service account to run reports. If the account has been disabled or the password expired, PTS will no longer be able to access the reports with the saved credentials, and the problem manifests as there being no report documents available to select from.
Symptoms
On the reports screen, you will be able to search and filter your prescription sample but you will not be able to select a report type, and the tab will read "Reports (0)".
Cause
- The service account that was setup for this purpose has either been disabled, or the password has expired
- On the SSRS server, the "SQL Server Reporting Services" Windows service has been stopped, disabled, or set to manual start type
Solution
Go to Applications Settings and verify the information in the following settings:
- SSRS Reports Service User
- SSRS Reports Service Password
More than likely, due to an expired password, a new password for the account will have to be created by IT and entered into the SSRS Reports Service Password setting.
To prevent the issue from reoccurring, IT need to prevent the account from being disabled, and the password from expiring.