[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