Article ID: 124117, created on Dec 31, 2014, last review on Sep 12, 2015

  • Applies to:
  • Operations Automation 6.0
  • Operations Automation 5.5
  • Operations Automation 5.4
  • Operations Automation 5.3


When a customer clicks the button Allow external access for a database in CCP, an error message appears:

Operation cannot be performed Database service <SERVICE_ID> has no external access.


Database server that hosts this database has only one IP which is internal. When one clicks Allow external access, the following select is performed:

SELECT 1 FROM dbm_services WHERE service_ip != comm_ip AND service_id = <SERVICE_ID>

If there is no external IP address, the query returns nothing.


The database server should be re-added to POA with an external IP address.

Search Words

has no external access

User created by CCP have no grants to access the DB

User created by CCP have no grants to access the Mysql DB


Database service 331 has no external access.

external db access

PostgreSQL, External access

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e 5b048d9bddf8048a00aba7e0bdadef37 a8cdca46e4357a6e38fded820770e272 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF