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

asked 03 May '16, 09:58

lebpas's gravatar image

lebpas
20191017
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 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...)

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

HTH

permanent link

answered 03 May '16, 13:32

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

Nick Elson S...
7.3k35107
accept rate: 32%

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×59
×19

question asked: 03 May '16, 09:58

question was seen: 2,098 times

last updated: 09 May '16, 05:11