[GNC] Export from Android can't open XML on Windows

[dragospuri]

John Ralls-2 wrote
>> On May 19, 2019, at 12:51 PM, dragospuri <

> dragospuri@

> > wrote:
>> 
>> Hello,
>> 
>> As the title says, the Android version of GnuCash works fine. I can
>> export
>> xml, not csv (says there are no transactions to export...). Don't know if
>> that matters.
>> 
>> After many hours googling I got to the trace file which has these 2
>> probably
>> important lines out of 30000:
>> 
>> * 22:34:02 ERROR 
> <gnc.backend.xml>
>  gnc_commodity*
>> dom_tree_to_commodity_ref(xmlNodePtr, QofBook*): assertion 'ret != NULL'
>> failed
>> 
>> * 22:34:07  WARN 
> <gnc.backend>
>  [GncXmlBackend::load()] Syntax error in Xml
>> File 
> <FILE ADDRESS>
>> 
>> How can I trace the NULL ref from here? Maybe correct the xml manually?
>> What can I do?
>> 
>> Android version: 2.4.0
>> Windows version: 3.5+(2019-03-30)
> 
> 
> The first one is saying that some commodity entry in the book isn't found
> in the commodities already loaded. That's probably not the problem,
> especially since the syntax error warning is 5 seconds later.
> 
> What are the 10 or so lines in the trace file immediately before the
> "Syntax error" message?
> 
> Regards,
> John Ralls
> _______________________________________________
> gnucash-user mailing list

> gnucash-user@

> 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.


Hi John,

Thank you for answering. I've been having this issue for a couple of years
and have only been updating my accounts on mobile, which is a lot slower...

These are the lines around the WARNING. They go like that for thousands of
lines above and hundreds below.


* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bd34de0
* 22:34:07  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bd34f00
* 22:34:07  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bd34de0
* 22:34:07  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bd34de0
* 22:34:07  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bac9040
* 22:34:07  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bac90d0
* 22:34:07  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bac91f0
* 22:34:07  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.translog> [xaccTransWriteLog] Attempt to write
disabled transaction log
* 22:34:07  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
trans=0bac9280
** 22:34:07  WARN <gnc.backend> [GncXmlBackend::load()] Syntax error in Xml
File D:\Google
Drive\GnuCash\20190519_220110_gnucash_export_MyFinance_12.gnucash.gnca*
* 22:34:07  INFO <gnc.account> [xaccAccountRecomputeBalance] acct=Template
Root starting baln=0/1
* 22:34:07  INFO <gnc.commodity> [gnc_commodity_table_insert] insert
0bd3ade0 template into nsp=0bc7eaf0 template
* 22:34:07  INFO <gnc.commodity> [gnc_commodity_table_insert] insert
0bf1b308 ADF into nsp=0bc73a10 CURRENCY
* 22:34:07  INFO <gnc.commodity> [gnc_commodity_table_insert] insert
0bf1b718 ADP into nsp=0bc73a10 CURRENCY
* 22:34:07  INFO <gnc.commodity> [gnc_commodity_table_insert] insert
0bf1aea8 AED into nsp=0bc73a10 CURRENCY
* 22:34:07  INFO <gnc.commodity> [gnc_commodity_table_insert] insert
0bf1b058 AFA into nsp=0bc73a10 CURRENCY
* 22:34:07  INFO <gnc.commodity> [gnc_commodity_table_insert] insert
0bf1b2d8 AFN into nsp=0bc73a10 CURRENCY
* 22:34:07  INFO <gnc.commodity> [gnc_commodity_table_insert] insert
0bf1b0d8 ALL into nsp=0bc73a10 CURRENCY



The only other out of the ordinary things I could find are at the very end
of the log file:

* 22:49:21  WARN <gnc.core-utils> Could not locate file AUTHORS
* 22:49:21  WARN <gnc.core-utils> Could not locate file DOCUMENTERS
* 22:49:21  WARN <gnc.core-utils> Could not locate file LICENSE

Any other way I could find more information about the syntax error?
The XML Tools plugin for Notepad++ doesn't give any parsing errors, so I
don't think it's an xml issue... But who knows.

Thanks again,
Dragos



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html