[GNC] save as sqlite3 error

Peter West pbw at pbw.id.au
Fri Oct 22 21:54:20 EDT 2021


FWIW, I just tried to save my postgresql-based data as sqlite3 and GnuCash crashed.

Peter
—
Peter West
pbw at ehealth.id.au
“And why do you not judge for yourselves what is right?”

> On 23 Oct 2021, at 11:42 am, Geoff <cleanoutmyshed at gmail.com> wrote:
> 
> Looks like that approach could work, but I'm afraid I don't know enough about the inner workings of GnuCash to advise you authoritatively.
> 
> Good luck!
> 
> 
> Regards
> 
> Geoff
> =====
> 
> On 22/10/2021 11:52 pm, Public Address wrote:
>> Thanks, interesting that deleting the “NULL” text and leaving it empty allowed it to go through.
>> “but direct database manipulation may void your GnuCash warranty.”
>> I was thinking about direct upload to the postgres table (creating my own guid and checking for duplication) but that doesn’t sound like a good idea?
>> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986 <https://go.microsoft.com/fwlink/?LinkId=550986>> for Windows
>> *From: *Geoff <mailto:cleanoutmyshed at gmail.com <mailto:cleanoutmyshed at gmail.com>>
>> *Sent: *20 October 2021 11:15
>> *To: *Public Address <mailto:public.address at hotmail.co.uk <mailto:public.address at hotmail.co.uk>>; David Carlson <mailto:david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com>>
>> *Cc: *gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>>
>> *Subject: *Re: [GNC] save as sqlite3 error
>> 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/ <https://www.autohotkey.com/> <https://www.autohotkey.com/ <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 <https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py><https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py <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 <https://go.microsoft.com/fwlink/?LinkId=550986> <https://go.microsoft.com/fwlink/?LinkId=550986 <https://go.microsoft.com/fwlink/?LinkId=550986>>> for Windows
>> >
>> > *From: *Geoff <mailto:cleanoutmyshed at gmail.com <mailto:cleanoutmyshed at gmail.com> <mailto:cleanoutmyshed at gmail.com <mailto:cleanoutmyshed at gmail.com>>>
>> > *Sent: *20 October 2021 04:29
>> > *To: *David Carlson <mailto:david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com> <mailto:david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com>>>
>> > *Cc: *Public Address <mailto:public.address at hotmail.co.uk <mailto:public.address at hotmail.co.uk> <mailto:public.address at hotmail.co.uk <mailto:public.address at hotmail.co.uk>>>;
>> > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto: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 <mailto:cleanoutmyshed at gmail.com> <mailto:cleanoutmyshed at gmail.com <mailto: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>>
>> > <https://wiki.gnucash.org/wiki/Logging <https://wiki.gnucash.org/wiki/Logging> <https://wiki.gnucash.org/wiki/Logging <https://wiki.gnucash.org/wiki/Logging>>>
>> >  >     <https://wiki.gnucash.org/wiki/Logging <https://wiki.gnucash.org/wiki/Logging>
>> > <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>
>> > <https://go.microsoft.com/fwlink/?LinkId=550986 <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 <mailto:gnucash-user at gnucash.org>
>> > <mailto:gnucash-user at gnucash.org <mailto: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>>
>> > <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>>>
>> >  >     <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><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>>
>> > <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>>>
>> >  >     <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> <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 <mailto:gnucash-user at gnucash.org>
>> > <mailto:gnucash-user at gnucash.org <mailto: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>>
>> > <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>>>
>> >  >     <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><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>>
>> > <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>>>
>> >  >     <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> <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 at 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.



More information about the gnucash-user mailing list