Question Re: Error in tutorial Reuse a CAP Java Service step 6, Deploy bookstore domain model in Technology Q&A

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

motajko — Wed, 06 Oct 2021 18:39:13 GMT

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?

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

liat_b — Thu, 07 Oct 2021 08:53:23 GMT

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

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

marcopodratz — Thu, 07 Oct 2021 13:05:39 GMT

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

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

johannesvogel — Thu, 07 Oct 2021 14:19:39 GMT

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

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

motajko — Thu, 07 Oct 2021 14:39:59 GMT

Thank you for quick reaction. Waiting for fix.

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

johannesvogel — Wed, 13 Oct 2021 10:56:31 GMT

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

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

motajko — Wed, 13 Oct 2021 13:28:17 GMT

I confirm it works OK now.

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

johannesvogel — Wed, 13 Oct 2021 13:34:53 GMT

Thanks for the feedback!