Question Re: Getting Error While deploying data model to SQLITE in Technology Q&A

Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 06:30:18 GMT

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.jpg error-2.jpg

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 06:35:14 GMT

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

Re: Getting Error While deploying data model to SQLITE

qmacro — Wed, 06 Nov 2019 06:35:36 GMT

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!

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 07:14:51 GMT

Still getting same error after following all steps !

Re: Getting Error While deploying data model to SQLITE

chgeo — Wed, 06 Nov 2019 07:37:21 GMT

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

Re: Getting Error While deploying data model to SQLITE

qmacro — Wed, 06 Nov 2019 07:43:53 GMT

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

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 07:50:30 GMT

capture.jpg

This is the output

node.js already installed

Check the version in 2nd screenshotnodejs-version.jpg

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 07:52:12 GMT

yes i have node.js 13 version only

thanks @Christian Georgi

Re: Getting Error While deploying data model to SQLITE

maxstreifeneder — Wed, 06 Nov 2019 07:56:19 GMT

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?

Re: Getting Error While deploying data model to SQLITE

maxstreifeneder — Wed, 06 Nov 2019 07:59:18 GMT

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

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 08:03:34 GMT

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

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 08:04:51 GMT

Successfully done with:

choco install nodejs-lts

npm install -D sqlite3

Still giving Error:

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

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 08:05:07 GMT

SAME ERROR

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 08:40:00 GMT

still getting error

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 08:42:42 GMT

Also getting this erro now inside VSC

new-error.jpg

Re: Getting Error While deploying data model to SQLITE

maxstreifeneder — Wed, 06 Nov 2019 11:48:03 GMT

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)

Re: Getting Error While deploying data model to SQLITE

saurabh009 — Wed, 06 Nov 2019 17:59:05 GMT

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