Getting Error While deploying data model to SQLITE

[saurabh009]

In this Tutorial:

https://developers.sap.com/tutorials/cp-apm-nodejs-create-service.html

Step 7.2 : Deploy the data model to an SQLite database:

cds deploy --to sqlite:db/my-bookshop.db

How to do that ?

I am getting Errors..error-1.jpgerror-2.jpg

[saurabh009]

The Correct Screesnhot attached (Please ignore others)error.jpg

[maxstreifeneder]

on another note: you have to install the sqlite package within your CAP project directory. don't think your project directory is called saurabh.sharma1?

[saurabh009]

iinside What do you meant by "CAP project directory" ? i am not clear

i am running command from Project path only

this one ran successfully:

npm install -D sqlite3

but this one giving error still even after node.js 12 version installed:

ds deploy --to sqlite:db/my-bookshop.db

[saurabh009]

Successfully done with:

choco install nodejs-lts

npm install -D sqlite3

Still giving Error:

cds deploy --to sqlite:db/my-bookshop.db

[saurabh009]

SAME ERROR

[saurabh009]

still getting error

[saurabh009 · Accepted solution]

RESOLVED now on my own.

What i did ? Delete and re-run all steps.

Where was error: File directory and 1 intermediate step was not performed properly.

Thanks to all for your kind support !

resolved-now.jpg

[maxstreifeneder]

Both commands need to be executed within the created CAP project. Doesn't seem you are executing them in the CAP project directory.

npm install -D sqlite3

cds deploy --to sqlite:db/my-bookshop.db

[saurabh009]

Also getting this erro now inside VSC

new-error.jpg

[maxstreifeneder]

I assume it is because you are running it in PowerShell. Please try to change your default Shell in VSCode to Bash.
otherwise your cds executable is not installed. (npm install -g @sap/cds-dk)

[qmacro]

Hi Saurabh, looks like you have some issues on your Windows machine that is preventing the build of the sqlite3 native components. In your case, I would recommend you take a look at the prerequisites for the CAP Node.js CodeJam, where the instructions take you through a nice way of installing the build tools for that OS, using the Chocolatey package manager. Then you can restart or continue with rene.jeglinsky 's tutorial. HTH!

[saurabh009]

Still getting same error after following all steps !

[chgeo]

Hi,

this is most certainly caused by the Node.js version 13 that you use. I guess for Node.js 13 there is no SQLite binary available (yet).

In general we recommend only to use long-term support (LTS) versions of Node.js. Version 12 is the latest LTS version, so my advice is to use this one (see LTS release timeline). It's also this version that is advertised on Node.js's download page as "Recommended for most users".

Regards,

Christian

[qmacro]

Saurabh, can you share with us what the output of the following was when you ran the following (from the prerequisites page)?

choco install nodejs-lts

[saurabh009]

capture.jpg

This is the output

node.js already installed

Check the version in 2nd screenshotnodejs-version.jpg

[saurabh009]

yes i have node.js 13 version only

thanks @Christian Georgi