Getting Executing Error Statement in the app deployed to BTP #238
Comments
|
Hi, please try this PR: SAP-samples/cloud-cap-samples-java#377 |
|
Sure I will check with your PR. Locally for me also it works Regards, |
|
Thanks for reporting, I'm able to reproduce with bookshop and my PR on BTP. Will investigate this issue. |
|
With some logger groups enabled I found this error in the log: @adamandre79 Hi Andre, maybe you have an idea what could cause this error on BTP only. This error happens when I try to delete an attachment from a book in the bookshop sample application. But it occurs only on BTP / HANA, locally it works fine. |
|
Hi, the fix is merged and a new snapshot 1.0.4-SNAPSHOT is deployed. Therefore I close this issue. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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
The text was updated successfully, but these errors were encountered: