delete of product in admin 3.1.4 - bad sql syntax
Posted: Wed Sep 10, 2014 7:13 pm
I'm trying to figure out what is going wrong with my delete request. I get the following hibernate log message :
query and message :
select entityitem0_.ENTITY_ITEM_ID as ENTITY1_187_, entityitem0_.ARCHIVED as ARCHIVED2_187_, entityitem0_.CEILING_ENTITY as CEILING3_187_, entityitem0_.CHANGE_TYPE as CHANGE4_187_, entityitem0_.CUST_CRITERIA as CUST5_187_, entityitem0_.ENTITY_ID as ENTITY13_187_, entityitem0_.ENTITY_LNKD_ID as ENTITY6_187_, entityitem0_.PERSIST_PERSPECTVE_ID as PERSIST14_187_, entityitem0_.REQUESTING_ENTITY_NAME as REQUESTI7_187_, entityitem0_.SANDBOX_ID as SANDBOX8_187_, entityitem0_.SCHEDULED_DATE as SCHEDULE9_187_, entityitem0_.SECONDARY_TYPE as SECONDA10_187_, entityitem0_.SECT_ENTITY_FIELD as SECT11_187_, entityitem0_.ENTITY_TRGT_ID as ENTITY12_187_ from BLC_SNDBX_ENTITY_ITEM entityitem0_ inner join BLC_SNDBX_ENTITY entityimpl1_ on entityitem0_.ENTITY_ID=entityimpl1_.ENTITY_ID where entityimpl1_.TYPE=? and (entityitem0_.SANDBOX_ID not in (?)) and (select count(propertyim2_.PROPERTY_ID) from BLC_SNDBX_PROPERTY propertyim2_ inner join BLC_SNDBX_ENTITY entityimpl3_ on propertyim2_.ENTITY_ID=entityimpl3_.ENTITY_ID where (propertyim2_.NAME in (?)) and (propertyim2_.VALUE in (?)) and entityimpl3_.ENTITY_ID=entityimpl1_.ENTITY_ID)=?
[ WARN] 15:30:34 SqlExceptionHelper - SQL Error: 932, SQLState: 42000
We're using Oracle 11g.
[ERROR] 15:30:34 SqlExceptionHelper - ORA-00932: inconsistent datatypes: expected - got CLOB
query and message :
select entityitem0_.ENTITY_ITEM_ID as ENTITY1_187_, entityitem0_.ARCHIVED as ARCHIVED2_187_, entityitem0_.CEILING_ENTITY as CEILING3_187_, entityitem0_.CHANGE_TYPE as CHANGE4_187_, entityitem0_.CUST_CRITERIA as CUST5_187_, entityitem0_.ENTITY_ID as ENTITY13_187_, entityitem0_.ENTITY_LNKD_ID as ENTITY6_187_, entityitem0_.PERSIST_PERSPECTVE_ID as PERSIST14_187_, entityitem0_.REQUESTING_ENTITY_NAME as REQUESTI7_187_, entityitem0_.SANDBOX_ID as SANDBOX8_187_, entityitem0_.SCHEDULED_DATE as SCHEDULE9_187_, entityitem0_.SECONDARY_TYPE as SECONDA10_187_, entityitem0_.SECT_ENTITY_FIELD as SECT11_187_, entityitem0_.ENTITY_TRGT_ID as ENTITY12_187_ from BLC_SNDBX_ENTITY_ITEM entityitem0_ inner join BLC_SNDBX_ENTITY entityimpl1_ on entityitem0_.ENTITY_ID=entityimpl1_.ENTITY_ID where entityimpl1_.TYPE=? and (entityitem0_.SANDBOX_ID not in (?)) and (select count(propertyim2_.PROPERTY_ID) from BLC_SNDBX_PROPERTY propertyim2_ inner join BLC_SNDBX_ENTITY entityimpl3_ on propertyim2_.ENTITY_ID=entityimpl3_.ENTITY_ID where (propertyim2_.NAME in (?)) and (propertyim2_.VALUE in (?)) and entityimpl3_.ENTITY_ID=entityimpl1_.ENTITY_ID)=?
[ WARN] 15:30:34 SqlExceptionHelper - SQL Error: 932, SQLState: 42000
We're using Oracle 11g.
[ERROR] 15:30:34 SqlExceptionHelper - ORA-00932: inconsistent datatypes: expected - got CLOB