Gnucash 2.6.18 export to sqlite is failing
bugzilla
bugzilla at orcon.net.nz
Sat Nov 4 09:52:31 EDT 2017
Hi everyone,
when I try to export my xml file to sqlite3 it fails with the following
error message in gnucash.trace
* 21:57:19 INFO <qof.object> [qof_object_foreach] type=gncTaxTable
* 21:57:19 INFO <qof.engine> [qof_collection_foreach] Hash Table size
of gncTaxTable before is 1
* 21:57:19 CRIT <gnc.backend.dbi> [sqlite3_error_fn()] DBI error: 19:
NOT NULL constraint failed: taxtable_entries.account
* 21:57:19 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()]
Error executing SQL INSERT INTO
taxtable_entries(taxtable,account,amount_num,amount_denom,type)
VALUES('08f93e8d3586eaa430e8f3213c1d0e0b',NULL,12000000,100000,1)
* 21:57:19 CRIT <gnc.backend.sql> [gnc_sql_do_db_operation()] SQL
error: INSERT INTO
taxtable_entries(taxtable,account,amount_num,amount_denom,type)
VALUES('08f93e8d3586eaa430e8f3213c1d0e0b',NULL,12000000,100000,1)
* 21:57:19 INFO <qof.engine> [qof_collection_foreach] Hash Table size
of gncTaxTable after is 1
* 21:57:19 INFO <qof.object> [qof_object_foreach] type=gncVendor
If I search my xml file for the string 08f93e8d3586eaa430e8f3213c1d0e0b
I will get entries which look like this:
<gnc:GncEntry version="2.0.0">
<entry:guid type="guid">07ec55f2b0c25d1fb9c6abc17e60e9bd</entry:guid>
<entry:date>
<ts:date>2014-08-08 12:00:00 +0200</ts:date>
</entry:date>
<entry:entered>
<ts:date>2009-11-19 09:59:37 +0100</ts:date>
</entry:entered>
<entry:description>Invoice description</entry:description>
<entry:qty>1000000/1000000</entry:qty>
<entry:i-acct
type="guid">8ca307f6b598a944c90b5a51e2ca59c4</entry:i-acct>
<entry:i-price>10600000/1000000</entry:i-price>
<entry:invoice
type="guid">ee97b01eaa71273e88224d4082b75f5b</entry:invoice>
<entry:i-disc-type>VALUE</entry:i-disc-type>
<entry:i-disc-how>SAMETIME</entry:i-disc-how>
<entry:i-taxable>0</entry:i-taxable>
<entry:i-taxincluded>0</entry:i-taxincluded>
<entry:i-taxtable
type="guid">08f93e8d3586eaa430e8f3213c1d0e0b</entry:i-taxtable>
</gnc:GncEntry>
<gnc:GncTaxTable version="2.0.0">
<taxtable:guid
type="guid">08f93e8d3586eaa430e8f3213c1d0e0b</taxtable:guid>
<taxtable:name>Steuertabelle 01</taxtable:name>
<taxtable:refcount>0</taxtable:refcount>
<taxtable:invisible>1</taxtable:invisible>
<taxtable:parent
type="guid">8e569076878f8126daafb6900ec07356</taxtable:parent>
<taxtable:entries>
<gnc:GncTaxTableEntry>
<tte:amount>12000000/100000</tte:amount>
<tte:type>VALUE</tte:type>
</gnc:GncTaxTableEntry>
</taxtable:entries>
</gnc:GncTaxTable>
<gnc:GncTaxTable version="2.0.0">
<taxtable:guid
type="guid">8e569076878f8126daafb6900ec07356</taxtable:guid>
<taxtable:name>Steuertabelle 01</taxtable:name>
<taxtable:refcount>0</taxtable:refcount>
<taxtable:invisible>0</taxtable:invisible>
<taxtable:child
type="guid">08f93e8d3586eaa430e8f3213c1d0e0b</taxtable:child>
<taxtable:entries>
<gnc:GncTaxTableEntry>
<tte:amount>12000000/100000</tte:amount>
<tte:type>VALUE</tte:type>
</gnc:GncTaxTableEntry>
</taxtable:entries>
</gnc:GncTaxTable>
However if I set up a new file with some test entries exporting to
sqlite3 is not a problem.
Would appreciate any hint which narrows the root course of this
problem.
Thanks
More information about the gnucash-devel
mailing list