EKEYTYPE: The key argument has to be of type `string` or `number`. Found: `undefined` in CAP.

[Boopalan]

Hi Experts!

GoodDay!

This issue was raised in between the development (when adding attachment feature to my CAP application – used @cap-js/sdm library as mentioned in CAPIRE documentation)

Below is the structure of my header and attachment entity.

InvoiceHeader – Entity

Attachment – Entity

I’ve implemented a custom handler for InvoiceHeader entity on Update event.

I’m running my application in a hybrid mode and I’m opening my annotated UI application (built using FPM). When trying to edit a record and saving it showing me the below error.

             EKEYTYPE: The key argument has to be of type `string` or `number`. Found: `undefined`

When I’m debugging it, the error was coming from the SELECT statement (which was working previously) line no.103 like in the below screenshot. However the query executed successfully where you can see the result in aHeaders variable.

I’m sure “ID” is the only key for InvoiceHeader Entity and the value is coming via “req.data.ID” parameter.

I’m trying to figure it out, I’m not sure where I’m lagging.

Help me to resolve this issue.

Thanks in Advance!!

Best Regards

Boopalan M

SAP Business Application Studio , SAP Cloud Application Programming Model ,

SAP HANA Cloud , SAP HANA Cloud, SAP HANA database 

[Boopalan]

When I remove the attachments : composition to many C_Attachment on attachments.Parent = $self, the update event is working as expected.

The error is happening when I include the above piece of code in my header entity.

Am I missing anything while adding the attachment feature to my application!

is that the reason why the error is coming up!

[pedro_iranzo]

Dropping in to say I'm also having this issue.

[Boopalan]

Hi @pedro_iranzo Thanks for trying it out. Do you suggest any fix for this issue?

[catano]

Hi @Boopalan ,

Could you take a look at the Serving Media Data topic in the documentation? 

entity Books { //...
  image : LargeBinary @Core.MediaType: imageType;
  imageType : String  @Core.IsMediaType;
}

Maybe that's what you are looking for instead of the attachments and sdm plugins.

Regards,
Peter