[GNC] Session Error: failed to get_backend using access method "C"

Wed Jul 1 11:52:48 EDT 2020

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