Problem:

Why might I get a "Failed to execute DDL statement" error when trying to connect to my database after upgrading from SilkCentral Test Manager 8.1 to SCTM 8.1.1?

Resolution:

QUESTION
----------------------------------

Why might I get a "Failed to execute DDL statement" error when trying to connect to my database after upgrading from SilkCentral Test Manager 8.1 to SilkCentral Test Manager 8.1.1?

ANSWER
----------------------------------

If you receive the following error message when upgrading, then it is likely that you have a case sensitive database;

"Failed to execute DDL statement (C:\Program Files\Segue\SC Test Manager 8.1.1\conf\AppServer\DbUpgrade\TM_3175.MSSQL.ddl - Line 1): [SKVQSXIT\BISKVI1]Column name "REQTREENODEID_PK_FK" does not exist in the target table."

Try editing the file TM_3175.MSSQL.ddl, located in the install path on the application server (Conf\AppServer\DbUpgrade), replacing the following single line;

create index IDX_ReqHist_RevisionNumber ON TM_RequirementsHistories(REQTREENODEID_PK_FK ASC, RevisionNumber DESC);

with;

create index IDX_ReqHist_RevisionNumber ON TM_RequirementsHistories(ReqTreeNodeID_pk_fk ASC, RevisionNumber DESC);