Database error for scheduled transactions

[Geoff Jankowski]

Used the right file.  Gnucash defaults to the last opened file and I only have one SQL file and it is definitely that one that lost the data.

However, thank goodness for time machine!  I was able to recover the file from last night's back up and have gingerly done the same things and so far it is fine.  Have also opened a new folder called backup and am going to regularly back up so if it does happen again i will have two sources to go back to.

I was not aware that the log file entries for SXs would not re-enter.  However, why does it give the database error message?

Gnucash is good as it means I no longer have to reboot into windows just to do the accounts but I do miss some of the simpler features from my old Quicken 2001 (like auto backup).








On 24 Jul 2013, at 19:01, Derek Atkins <warlord at MIT.EDU> wrote:

> Hi,
> 
> Geoff Jankowski <geoff.jankowski at me.com> writes:
> 
>> GNUCASH 2.4.13 (built from r4dc6397+ on 2013-04-20) on a Mac OSX 10.8.4
>> 
>> After successfully transferring all my data from Quicken to gnucash
>> via qif file and reconciling all my accounts, I today lost everything
>> I have added to gnucash since 24th June.  This is also the day I moved
>> from an XML format to an SQL file.
>> 
>> I do not recall doing anything special at the time and have regularly
>> closed and opened gnucash on the machine which has also regularly been
>> shut down and restarted.  I can see no reason for this sudden data
>> loss.
>> 
>> After researching what to do I have rebuilt the data from the log
>> files into a test copy of the file that I made to preserve the
>> original.
>> 
>> Although some of the log files enter without error, some of them give
>> a series of "Unable to save to database" errors.  The number varies
>> for each file.  I think I have worked out that it is the scheduled
>> transactions in the log file that it is unable to process as the data
>> has all been recovered except for the scheduled transactions of which
>> there were many!  I have not tried to reconcile yet as I can see that
>> the scheduled transactions are all missing.
>> 
>> I have read that there were a load of bugs around this activity in the
>> previous 2.3.x versions but that it was supposedly fixed.
>> 
>> I am assuming that the data is still there but somehow locked in a
>> database that my copy of gnucash cannot access.  Has anyone else had
>> this problem and is there a fix?  If not, I will have to dispense with
>> the scheduled transactions (a bit of a pain) until it can be resolved.
>> Where is this data stored and can I extract and use it in some other
>> way?
>> 
>> I welcome any feedback or links to help me resolve the problem.  Thanks.
> 
> Are you sure that you didn't accidentally re-open your old XML data file
> instead of the new SQLite data file?
> 
> Moreover, SQL is still considered Beta; there are still known data loss
> issues when using the SQL backend, so you risk losing your data.  It's
> why we still do not recommend you use it for real data unless you know
> what you are doing and make good backups.
> 
> As for replaying log files; you cannot replay an SX; it doesn't work.
> So if you entered or modified an SX then the log replay will fail.
> Similarly you cannot replay account modifications or any
> business-feature operations.
> 
> I would first check your file system and make sure you're opening the
> correct data file.  Note that double-clicking on a data file does NOT
> open that data file on a Mac!!  So if you double-clicked on one file
> thinking that's what you were working on -- you were wrong, and opened
> the last file you had opened via File -> Open or saved via File -> Save As.
> 
> Good Luck,
> 
>> Geoff 
>> +44 20 7100 1092
>> +44 7770 58 48 38
>> +33 5 46 97 13 89
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available