Search Engine: Elastic

Article ID: 123773, created on Dec 3, 2014, last review on Jul 14, 2018

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

Symptoms

Attempt to delete the Hardware Node fails with the error in Provider Control Panel:

Host deletion failed There are customer services installed on the host. Try to remove them first. 

The following error is shown in /var/log/pa/core.log on the Management Node:

'SELECT 1 FROM dual WHERE EXISTS (SELECT 1 FROM aps_dedicated_service_instances WHERE vps_host_id =  ? AND status !=  ? AND NOT EXISTS (SELECT 1 FROM aps_dedicated_service_instances WHERE app_instance_id = si.app_instance_id AND service_instance_id < si.service_instance_id))'($0 = 18, $1 = 'x')
Apr  1 16:17:47 DC4HP14PAROSS01 : DBG [1:2232:15ac:1 1:2232:bb8 Kernel]: STMT [Con:58, 0C80F938 txn:3785074] ' SELECT app_instance_id FROM aps_external_application_instances WHERE host_id =  ?'($0 = 18)
Apr  1 16:17:47 DC4HP14PAROSS01 : DBG [1:2232:15ac:1 1:3524:10f4 lib]: [txn:3785074 Plesk::APS::APSManager_impl::onPrepareRemoveHost] {module_id="HostManager"; code="40"} Host #18 is busy by services that are controlled by SC #27.

Cause

This host was used for provisioning of some 'External System' APS, and related records were left in OA system database.

Resolution

Please contact TAM or Pooled Technical Associates (pta@odin.com) to resolve the issue.

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e 5b048d9bddf8048a00aba7e0bdadef37 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF