UMC Console is accessible but not populating data. The Java policy editor only shows canned policies but no other policies are displayed. The error message displayed below, from UMC, prescribes adding the DCS server certificate into the browser's certificate store. If this has already been completed and the assets are still not displayed, verify connectivity to the management server's database and that the scsp_ops user has full permission thereto.
java.sql.SQLException: The EXECUTE permission was denied on the object '<object>', database '<database_name>', schema 'dbo'.
System Error: Unable to connect to DCS: Server. Ensure that you have accepted the DCS: Server certificate in the web browser. If the problem persists, contact service administrator.
Since the UMC console can still be accessed there most likely is not an issue connecting to the database (on 6.7 and later), in this case the scsp_ops user lacks the necessary permissions to modify the database.
Ensure that the scsp_ops user has DBO permissions on the DCS management database and the management server has access thereto. Once permissions are restored, restart the DCS manager.
Subscribing will provide email updates when this Article is updated. Login is required.