How to fix oracle error (ORA-00932 - Inconsistent data types) excepted - got BLOB Query

1293 Views

Hi,

We have created the below one for application related configuration. 1. configurationMap map datatype which has key/value pair as string 2. APPCONFIG item type which has attributes string(configname) and configurationMap

Eg: TESTCONFIG SITEID: uk THEMEID: uktheme

When we directly CREATE/EDIT new APPCONFIG value in hybris HMC we could not save the values and throws an incompatible data type error. This worked fine in hybris 4.7. In hybris 5.1 its causing an issue. With the impex we are able to create/modify.

Please suggest how to resolve.

Error: The item could not be saved due to the following errors: [de.hybris.platform.servicelayer.interceptor.impl.UniqueAttributesInterceptor@7bea5f27]: unexpected validator error: SQL search error : ORA-00932: inconsistent datatypes: expected - got BLOB query = 'SELECT item_t0.PK FROM esceappconfig item_t0 WHERE (( item_t0.p_configurationproperty = ? AND item_t0.p_code = ? )) AND (item_t0.TypePkString=? )', values = [{xmlPostIndexCopy=/home/attfqa/FatwireIndex_es/HybrisIndex/index/, xmlOutputLocalizedDir=/home/attfqa/FatwireIndex_es/xmlpostDump/LocalizedAttributes/localized, XMLPostShell=/home/attfqa/FatwireIndex_es/XMLPostUtility/xmlPost.sh, deleteIndexes=NO, xmlOutputPackageDir=/home/attfqa/FatwireIndex_es/xmlpostDump/Package/package, xmlOutputDeviceDir=/home/attfqa/FatwireIndex_es/xmlpostDump/Device/device, configFileName=XMLPostConfig_es, mainIndexFolder=/home/attfqa/attfHybris51/hybris/data/solrfacetsearch/ES/telefonica_Product/index/, isRunXMLPost=YESsd}, XML_POST, 8796133130322]

Thanks Prashanth.