Error: "Object cannot be cast from DBNull to other types" when upgrading to Archive Manager 5.1.2 (4328931)

Error: "Object cannot be cast from DBNull to other types" when upgrading to Archive Manager 5.1.2

When upgrading to Archive Manager 5.1.2 the below error is seen when configuring Active Directory Connector

2015-09-30 09:14:30,877 [68] INFO  ConfigurationController - Running - Configuring Active Directory Connector.
2015-09-30 09:14:31,142 [68] ERROR ConfigurationController - Error - Error configuring Active Directory Connector.
System.InvalidCastException: Object cannot be cast from DBNull to other types.

This is because the DomainName of the NDS LoginDomain entries is the same as the DomainName of the new AD domain. The LoginDomainInsert stored procedure is not performing an insert correctly and returning a DBNull for the LoginDomainID.

Disclaimer: The following resolution contains SQL Queries. SQL Queries are provided "As is" for reference purposes. Quest accepts no liability for issues arising from incorrect usage of SQL Queries. Please ensure that full and current database backups exist before making any changes to the Archive Manager database, if in doubt please contact support.

If no one authenticate to the NDS domain and the NDS domain controller is decommissioned already then please try to run the below query it will rename the DomainNames for NDS to OLDALS. This will allow the new ALS AD domain to be inserted correctly.

UPDATE LoginDomain SET DomainName = 'OLDALS' WHERE LDAPType = 'NDS'