2149171 - Error about: SQL search error : ORA-00932: inconsistent datatypes: expected - got BLOB

Symptom

After defining an Item types you could get the following error when adding instances from the hMC:

Caused by: de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: SQL search error : ORA-00932: inconsistent datatypes: expected - got BLOB
at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:169)
at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearch(FlexibleSearch.java:1778)
at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.compute(FlexibleSearchCacheUnit.java:46)
at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:302)
at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:275)
at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:182)
at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.myGet(FlexibleSearchCacheUnit.java:85)
at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1454)
at de.hybris.platform.jalo.JaloSession.search(JaloSession.java:2206)
at de.hybris.platform.jalo.JaloSession.search(JaloSession.java:2141)
at de.hybris.platform.jalo.JaloSession.search(JaloSession.java:2146)
at de.hybris.platform.servicelayer.interceptor.impl.UniqueAttributesInterceptor.onValidate(UniqueAttributesInterceptor.java:145)
at de.hybris.platform.servicelayer.internal.model.impl.ModelWrapper.validate(ModelWrapper.java:121)
... 68 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got BLOB

Product

hybris Commerce Suite 5.1 ; hybris Commerce Suite 5.1.1

Keywords

KBA , CEC-SCC-CDM-CKP-COR , Core , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.