cancel
Showing results for 
Search instead for 
Did you mean: 

Apply log: identity value not found

Former Member
2,441

Hi,

When applying a transaction log to a DB, I get the following error:

Invalid transaction log (id=3, page_no=0x00000048, offset=0x0f75): identity value not found

What does 'identity value not found' mean ?

Using SA 16.0.0.1948

Thank you

VolkerBarth
Contributor
0 Kudos

Just out of curiosity:

Could you find out via the DBTRAN utility at what operation the log corruption has occured (and if so, could you partially use the log, i.e. that part that could be translated)?

Former Member
0 Kudos

Actually, just now I got the same error from another client on a completely different server, same SA version, so I investigated further. I can successfully do a dbtran of the log and apply with ISQL, so I don't think it's a simple log corruption problem.

VolkerBarth
Contributor
0 Kudos

As 16.0.0.1948 is quite an old build and newer EBFs list some fixes w.r.t. transaction log corruption - can you try a newer build?

(That's just wild guessing on my part...)

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

The word "identity" in that error is referring to identity of the row being changed at that point in the transaction log. This identity would usually consist of the primary key values (if a pkey exists or some stand in) and it is just at that point where the corruption in the transaction log was detected.

So basically this is happending at a point where there is some kind of an update or delete operation ... but the main message is the log file is corrupted. And that is really all we now about this. Prior to Engineering change# 756886 you would not have even seen this extra text ... just the error text up to the closing ')'.

HTH

Answers (0)