SQL Anywhere database - Translate log file

Author

Translate log file - ERROR

Michas

2005-04-22, 7:23 am

I have to translate log file,

"c:\Program Files\sybase\SQL Anywhere 9\win32\dbtran.exe" -sr
D:\tmp\ca2005.log D:\tmp\ca2005.sql
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^

but I've got error message:

++++++++++++++++++++
++++++++++++++++++++
+++++++
Adaptive Server Anywhere Log Translation Utility Version 9.0.1.1751
WARNING: Debug info for SQLRemote generated. Do not apply to a database.
Transaction log "D:\tmp\sl2005.log" starts at offset 0000398503
16% complete
Invalid column ID found while reading the database log file. This is an
internal
error.
Log operation at offset 0023776615 has bad data at offset 0023776627
++++++++++++++++++++
++++++++++++++++++++
++++++++

Validate database didn't help.

any ideas how can I pass this error?

--
Best regards,
<ML>

Rob Waywell

2005-04-22, 7:23 am

The log file is corrupt at this point. Your first option would be to check
your mirror log file. As long as the mirror log file is clean then you are
in good shape.

If you do not have a mirror log file and you require this log file for SQL
Remote, then you should open a case with Tech Support to see if they can
help salvage this log file for you.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Michas" <michas@seth.pl> wrote in message news:4268bdff$1@foru
ms-1-dub...
> I have to translate log file,
>
>
> "c:\Program Files\sybase\SQL Anywhere 9\win32\dbtran.exe" -sr
> D:\tmp\ca2005.log D:\tmp\ca2005.sql
>
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^
^^^
>
> but I've got error message:
>
> ++++++++++++++++++++
++++++++++++++++++++
+++++++
> Adaptive Server Anywhere Log Translation Utility Version 9.0.1.1751
> WARNING: Debug info for SQLRemote generated. Do not apply to a database.
> Transaction log "D:\tmp\sl2005.log" starts at offset 0000398503
> 16% complete
> Invalid column ID found while reading the database log file. This is an
> internal
> error.
> Log operation at offset 0023776615 has bad data at offset 0023776627
> ++++++++++++++++++++
++++++++++++++++++++
++++++++
>
> Validate database didn't help.
>
> any ideas how can I pass this error?
>
> --
> Best regards,
> <ML>
>
>

Michas

2005-04-22, 9:23 am

Unfortunately I don't have the log mirror file.
Do you know how can I repair my log file?

--
Best regards
<ml>

> The log file is corrupt at this point. Your first option would be to check
> your mirror log file. As long as the mirror log file is clean then you are
> in good shape.
>
> If you do not have a mirror log file and you require this log file for SQL
> Remote, then you should open a case with Tech Support to see if they can
> help salvage this log file for you.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> Developer Community at www.ianywhere.com/developer
> "Michas" <michas@seth.pl> wrote in message news:4268bdff$1@foru
ms-1-dub...
> ^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^
> ^^^
>
>

Chris Keating $iAnywhere Solutions$

2005-04-22, 9:23 am

From the previous post
"... then you should open a case with Tech Support to see if they can
help salvage this log file for you."

"Michas" <michas@seth.pl> wrote in message news:4268f763@forums
-2-dub...
> Unfortunately I don't have the log mirror file.
> Do you know how can I repair my log file?
>
> --
> Best regards
> <ml>
>
>
>
>

Sponsored Links