The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.


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

Thank you

asked 03 May '16, 09:58

lebpas's gravatar image

accept rate: 0%

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)?

(06 May '16, 04:51) Volker Barth

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.

(06 May '16, 14:58) lebpas
Replies hidden

As 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...)

(06 May '16, 17:30) Volker Barth

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 ')'.


permanent link

answered 03 May '16, 13:32

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 31%

edited 05 May '16, 15:45

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 03 May '16, 09:58

question was seen: 671 times

last updated: 09 May '16, 05:11