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:cleanoutmys...@gmail.com>
Sent: 20 October 2021 04:29
To: David Carlson<mailto:david.carlson....@gmail.com>
Cc: Public Address<mailto:public.addr...@hotmail.co.uk>; 
gnucash-user@gnucash.org<mailto:gnucash-user@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 <cleanoutmys...@gmail.com
> <mailto:cleanoutmys...@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@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@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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

_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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.

Reply via email to