Return
-
Title
Error when manually upgrading the database to version 7.0 "Invalid column name 'ProductName'" -
Description
When attempting to upgrade the MessageStats database to version 7.0 using the SQL Migration Script the following error may be seen in the results of the SQL query:
Msg 207, Level 16, State 1, Procedure PR_GetAppInfo, Line 27 Invalid column name 'ProductName'.
-
Cause
You started using MessageStats before MessageStats 6.5 and are missing the ProductName column in the T_Configuration table
-
Resolution
Download the script from this article and continue with the upgrade:
https://support.quest.com/SolutionDetail.aspx?id=SOL98218&pr=MessageStats
-
Defect ID
TF00244508