Error in Generating Tracking Code Report

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Error in Generating Tracking Code Report

Koon Sang
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)