Unable to open a subscription: No subscriptions are listed for your account; therefore, no operations are available. Please contact your service provider for assistance with subscribing to the services

Symptoms

• Accessing a subscription via Plesk > Subscriptions fails with the following warning:

  PLESK_WARN: Warning: No subscriptions are listed for your account; therefore, no operations are available. Please contact your service provider for assistance with subscribing to the services.

• The following errors can be found in the /var/log/plesk/panel.log or %plesk_dir%adminlogsphp_error.log files with the enabled debug logging:

  DEBUG [panel] Smb_Exception: Access to the foreign subscription is denied.
   
   WARN [panel] No subscriptions are listed for your account; therefore, no operations are available. 
   Please contact your service provider for assistance with subscribing to the services. 
   
   DEBUG [panel] Unable to access task/task-progress without subscription

• The enabled show.sql_query option in the panel.ini file provides with the following info in the /var/log/plesk/panel.log or %plesk_dir%adminlogsphp_error.log files:

  DEBUG [dbquery] [38] SQL: SELECT domains.* FROM domains WHERE (cl_id = 1 AND webspace_id = '0' AND id = '-1')

• The smb_users.subscriptionDomainId table contains an incorrect value:

  # plesk db “select id,login,subscriptionDomainId from smb_users where subscriptionDomainId=‘-1’“

  +—-+———————-+———————-+
  | id | login | subscriptionDomainId |
  +—-+———————-+———————-+
  | 1 | admin | -1 |
  | 1 | user1 | -1 |
  +—-+———————-+———————-+

Cause

Database inconsistencies in the smb_users table.

Resolution

1. Connect to the server via SSH or RDP.

2. Create a backup of the psa database.

3. Update the subscriptionDomainId value with the proper value:

   # plesk db “update smb_users set subscriptionDomainId=”0″ where subscriptionDomainId=”-1″ and isBuiltIn=1;”