Hello Experts,Tried to run cds deploy with SQLite3 db with option "schema_evolution": "auto". I am using "dummy" authorisation.cds version: 7.7.0swlite3 version: 5.1.7Do you know if it is supposed to work at all?Currently, I get this error:[Error: SQ...
Hi,
My preferable IDE for developing SAP Cloud Foundry apps is VSCode and I successfully managed to run all the applications from the laptop (using default-services.json and default-env.json files) and almost all Cloud Foundry services can be consu...
Recently we moved our development to the Cloud.
Our MTA application uses HANA DB service in the cloud and creates DB tables at run-time (using CREATE TABLE statement). We also use HDI container to define and deploy DB artifacts to the cloud.
An...
Just a moments ago tried to build my MTA project and currently the build fails with the following error:
20:48:11 (Executor) Running "openui5_preload:preloadTmp" (openui5_preload) task20:48:12 (Executor) Warning: Cannot read property 'length' of un...
An hour ago Web IDE stopped building - all attempts to run build from within Web IDE fail. The task "prerequisites for Task for mta build" runs for a few minutes and then message appears:
(MTA BUILD) Failed to sync the workspace.
And the overall...
I figured this out: deleting the old db file and deploying the db with schema_evolution set to auto was necessary. In this case, an additional table will be created in the db:CREATE TABLE cds_model (csn CLOB);The single entry in this table contains...
We have been having this issue from time to time, and so far the only trick helps: completely undeploy the whole MTA, then deploy again.To display the MTA list use `cf mtas` command, then use `cf undeploy <your mta name>`
Another solution: create a separate schema for db objects created at run-time, though this leads to a bunch of tasks - granting privileges to that schema, separate users, etc.
Hi Piyush,If you change the ownership of the table then you can drop the table using DB explorer, because you access DB with #00 user. Or you can use a stored procedure with dynamic SQL to call it at run-time.
Hi Arley,Thanks for the suggestion. Actually we have been using VSCode for a couple of years by now, so yes we use also this approach. Besides, while developing we normally run the whole application on the local machine (e.g. developer's laptop) and ...
