Error log "Property 'begda' has invalid value '00000000'"

[sudarshan_d29]

Hi,

I got an error during consuming data at gateway client "Error log "Property 'begda' has invalid value '00000000'"".

I am exposing data from CDS view to odata service using "import->reference->data definition".

begda (last changed date) - data type is DATE and it has null value

If there is any specific annotation to make the date field null-able or correct the format, please let me know

Awaiting for you reply,

Sudarshan David

[shilpabasavaraj]

Hi Sudarshan David,

In OData, the entity will have a property Nullable. Make it true(Check the checkbox) for begda. It will work.

Note: The Edm.DateTime fields should be mandatorily maintained as Nullable, unless its not a key field in the entity. Else you will face this issue.

Regards,

Shilpa B.

[sudarshan_d29]

Hi Shilpa,

Yes we can make Nullable manually, I have created Odata using CDS reference though I am can't change the properties directly,

But I can add properties in CDS which will affect after regenerating,

For example: in CDS

Below code is working fine,

@Semantics.businessDate.from: true 
begda,<br>

and below code in not working,

@Semantics.businessDate.from: true 
key begda,

[glauco]

Thank you Sudarshan David.
I had same error here and you solution solved my issue.

[FreddyTorresC]

Hi Shilpa,

Thanks, it's works.

Regards,

Freddy

[MahmoudNasr]

Thanks, it's works.