Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

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

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

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


Old KB# 25167

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:53
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.