System Platform 2014 Galaxy Migration Failure
SOLVER |
Description
This article summarizes a problem and resolution to an undocumented issue involving migrating a System Platform 2014R2 galaxy to version 2014 after upgrading the software.
Author | Rufus Handsome |
Publish Date | 1/6/2014 |
Applies to Software | System Platform |
Applies to Version | 2014 |
Applies to System/Module | None |
Article Version | 01.01.01 |
************************************************************************************************************************************************************
Problem
When opening the IDE and connecting to the galaxy, the user is presented with an informational dialog box indicating that the previous galaxy is older and needs to migrated to the current version. When answering the yes, the process immediately fails. No failure indications are given in the SMC Logger or Windows Event Viewer.
Resolution
Intermittent SQL errors have been observed during migration of Galaxies. During Galaxy migration, some internal stored procedures invoke the xp_cmdshell stored procedure. The xp_cmdshell stored procedure is enabled and disabled by the xp_cmdshell server configuration option.
If the xp_cmdshell server configuration option is disabled (set to 0), either by another application, or manually by an administrator, and one or more migration processes attempt to call the xp_cmdshell stored procedure, SQL errors will occur.
Disabling the xp_cmdshell stored procedure may also prevent other operations, such as deleting objects, from completing properly.
To avoid these problems, do not disable the xp_cmdshell server configuration option.
If the option has been disabled, run the sp_configure system stored procedure to enable the option:
1. Prime advanced options for the change:
EXEC sp_configure ‘show advanced options’, 1 GO
RECONFIGURE
GO
2. Enable the feature:
EXEC sp_configure ‘xp_cmdshell’, 1
GO
RECONFIGURE
GO