Re: Journal entry for identity column changes?

Not sure if this was your situation, but I have seen situations where
identity column values were incorrect after a restore where the save used
for the restore was performed using a replicated copy of the table.
The solution was to get the highest value in the identity column and reset
the starting identity value to that plus 1.
It seems like the identity column value is included in the journal entry
and is then written into the target table directly from the journal entry,
so whatever it is in the database that increments and maintains the
identity value gets "left behind" (I'm guessing there is something in the
table header somewhere that maintains that counter, but that is just a
guess)

I guess its equally possible that if some rows were inserted or copied as
part of a bulk operation or a fix that already had a valid identity column
value or the identity column value of existing rows was changed for some
reason (can you even do that) then the identity value counter itself might
not have been incremented or kept up with what was done.

On Sat, Jul 10, 2021 at 2:47 AM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

Thanks David. We don't know if it changed, we are trying to find out what
happened. We dealt with this when the new HA Vendor struggled with
replicating files with identity values.

On Fri, Jul 9, 2021 at 10:31 AM David Gibbs via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

On 7/8/21 8:49 AM, Art Tostaine, Jr. wrote:

We had a table start getting duplicate keys this morning. I reset the
identity column value to a higher number and all was well.

Shouldn't I see a journal entry for that table that shows the value was
changed?

How is the identity column being changed?

IIRC, a journal entry would be created when data is added or changed in
the table, not when attributes of the table are changed.

david

--
I'm riding in the American Diabetes Association's Tour de Cure to raise
money for diabetes research, education, advocacy, and awareness. You
can make a tax-deductible donation to my ride by visiting
https://mideml.diabetessucks.net.

You can see where my donations come from by visiting my interactive
donation map ... https://mideml.diabetessucks.net/map (it's a geeky
thing).
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com