Hello All, I am again getting following error in rendering the communication sub tab by following the same steps while working on latest revision 753126.It is reporting the same error on revision no 752909 also.
It gives an error:- org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Error doing entity query by condition: org.ofbiz.base.util.GeneralException: Error doing find by condition: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT CR.PARTY_ID, CR.ROLE_TYPE_ID, CR.STATUS_ID, CR.CONTACT_MECH_ID, CE.COMMUNICATION_EVENT_ID, CE.COMMUNICATION_EVENT_TYPE_ID, CE.ORIG_COMM_EVENT_ID, CE.PARENT_COMM_EVENT_ID, CE.STATUS_ID, CE.CONTACT_MECH_TYPE_ID, CE.CONTACT_MECH_ID_FROM, CE.CONTACT_MECH_ID_TO, CE.ROLE_TYPE_ID_FROM, CE.ROLE_TYPE_ID_TO, CE.PARTY_ID_FROM, CE.PARTY_ID_TO, CE.ENTRY_DATE, CE.DATETIME_STARTED, CE.DATETIME_ENDED, CE.SUBJECT, CE.CONTENT_MIME_TYPE_ID, CE.CONTENT, CE.NOTE, CE.REASON_ENUM_ID, CE.CONTACT_LIST_ID, CE.HEADER_STRING, CE.FROM_STRING, CE.TO_STRING, CE.CC_STRING, CE.BCC_STRING, CE.MESSAGE_ID FROM OFBIZ.COMMUNICATION_EVENT_ROLE CR INNER JOIN OFBIZ.COMMUNICATION_EVENT CE ON CR.COMMUNICATION_EVENT_ID = CE.COMMUNICATION_EVENT_ID WHERE CR.PARTY_ID = ? ORDER BY CE.ENTRY_DATE DESC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) Thanks and Regards Nishita Jain > >
