SAP DBTech JDBC: Value too large for column

[former_member655799]

while creating product through creation wizard in Hybris, getting below exception in error log, instead of error notification in creation wizard.

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica} span.Apple-tab-span {white-space:pre}

| Caused by: de.hybris.platform.persistence.hjmp.HJMPFinderException: SAP DBTech JDBC: Value too large for column: [de.hybris.platform.servicelayer.interceptor.impl.uniqueattributesinterceptor@711b7265]:ambiguous unique keys {catalogversion=catalogversionmodel (8796093186649@50), code=291311434} for model lsvariantproductmodel (<unsaved>) - found 1 item(s) using the same keys (maximum length is 255).

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.persistence.type.AtomicType_HJMPWrapper.ejbFindByCodeExact(AtomicType_HJMPWrapper.java:1165) ~[coreserver.jar:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at sun.reflect.GeneratedMethodAccessor304.invoke(Unknown Source) ~[?:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.util.Utilities.callMethod(Utilities.java:1038) ~[coreserver.jar:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.util.Utilities.callMethod(Utilities.java:1028) ~[coreserver.jar:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.persistence.framework.HomeInvocationHandler.invoke(HomeInvocationHandler.java:90) ~[coreserver.jar:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at com.sun.proxy.$Proxy157.findByCodeExact(Unknown Source) ~[?:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.persistence.type.TypeManagerEJB.findByCodeExact(TypeManagerEJB.java:280) ~[coreserver.jar:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.persistence.type.TypeManagerEJB.getType(TypeManagerEJB.java:249) ~[coreserver.jar:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.persistence.type.TypeManagerEJB.getType(TypeManagerEJB.java:234) ~[coreserver.jar:?]

INFO | jvm 1| main| 2019/11/21 20:08:09.892 | at de.hybris.platform.jalo.type.TypeManager.getType(TypeManager.java:125) ~[coreserver.jar:?]

[former_member620692]

Let us know the following:

1. Version of Hybris
2. Database name and version
3. Database driver version
4. Whether it's happening in uncustomized code (e.g. the OOTB accelerator set up using recipe)

[vedesai]

Even I am facing the exact same issue. Has anyone found a solution for this?

INFO | jvm 1 | main | 2020/01/16 10:31:40.010 | Caused by: de.hybris.platform.persistence.hjmp.HJMPFinderException: SAP DBTech JDBC: Value too large for column: :ambiguous unique keys {<unique combination of the columns on data model>}

The same works fine and I can see the error message displayed on Backoffice create wizard. However, with SAP HANA DB, it is not giving any error message on backoffice and this error is thrown in the logs.

[former_member655799]

Please find below details:

1. Version of Hybris:1811
2. Database name and version : SAP, Version: 1.00.122.17.1526900527
3. Database driver version: HDB : 2.3.55-66380bf563d4bc3dcded5988c2f3d946c0f55a1e
4. Whether it's happening in uncustomized code : yes (while creating duplicate product through creation wizard, notification popup does not appear instead, this error appears in error log)

Also, this issue does not appear in mysql and HSql.