Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • WP Guardian
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • WP Guardian
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • WP Guardian
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • WP Guardian
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

Unable to access domain page in Plesk GUI: Unable to find service node for ip address with id

 
backupdatabasedomainshostedip

Symptoms

  • Unable to access Plesk > Domains > example.com page with the error:

    Error: Unable to find service node for ip address with id=

  • The "plesk repair db" utility reports the following inconsistencies:

    Inconsistency in the table 'DomainServices' for the column
    ipCollectionId: Web service cannot operate: the IP address list with
    ID 63 is empty .................................................... [ERROR]

Cause

Database inconsistency

Resolution 

  1. Log into the server via RDP
  2. Start a command prompt as Administrator
  3. Create a backup for psa database in C: root:

    plesk db dump psa > C:psa.sql

  4.  Find database inconsistency:

    plesk repair db -n

    The output will be similar to the following:

    Inconsistency in the table 'DomainServices' for the column
    ipCollectionId: Web service cannot operate: the IP address list with
    ID 63 is empty .................................................... [ERROR]

  5.  Using the ID from the error above, findv ID of the affected domain:

    plesk db " select * from DomainServices where ipCollectionId = 63;"
    +------+--------+------+--------+---------------+----------------+
    | id | dom_id | type | status | parameters_id | ipCollectionId |
    +------+--------+------+--------+---------------+----------------+
    | 2126 | 924 | web | 0 | 0 | 63 |
    +------+--------+------+--------+---------------+----------------+

  6.  Then find the name of the affected domain by executing the following command, using dom_id found on the previous step as id:

    plesk db "select name from domains where id=924;"
    +---------------+
    | name |
    +---------------+
    | exampe.com |
    +---------------+

  7. Using the query below, determine that example.com domain is hosted on IP 203.0.13.2:

    plesk db "select val,displayVal from dns_recs where host like '%example.com%';"
    ..................................................
    +------------------------------+------------------------------+
    | val | displayVal
    +------------------------------+------------------------------+
    | 203.0.13.2 | 203.0.13.2
    | 203.0.13.2 | 203.0.13.2 |

  8.  Find ID of the 203.0.13.2 IP:

    plesk db "select id from IP_Addresses where ip_address='203.0.13.2';"
    +----+
    | id |
    +----+
    | 60 |
    +----+

  9. Run the following commands one by one to fix database inconsistency for example.com domain:

    plesk db "insert into IpAddressesCollections values(63, 60)"

    plesk db "insert into IpAddressesCollections values(63, 60)"

Read the full article
Related Posts

Exploring Plesk’s Added Value Solutions So Far in 2023

Read More »

Unveiling Sitejet Builder: The Perfect Match for Your Effortless Website Creation Needs

Read More »

Dynamic List vs. Active List: A Comprehensive Comparison – Unveiling the Ultimate Winner!

Read More »
Knowledge Base

Unable to add domain to an existing webspace in Plesk: Unable to load object of type IPAddress with id=XX

Read More »

Error while creating a domain: A specified logon session does not exist. It may already have been terminated.

Read More »

Unable to repair domains in Plesk using “plesk repair db” utility: The following domains are assigned to already removed IP addresses

Read More »

Some elements Plesk interface/websites hosted on Plesk are not loaded when Cloudflare’s Rocket Loader is used

Read More »

Hosting Wiki

  • Server Redundancy
  • Bare Metal Server
  • Backup
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • JavaScript
  • Domain
  • Plesk
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • IPv6
  • IPv4
  • SIP
  • UDP/IP
  • TCP/IP
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family