installing repository but get error "Cannot insert NULL value" (45533)
installing repository but get error "Cannot insert NULL value"
During upgrade of the Repository Database, the installer fails.
During upgrade repository database the installer has two major problems:
On some SQL server instances the Server host name return NULL, that cause us to failed since we can't add NULL value to the host name on QUEST_INSTANCE_DIM .
When objects create partially we failed to run drop on a table that associated with constrain
Download the two scripts from the Attachment
Replace the advisory script "quest_pa_rep_create_advtables_mssql.sql" located at <QUEST_HOME>\agents\SC_MSSQL\6.0\data, on the MiddleWare host machine (backup first).
Replace quest_pa_rep_insert_advdata_mssql.sql located at <QUEST_HOME>\agents\SC_MSSQL\6.0\data, on the MiddleWare host machine (backup first).
Proceed adding repository with the installer
NOTE: This issue can happen also when the Database is created as a new one, during upgrading.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED.