Error in rendering Communication Screen in Party Mgr

[Nishita Jain]

Hello All,

I am facing a problem while clicking on communication tab for a particular
party in Party Mgr Application. I am working on latest revision 752847.

I performed following steps:-

1:- Clicked on Party Mgr Application.
2:- Created a new Person / selected an existing party.
3:- Clicked on communication sub tab for that particular party / person.

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.GenericModelException: Field with name lastUpdatedStamp not
found in the CommunicationEventAndRole Entity (Field with name
lastUpdatedStamp not found in the CommunicationEventAndRole Entity) (Error
doing entity query by condition: org.ofbiz.base.util.GeneralException: Error
doing find by condition: org.ofbiz.entity.GenericModelException: Field with
name lastUpdatedStamp not found in the CommunicationEventAndRole Entity
(Field with name lastUpdatedStamp not found in the CommunicationEventAndRole
Entity))

There is no such field like lastUpdatedStamp in entity
CommunicationEventAndRole.


Thanks and Regards

Nishita Jain

[hans_bakker]

Thank you for reporting this,
fixed in rev 752909.

Regards,
Hans

On Thu, 2009-03-12 at 19:22 +0530, Nishita Jain wrote:

> Hello All,
>
> I am facing a problem while clicking on communication tab for a particular
> party in Party Mgr Application. I am working on latest revision 752847.
>
> I performed following steps:-
>
> 1:- Clicked on Party Mgr Application.
> 2:- Created a new Person / selected an existing party.
> 3:- Clicked on communication sub tab for that particular party / person.
>
> 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.GenericModelException: Field with name lastUpdatedStamp not
> found in the CommunicationEventAndRole Entity (Field with name
> lastUpdatedStamp not found in the CommunicationEventAndRole Entity) (Error
> doing entity query by condition: org.ofbiz.base.util.GeneralException: Error
> doing find by condition: org.ofbiz.entity.GenericModelException: Field with
> name lastUpdatedStamp not found in the CommunicationEventAndRole Entity
> (Field with name lastUpdatedStamp not found in the CommunicationEventAndRole
> Entity))
>
> There is no such field like lastUpdatedStamp in entity
> CommunicationEventAndRole.
>
>
> Thanks and Regards
>
> Nishita Jain

--
Antwebsystems.com: Quality OFBiz services for competitive rates

[Nishita Jain]

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
>
>

[hans_bakker]

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

[Nishita Jain]

>
> Thanks Hans for solving the error.Now it is working fine.
>