Search Engine: Elastic

Article ID: 134414, created on Jun 27, 2019, last review on Jun 27, 2019

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

Symptoms

Customer wants to add a domain in SpamExperts tab, however it failes with the error:

'domains' is invalid: Unique validation failed

There are at least two SpamExperts subscriptions assigned to the account.

Cause

When adding a domain in Spamexperts tab for subscription #209457 the following query was logged in osscore:/var/log/poa.debug.log:

plesk=> 
SELECT "AROS"."name", "AROS"."value", "AROS"."uuid" FROM (("aps_registry_object_setting" "AROS" INNER JOIN "aps_registry_object" "ARO2" ON ("AROS"."registry_object_id" = "ARO2"."id") AND ("ARO2"."uid" <> '')) INNER JOIN "aps_resource" "AR" ON "ARO2"."id" = "AR"."registry_object_id") WHERE (("AR"."app_id" IN (SELECT "AA"."id" FROM (("aps_application" "AA" INNER JOIN "aps_registry_object" "ARO1" ON "AA"."registry_object_id" = "ARO1"."id") INNER JOIN "aps_registry_object_tag" "AROT" ON (("ARO1"."id" = "AROT"."registry_object_id") AND ("AROT"."name" = 'owner')) AND ("AROT"."value" = '6299341')))) AND ( NOT (("AROS"."uuid" IS NULL) OR ("AROS"."uuid" = '')))) AND ((("AROS"."uuid" = 'context_domains_spamexperts-integration') AND ("AROS"."value" = 'example.com')) OR (("AROS"."uuid" = 'context_provisioned_domains_spamexperts-integration') AND ("AROS"."value" = ''))) ORDER BY "AROS"."name";
        name         | value |                        uuid
---------------------+-------+-----------------------------------------------------
 provisioned_domains |       | context_provisioned_domains_spamexperts-integration

New subscription attempts to be provisioned with NULL value for SpamExperts domains and since NULL value already exists for another subscription, it is considered to be duplicated.

Resolution

The solution is to temporary disable Activation Parameter Automatically provision application for resource SpamExperts and resubmit the order. After the order completes successfully, you can login to CCP and create an instance of SpamExperts application if required.

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

Email subscription for changes to this article
Save as PDF