topic Re: Reconcile Error (Underlying DBMS Violation of Primary Key) in Data Management Questions

Reconcile Error (Underlying DBMS Violation of Primary Key)

NickKenczka — Wed, 23 Nov 2011 16:23:41 GMT

Hello All,

We are having a curious reconcile issue within our database. I've attached the following error message I am getting when attempting reconcile with the QAQC version and my own version created from QAQC. I don't really understand this error, but what I am getting out of it is that it is explaining that there is an issue with duplicate primary key values within the table from my version? Note, the primary keys are the object ID and Global IDs so I have no control over these, obviously.

Some background info on this table is that it is a table we manage that has the information for all subdivision, annexation, development plans, etc. and is a stand alone table at the root of the database. The table is versioned, and the edits are being pushed to the base tables. We are working in a SQL 2005 database. If anyone can provide any sort of feedback on this error I thank you in advance.

Re: Reconcile Error (Underlying DBMS Violation of Primary Key)

NickKenczka — Thu, 15 Dec 2011 13:08:34 GMT

Was just wondering if anyone had any idea as to how I can resolve this issue. Thanks in advance.

Re: Reconcile Error (Underlying DBMS Violation of Primary Key)

ManojGarg — Tue, 20 Dec 2011 06:28:41 GMT

Hi,

Since you are doing reconcile, that means this is a versioned table.
If correct then you mentioned you have primary key on objectid and global id.
What do you mean by global id ? is that not sde_state_id?

If this is not sde_state_id then primary key should be on objectid and sde_state_id.
When you try to reconcile, same row gets created in a new sde state id.. Since you are not having sde state id hence this might be the issue.

Re: Reconcile Error (Underlying DBMS Violation of Primary Key)

BenLin — Tue, 03 Jan 2012 20:07:48 GMT

Hi Nick,

Here is the solution for this primary key violation error.

1. Save all your users' edits and disconnect all your users from the SDE/SQL Server geodatabase.

2. From SQL Server Management Studio, create a full database backup.

3. From SDE server, run following command to identify any orphaned, duplicated records.
sdegdbrepair -o diagnose_tables -d SQLSERVER -D <database_name> -s <SQLSERVER_instance_name> -u <sysadmin_user> -p <password>

Note, you need to use your actual database settings to replace those <> values.

4. If you do see any orphaned, duplicated records from step 3, please run following command to fix those problems.
sdegdbrepair -o repair_tables -d SQLSERVER -D <database_name> -s <SQLSERVER_instance_name> -u <sysadmin_user> -p <password>

5. You can now try reconciling the problematic version again.

Thanks,
Ben

Re: Reconcile Error (Underlying DBMS Violation of Primary Key)

Kaone3000 — Mon, 28 Oct 2024 10:06:22 GMT

Hello Nick

Disconnect all your database connections
then Run the Repair Version Tables Tool, on The Child Version u want to reconcile,

If the tool finishes then you will be able to Reconcile and Post.