topic Re: Build Geometric Network failing in Oracle at ArcGIS 10 in Data Management Questions

Build Geometric Network failing in Oracle at ArcGIS 10

DavidKlein — Tue, 01 Mar 2011 01:00:04 GMT

Hi All,

I've loaded a heap of electric data into an Oracle geodatabase. When I try to build a network from this data, it fails with the following error:

Build Geometric Network failed.
DBMS table not found [ ORA-00942: table or view does not exist] [GISMIG1.T_1_PolyErrors] [STATE_ID = 7]
DBMS table not found [ ORA-00942: table or view does not exist] [GISMIG1.T_1_LineErrors] [STATE_ID = 7]
DBMS table not found [ ORA-00942: table or view does not exist] [GISMIG1.T_1_PointErrors] [STATE_ID = 7]
DBMS table not found [ ORA-00942: table or view does not exist] [GISMIG1.T_1_DirtyAreas] [STATE_ID = 7]

2 other relevant facts I have found:

1) I can load this same data into a File Geodatabase and the Geometric Network builds just fine.

2) These 4 T_* tables that it is looking for do in fact briefly exist, shortly after I begin the Geometric Network build process. Then they are gone again, and the build process blows up complaining it cannot find them. It is as if ArcGIS is creating these tables for temporary use, but deleting them before it is done with them.

Has anyone seen this behavior? Any advice how to solve it?

Cheers,
Dave

Re: Build Geometric Network failing in Oracle at ArcGIS 10

CraigGillgrass — Tue, 01 Mar 2011 11:55:46 GMT

Dave,

Can you contact Tech Support and log an incident for this issue?
http://support.esri.com/phoneSupport#us

We'll probably need to get a dump of your database in house for testing. I have not seen this issue before.

thanks,

Re: Build Geometric Network failing in Oracle at ArcGIS 10

SharonStevenson — Tue, 02 Aug 2011 19:03:41 GMT

Did you find a solution to this problem? I'm having the same issue.

Re: Build Geometric Network failing in Oracle at ArcGIS 10

PaulSchneider — Wed, 16 Nov 2011 14:13:58 GMT

We were having a similar issue, only on SQL Server. In the first step of the Geometric Network Wizard we had been selecting 'Yes' to 'Snap Features within a specified tolerance'; and specifying a looser tolerance level than the feature dataset is based on. By selecting 'No', we were able to create and build the geometric network successfully.

We still needed to snap our features however, so we used the Snap Tool (Editing Tools Toolbox); which gave us a little more control over how snapping was carried out anyway.

Maybe this will work for your Feature Dataset?

Re: Build Geometric Network failing in Oracle at ArcGIS 10

AndrzejMilosz — Thu, 06 Jun 2013 08:17:33 GMT

I have the same error building geometric network in Oracle with ArcGIS 10. I check "Snap features within specified tolerance" to Yes and give value there 0,0009 Meters.
[ATTACH=CONFIG]25046[/ATTACH]

I would be thankful for any suggestions to solve this problem,

Andrzej

Re: Build Geometric Network failing in Oracle at ArcGIS 10

WilliamCraft — Tue, 02 Jul 2013 21:05:09 GMT

Are you attempting to build the network as the schema owner or as SDE? Otherwise, does the DBMS user account you are using have permissions to the tables (base, F, S, A, D) of the objects participating in the network?

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Wed, 23 Apr 2014 22:50:51 GMT

So, I've just encountered the same error in oracle with ArcGIS 10.0. I'm executing this as the schema owner. Would it be preferred to execute it as SDE?

Thanks,
Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Wed, 23 Apr 2014 23:00:34 GMT

Just tried it as SDE.. same error.

Any suggestions at all would be greatly appreciated.

Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Wed, 23 Apr 2014 23:19:47 GMT

One further point of information that I just realized may be important. There are two datasets in this instance. One for gas and one for electric. I had previously successfully created a geometric network for the gas dataset -- as the gas schema owner. The error is now occurring when I try to create a network in the electric dataset.. as either the electric schema owner or as SDE.

Is it possible that I now don't have permission to tables created when the first network was built?

Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

WilliamCraft — Wed, 23 Apr 2014 23:43:07 GMT

Which version of Oracle? I am wondering if your UNDO tablespace is being exhausted when creating the geometric network(s) in Oracle due to an extremely long transaction; especially since you mentioned that 4 T_* tables briefly exist. How long does it run against Oracle before it fails? You also said earlier that it worked in a file geodatabase. Log into your Oracle database via SQLplus and check your undo parameters:

SHOW PARAMETER undo

You should see something similar to this:

undo_management string AUTO

undo_retention integer 3600

undo_tablespace string UNDOTBS1

I'm specifically interested in seeing your undo retention parameter value. It might be that the undo retention value is too large, or the UNDO tablespace is to small. If it is too large, then Oracle will keep buffering data until the tablespace fills up. I've found this article to be helpful at times.

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Wed, 23 Apr 2014 23:47:07 GMT

Thanks much for the reply.!

I'm running Oracle 11.2.0.1.0.

Result of SHOW PARAMETER UNDO are

undo_management   AUTO
undo_retention         900
undo_tablespace       UNDOTBS1

Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

WilliamCraft — Sat, 11 Dec 2021 08:45:36 GMT

What are the results of this query when run against Oracle as SYS?

SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]",
SUBSTR(e.value,1,25) "UNDO RETENTION [Sec]",
ROUND((d.undo_size / (to_number(f.value) *
g.undo_block_per_sec)))"OPTIMAL UNDO RETENTION [Sec]"
FROM (
SELECT SUM(a.bytes) undo_size
FROM v$datafile a,
v$tablespace b,
dba_tablespaces c
WHERE c.contents = 'UNDO'
AND c.status = 'ONLINE'
AND b.name = c.tablespace_name
AND a.ts# = b.ts#
) d,
v$parameter e,
v$parameter f,
(
SELECT MAX(undoblks/((end_time-begin_time)*3600*24))undo_block_per_sec
FROM v$undostat
) g
WHERE e.name = 'undo_retention'
AND f.name = 'db_block_size';

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Thu, 24 Apr 2014 00:01:43 GMT

ACTUAL UNDO SIZE: 8880
UNDO RETENTION: 900
OPTIMAL UNDO RETENTION: 101895

I'm not an Oracle wiz - but it would seems my undo retention is much less than optimal.

Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

WilliamCraft — Thu, 24 Apr 2014 00:06:26 GMT

Maybe. Oracle is supposed to automatically tune the undo retention size when set to AUTO. If you're open to modifying the value and this isn't a production database, try something like this in SQLplus and then attempt to create your geometric network again after making a new connection:

ALTER SYSTEM SET UNDO_RETENTION = 150000;

If it doesn't work, then change it back to the default setting of 900:

ALTER SYSTEM SET UNDO_RETENTION = 900;

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Thu, 24 Apr 2014 00:10:41 GMT

This is not a production instance... I'll give it a try and keep you posted.

Thanks again!
Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Thu, 24 Apr 2014 00:25:09 GMT

crafty (Hope its ok to use that name) -

I would love to buy you a beer if I ever get the chance. The network build completed with the results I was expecting/hoping for.

Thanks a million!
Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

WilliamCraft — Thu, 24 Apr 2014 00:30:37 GMT

Ed, I'm so glad it worked for you! Thanks for the follow-up and for letting me know. I'm up for a beer anytime... no need to buy. Maybe sometime if you're at the Esri UC we can get a chance to meet. Have a great weekend!

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Thu, 15 May 2014 15:54:17 GMT

Now, unfortunately, this issue has re-surfaced. I've had to drop and re-create the network on this database and I'm getting the original error -- even with the undo_retention parameter set to 150000. I re-executed the SQL and found that the optimal value was now at about 278000 so I reset undo_retention to 300000. Same error results.

Now I'm going to try two things:

1. Return the parameter to its original setting - 900
2. Contact ESRI tech support

Ed

Re: Build Geometric Network failing in Oracle at ArcGIS 10

EdwardBlair — Thu, 15 May 2014 21:30:04 GMT

OK, in this case I found I had inadvertently assigned a subtype to the AncillaryRole field on a point feature class. There should have been no subtype. Also, all values in this field were blank. Removing the subtype assignment allowed the network build to complete successfully.

There used to be an error message when null subtype values were found.

Anyway, this was my problem.

Ed