cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Following step-by-step tutorial "Reuse a CAP Java Service" (Reuse a CAP Java Service | Tutorials for SAP Developers) and when in step 6 "Deploy bookstore domain model" I run command

cds deploy --to sqlite

I get following error in SAP Business Applications Studio:

user: bookstore $ cds deploy --to sqlite
 > filling sap.capire.bookstore.Authors from ./db/data/sap.capire.bookstore-Authors.csv 
 > filling sap.capire.bookstore.Books from ./db/data/sap.capire.bookstore-Books.csv 
[ERROR] SQLITE_ERROR: cannot modify sap_capire_bookstore_Books because it is a view in: 
INSERT INTO sap_capire_bookstore_Books ( ID, title, descr, author_ID, stock, price, currency_code, category_ID, createdAt , createdBy, modifiedAt, modifiedBy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

I was afraid of typos so I re-created the whole DevSpace from scratch when I first encountered this error and repeated all the steps again. Result is the same.

Any hints what may be wrong?

0 Likes
View Entire Topic
johannesvogel
Product and Topic Expert
Product and Topic Expert

Hi otajovicmilan82 and marcopodratz,

thank you for reporting!

This issue was also reported internally already and we're working on a fix.

We are very sorry for that inconvenience.

Best regards,

Johannes