Article ID: 126184, created on Jul 14, 2015, last review on Jul 14, 2015

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

All domains of a Plesk node are not shown in OBAS, causing all the websites to go offline.

Cause

System user of some subscription is absent. As a result, Plesk returns an error in responce to the XML API request "get domain list":

======================================

Request

<packet version="1.6.6.0">
<webspace>
  <get>
    <filter/>
    <dataset>
        <hosting/>
    </dataset>
  </get>
</webspace>
</packet>

======================================
Response

<?xml version="1.0" encoding="UTF-8"?>
<packet version="1.6.6.0">
  <webspace>
    <get>
      <result>
        <status>error</status>
        <errcode>1002</errcode>
        <errtext>Unable to load object of type SysUser with id=666: SysUser: unable to select: no such row in the table</errtext>
      </result>
    </get>
  </webspace>
  <output>/opt/psa/admin/plib/functions.php:1641
/opt/psa/admin/plib/api-rpc/AgentHosting.php:627
/opt/psa/admin/plib/api-rpc/AgentWebSpace.php:573
/opt/psa/admin/plib/api-rpc/AgentWebSpace.php:1323
/opt/psa/admin/plib/api-rpc/AgentHosting.php:1751
/opt/psa/admin/plib/api-rpc/PleskAPIOperator.php:125
/opt/psa/admin/plib/api-rpc/PleskAPIOperator.php:70
/opt/psa/admin/plib/api-rpc/Agent.php:577
/opt/psa/admin/plib/api-rpc/PleskAPIOperator.php:125
/opt/psa/admin/plib/api-rpc/PleskAPIOperator.php:70
/opt/psa/admin/plib/api-rpc/Agent.php:205
/opt/psa/admin/htdocs/enterprise/control/agent.php:10
</output>
</packet>

Resolution

To resolve the issue, please fix the issue on the Plesk node (contact Odin Technical Support if necessary) and launch OBAS Plesk node synchronization under Top > Service Director > Plesk Manager > Nodes > Node name > General Settings > Synchronize now

Search Words

Plesk domains are missing

SysUser: unable to select: no such row in the table

domains

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF