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.