[jira] Created: (OFBIZ-3150) Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]

[Nicolas Malin (Jira)]

Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]
--------------------------------------------------------------------------------------------------

                 Key: OFBIZ-3150
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3150
             Project: OFBiz
          Issue Type: Bug
          Components: framework
    Affects Versions: SVN trunk
            Reporter: Amit Sharma
             Fix For: SVN trunk


Steps for generating error:
1) Hit URL https://localhost:8443/webtools/control/xmldsdump
2) Depress "Check All" button on Export section.
3) Fill following fields.
Output Directory   : <Eport path>
Records Updated Before : <Current time>

ERROR:

SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, AFFILIATE_NAME, AFFILIATE_DESCRIPTION, YEAR_ESTABLISHED, SITE_TYPE, SITE_PAGE_VIEWS, SITE_VISITORS, DATE_TIME_CREATED, DATE_TIME_APPROVED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.AFFILIATE WHERE (LAST_UPDATED_TX_STAMP < ?) ORDER BY PARTY_ID ASC (ERROR: operator does not exist: timestamp with time zone < character varying).

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amit Sharma updated OFBIZ-3150:
-------------------------------

    Attachment: OFBIZ-3150.patch

Here is the patch for the same.

Regards
--
Amit Sharma

> Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]
> --------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-3150
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3150
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: Amit Sharma
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-3150.patch
>
>
> Steps for generating error:
> 1) Hit URL https://localhost:8443/webtools/control/xmldsdump
> 2) Depress "Check All" button on Export section.
> 3) Fill following fields.
> Output Directory   : <Eport path>
> Records Updated Before : <Current time>
> ERROR:
> SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, AFFILIATE_NAME, AFFILIATE_DESCRIPTION, YEAR_ESTABLISHED, SITE_TYPE, SITE_PAGE_VIEWS, SITE_VISITORS, DATE_TIME_CREATED, DATE_TIME_APPROVED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.AFFILIATE WHERE (LAST_UPDATED_TX_STAMP < ?) ORDER BY PARTY_ID ASC (ERROR: operator does not exist: timestamp with time zone < character varying).

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-3150.
----------------------------------

       Resolution: Fixed
    Fix Version/s: Release Branch 9.04
         Assignee: Jacques Le Roux

Thanks Amit,

Your patch is in trunk at r832776, R9.04 r832779

> Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]
> --------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-3150
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3150
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: Amit Sharma
>            Assignee: Jacques Le Roux
>             Fix For: Release Branch 9.04, SVN trunk
>
>         Attachments: OFBIZ-3150.patch
>
>
> Steps for generating error:
> 1) Hit URL https://localhost:8443/webtools/control/xmldsdump
> 2) Depress "Check All" button on Export section.
> 3) Fill following fields.
> Output Directory   : <Eport path>
> Records Updated Before : <Current time>
> ERROR:
> SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, AFFILIATE_NAME, AFFILIATE_DESCRIPTION, YEAR_ESTABLISHED, SITE_TYPE, SITE_PAGE_VIEWS, SITE_VISITORS, DATE_TIME_CREATED, DATE_TIME_APPROVED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.AFFILIATE WHERE (LAST_UPDATED_TX_STAMP < ?) ORDER BY PARTY_ID ASC (ERROR: operator does not exist: timestamp with time zone < character varying).

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.