Article ID: 129275, created on Aug 19, 2016, last review on Aug 19, 2016

  • Applies to:
  • Operations Automation 6.0
  • Operations Automation 5.5

Symptoms

Whenever a customer places an order to purchase a Linux Shared Hosting subscription, the following error is thrown:

Service Creation Failed: Parallels Operations Automation error # == Error while calling pem.activateSubscription ==error_code = 0error_message = Virtual host 'www.d1234567-1699.domain.tld' already exist.Subscription #1234567 does not exist..

Investigation of OA main system log shows that there was an attempt to insert record d1234567-1699 twice:

  • First attempt - it was successful:

    Apr 30 15:28:59 poa : DBG [1:60735:b30e0b90:134 1:60735:b07f6b90 Kernel]: STMT [Con: 58549, 0x88a8ad0 txn:73743] ' SELECT 1 AS c  FROM apache_hostlist h  JOIN apache_homedir_entries he  ON (h.homedir_id = he.homedir_id)  WHERE h.service_id =  ? AND LOWER(he.recordname || '.' || he.domain_name)  IN (LOWER( ? ), LOWER( ? ))  OR LOWER(he.domain_name) IN (LOWER( ? ))'($0 = 40, $1 = 'www.d1234567-1699.domain.tld', $2 = 'www.d1234567-1699.domain.tld', $3 = 'www.d1234567-1699.domain.tld')
    
  • Here is the second attempt - it failed with the following error:

    Apr 30 15:29:04 poa : DBG [1:60735:b30e0b90:134 1:60735:b07f6b90 Kernel]: STMT [Con: 58549, 0x88a8ad0 txn:73743] ' SELECT 1 AS c  FROM apache_hostlist h  JOIN apache_homedir_entries he  ON (h.homedir_id = he.homedir_id)  WHERE h.service_id =  ? AND LOWER(he.recordname || '.' || he.domain_name)  IN (LOWER( ? ), LOWER( ? ))  OR LOWER(he.domain_name) IN (LOWER( ? ))'($0 = 40, $1 = 'www.d1234567-1699.domain.tld', $2 = 'd1005497-1704.mtnbusiness.cm', $3 = 'www.d1234567-1699.domain.tld')
    Apr 30 15:29:04 poa : DBG [1:60735:b30e0b90:134 1:60983:b19d2b90 lib]: [txn:73743 apache::Service_impl::createMainDS] {module_id="Apache"; code="600"; old_code="7"} Virtual host 'www.d1234567-1699.domain.tld' already exist.
    

Cause

The reason of this duplicate insertion is a misconfiguration in the Linux Shared Hosting Service Template on the OA side. The Service Template has two Linux Shared Hosting related resources. In the activation parameters of this service template the Web prefix for Provider Domains and the Default Domain's Identifier parameters for both of those resources have the same value.

Resolution

Remove one of the resources from the Service Template, cancel the current order and place a new order.

Alternatively, you can change either of the Web prefix for Provider Domains or the Default Domain's Identifier parameters in one of the Linux Shared Hosting resources so it does not match the other one, then try placing a new order.

Search Words

Service

Linux Shared Hosting

parameters

Service template

Parallels Operations Automation error #extype_id #600, module_id #Apache, Virtual host

misconfiguration

order

Virtual host already exist

Template

hosting

fail

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF