[GNC] save as sqlite3 error

Geoff cleanoutmyshed at gmail.com
Wed Oct 20 06:14:52 EDT 2021


That would do it - the schema prohibits NULLs.

I don't believe it is possible to import securities, it is not an option 
on the Import menu.  Depending how many you have, you could consider:-

Learning to script AutoHotKey - https://www.autohotkey.com/ - which is 
excellent for automating Windows applications.

Or (big stretch) have a look at PieCash - the securities table is called 
"commodities" - 
https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py 
- but direct database manipulation may void your GnuCash warranty.

I reckon you will probably find it quicker to type them in yourself - 
you can import price data from CSV once the securities themselves are 
set up.

Hope this helps.

Regards

Geoff
=====



On 20/10/2021 7:25 pm, Public Address wrote:
> 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 <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>
>  >     <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 
> <https://go.microsoft.com/fwlink/?LinkId=550986>>> for Windows
>  >      >
>  >      >
>  >      >
>  >      > _______________________________________________
>  >      > gnucash-user mailing list
>  >      > gnucash-user at gnucash.org <mailto: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>
>  >     <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>
>  >     <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 
> <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>
>  >     <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>
>  >     <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: gnc_null_memo.jpg
Type: image/jpeg
Size: 76539 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20211020/a820b5b1/attachment-0001.jpg>


More information about the gnucash-user mailing list