June 25, 2024 at 10:17 am
On our Java Hibernate program it is giving a duplicate value on an insert on a table where there are no values remotely close to the vales being inserted. The developers have stepped through their code, connecting from other source code, though the program has not changed in 2 years. Running the insert directly in sql works perfectly. The code works fine in another environment, when we restore the production database to another environment it fails with the same error. On this environment we did a reorg of the index, recreated the index, did a full consistency check on the db with dbcc checkdb including indexes and fond nothing. We are totally out of ideas what to do next
June 25, 2024 at 1:08 pm
If you can recreate the issue in a test environment, can you try removing the index, performing the problematic insert & then looking at the results?
Or could the source data itself contain dupes?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 25, 2024 at 1:13 pm
Is the duplicate column an identity column or using a sequence? If so, are the current values behind the actual values in the database?
June 25, 2024 at 2:11 pm
and is the insert a single statement inserting single row values or is it the result of joining other tables - including the possibility of being done on a merge statement where some rows change value (which would remove the duplicate error) and a new row is inserted?
June 26, 2024 at 8:02 am
Problem resolved, was a odd glitch in code that did not copy data from from an order through to the GRN, you had to reapply the order details, then the data tried writing to the wrong table as it it did not see the data. I am still confused why it caused a duplicate though. Apparently it writes 2 journal records to the other table which does not have the Unique index.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply