SAP Business application studio, sqlite connection issue

[former_member705678]

I have implemented service in the business application studio and tried to connect with Sqlite. When I am trying to establish an SQLite connection system is showing the error as "You need to install "sqlite3@4.1.1" to connect to SQLite -bookshop'.

When I try to install s showing the error as "Failed to install dependencies for SQLite: Request DependencyInstaller/install failed with message: > sqlite3@4.1.1 install /tmp/vscode-unpacked/sqltools-0.21.8.vsix/extension/node_modules/sqlite3 > node-pre-gyp install --fallback-to-build sh: 1: node-pre-gyp: not found npm ERR! code ELIFECYCLE npm ERR! syscall spawn npm ERR! file sh npm ERR! errno ENOENT npm ERR! sqlite3@4.1.1 install: node-pre-gyp install --fallback-to-build npm ERR! spawn ENOENT npm ERR! npm ERR! Failed at the sqlite3@4.1.1 install script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above. npm ERR! A complete log of this run can be found in: npm ERR! /home/user/.npm/_logs/2020-09-13T03_38_30_462Z-debug.log".

[maheshpalavalli · Accepted solution]

It looks like an issue from SAP, you can follow the below link:

https://github.com/SAP-samples/sap-devtoberfest-2020/issues/44

Meanwhile as suggested above, try using SQLite CLI to get the information.

Regards,

Mahesh

[former_member705678 · Accepted solution]

Hi Mahesh,

Thanks for replies

But still, I'm getting the same error.

[maheshpalavalli · Accepted solution]

abhisheksingh98 yes it will not work, as per max, sap will come with fix next week.Meanwhile, you can use the SQLite CLI(Command line interface) to check the tables and data, but you have to manually type commands there.Regards,Mahesh

[former_member705678 · Accepted solution]

Yes maheshkumar.palavalli, I can see the table by manual type.Thank you.