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 <geert.gnuc...@kobaltwit.be> 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 < > geert.gnuc...@kobaltwit.be> > > > > > > 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 gnucash-user@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.
