Getting Executing Error Statement in the app deployed to BTP #238
Description
I deployed a bookshop app from https://github.com/SAP-samples/cloud-cap-samples-java/
with cds-feature-attachments 1.0.4-SNAPSHOT and then when I access the app and upload an attachment and just select it and click on delete I get "Error executing statement".
App link https://sdmgoogleworkspacedev-rashmi-bookshop-app.cfapps.eu12.hana.ondemand.com/app/fiori.html
Logs are STDOUT EXPANDLIST []
2024-10-16T10:01:46.168+0000 [APP/PROC/WEB/0] STDOUT STATEMENT {"ref":[{"id":"AdminService.Books.attachments","where":[{"ref":["IsActiveEntity"]},"=",{"val":true},"and",{"ref":["up__ID"]},"=",{"val":"fc1d65f8-172d-4aa8-ab6f-c24aacbda80a"},"and",{"ref":["ID"]},"=",{"val":"f83cd1fe-8003-4678-b6e2-9ea63062251d"}]}]}
2024-10-16T10:01:46.169+0000 [APP/PROC/WEB/0] STDOUT SELECT {"SELECT":{"from":{"ref":[{"id":"AdminService.Books.attachments","where":[{"ref":["IsActiveEntity"]},"=",{"val":true},"and",{"ref":["up__ID"]},"=",{"val":"fc1d65f8-172d-4aa8-ab6f-c24aacbda80a"},"and",{"ref":["ID"]},"=",{"val":"f83cd1fe-8003-4678-b6e2-9ea63062251d"}]}]},"columns":["*"],"forUpdate":{"wait":10}}}
2024-10-16T10:01:46.180+0000 [APP/PROC/WEB/0] STDOUT {"msg":"Exception marked the ChangeSet 161 as cancelled: Error executing the statement (service 'PersistenceService$Default', event 'READ', entity 'AdminService.Books.attachments')","tenant_id":"sdmgoogleworkspace","component_id":"d53a99bc-16db-4cb8-823f-8489a9969086","level":"INFO","written_ts":"1729072906180211492","logger":"com.sap.cds.adapter.odata.v4.processors.CdsProcessor","component_name":"bookshop-srv","thread":"http-nio-8080-exec-6","organization_name":"sdmgoogleworkspacedev","type":"log","space_name":"Rashmi","organization_id":"86ed15cb-107b-4f0c-a7b1-4da3746bd26c","correlation_id":"fbe573ee-b951-42e0-6a1b-a89e453818ab","written_at":"2024-10-16T10:01:46.180Z","space_id":"cc864b82-3ce9-4b71-b611-fca2e66e0578","request_id":"fbe573ee-b951-42e0-6a1b-a89e453818ab","container_id":"10.0.201.13"}
2024-10-16T10:01:46.183+0000 [APP/PROC/WEB/0] STDOUT {"msg":"Error executing the statement (service 'PersistenceService$Default', event 'READ', entity 'AdminService.Books.attachments')","tenant_id":"sdmgoogleworkspace","component_id":"d53a99bc-16db-4cb8-823f-8489a9969086","level":"ERROR","written_ts":"1729072906181865975","logger":"com.sap.cds.adapter.odata.v4.processors.CdsProcessor","component_name":"bookshop-srv","thread":"http-nio-8080-exec-6","organization_name":"sdmgoogleworkspacedev","type":"log","exception_message":"Error executing the statement (service 'PersistenceService$Default', event 'READ', entity 'AdminService.Books.attachments')","space_name":"Rashmi","organization_id":"86ed15cb-107b-4f0c-a7b1-4da3746bd26c","exception_type":"com.sap.cds.services.impl.ContextualizedServiceException","correlation_id":"fbe573ee-b951-42e0-6a1b-a89e453818ab","written_at":"2024-10-16T10:01:46.180Z","space_id":"cc864b82-3ce9-4b71-b611-fca2e66e0578","request_id":"fbe573ee-b951-42e0-6a1b-a89e453818ab","container_id":"10.0.201.13","stacktrace":["com.sap.cds.services.impl.ContextualizedServiceException: Error executing the statement","\tat com.sap.cds.services.impl.ServiceImpl.dispatch(ServiceImpl.java:256)","\tat com.sap.cds.services.impl.ServiceImpl.emit(ServiceImpl.java:177)","\tat com.sap.cds.services.ServiceDelegator.emit(ServiceDelegator.java:33)","\tat com.sap.cds.services.utils.services.AbstractCqnService.run(AbstractCqnService.java:53)","\tat com.sap.cds.services.utils.services.AbstractCqnService.run(AbstractCqnService.java:43)","\tat com.sap.cds.feature.attachments.handler.common.DefaultAttachmentsReader.readAttachments(DefaultAttachmentsReader.java:57)","\tat com.sap.cds.feature.attachments.handler.draftservice.DraftCancelAttachmentsHandler.readAttachments(DraftCancelAttachmentsHandler.java:113)","\tat com.sap.cds.feature.attachments.handler.draftservice.DraftCancelAttachmentsHandler.getCondensedActiveAttachments(DraftCancelAttachmentsHandler.java:117)","\tat com.sap.cds.feature.attachments.handler.draftservice.DraftCancelAttachmentsHandler.processBeforeDraftCancel(DraftCancelAttachmentsHandler.java:66)","\tat com.sap.cds.services.impl.handlerregistry.HandlerRegistryTools$DescribedHandler.process(HandlerRegistryTools.java:165)","\tat com.sap.cds.services.impl.ServiceImpl.dispatch(ServiceImpl.java:221)","\tat com.sap.cds.services.impl.Service
