Search Engine: Elastic

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

Symptoms

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.

Cause

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.

Resolution

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

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

Email subscription for changes to this article
Save as PDF