Search the VMware Knowledge Base (KB)
View by Article ID

Database in read-only mode under System Diagnostic Dashboard (2146543)

  • 0 Ratings

Symptoms

  • Database shows read only mode though we can make changes to vIDM configurations:

    • Change entitlement
    • Add/Remove Users /Groups/application, and so on.
  • Under SaaS Database Properties, the Database Read-Only is set to False.
  • In the horizon.log file, you see entries similar to:

    ERROR (main) [;;] com.vmware.horizon.datastore.impl.DbConnectionCheckServiceImpl - Error connecting the database
    com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'id_pkey' in the database. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216

Resolution

This issue is resolved in VMware Identity Manager 2.7, available at VMware Downloads.

To work around to this issue if you do not want to upgrade, drop the Temporary table.
 
Important: Take a backup of the database before making any changes.

  1. To find the temporary table, run the script:

    SELECT 

        OBJECT_NAME(OBJECT_ID) AS NameofConstraint

            ,SCHEMA_NAME(schema_id) AS SchemaName

            ,OBJECT_NAME(parent_object_id) AS TableName

            ,type_desc AS ConstraintType

        FROM sys.objects

        WHERE type_desc LIKE '%CONSTRAINT'
        
    AND OBJECT_NAME(OBJECT_ID)='XYZ'

  2. Replace XYZ with id_pkey.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 0 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 0 Ratings
Actions
KB: