Problem:

Why do I get an error message "Failed to execute DLL statement when upgrading SilkCentral Test Manager"

Resolution:

"Failed to execute DLL statement (C:\Program Files\Borland\SC Test Manager 2008 R2\Conf\Appserver\DbUpgrade\TM_xxxx.MSSQL - Line x): Cannot insert value NULL into column "ChangedAt", table "[databasename].dbo.TM_Attributes"; column does not allow null. INSERT fails."

This error may arise because the row within the table SCC_Project contains Null values in the column "ChangedAt".

To check if this is the case execute the following query from SQL Server Management Studio on the SilkCentral Test Manager Datbase

SELECT count(ProjectID_pk) as "Projects with null Changed At" from SCC_Projects where ChangedAt IS NULL

If the count is greater than zero then the following statment needs to be executed:

UPDATE SCC_Projects SET ChangedAt = GETUTCDATE() WHERE ChangedAt IS NULL

After this statement has been executed on the database, open SilkCentral Test Manager and reconnect to the database ensuring that the username connecting to the database has full system administrative privileges on the SilkCentral Test Manager database