topic ArcSde Reconcile Problem. Please Help in Data Management Questions

ArcSde Reconcile Problem. Please Help

BilalMustafa — Wed, 23 Oct 2013 09:51:18 GMT

Dear All,,

i have be working on attaching building images using the attachment ability in Gis v.10 via ORACLE v.11 the problem is:

After few days i remember that i didn't do any reconcile function and i tired to do but all i have is a pop up error box with the following text " The version could not be reconciled. Underlying DBMS error [ORA-00001: unique constraint (SDE.A23_PK) violated] {SDE.LANDS_USE]
How can i fix it & Backup the building feature with the attached Images ?

Thanks,,

Bilal

Re: ArcSde Reconcile Problem. Please Help

NidhinKarthikeyan — Wed, 23 Oct 2013 11:13:17 GMT

Bilal,

Try to Reconcile after removing the attachment. Take a copy of the data and keep it on your local drive before you remove the attachment from the database.

Regards,

Re: ArcSde Reconcile Problem. Please Help

VinceAngelo — Wed, 23 Oct 2013 11:31:37 GMT

Once you get your geodatabase stable again, you really ought to take the effort
to re-implement using best practices --

Create a tablespace to store geodata

Create a user to own geodata (with DEFAULT TABLESPACE in the new tablespace)

Transfer all the geodata owned by SDE into new tables owned by the owner user

If you haven't been doing them already, institute a regular backup mechanism

Among the benefits will be reduced possibility of corruption of the geodatabase
due to SDE tablespace overfill.

- V