Data exception: invalid character value for cast

[5mark]

Here's the itemtypes I have defined:

Now whenever I try to add the productsCategories to PointOfService from backoffice I get the error mentioned above.

Any help would be appreciated

// ProductCategories collection

<collectiontype code="ProductCategories" elementtype="ProductsCategory" autocreate="true" generate="false" type="list" />

<itemtype code="ProductsCategory" generate="true" autocreate="true">
  <deployment table="ProductsCategory" typecode="30145" />
  <attributes>
    <attribute qualifier="name" type="localized:java.lang.String">
    <description>Name of the category</description>
    <persistence type="property" />
    <modifiers write="true" read="true" />
  </attribute>
  <attribute qualifier="availableProducts" type="localized:java.lang.String">
    <description>Available products for the category</description>
    <persistence type="property" />
    <modifiers write="true" read="true" />
  </attribute>
</attributes>
</itemtype>
<itemtype code="PointOfService" generate="false" autocreate="false">
  <attributes>
    <attribute qualifier="productsCategories" type="ProductCategories">
    <persistence type="property" />
    <modifiers read="true" write="true" />
    </attribute>
  </attributes>
</itemtype>

[adiputera]

Can you add more stacktrace?

[5mark]

So, since someone has asked for the stack trace, I'll add it here.

Here it is:

ERROR [hybrisHTTP36] [DefaultEditorAreaController] Object 8796093417464 could not be saved
com.hybris.cockpitng.dataaccess.facades.object.exceptions.ObjectSavingException: Object 8796093417464 could not be saved
        at com.hybris.backoffice.cockpitng.dataaccess.facades.object.DefaultPlatformObjectFacadeStrategy.save(DefaultPlatformObjectFacadeStrategy.java:156) ~[classes/:?]
        at com.hybris.cockpitng.dataaccess.facades.object.impl.DefaultObjectFacade.saveSingleObject(DefaultObjectFacade.java:157) ~[cockpit-data-integration-6.4.0.0-RC14.jar:?]
        at com.hybris.cockpitng.dataaccess.facades.object.impl.DefaultObjectFacade.save(DefaultObjectFacade.java:168) ~[cockpit-data-integration-6.4.0.0-RC14.jar:?]
        at com.hybris.cockpitng.dataaccess.facades.object.impl.PermissionAwareObjectFacade.save(PermissionAwareObjectFacade.java:123) ~[cockpit-data-integration-6.4.0.0-RC14.jar:?]
        at com.hybris.cockpitng.widgets.baseeditorarea.DefaultEditorAreaLogicHandler.performSave(DefaultEditorAreaLogicHandler.java:46) ~[backoffice-widgets-6.4.0.0-RC14.jar:?]
        at com.hybris.cockpitng.widgets.baseeditorarea.DefaultEditorAreaController.performSave(DefaultEditorAreaController.java:577) ~[backoffice-widgets-6.4.0.0-RC14.jar:?]

And

656) ~[coreserver.jar:?]
        at com.hybris.backoffice.cockpitng.dataaccess.facades.object.DefaultPlatformObjectFacadeStrategy.executeWithWorkflowTemplateActivation(DefaultPlatformObjectFacadeStrategy.java:169) ~[classes/:?]
        at com.hybris.backoffice.cockpitng.dataaccess.facades.object.DefaultPlatformObjectFacadeStrategy.save(DefaultPlatformObjectFacadeStrategy.java:148) ~[classes/:?]
        ... 106 more
Caused by: org.springframework.dao.DataIntegrityViolationException: query; SQL []; data exception: invalid character value for cast; nested exception is java.sql.SQLDataException: data exception: invalid character value for cast
        at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:82) ~[spring-jdbc-4.3.3.RELEASE.jar:4.3.3.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[spring-jdbc-4.3.3.RELEASE.jar:4.3.3.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.3.3.RELEASE.jar:4.3.3.RELEASE]
        at de.hybris.platform.jdbcwrapper.DataSourceImpl.translateToDataAccessException(DataSourceImpl.java:1030) ~[coreserver.jar:?]
        at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState.storeChanges(GenericBMPBean.java:1610) ~[coreserver.jar:?]
        at de.hybris.platform.persistence.GenericBMPBean.ejbStore(GenericBMPBean.java:306) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.executeEntityStore(Transaction.java:1605) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.executeEJBModifications(Transaction.java:1561) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.flushDelayedStore(Transaction.java:1517) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.commit(Transaction.java:679) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.finishExecute(Transaction.java:1213) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.execute(Transaction.java:1200) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.execute(Transaction.java:1155) ~[coreserver.jar:?]
        at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2095) ~[coreserver.jar:?]
        at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2070) ~[coreserver.jar:?]

[adiputera]

Looking at the log, usually that was because of change in the type of the attribute.

For example, let's say at first my item type was like these:

<itemtype generate="true" code="ThisTestNewItemType">   
    <attributes>
      <attribute qualifier="city" type="java.lang.String">
         <description>This is to show that at first I create item type with String type</description>
         <modifiers optional="false"/>
         <persistence type="property"/>
      </attribute>
   </attributes>
</itemtype>

And then, I do update system, so the column will be created in database with nvarchar type.

Then, I want to change it to some item type, instead of String, so my item type will look like these:

<itemtype generate="true" code="ThisTestNewItemType">
   <attributes>
      <attribute qualifier="city" type="City">
         <description>This is to show that at first I create item type with String type, then change it to some item type</description>
         <modifiers optional="false"/>
         <persistence type="property"/>
      </attribute>
   </attributes>
</itemtype>

And then, I do update system, but hybris will not change the column type in database, so it stays as nvarchar, for item type attribute, the column in database should be bigint. You have 4 options:

1. in HAC -> maintenance -> clean up -> Type System, clear all orphaned types, then do update system, or

2. Change the qualifier name, then do update system, or

3. Delete the column manually from database, then do system update, or

4. Alter the column manually from database, then do system update