[GNC] save as sqlite3 error

Wed Oct 20 04:25:25 EDT 2021

Thank you all.  Someone last night pointed me to the trace file.  I tried to save as sqlite3, failed then closed down.  The last lines are as follows:

* 17:59:21 ERROR <gnc.engine> gboolean qof_book_is_readonly(const QofBook*): assertion 'book != NULL' failed
* 17:59:26 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 19: NOT NULL constraint failed: splits.memo
* 17:59:26 ERROR <gnc.backend.dbi> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL INSERT INTO splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom) VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24 17:57:12',46353,100,46353,100)
* 17:59:26 ERROR <gnc.backend.sql> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom) VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24 17:57:12',46353,100,46353,100)

I am not sure how to look for transactions via the guid_tx, but I searched for 463.53.  I was then shown a split transaction view of a transaction that was put into the imbalance account.  The description was “NULL” where the rectangle is in the attached.  Some of my other imbalance entries had this entry, some did not.  So I removed them all and now it writes.

I don't believe I put these “NULL”s in, I think gnucash did it so might be something to look into.

Not sure if you saw my other question – can import securities (not the security transactions) or can I only add them via the GUI?

Many Thanks

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows

From: Geoff<mailto:cleanoutmyshed at gmail.com>
Sent: 20 October 2021 04:29
To: David Carlson<mailto:david.carlson.417 at gmail.com>
Cc: Public Address<mailto:public.address at hotmail.co.uk>; gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
Subject: Re: [GNC] save as sqlite3 error

Good pickup David - Thunderbird dropped the attachment, but I can see it
via Gmail  {:--(

Not that it helps much PA, as John said, please check the trace file.

Geoff
=====

On 20/10/2021 2:04 pm, David Carlson wrote:
> It is odd that PA's screenshot made it to my Gmail account in Windows OS
> when it did not get to Geoff's email client, or maybe it did but Geoff
> did not see it because for some reason there was an inline link as well
> as an attachment at the end.  In either case I cannot comment on the
> sqlite issue as I have no experience with that.  Did I see an email
> elsewhere suggesting that sometimes an incorrect version of some library
> program was incorrectly selected by the installation program?
>
> On Tue, Oct 19, 2021 at 8:16 PM Geoff <cleanoutmyshed at gmail.com
> <mailto:cleanoutmyshed at gmail.com>> wrote:
>
>     Hi PA
>
>     I can't help you with this error except to say that I am running on the
>     same build on Windows 10 and cannot reproduce your problem.  BUT I do
>     not have Trading Accounts switched on.
>
>     I successfully saved a 35MB XML file to SQLite and can access that file
>     in both GnuCash and the SQLite DB Browser.  See attached screenshot.
>
>     (Your screenshot didn't come through - try attaching instead of
>     pasting).
>
>     Have you tried debugging: https://wiki.gnucash.org/wiki/Logging
>     <https://wiki.gnucash.org/wiki/Logging>
>
>     Start gnucash.exe from the command line with the "--debug" switch.  In
>     my case, the log files are called gnucash.traceXXXXXX.log in
>     ~\AppData\Local\Temp
>
>     Being Windows, perhaps a reboot may help?
>
>     Good luck.
>
>     Regards
>
>     Geoff
>     =====
>
>     On 19/10/2021 6:27 pm, Public Address wrote:
>      > Hi - In xml format
>      >
>      > Trying to save as sqlite3 getting error when file gets to 213kb.
>     Plenty of room on disk.  I have tried different drives, different
>     filenames no luck.
>      >
>      > [cid:image001.png at 01D7C4C2.F1FEDBF0]
>      >
>      >
>      > Many thanks
>      >
>      > Windows 10
>      > GNU      4.8
>      > Build ID 4.8a+ (2021-09-28)
>      > Finance::Quote 1.49
>      >
>      > Trading Accounts: on
>      >
>      > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986
>     <https://go.microsoft.com/fwlink/?LinkId=550986>> for Windows
>      >
>      >
>      >
>      > _______________________________________________
>      > gnucash-user mailing list
>      > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>      > To update your subscription preferences or to unsubscribe:
>      > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>      > If you are using Nabble or Gmane, please see
>     https://wiki.gnucash.org/wiki/Mailing_Lists
>     <https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
>      > -----
>      > Please remember to CC this list on all your replies.
>      > You can do this by using Reply-To-List or Reply-All.
>      > _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     To update your subscription preferences or to unsubscribe:
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>     If you are using Nabble or Gmane, please see
>     https://wiki.gnucash.org/wiki/Mailing_Lists
>     <https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
>     -----
>     Please remember to CC this list on all your replies.
>     You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
> David Carlson

-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnu.JPG
Type: image/jpeg
Size: 27336 bytes
Desc: gnu.JPG
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20211020/e0811cc7/attachment-0001.jpe>