Change tracking not working in Multi-tenant CAP Nodejs Project

[vishalsharma190596]

I am trying to add the plugin @cap-js/change-tracking to store change logs for an Entity in my CAP Nodejs multi tenant Project.

I have followed the guide to implement this Change Tracking Plugin for SAP Cloud Application Programming Model (CAP).

I have added the @changelog annotations to an entity for which I am trying to track changes. This brings the facet in the fiori elements object page. And when I trying to edit a record and save it from the app I am getting below error:

no such table: sap_changelog_ChangeLog in: INSERT INTO sap_changelog_ChangeLog

Below is how I have added the annotation to my service entity in file app/managebooks/annotations.cds :

annotate service.Books with {
title @changelog;
};

It needs the table sap_changelog_ChangeLog to persist the change log entries but just by adding the module in package.json and adding annotation to properties is not generating the table while doing local testing with sqlite. Please let me know if there are some steps missed here.

Thanks & Regards,
Vishal Sharma

[vishalsharma190596]

Please find the Git repo for the sample app below:
https://github.tools.sap/I583347/change-tracking.git

[nkaputnik]

@vishalsharma190596
did you also redeploy/build the database after installing the change log plugin?

Best,
Nick

[vishalsharma190596]

@nkaputnik Yes I have done the cds build and redeployement multiple times. Still no issues. Request you to please get the sample project from the git repo I have mentioned above and let me know if there are any issues you could recognize. Also would appreciate it if you could try to replicate the change tracking in the same multi-tenant project from the git repo.

Thanks & Regards,
Vishal Sharma

[nkaputnik]

Hello @vishalsharma190596
can you give me you SAP User ID, I'll set up a meeting next week to jointly go through the use case, the repo you gave me doesn't have any noticable issues for me.

Best,
Nick

[vishalsharma190596]

Sure Nick,

My SAP email id is vishal.sharma08@sap.com

Thanks & Regards,
Vishal Sharma

[gekko68]

Hi, has this issues being resolved as I am having the same issue. Multi Tenant Project with HANA. The tables are not getting generated .

Update : I fixed the issue as we have build tasks in package.json and I added "@cap-js/change-tracking"

{
"for": "hana",
"options": {
"model": [
"db",
"db/hana",
"tenant-api/srv",
"srv/srv",
"@sap/cds-mtxs/db/extensions",
"@sap/cds-mtxs/srv/bootstrap",
"@sap/cds-common-content",
"@cap-js/change-tracking"
]
}
},

But now I get the following error :

invalid column name: CHANGES

and :

INSERT INTO sap_changelog_ChangeLog (entity,entityKey,serviceEntity,changes) VALUES (?,?,?,?)

However this is how the table gets generated and there is no field "Changes"

COLUMN TABLE sap_changelog_ChangeLog (
createdAt TIMESTAMP,
createdBy NVARCHAR(255),
modifiedAt TIMESTAMP,
modifiedBy NVARCHAR(255),
ID NVARCHAR(36) NOT NULL,
serviceEntity NVARCHAR(5000),
entity NVARCHAR(5000),
entityKey NVARCHAR(36),
PRIMARY KEY(ID)
)

Any idea ?