Return
-
Title
After upgrade, the "Reports" link throwing error in web portal -
Description
After the Database was upgraded from 7.0.2 to 7.1.3, the web portal reports link throws the following error:
"VI.Base.ViException: Error during execution of statement: select ObjectKeyUsedBy, xdateupdated, UID_DialogParameterSet, DisplayName, xmarkedfordeletion from DialogParameterSet where (ObjectKeyUsedBy in (select XObjectKey from RPSSubscription where )) ---> VI.DB.DatabaseException: Database error 102: Incorrect syntax near ')'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near ')'."The same error is thrown with Devices & Assign Ownership links.
-
Cause
The configuration parameter RPS is not enabled.
Having the RPS parameter enabled makes the report subscription components available in the web portal. If this parameter is not enabled then attempting to access reports will result in a thrown exception.
-
Resolution
Enable the "RPS" parameter by opening Designer and navigating to Getting Started | Edit configuration parameters | QER | RPS.
Note that changes to this parameter require recompiling the database. -
Additional Information
Additional information pertaining to the configuration parameters for subscribable reports can be found here: Configuration Parameters for Subscribable Reports