Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

When auditing is turned on the dbupgrade utility corrupts the log file it creates in the process:

Log file was generated with missing connect operation Log operation at offset 0219742914739 has bad data at offset 0219742914746 An error occurred while attempting to translate the log file '180723AB.LOG'.

This is seen consistently using the SQLA 16

asked 23 Jul '18, 14:09

JJ%20Diaz's gravatar image

JJ Diaz
accept rate: 0%

What version is the database that gets upgraded?

(23 Jul '18, 14:23) Chris Keating

I tried upgrading a v12.0.1 Build 4436 with auditing enabled and it appears to work. Can you provide the steps to repro?

(23 Jul '18, 14:34) Chris Keating

Upgrading from to I have the procedure we used and would be happy to send it to you.

(23 Jul '18, 14:49) JJ Diaz

I am creating a new database with 12 and will try to recreate this issue. It is very repeatable with existing databases but they are a bit large to send to you.

(23 Jul '18, 14:55) JJ Diaz

I just created a database from scratch and was able to repeat the issue Log file corrupted (invalid page number found) Log operation at offset 0000600412 has bad data at offset 0000600432 An error occurred while attempting to translate the log file 'D:\SQL Anywhere 16\Database Files\Conversion Test\180723AA.LOG'.

(23 Jul '18, 15:11) JJ Diaz

Must translate the log file created during upgrade process to find the issue. We did this to replicating (SQLRemote) databases and found it on the next send operation. Identical issue can be found with detran.

(23 Jul '18, 15:14) JJ Diaz

Can you send me the procedure? My email is I will try with the same v16 version you are testing also.

(23 Jul '18, 16:03) Chris Keating
More comments hidden
showing 5 of 7 show all flat view

This is a confirmed bug in SQLA 16

permanent link

answered 07 Aug '18, 17:39

JJ%20Diaz's gravatar image

JJ Diaz
accept rate: 0%

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: 23 Jul '18, 14:09

question was seen: 1,248 times

last updated: 07 Aug '18, 17:39