Error in tutorial Reuse a CAP Java Service step 6, Deploy bookstore domain model

[motajko]

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?

[marcopodratz]

Very intersted on how it is possible to sort this out as i just run into the same problem!

[johannesvogel · Accepted solution]

Hi otajovicmilan82 and marcopodratz ,

we just released @sap/cds version 5.5.4 which includes the fix for this issue.

Thank you again for reporting and have a nice day,

Johannes

[motajko · Accepted solution]

I confirm it works OK now.

[johannesvogel · Accepted solution]

Thanks for the feedback!

[johannesvogel]

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

[motajko]

Thank you for quick reaction. Waiting for fix.

[liat_b]

Hi, iwona.hahn can you please take a look?