Error in Generating Tracking Code Report

[Koon Sang <ko...@igine.com>]

In https://localhost:8443/marketing/control/MarketingReport, when I want to
generate Tracking Code Report, I got the following error:

org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://marketing/widget/MarketingReportScreens.xml#TrackingCodeReport]:
org.ofbiz.base.util.GeneralException: Error running Groovy script at
location
[component://marketing/webapp/marketing/WEB-INF/actions/reports/TrackingCodeReport.groovy]
(SQL Exception while executing the following:SELECT TC.TRACKING_CODE_ID,
COUNT(TCV.VISIT_ID) FROM public.TRACKING_CODE TC LEFT OUTER JOIN
public.TRACKING_CODE_VISIT TCV ON TC.TRACKING_CODE_ID = TCV.TRACKING_CODE_ID
WHERE (TCV.FROM_DATE >= ? AND TCV.FROM_DATE <= ? AND TC.TRACKING_CODE_ID =
?) GROUP BY TC.TRACKING_CODE_ID ORDER BY TC.TRACKING_CODE_ID ASC (ERROR:
operator does not exist: timestamp with time zone >= character varying
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Position: 192)) (Error running Groovy script at location
[component://marketing/webapp/marketing/WEB-INF/actions/reports/TrackingCodeReport.groovy]
(SQL Exception while executing the following:SELECT TC.TRACKING_CODE_ID,
COUNT(TCV.VISIT_ID) FROM public.TRACKING_CODE TC LEFT OUTER JOIN
public.TRACKING_CODE_VISIT TCV ON TC.TRACKING_CODE_ID = TCV.TRACKING_CODE_ID
WHERE (TCV.FROM_DATE >= ? AND TCV.FROM_DATE <= ? AND TC.TRACKING_CODE_ID =
?) GROUP BY TC.TRACKING_CODE_ID ORDER BY TC.TRACKING_CODE_ID ASC (ERROR:
operator does not exist: timestamp with time zone >= character varying
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Position: 192)))

Ofbiz version: 9.04 (2010-02-17)
-- 
View this message in context: http://n4.nabble.com/Error-in-Generating-Tracking-Code-Report-tp1563970p1563970.html
Sent from the OFBiz - User mailing list archive at Nabble.com.