Question Re: SAP CAP project with persistent database: Error - missing localized_* tables in Technology Q&A

SAP CAP project with persistent database: Error - missing localized_* tables

iashishsingh — Tue, 18 Feb 2020 05:23:12 GMT

Hello,

I am trying to run the sample bookshop app provided in the SAP CAP samples(https://github.com/SAP-samples/cloud-cap-samples). It runs as expected when using the default in-memory sqlite database (which is the default setting). If I try to change the settings to use a persistent sqlite database, the services are throwing errors of form:

SQLITE_ERROR: no such table: localized_<service-name>_<entitiy-name>

http://localhost:4004/browse/Books


<error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>500</code>
<message>SQLITE_ERROR: no such table: localized_CatalogService_Books</message>
</error>

Following is a step by step detail of what I've done. Any insight into what might be going wrong and how to fix it would be very much appreciated. Thanks!

Clone sample apps from https://github.com/SAP-samples/cloud-cap-samples

cd cloud-cap-samples/
npm i
npm run bookshop

The default configuration runs the sqlite database in-memory. In order to use the persistent database, do following changes:

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

The cds deploy command will create a persistent database and fill the necessary tables using sample CSV data files. It also updates the package.json with cds configuration to use a persistent database instead of the default in-memory database. You should see console messages like following:

> filling sap.capire.bookshop.Authors from db/data/sap.capire.bookshop-Authors.csv
 > filling sap.capire.bookshop.Books from db/data/sap.capire.bookshop-Books.csv
 > filling sap.capire.bookshop.Books_texts from db/data/sap.capire.bookshop-Books_texts.csv
 > filling sap.capire.bookshop.OrderItems from db/data/sap.capire.bookshop-OrderItems.csv
 > filling sap.capire.bookshop.Orders from db/data/sap.capire.bookshop-Orders.csv
 > filling sap.common.Currencies from db/data/sap.common-Currencies.csv
 > filling sap.common.Currencies_texts from db/data/sap.common-Currencies_texts.csv
/> successfully deployed to ./my.db
 > updated ./package.json

The package.json should have an updated "cds" section as follows -

"cds": {
    "requires": {
      "db": {
        "kind": "sqlite",
        "model": "db/schema.cds",
        "credentials": {
          "database": "my.db"
        }
      }
    }
  }

Now, if we trigger command 'cds run', the cds should start serving using the persistent database.

cds run

[cds] - connect to datasource - sqlite:my.db
[cds] - serving AdminService at /admin
[cds] - serving CatalogService at /browse - with impl: srv/cat-service.js
[cds] - service definitions loaded from:


  app/index.cds
  srv/admin-service.cds
  srv/cat-service.cds
  app/admin/fiori-service.cds
  app/browse/fiori-service.cds
  app/orders/fiori-service.cds
  app/common.cds
  db/schema.cds
  ../../node_modules/@sap/cds/common.cds


[cds] - launched in: 1303.835ms
[cds] - server listening on http://localhost:4004

Now, if you go to link http://localhost:4004/browse/Books, it shows following error:

<error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>500</code>
<message>SQLITE_ERROR: no such table: localized_CatalogService_Books</message>
</error>

Re: SAP CAP project with persistent database: Error - missing localized_* tables

david_kunz2 — Tue, 18 Feb 2020 06:04:15 GMT

Dear Ashish,

Thanks for reporting this issue, it seems like a bug!
Which version of `@sap/cds` are you using? You can find this information by typing `cds -v`.

I tested it with `@sap/cds: 3.21.3` and it works fine.

Thanks and best regards,
David

Re: SAP CAP project with persistent database: Error - missing localized_* tables

iashishsingh — Tue, 18 Feb 2020 06:29:31 GMT

Hi David,

Thanks for your quick reply!

My machine also has the same 3.21.3 version. Here is the output of `cds -v`:

@sap/cds-dk: 1.4.4
@sap/cds: 3.21.3
@sap/cds-compiler: 1.21.1
@sap/cds-foss: 1.1.0
@sap/cds-messaging: 1.5.0
@sap/cds-reflect: 2.9.2
@sap/cds-rest: 1.3.0
@sap/cds-services: 1.22.0
@sap/generator-cds: 2.11.1
Node.js: v10.16.0<br>

The bookshop/package.json has "@sap/cds": "latest" under "dependencies".

Sorry, I did not clearly understand you. Is it a bug in cds or does it look like a setup issue at my end?

Thanks David!

Re: SAP CAP project with persistent database: Error - missing localized_* tables

iashishsingh — Tue, 18 Feb 2020 06:32:20 GMT

Some additional information:

If I deploy the same app to SAP HANA cloud using the guide: https://cap.cloud.sap/docs/advanced/deploy-to-cloud, the service works fine as expected. The issue appears to be occurring when using the persistent database as sqlite.

Re: SAP CAP project with persistent database: Error - missing localized_* tables

qmacro — Tue, 18 Feb 2020 07:04:55 GMT

Great question, well formed and lots of detail. Nice work!

Re: SAP CAP project with persistent database: Error - missing localized_* tables

iashishsingh — Tue, 18 Feb 2020 07:16:40 GMT

Hi dj.adams.sap and thanks! Have learned a lot from your live recordings which I discovered very recently on Youtube. Can't appreciate you enough for the efforts you have been making!

Re: SAP CAP project with persistent database: Error - missing localized_* tables

chgeo — Wed, 19 Feb 2020 08:36:28 GMT

Could you change the `model` property in package.json to

"model": ["db", "srv"]

and try again?

Re: SAP CAP project with persistent database: Error - missing localized_* tables

iashishsingh — Thu, 20 Feb 2020 05:10:59 GMT

Hi Christian. Thanks for your suggestion! I tried changing it to

"model": ["db", "srv"]

but getting the same error as before. To make it easier for the error to be reproduced, I've pushed my changes under a fork of cloud-cap-samples repo here: https://github.com/git-ashish/cloud-cap-samples. The changes have been made to packages/bookshop folder.

Thanks.

Re: SAP CAP project with persistent database: Error - missing localized_* tables

chgeo — Thu, 20 Feb 2020 13:19:18 GMT

We have analysed the issue and will fix it in the next release (around next week). As a workaround you can revert this commit in the bookshop repository.

Anyways, thanks for reporting!

Re: SAP CAP project with persistent database: Error - missing localized_* tables

iashishsingh — Fri, 21 Feb 2020 12:33:14 GMT

Thanks Christian! Reverting this commit did not solve the error but looking forward the fix in the next release!

Re: SAP CAP project with persistent database: Error - missing localized_* tables

jalf1991 — Tue, 02 Jun 2020 02:46:02 GMT

Hi @christian.georgi

the issue is with this package.json file. I delete this lines in the json and all run fine:

"requires": { "db": { "kind": "sqlite", "model": [ "db", "srv" ], "credentials": { "database": "sqlite.db" } } }

Re: SAP CAP project with persistent database: Error - missing localized_* tables

former_member643578 — Thu, 02 Jul 2020 04:57:02 GMT

Instead of cds run command try the following command

npx nodemon -e cds,csv,properties -w app -w db -x "cds deploy && cds run"

Re: SAP CAP project with persistent database: Error - missing localized_* tables

hschaefer123 — Fri, 25 Sep 2020 14:56:20 GMT

Hi,
i have similar issues after deployment to CFm but just using in-memory db!

Re: SAP CAP project with persistent database: Error - missing localized_* tables

NicolasSchwarz — Thu, 21 Jan 2021 09:00:23 GMT

Hey, I faced the same problem with the localized-error. Did you find a solving?

Re: SAP CAP project with persistent database: Error - missing localized_* tables

former_member214945 — Fri, 07 May 2021 00:05:24 GMT

This really does the trick. Thanks!

Re: SAP CAP project with persistent database: Error - missing localized_* tables

jasonmuzzy — Wed, 09 Jun 2021 00:35:31 GMT

This really does work, thank you! Can you explain what this command is doing differently than just normal cds deploy followed by cds run?

Re: SAP CAP project with persistent database: Error - missing localized_* tables

MattRook — Mon, 09 Sep 2024 19:45:54 GMT

Hi I know this is an old post but I am currently doing this same training project and I have the same issue. I'm surprised there isn't a more definitive solution 4 years later but I got it to work. I have had this problem before on other frameworks and the problem lies in the package-lock.json file. Delete that file, do an 'npm install' and redeploy with 'cds deploy'. That should refresh the package-lock file and update all the settings and work.