Thanks for reporting this again: fixed in rev: 753148.
On Fri, 2009-03-13 at 11:25 +0530, Nishita Jain wrote:
> 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
> >
> >
--
Antwebsystems.com: Quality OFBiz services for competitive rates
