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.
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.
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.
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy