Search Engine: Elastic

Article ID: 134136, created on Jun 11, 2019, last review on Jun 11, 2019

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

Symptoms

Upon removal a customer account that has domains / subscriptions / service users etc, everything is removed from the OA database except for the domains.

Also the issue can manifest itself in a different way: an attempt to remove a subdomain from CCP can fail with the following error:

Duplicate key violates unique constraint 'domains_uni0' while executing ' UPDATE domains SET deleted='y' WHERE domain_id = ?'.

Cause

There was a subdomain with same name that was canceled a long ago under the same customer with a different domain_id. One of the domain status was deleted = 'y'. OA did not perform validation while adding a second subdomain with the same name - this issue has been reported as POA-92217.

Domains remain in the domains table after removal, though its mode parameter is changed to d (deleted). This usually leads to a domain record duplication in database, which, in its turn, causes the issue POA-92217 to occur.

Resolution

POA-92217 was fixed in OA 7.0. To resolve the issue, please upgrade to at least 7.0. To workaround the issue, it is necessary to remove the records with mode = d from domains table manually. Please contact CloudBlue technical support to perform that operation.


WARNING Never perform database operations yourself, however obvious and simple they may seem.


0871c0b47b3b86ae3b1af4c2942cd0ce 8fc71f07abe5b233fea1ae0377cd5e3d 5356b422f65bdad1c3e9edca5d74a1ae 1941880841f714e458ae4dc3d9f3062d 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 dd79f16c76b9dca75205ab5e9f5465ea

Email subscription for changes to this article
Save as PDF