Hi CAP Experts, I am working on the CAP Tutorial https://developers.sap.com/tutorials/cp-apm-nodejs-create-service.html#ad94d17b-8f0d-420e-b658-d44828bbee6b. In step 7 – add initial data, I added the data as per the tutorial though I observed that the “cds add data” command created ; separated fields. So, I changed my data like below.
my.bookshop-Authors.csv
ID;name
101;Emily Brontë
107;Charlote Brontë
150;Edgar Allen Poe
170;Richard Carpenter
my.bookshop-Books.csv where I changed the column separators as , instead of ;
ID,title,author_ID,stock
201,Wuthering Heights,101,12
207,Jane Eyre,107,11
251,The Raven,150,333
252,Eleonora,150,555
271,Catweazle,170,22
But as soon as I save those files, I get below errors in cds watch
[Error: ENTITY_ALREADY_EXISTS] {
errno: 19,
code: 400,
originalMessage: ‘SQLITE_CONSTRAINT: UNIQUE constraint failed: my_bookshop_Authors.ID’,
numericSeverity: 4
}
Please help.
Thanks,
Mainak