SAP CAP - Assert reference integrity error thrown when using ID returned from after handler

[WilliamW]

In the after create event handler of an entity (FundsAllocationReport), I am performing some logic and creating some data to insert into a table associated with the entity (CustomerClaims). As part of the payload in the INSERT statement I provide the ID of the recently created entity (FundsAllocationReport).

What is happening is, intermittently, CAP is throwing ASSERT_REFERENCE_INTEGRITY error on the ID.

Above is data sent by After create handler

The same ID returned by After create handler is not in the database??? How is this possible??

Here also is the data model:

This must be framework bug?? CAP fires the after event on create before the entity is created on the database??

[mariya_yordanova]

Hello wwrigley,

Could you please send a SELECT query to the entity the assocation is pointing to in your after handler before you send the insert query to verify the entity really exist in the database?

If it exists and you still see the integrity error, it might indicate it is an error in the framework. Than please provide the cds version and reproducible sample project, so we can look into it.

Best Regards

Maria

[mauriciolauffer]

Hi,

Replace Association by Composition (https://cap.cloud.sap/docs/cds/cdl#associations). My guess is the data hasn't been committed to the database yet.