HANA XSA "invalid dbTypeName name: DAYDATE"

[jthuijls]

Hi,

Lifted and shifted an XSA application from one HANA Express to another. Both 2.0 but there might be a minor version difference.

the xsodata $metadata returns:

{
  "error": {
    "code": "500",
    "message": {
      "lang": "en-US",
      "value": "invalid dbTypeName name: DAYDATE"
    }
  }
}

The error seems to come from the parameter definition of an hdbcalculationview, this is what the metadata actually seems to return if I check the network call:

            <EntityType Name="WeeklyTimeSheetViewType">
                <Key>
                    <PropertyRef Name="IP_START_DATE"/>
                    <PropertyRef Name="IP_EMP_ID"/>
                    <PropertyRef Name="EMPLOYEE_ID"/>
                    <PropertyRef Name="PROJECT_ID"/>
                    <PropertyRef Name="START_DATE"/>
                </Key>
                <Property Name="IP_START_DATE"{"error":{"code":"500","message":{"lang":"en-US","value":"invalid dbTypeName name: DAYDATE"}}}

Which is defined as:

"WeeklyTimesheet" as "WeeklyTimeSheetView" keys ... parameters via key and entity "WeeklyTimeSheet";

In the calculation view, the parameter is set as:

  <variable id="IP_START_DATE" parameter="true">
    <descriptions defaultDescription="IP_START_DATE"/>
    <variableProperties datatype="DATE" mandatory="true">
      <valueDomain type="Date"/>
      <selection multiLine="false" type="Single"/>
      <defaultRange lowValue="2019-10-1"/>
    </variableProperties>
  </variable>

If I leave *out* the _via entity_ bit, I can see my metadata. Otherwise, it spits the error above.

The service itself returns correct results, meaning all entities run and return data.

Anyone who can help? Additional information can be provided

Thanks

[former_member610208]

Hi! I had the same problem, but I fixed using TIMESTAMP instead of DATE on Hana Input Parameter:

[jthuijls]

I did this, and removed the `via key` part. It stopped trying to map the view's input parameters to the DB type after that. Thanks for putting me on the right track