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

Wed Jul 1 12:11:59 EDT 2020

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. <flipp31a at gmail.com> 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 <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
>>
>>
>>
>>
>>
>