I have this version installed as well Version: 3.10 Build ID: 3.10+(2020-04-11) Finance::Quote: 1.49
What shall I check? On Wed, Jul 1, 2020 at 11:52 AM Lipp F. <[email protected]> wrote: > It is a bug indeed. Standard Windows path works fine in some parts of the > code but not everywhere. You can see the book file loaded and identified as > sqlite3. See logs below. > > > C:\tools\gnucash\bin>gnucash-cli.exe --debug --report run --name="Net > Worth Linechart" --output-file=r-nwl.html > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' > * 11:46:50 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] > GNC_DBD_DIR not set: using libdbi built-in default > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] 3 DBD > drivers found > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver: > mysql > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver: > pgsql > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver: > sqlite3 > * 11:46:51 INFO <gnc.gui> [Gnucash::CoreApp::start] System locale > returned (null) > * 11:46:51 INFO <gnc.gui> [Gnucash::CoreApp::start] Effective locale set > to English_United States.1252. > * 11:46:51 INFO <gnc.engine> [gnc_hook_num_args] no hook lists > * 11:46:51 MESSG <gnc.report.core> loading saved reports > * 11:46:51 MESSG <gnc.report.core> loading stylesheets > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-days, settings_ptr: 01534078, handler_id: 1 > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-type-never, settings_ptr: 01534078, > handler_id: 2 > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-type-days, settings_ptr: 01534078, handler_id: > 3 > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-type-forever, settings_ptr: 01534078, > handler_id: 4 > * 11:46:52 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: file-compression, settings_ptr: 01534078, handler_id: > 5 > * 11:46:52 INFO <gnc.gui> [scm_run_report] Loading datafile > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'... > * 11:46:52 INFO <gnc.account> [xaccAccountRecomputeBalance] acct=Template > Root starting baln=0/1 > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 0726ec30 template into nsp=0702b1a0 template > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 097add18 ADF into nsp=0702b220 CURRENCY > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 097adcf8 ADP into nsp=0702b220 CURRENCY > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 097adc08 AED into nsp=0702b220 CURRENCY > ..................... > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 098a4228 XPD into nsp=0702b220 CURRENCY > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 098a4258 XPT into nsp=0702b220 CURRENCY > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 098a42a8 XSU into nsp=0702b220 CURRENCY > * 11:47:02 INFO <qof.session> [QofSessionImpl::load_backend] Selected > provider GnuCash Libdbi (SQLITE3) Backend > * 11:47:02 INFO <gnc.backend.dbi> > [QofDbiBackendProvider<Type>::type_check] doesn't exist (errno=5) -> DBI > * 11:47:02 WARN <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()] > Sqlite3 file 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' > not found > * 11:47:02 INFO <qof.session> [QofSessionImpl::begin] Done running > session_begin on backend > * 11:47:02 ERROR <gnc.gui> [scm_cleanup_and_exit_with_failure()] Session > Error: Sqlite3 file > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' not found > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncVendor before is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncVendor after is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEntry before is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEntry after is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEmployee before is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEmployee after is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncCustomer before is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncCustomer after is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncInvoice before is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncInvoice after is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > Lot before is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > Lot after is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > Budget before is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > Budget after is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > SchedXaction before is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > SchedXaction after is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > Trans before is 0 > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > Trans after is 0 > > On Wed, Jul 1, 2020 at 11:31 AM Geert Janssens <[email protected]> > wrote: > >> Ok, this does look like a bug. >> >> >> >> Just to estimate the scope, can you open the data file in gnucash from >> the command line ? That is, does >> >> C:\tools\gnucash\bin>gnucash.exe >> /C/Users/*****/Downloads/gnuCash-test-2/t14.sqlite3.gnucash >> >> or >> >> C:\tools\gnucash\bin>gnucash-cli.exe >> C:\Users\*****\Downloads\gnuCash-test-2\t14.sqlite3.gnucash >> >> work ? >> >> >> >> Did this work in 3.x ? >> >> >> >> Regards, >> >> >> >> Geert >> >> >> >> Op woensdag 1 juli 2020 17:22:47 CEST schreef Lipp F.: >> >> > Still not working, different error though. Tried uppercase C and >> >> > lowercase c as well: >> >> > >> >> > C:\tools\gnucash\bin>gnucash-cli.exe --report run --name="Net Worth >> >> > Linechart" --output-file=r-nwl.html >> >> > /C/Users/*****/Downloads/gnuCash-test-2/t14.sqlite3.gnucash >> >> > * 11:16:08 WARN <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()] >> >> > Sqlite3 file /C/Users/*****/Downloads/gnuCash-test-2/t14.sqlite3.gnucash >> >> > not found >> >> > * 11:16:08 ERROR <gnc.gui> [scm_cleanup_and_exit_with_failure()] Session >> >> > Error: Sqlite3 file >> >> > /C/Users/*****/Downloads/gnuCash-test-2/t14.sqlite3.gnucash not found >> >> > >> >> > On the other hand, if the file paths have no directory, gnucash-cli >> works >> >> > as expected. >> >> > >> >> > >> >> > >> >> > On Wed, Jul 1, 2020 at 10:59 AM Geert Janssens < >> [email protected]> >> >> > >> >> > wrote: >> >> > > Op woensdag 1 juli 2020 15:08:29 CEST schreef Lipp F.: >> >> > > > Hi everyone, >> >> > > > >> >> > > > >> >> > > > >> >> > > > Just evaluating 4.0 on Windows 10, sqlite3 backend, before a full >> >> > > >> >> > > switch. I >> >> > > >> >> > > > have noticed that gnucash-cli.exe does not seem to work: >> >> > > > >> >> > > > >> >> > > > >> >> > > > C:\tools\gnucash\bin>gnucash-cli.exe --debug --quotes get <file >> name> >> >> > > > >> >> > > > ................... >> >> > > > >> >> > > > * 08:54:19 INFO <qof.session> [QofSessionImpl::load_backend] The >> >> > > > provider >> >> > > > >> >> > > > providers access_method, file, but we're loading for access_method, >> C. >> >> > > > >> >> > > > Skipping. >> >> > > > >> >> > > > * 08:54:19 INFO <qof.session> [QofSessionImpl::load_backend] The >> >> > > > provider >> >> > > > >> >> > > > providers access_method, sqlite3, but we're loading for >> access_method, >> >> > > > C. >> >> > > > >> >> > > > Skipping. >> >> > > > >> >> > > > * 08:54:19 INFO <qof.session> [QofSessionImpl::load_backend] The >> >> > > > provider >> >> > > > >> >> > > > providers access_method, mysql, but we're loading for >> access_method, C. >> >> > > > >> >> > > > Skipping. >> >> > > > >> >> > > > * 08:54:19 INFO <qof.session> [QofSessionImpl::load_backend] The >> >> > > > provider >> >> > > > >> >> > > > providers access_method, postgres, but we're loading for >> access_method, >> >> > > >> >> > > C. >> >> > > >> >> > > > Skipping. >> >> > > > >> >> > > > * 08:54:19 INFO <qof.session> [QofSessionImpl::load_backend] The >> >> > > > provider >> >> > > > >> >> > > > providers access_method, xml, but we're loading for access_method, >> C. >> >> > > > >> >> > > > Skipping. >> >> > > > >> >> > > > * 08:54:19 INFO <qof.session> [QofSessionImpl::load_backend] The >> >> > > > provider >> >> > > > >> >> > > > providers access_method, file, but we're loading for access_method, >> C. >> >> > > > >> >> > > > Skipping. >> >> > > > >> >> > > > * 08:54:19 ERROR <gnc.gui> [scm_cleanup_and_exit_with_failure()] >> Session >> >> > > > >> >> > > > Error: failed to get_backend using access method "C" >> >> > > > >> >> > > > >> >> > > > >> >> > > > Same error for reporting: >> >> > > > >> >> > > > >> >> > > > >> >> > > > C:\tools\gnucash\bin>gnucash-cli.exe --debug --report run >> >> > > >> >> > > --name="Advanced >> >> > > >> >> > > > Portfolio" --output-file=rpt.html <file name> >> >> > > > >> >> > > > >> >> > > > >> >> > > > >> >> > > > >> >> > > > I would assume that "failed to get_backend using access method "C" >> >> > > > >> >> > > > " refers somehow to the book file but after trying backslash, slash >> and >> >> > > > >> >> > > > double backslash in the file name, the result is the same. >> >> > > >> >> > > Have you tried >> >> > > >> >> > > "/c/path/to/your/book" ? >> >> > > >> >> > > >> >> > > >> >> > > Regards, >> >> > > >> >> > > >> >> > > >> >> > > Geert >> >> >> >> >> > _______________________________________________ gnucash-user mailing list [email protected] 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.
