on 2022 Feb 02 1:29 PM
Hi experts,
I am currently developing a node-based CAP-application with HANA as database. I have created a table via CDS that manages the assignment between user and a warehouse. It all ran fine but recently some problems started coming up when trying to change data in the table when the user ID column contains the '@' sign (which in productive scenarios is always because we are using email addresses for the user ID). In my test cases, the data manipulation ran fine when omitting the '@' sign (which is not really a possibility without bigger restructuring)
When trying to update the data, the request basically times out. It does not matter if I update the data programmatically via CAP, via direct OData calls to the table entity or directly in HANA DB Explorer (no difference between change via Open Data or INSERT/UPDATE statement)
My dependencies in package.json look as follows:
"dependencies": {
"@sap/approuter": "~10.2.0",
"@sap/audit-logging": "~5.0.0",
"@sap/cds": "~5.0.4",
"@sap/cds-odata-v2-adapter-proxy": "~1.6.1",
"@sap/hana-client": "~2.7.26",
"@sap/xsenv": "~3.1.0",
"@sap/xssec": "~3.1.2",
"express": "~4.17.1",
"node-rest-server": "~2.0.0",
"passport": "~0.4.1"
},
"devDependencies": {
"@sap/hdi-deploy": "~4",
"@sap/html5-app-deployer": "2.0.0"
},
The table is defined as seen below
@cds.autoexpose
entity User2ForwardingAgent {
key UserId : String(100);
key ForwardingAgentId : String(20);
User : Association to one UserMaster
on $self.UserId = User.Username;
ForwardingAgent : Association to one ForwardingAgent
on $self.ForwardingAgentId = ForwardingAgent.ForwardingAgentId;
}
// related tables for completeness:
entity UserMaster : managed {
key Username : String(100);
Email : String(100);
Firstname : String(30);
Lastname : String(30);
Language : String(2);
UserType : String(1) enum {
T = 'customerintenal';
W = 'warehouse';
A = 'forwardingagent';
P = 'PowerUser';
};
IsActive : Boolean;
Warehouses : Association to many User2Warehouse
on $self.Username = Warehouses.UserId;
ForwardingAgents : Association to many User2ForwardingAgent
on $self.Username = ForwardingAgents.UserId;
whses : String;
agents : String;
}
entity ForwardingAgent {
key ForwardingAgentId : String(20);
Description : String(100);
City : String(40);
Country : String(50);
Street : String(100);
Users : Association to many User2ForwardingAgent
on $self.ForwardingAgentId = Users.ForwardingAgentId;
Warehouses : Association to many Warehouse2ForwardingAgent
on $self.ForwardingAgentId = Warehouses.ForwardingAgentId;
}
Your used CAP version is very old. I would suggest you try an upgrade.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.