Getting error when saving a draft - incorrect syntax near "=": line 1 col 332 (at pos 332)

[louenas]

Describe the bug
Getting the following error when saving the Draft

[cds] - SqlError {message: 'sql syntax error: incorrect syntax near "=": line 1 col 332 (at pos 332)', code: 257, sqlState: 'HY000', level: 1, position: 0, …}
cds-log.js:101
[error] - 500 > {
message: 'sql syntax error: incorrect syntax near "=": line 1 col 332 (at pos 332)',
code: '257'
}

To Reproduce
Click on Upload and then click on Save

Expected behavior
Should save the attachment
[ ] is it a regression issue?
not sure

Screenshots

Here is the project dependencies:
Th project is using HANA Cloud. I could see that the attachment Tables where created.
"dependencies": {
"@cap-js/attachments": "^1.1.8",
"@cap-js/hana": "^1",
"@sap-ai-sdk/foundation-models": "^1.3.0",
"@sap-ai-sdk/orchestration": "^1.3.0",
"@sap-cloud-sdk/http-client": "^3.22.2",
"@sap-cloud-sdk/util": "^3.22.2",
"@sap/cds": "^8",
"@sap/low-code-event-handler": "^1.2.4",
"@sap/mdk-tools": "^1.3.1",
"@sap/xsenv": ">=3.3.2 <3.3.3",
"@sap/xssec": "^4.2.6",
"express": "^4",
"hdb": "^0.19.10",
"passport": "^0.7.0"
},
"devDependencies": {
"@cap-js/cds-types": "^0.6",
"@cap-js/sqlite": "^1",
"@sap/dev-cap-tools": "^1.31.0",
"@sap/ux-specification": "UI5-1.120"
}

[liandroK]

Have the same problem

[SoujitD-SAP]

Hi @louenas
I was looking into this issue with the same dependencies you mentioned, but it did not produce any error mentioned above. Screenshots attached below

Regards
Soujit Das

[louenas]

I just tested with embedded SQL Lite, and it worked! I get the error when I test with HANA Cloud.

[SoujitD-SAP]

Hi @louenas
I tested the attachment plugin with the hybrid environment using hana cloud bindings and other dependencies you mentioned above, but it did not produce any error mentioned. Could you provide some sample applications along with the configurations so that we can test it and reproduce the error.

Regards
Soujit Das

[SoujitD-SAP]

Hi @louenas , We tested your app using the HANA bindings and other dependencies for the attachments plugin, but it did not reproduce any error.

Regards
Soujit

[pallavjadav]

Hi @SoujitD-SAP ,

I am facing similar issue.

Below is repo link.
https://github.com/pallavjadav/attachment-demo

I am trying to use SAP HANA Cloud here.

Reference - https://community.sap.com/t5/technology-blogs-by-members/working-with-the-attachment-plugin-cloud-application-programming/ba-p/13705424

Thanks,
Pallavkumar Jadav