cancel
Showing results for 
Search instead for 
Did you mean: 

Error: SQLITE_ERROR: no such table: sqlite_schema after upgrade to cds v6.7.0

04-14-2023 12:15 PM
HPSeitz Active Participant
2746 views 3 comments
0 Likes
SAP Managed Tags
Subscribe

After upgrade to the lastest version of cds v6.7.0 the command cds deploy --to sqlite:mysqlite.db fails with the following error:

[Error: SQLITE_ERROR: no such table: sqlite_schema in: 
SELECT 1 FROM sqlite_schema ALIAS_1 WHERE name = ? LIMIT 1] {
  errno: 1,
  code: 'SQLITE_ERROR',
  query: 'SELECT 1 FROM sqlite_schema ALIAS_1 WHERE name = ? LIMIT 1',
  values: [ 'cds_xt_Extensions' ]<br>

With the previous version cds v6.6.1 it works fine and the deployment to sqlite work as expected. The cap project is a "normal" one, no extension stuff.

Is there any setting necessary to mark the project with the v6.7.0 version to prevent the failing SELECT statement?

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

HPSeitz
Active Participant
0 Likes

I guess the following will do the trick

"db": {
    "kind": "sqlite",
    "schema_evolution": "auto"
}
jlong
Product and Topic Expert
Product and Topic Expert
0 Likes
You might need to run `cds deploy` as well.
Ask a Question