Article ID: 125036, created on Mar 27, 2015, last review on Apr 3, 2015

  • Applies to:
  • Operations Automation
  • Business Automation 5.5

Symptoms

When trying to disable subscription or process Cancellation order to disable it following error is returned:

Removing of Service of Subscription #1001141 is failed. Stop service of Order Item #60851 failed. 
There is no FTP access to log files in homedir with ID = <HD_ID>.

Cause

The reason of this error is that there is obsolete record in POA database which did not have any records in referenced tables, for example:

plesk=> SELECT  *  FROM proftpd_lfa_data WHERE hd_id =  <HD_ID>;
   login    | vhost_id | hd_id  | rti_id   | state_flg
------------+----------+--------+----------+-----------
 lfag101250 |        5 | 101250 | <RTI_ID> |         1
(1 row)

Such record can left after webspace removal due to the software issue with ID #POA-85768 which has been fixed in POA 5.5 update 8, but still can occur if the webspace in question was removed prior to POA 5.5 update 8 installation.

Ultimate removal of these records will be done in scope of POA-91548.

Resolution

First check:

plesk=# select * from domain_services where hd_id = <HD_ID>;
 ds_id | owner_id | domain_id | subscription_id | hd_id | service_id | name | creation_date | is_locked
-------+----------+-----------+-----------------+-------+------------+------+---------------+-----------
(0 rows)

If no relevant records are found then remove obsolete record from POA DB:

plesk=> DELETE FROM proftpd_lfa_data WHERE hd_id = <HD_ID> and rti_id =  <RTI_ID>;

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 5356b422f65bdad1c3e9edca5d74a1ae

Email subscription for changes to this article
Save as PDF