Question Re: SQL Anywhere 12 repair database logfile in Technology Q&A

SQL Anywhere 12 repair database logfile

Former Member — Mon, 08 Dec 2014 10:23:12 GMT

Hello first time user here. I am using SQL Anywhere 12 v 12.0.1.3298. And I am attempting to translate a customers database log. I have made several attempts using 2 different copies of their log file. The point that I get the failure at has varied a little. This is the message that I get. "... Checkpoint at 2014/01/03 22:00 Unable to reset output file An error occurred while attempting to translate the log file 'C:\\Users\\ACrosby\\Desktop\\Memphis City Cartage, Inc\\ptools.log'." Any ideas or suggestions?

Re: SQL Anywhere 12 repair database logfile

reimer_pods — Mon, 08 Dec 2014 10:28:39 GMT

Can you decribe exactly what steps you've taken before that message appeared? Have you verified, that it is really a database log?

Re: SQL Anywhere 12 repair database logfile

Former Member — Mon, 08 Dec 2014 10:36:56 GMT

I transferred the database log xxxxxx.log from the customers server to my desktop via ftp. The I open Sybase Central and connect to SQL Anywhere 12. And then I go to Tools and select Translate log file. And step through the wizard and begin the translation.

Re: SQL Anywhere 12 repair database logfile

MarkCulp — Mon, 08 Dec 2014 10:49:22 GMT

The error message "Unable to reset output file" occurs when dbtran is trying to initialize (truncate) the output file or it is trying to open/create a new output file ... and in either case it got an error doing the operation. As such I suspect there is a permission problem on the (already existing) output file. I suggest you try specifying a different output file name using dbtran's -o output-file option.