topic Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology in ArcGIS Utility Network Questions

Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Wed, 25 Nov 2020 19:35:06 GMT

Hello,

I am trying to configure a utility Network on a Oracle 19c db.

After I create and configure a Utility Network and go to "Enable Topology" the error "The requested operation is unsupported by instance db" occurs, with FDO error: -2147155618.

I do not receive this error on SQL Server db.

Can anyone help me with this?

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

MelissaJarman — Tue, 01 Dec 2020 17:44:57 GMT

@RafaelFernandes_de_Souza - What version of ArcGIS Pro and ArcGIS Enterprise are you using? I am not able to reproduce using a basic UN with Oracle 19c when using ArcGIS Pro 2.7.

What about the Utility Network? Did you apply an asset package or configure manually? Is there data loaded into the network classes?

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Wed, 02 Dec 2020 01:46:18 GMT

Hello Melissa.

I am using ArcGIS Pro 2.6.3.

The Utility Network was configured manually. I created the Utility Network on SQL Server, export the Asset Package and tried to import on Oracle Geodatabase. When it fail I created a new Utility Network with the same configuration of the one of SQL Developer and at the time of Enabling Network Topology it fails.

The problem occurs when the feature classes is with data. When I try with no data, the tool execution succed. But when I try to validade topology, another error appears. A generic error.

I have configured an Oracle 19c on Staging environmet and tried to create a geodatabase to test in an isolated environmet, but I receive an error (Error creating geodatabase admin user. [ERROR: Failed to create new Oracle user sde (-51).) when trying to create the geodatabase. The print of the error when creating the geodatabase is attached.

I discovered the link https://support.esri.com/en/technical-article/000012259 for this error, but the database is not plugable.

I don't know if the error of the "Create Enteprise Geodatabase" tool is related to the problem of the Utility Network.

The production environment was updated from Oracle 11g to 19c, therefore, we have not created a geodatabase in production, because the geodatabase already exist from previous versions of Oracle.

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

PaulLeBlanc1 — Wed, 02 Dec 2020 02:53:40 GMT

I loaded an asset package (with subnetwork controllers) using Pro 2.6.3 and then enabled the topology successfully.

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Wed, 02 Dec 2020 12:13:22 GMT

Hi Paul.

Did you did it on Oracle 19c geodatabase?

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

MelissaJarman — Wed, 02 Dec 2020 18:16:02 GMT

Yes he was using Oracle 19c.

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Wed, 02 Dec 2020 18:45:30 GMT

Melissa,

Can you please upload the asset package for me to test here?

Another problem is that I cant export or import asset package from this Oracle geodatabase. I can only import/export in SQL Server geodatabase.

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

PaulLeBlanc1 — Wed, 02 Dec 2020 23:38:57 GMT

What error do you get when importing/exporting from Oracle? Is it the same configuration as you have on SQL server?

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Thu, 03 Dec 2020 00:22:58 GMT

Paul,

Is the same configuration. I will try again and send you the results.

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Thu, 03 Dec 2020 18:54:53 GMT

Paul,

I created an empty Oracle db an created a enteprise geodatabase and imported the asset package with no errors.
THe error occurs only in the geodatabase that was upgrated from Oracle 11 to 19c. Did You think that the upgrade of the database may have caused the error?

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Fri, 04 Dec 2020 18:18:12 GMT

Paul,

We have contacted the support of Oracle. It seems to be some error on the sde tables.
I've asked them to create a new database to teste creating a new enterprise geodatabase and load the data from the old database of all other schemas, except sde.

I'll post here the results.

Thank you for the help.

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

GeoffreyWest4 — Wed, 06 Jan 2021 20:04:58 GMT

Hi @RafaelFernandes_de_Souza - I have seen this error at a customer site. Are you using custom CONFIG_KEYWORDS? The issue for us appeared when we exported subnetwork, I believe the UNICODE_STRING field in one of the SDE tables should have been NVARCHAR instead of VARCHAR. I can confirm the table later. This was also Oracle 19C.

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

RafaelFernandes_de_Souza — Wed, 06 Jan 2021 20:26:17 GMT

Hi @GeoffreyWest4 - I am using default config_keywords.

When I created a new instance in Oracle for test and created a new Enterprise Geodatabase, it works without any error.

I think that the problem can be what you said. the UNICODE_STRING field.

Can you please tell me what table is?

Thank you for your help.

- Rafael Fernandes de Souza

Re: Error The requested operation is unsupported by instance db FDO error: -2147155618 - Enable Network Topology

gpgisandsky — Mon, 05 May 2025 10:24:20 GMT

Hi @GeoffreyWest4 I'm on Oracle 19c and I have similar error. Can you confirm that there is a problem on a field in one of the SDE tables? What about the table name and the field name?