Article ID: 118425, created on Nov 4, 2013, last review on May 7, 2014

  • Applies to:
  • Plesk Automation

Symptoms

I created subscription, but provisioning failed on task "Create the blank subscription" with the following error:

Duplicate key violates unique constraint 'plesk_subscriptions_pk0' while executing ' INSERT INTO plesk_subscriptions (ext_id, is_brand) VALUES ( ?, ? )'.

Cause

Service Template misconfiguration. It is not possible to use two resources based on "Subscription Resource class" in one service template.

Resolution

  1. Go to service template which was used for subscription creation:

    Products > Service Templates > template name > Resources

  2. Make sure that resource "Number of domains" and "Number of subdomains" is not mentioned twice, if so - then it is needed to remove one of resources based on "Subscription Resource class".

Search Words

Duplicate key violates unique constraint

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF