Installation Note 54944: The 6.0R14U1 to 6.0R14U2 migration script might fail with errors during migration to SAS® Marketing Operations Management 6.3
 |  |  |  |
In SAS Marketing Operations Management 6.3, the script that migrates 6.0R14U1 to 6.0R14U2 might fail with the following errors:
Error 1:
Table or indexed view 'ALFCT_SEARCHABLE_FILE_TEXT' does not have a full-text index or user does not have permission to perform this action. at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlA ction action, Object execObject, DataSet fillDataSet, Boolean catchException) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Error 2:
System.Data.SqlClient.SqlException: Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'FISCALYEAR'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'QUARTER'. Invalid column name 'FISCALYEAR'. Invalid column name 'QUARTER'. at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlA ction action, Object execObject, DataSet fillDataSet, Boolean catchException) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
This problem occurs when the database execution mode is set to Automatic and one of the migration procedures tries to drop nonexistent objects.
In particular, you need to verify the existence of the FULLTEXT INDEX and FULLTEXT CATALOG objects before you start the migration. If these objects do not exist, you need to create them.
Contact SAS Technical Support if you require further assistance.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Operations Management | Microsoft® Windows® for x64 | 6.0_R14_U1 | 6.4 | ||
| Type: | Installation Note |
| Priority: | high |
| Date Modified: | 2015-01-07 15:22:45 |
| Date Created: | 2015-01-07 10:23:45 |