topic Re: Problem ArcSDE and Oracle. in Data Management Questions

Problem ArcSDE and Oracle.

RahatSyed — Sat, 14 Aug 2010 18:27:26 GMT

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.

Re: Problem ArcSDE and Oracle.

TomBrown — Thu, 19 Aug 2010 18:40:05 GMT

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.

Re: Problem ArcSDE and Oracle.

BarryGhotra — Mon, 28 Feb 2011 17:12:18 GMT

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

Re: Problem ArcSDE and Oracle.

DavidCook1 — Wed, 25 May 2011 18:35:22 GMT

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.

Re: Problem ArcSDE and Oracle.

KevinDunlop — Thu, 17 May 2012 23:11:06 GMT

David,

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

Re: Problem ArcSDE and Oracle.

SelahattinTASPINAR — Mon, 07 Oct 2013 04:52:18 GMT

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.

Re: Problem ArcSDE and Oracle.

ibrahimeid — Tue, 21 Oct 2014 12:49:33 GMT

sam the problem

Re: Problem ArcSDE and Oracle.

HalWatson — Wed, 21 Jan 2015 17:53:29 GMT

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.