GIGYA CCV1 exception while logging in

[former_member748081]

Hello experts,

We are using gigya connector for hybris 6.4 and getting below exception while logging in.

] [GigyaRaasController] de.hybris.platform.servicelayer.exceptions.ModelSavingException: org.springframework.dao.DataIntegrityViolationException: query; SQL []; [303]: invalid DATE, TIME or TIMESTAMP value: given date value is invalid: type_code=61, index=7; nested exception is com.sap.db.jdbc.exceptions.SQLDataExceptionSapDB: [303]: invalid DATE, TIME or TIMESTAMP value: given date value is invalid: type_code=61, index=7

It works fine with HSQL but issue is when SAPDB is used.

[former_member712212]

Hi,

It looks like can not convert the value to the corresponding type.

Have you defined already the attribute how to be represented in the SAPDB / Hana ?

If not, then you have to do the following.

<attribute qualifier="myDate" type="java.util.Date">
   <description>myDate</description>
   <modifiers read="true" write="true" search="true" optional="false" unique="true"/>
   <persistence type="property">
      <columntype database="sap">
      <value>TIMESTAMP</value>
      </columntype>
   </persistence>
</attribute>

Here are the types in HANA that are store date time values which you can use.

Hana - Date Time

Once it is deployed on CCV1 you need to request or execute UpdateSystem in order the column to be created with the right format.

Best Regards,