Article ID: 114234, created on Jun 28, 2012, last review on Apr 28, 2014

  • Applies to:
  • Operations Automation


Task to create Sitebuilder site fails with error message Duplicate key violates unique constraint 'sb_ftp_hosts_pk' like in the example below:Task ID 218931
Queue name      sb_user34
Task name       Create Parallels Plesk Sitebuilder site ''
Task description        Create Parallels Plesk Sitebuilder site ''
Queue status    Failed    
Start not earlier than  Jun-20-2012 21:02
Method name     taskCreateSite on OBJREF:SiteBuilder:0:getCustomer:34
Last execution output   Duplicate key violates unique constraint 'sb_ftp_hosts_pk' while executing ' INSERT INTO sb_ftp_hosts (hostname, server_id, user_id, guid) VALUES( ?, ?, ?, ? )'.


A record with the same hostname and server ID is already present in the table sb_ftp_hosts in POA database and new one cannot be added due to the constraint.There is a misconfiguration in FTP settings of webspace on legacy shared hosting.


To solve the problem Provider may specify FTP prefix for physical hosting resource type used in the Service Template a customer subscription is based on (Apache Physical Hosting or IIS Physical Hosting), so FTP URL of a customer webspace will be unique.

Another way to solve the problem is to set the parameter Use IP-address of FTP server for website publishing of  SItebulder resource type in Service Template to No.

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF