cap-js / attachments

The @cap-js/attachments package is a CDS plugin that provides out-of-the box asset storage and handling by using an aspect Attachments. It also provides a CAP-level, easy to use integration of the SAP Object Store.
Apache License 2.0
6 stars 4 forks source link

CAP/Fiori Elements application error during save #58

Closed ch-sap closed 3 weeks ago

ch-sap commented 3 weeks ago

Hi,

we have a CAP/Fiori Elements application with cap-js/attachment and deployed it to cloud foundry. We used object store to save the attachments.

The attachment association is added to an entity which is draft-enabled

The attachment reuse UI is shown and I could successfully upload a text file, but when I save the draft, I get an error.

The CF log shows me: 46f4e81c0e6","timestamp":1717600545660,"msg":"sql syntax error: incorrect syntax near \")\": line 1 col 100 (at pos 100)","message":"sql syntax error: incorrect syntax near \")\": line 1 col 100 (at pos 100)","code":257,"sqlState":"HY000","position":100,"query":"SELECT url AS \"url\" FROM localized_PoetrySlamService_PoetrySlams_attachments ALIAS_1 WHERE ID IN ( )"

In chrome, I get: Log-dbg.js:499 2024-06-05 17:15:45.205100 Failed to execute /PoetrySlams(ID=79ceab87-300d-4b66-8cc3-f82c679b77a1,IsActiveEntity=false)/PoetrySlamService.draftActivate(...) - Error: Communication error: 500 Internal Server Error

Could you please give advice?

Best regards, Christine

muskansethi1 commented 3 weeks ago

Hi @ch-sap,

Can you check which version of the plugin is being used? This issue has been resolved in version 1.1.1

Best Regards, Muskan

ch-sap commented 3 weeks ago

Hello Muskan,

issue is solved with the newest version. Thank you.

Best regards, Christine