Article ID: 120612, created on Mar 19, 2014, last review on Aug 8, 2015

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Cannot migrate the subscription with MSSQL database resource:

  File "/usr/lib/python2.7/site-packages/parallels/common/migrator.py", line 993, in _get_active_node_ids
    if host.index('\\') != -1:
ValueError: substring not found
[ERROR] | Unexpected error: 'substring not found', migration is aborted. See the traceback above for more information.

Cause

The issue is caused by absence of MSSQL service node.

Source domain has MSSQL database and during the migration process PA tries to find appropriate service node for the migration. Basically MSSQL servers added through PA have the following host name pattern:

<..IP address..>\<..MSSQL server name..>

For example: 192.0.2.2\MSSQLSERVER

But external MSSQL server has only IP address as a host name, as a result migration tool cannot parse its host name properly and fails.

The behavior is caused by software issue PPA-771. The fix is included in MU #4.

Resolution

Update PA installation to the latest version:

/usr/local/ppa/bin/ppa_update --install-updates

Search Words

Unexpected error: 'substring not found', migration is aborted. See the traceback above for more information.

33a70544d00d562bbc5b17762c4ed2b3 e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF