Geometric Network Issue after Compress

[EmadAl-Mousa]

Greetings All,

We are havin the following environment:

SERVER: IBM AIX 6.1
Database: ORACLE11gR2 (11.2.0.3.6)
ArcSDE 9.3.1 SP2

The reason we didn't upgrade ArcSDE on this database instance, is because we are using "Telcordia Network Engineer software" for this geodatabase.

for some reason, after perfoming compress , all feature classes related to a geometric network are not working properly.

we found errors such as "Error opening feature calss No current record".

your thoughts and recommendations are highly appreciated.

[EmadAl-Mousa · Accepted solution]

I Found the solution:

Use ArcGIS Desktop 10.1 since its powerful in client administration of SDE.

I have performed "FULL RECONCILE" for all versions using ArcCatalog 10.1 . Then, on the database server where my ArcSDE engine is
residing i have executed the "compress command".

you will receive a "constraint issue" and the compress will fail .....that's fine .....all what you need is to use the sdegdbrepair command. to check more details about the feature class or table that is causing this, check the last records of your ArcSDE logs on the server.

sdegdbrepair -o repair_tables -d <{ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL}>
[-r versioned table name | file=<table_list>] [-V {ALL | NONE | <version_name>} | STATE:<state_id>]
[-H <home_directory>] [-u <ArcSDE_admin_user>] [-p <ArcSDE_admin_password>]
[-D <database_name>] [-s <server_name>] [-i <master_geodatabase_service>:<user_schema>] [-N] [-q]

the parameters in red are the important ones ...

ArcSDE Command reference: http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/whnjs.htm


Regards,
Emad Al-Mousa