Skip to main content
InSource Solutions

System Platform 2014 Galaxy Migration Failure

problem-solving.jpg
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