nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem ArcSDE and Oracle.

RahatSyed

I have developed multiple GeoDatabases in one Oracle Database. I have registered Datasets as versions. When I am trying to Archive GeoDatabase then it gives me error: "Failed to enable Archiving Underlying DBMS error [Error executing Stored Procedure sde.instances_util.check_instance_table_conflicts:: ORA-00942: table or view doesnot exist]"

Can anybody help me resolving this problem.

Vind meer berichten getagd met

Accepted answers

All comments

HalWatson

FYI, I also had to remove "orphaned" records in the SDE.ST_GEOMETRY_COLUMNS table which referenced the same "owners" from the SDE.INSTANCES table (records now deleted). Once that was done, I could create a new feature class.

ibrahimeid

sam the problem

SelahattinTASPINAR

Hi,

I faced the same problem. Even I removed and recreated the schema instance I got errors in sde_setup.log file as shown below:

[Mon Oct 7 08:16:12 2013] Error creating GDB_Tables_Last_Modified table...
[Mon Oct 7 08:16:12 2013] ERROR Creating Geodatabase tables
, Error = -51
,EXT_Error = -942
,EXT_ERROR1 = Error executing stored procedure sde.instances_util.check_instance_table_conflicts
,EXT_ERROR2 = ORA-00942: table or view does not exist

After deleting the orphan record from SDE.INSTANCES related to deleted instance, the problem was solved.

Thanks a lot!

Sincerely.

KevinDunlop

David,

Thanks a ton! I had the same issue and as soon as I did this it fixed!

DavidCook1

I encountered this issue with ArcGIS 10.0 and Oracle 11gR2.

I was trying to create a featureclass in a Schema Geodatabase.

In my case I had a development database that had 5 schema geodatabases. One of the schemas was dropped from Oracle - without using the sdesetup -o delete command. This left an orphan record in the INSTANCES table in the Master geodatabase (in my case, the SDE schema).

As this was development, I deleted the orphan record from the master geodatabase. As soon as I did that I was able to create the feature class.

BarryGhotra

Did anyone ever get this resolved. Please help as we are experiencing the same...

TomBrown

Can you please tell us the ArcGIS release?

Also, are you attempting to enable archiving on a feature dataset or class in a schema instance other than the master instance?

Have you reported this issue to ESRI Support?

Thanks, with more information we can attempt to reproduce your error.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.