[jira] Created: (OFBIZ-3789) No results when searching with keywords in catalog

[Nicolas Malin (Jira)]

No results when searching with keywords in catalog
--------------------------------------------------

                 Key: OFBIZ-3789
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
             Project: OFBiz
          Issue Type: Bug
          Components: product
    Affects Versions: SVN trunk
            Reporter: Erwan de FERRIERES
             Fix For: SVN trunk


Steps to reproduce :

go to : https://localhost:8443/catalog/control/keywordsearch
then in the Keywords textbox, type GZ, then hit enter key.
No results are shown.

Log error in the console :
2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
 keywordFixedOrSetAndList={}
2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
---- exception report ----------------------------------------------------------
Error in product search
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
---- cause ---------------------------------------------------------------------
Exception: java.sql.SQLSyntaxErrorException
Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.impl.jdbc.EmbedSQLException
Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.iapi.error.StandardException
Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
---- stack trace ---------------------------------------------------------------
ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.


--
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-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12874663#action_12874663 ]

matthieu bollot commented on OFBIZ-3789:
----------------------------------------

I don't know exactly yet what is it about but it is related to commit number 948442

to have GROUP BY column1

you need to have select column1 ... GROUP BY column1

But may be the commit is good and it's something else (the request) that needs to be corrected.

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>             Fix For: SVN trunk
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

--
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-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Erwan de FERRIERES reassigned OFBIZ-3789:
-----------------------------------------

    Assignee: Adam Heath

Hi Adam,
As it is related to your commit (948442), I assign it to you !

Cheers,

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>            Assignee: Adam Heath
>             Fix For: SVN trunk
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

--
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-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12875154#action_12875154 ]

Adam Heath commented on OFBIZ-3789:
-----------------------------------

This bug is not due to GROUP BY issues.  There is no GROUP BY in the given query.  There is a bug in derby in that it has a wrong error message.

This is due to ORDER BY *always* using the aliased column name for a view; instead, it should only do so when DatasourceInfo.aliasViews allows it to.  Looking at EntityConditionBase, getColName(), it checks whether the entity is a view, and if aliasViews is true, then it uses the colAlias.  But since aliasViews is turned off for derby, getColName() ends up calling ModelField.getColName(), and that is the aliased field for views.

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>            Assignee: Adam Heath
>             Fix For: SVN trunk
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

--
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-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12875180#action_12875180 ]

Jacques Le Roux commented on OFBIZ-3789:
----------------------------------------

Not sure it's related but using Postgres I get this

2010-06-03 18:13:16,609 (http-0.0.0.0-28443-5) [    ConfigXMLReader.java:120:INFO ] controller loaded: 0.031s, 466 requests, 144 views in jndi:/0.0.0.0/catalog/WEB-INF/controller.xml
2010-06-03 18:13:16,625 (http-0.0.0.0-28443-5) [     RequestHandler.java:741:INFO ] Rendering View [keywordsearch], sessionId=35798BDD7FF98064A8A757E3C135DC27.jvm1
2010-06-03 18:13:16,718 (http-0.0.0.0-28443-5) [      ScreenFactory.java:128:INFO ] Got 5 screens in 0.015s from: file:/D:/workspace/ofbizDev/applications/product/widget/catalog/FindScreens.xml
2010-06-03 18:13:16,734 (http-0.0.0.0-28443-5) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [gz], got set: []
2010-06-03 18:13:16,734 (http-0.0.0.0-28443-5) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
 keywordFixedOrSetAndList={}
2010-06-03 18:13:16,734 (http-0.0.0.0-28443-5) [      ProductSearch.java:654:ERROR]
---- exception report ----------------------------------------------------------
Error in product search
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID =
PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE ((PK1.KEYWORD LIKE ?)) ORDER BY TOTAL_RELEVANCY DESC (ERREUR: la colonne ½ total_relevancy ╗ n'existe pas)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERREUR: la colonne ½ total_relevancy ╗ n'existe pas
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERREUR: la colonne ½ total_relevancy ╗ n'existe pas

(n'existe pas = does not exist)

I can see the totalRelevancy in ProductSearch.java

HTH

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>            Assignee: Adam Heath
>             Fix For: SVN trunk
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

--
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-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12875582#action_12875582 ]

Erwan de FERRIERES commented on OFBIZ-3789:
-------------------------------------------

totalRelevancy is added to a dynamicView.
There is nothing related to the database type.

Anyway, what should be done to make it work ? No matter derby or postgres was used, but keyword search was working before your commit.

When committing your fix, adding a junit test would be great too.

TIA,

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>            Assignee: Adam Heath
>             Fix For: SVN trunk
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

--
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-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adam Heath closed OFBIZ-3789.
-----------------------------

    Resolution: Fixed

This is fixed in revision 951553.

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>            Assignee: Adam Heath
>             Fix For: SVN trunk
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

--
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-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12875940#action_12875940 ]

Erwan de FERRIERES commented on OFBIZ-3789:
-------------------------------------------

Thanks !

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>            Assignee: Adam Heath
>             Fix For: SVN trunk
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

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

[rohit]

Hi Adam,

Can you please re-check the commit. I am running postgres 8.4 on FC8 and JDK 1.6._17. I am still getting the error as below:

2010-06-14 03:58:48,600 (TP-Processor5) [     ControlServlet.java:144:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-06-14 03:58:48,604 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [gizmos], got set: []
2010-06-14 03:58:48,605 (TP-Processor5) [     RequestHandler.java:638:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success]
2010-06-14 03:58:48,646 (TP-Processor5) [     RequestHandler.java:741:INFO ] Rendering View [keywordsearch], sessionId=2173C489A0B096AA162A2EFBFD169C0B.jvm1
2010-06-14 03:58:48,703 (TP-Processor5) [      ScreenFactory.java:128:INFO ] Got 30 screens in 0.054s from: file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CatalogScreens.xml
2010-06-14 03:58:48,720 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [gizmos], got set: []
2010-06-14 03:58:48,720 (TP-Processor5) [      ProductSearch.java:272:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gizmo%}
 keywordFixedOrSetAndList={}
2010-06-14 03:58:48,721 (TP-Processor5) [      ProductSearch.java:625:INFO ] topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-06-14 03:58:48.719') AND pcm2FromDate < '2010-06-14 03:58:48.719' AND pcm2ProductCategoryId IN ('CATALOG1_SEARCH'))
2010-06-14 03:58:48,749 (TP-Processor5) [      ProductSearch.java:790:ERROR]
---- exception report ----------------------------------------------------------
Error getting results from the product search query
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT COUNT(DISTINCT TOTAL_RELEVANCY) FROM ((public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND PK1.KEYWORD LIKE ? AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) (ERROR: column "total_relevancy" does not exist
  Position: 23)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: column "total_relevancy" does not exist
  Position: 23
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: column "total_relevancy" does not exist
  Position: 23
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1073)
org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:765)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:960)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)

[rohit]

Hi Adam,

Can you please re-check the commit. I am running postgres 8.4 on FC8 and JDK 1.6._17. I am still getting the error as below:

2010-06-14 03:58:48,600 (TP-Processor5) [     ControlServlet.java:144:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-06-14 03:58:48,604 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [gizmos], got set: []
2010-06-14 03:58:48,605 (TP-Processor5) [     RequestHandler.java:638:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success]
2010-06-14 03:58:48,646 (TP-Processor5) [     RequestHandler.java:741:INFO ] Rendering View [keywordsearch], sessionId=2173C489A0B096AA162A2EFBFD169C0B.jvm1
2010-06-14 03:58:48,703 (TP-Processor5) [      ScreenFactory.java:128:INFO ] Got 30 screens in 0.054s from: file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CatalogScreens.xml
2010-06-14 03:58:48,720 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [gizmos], got set: []
2010-06-14 03:58:48,720 (TP-Processor5) [      ProductSearch.java:272:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gizmo%}
 keywordFixedOrSetAndList={}
2010-06-14 03:58:48,721 (TP-Processor5) [      ProductSearch.java:625:INFO ] topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-06-14 03:58:48.719') AND pcm2FromDate < '2010-06-14 03:58:48.719' AND pcm2ProductCategoryId IN ('CATALOG1_SEARCH'))
2010-06-14 03:58:48,749 (TP-Processor5) [      ProductSearch.java:790:ERROR]
---- exception report ----------------------------------------------------------
Error getting results from the product search query
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT COUNT(DISTINCT TOTAL_RELEVANCY) FROM ((public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND PK1.KEYWORD LIKE ? AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) (ERROR: column "total_relevancy" does not exist
  Position: 23)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: column "total_relevancy" does not exist
  Position: 23
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: column "total_relevancy" does not exist
  Position: 23
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1073)
org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:765)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:960)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)

[Adam Heath-2]

rohit wrote:
> Hi Adam,
>
> Can you please re-check the commit. I am running postgres 8.4 on FC8 and JDK
> 1.6._17. I am still getting the error as below:

What were you doing at the time?  What was your start page?  What form
values did you fill out?  Which submit button did you hit?  Please be
specific, because I did look at this, and couldn't repeat it the last
time(or did fix a problem).

<general>
It's also best to include the series of steps that you have done when
reporting a problem.  This way anyone else can repeat the issue.
</general>

> 2010-06-14 03:58:48,600 (TP-Processor5) [     ControlServlet.java:144:INFO ]
> [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since
> last(Begin):0.0]]
> 2010-06-14 03:58:48,604 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ]
> Expanded keyword [gizmos], got set: []
> 2010-06-14 03:58:48,605 (TP-Processor5) [     RequestHandler.java:638:INFO ]
> Ran Event
> [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride]
> from [request], result is [success]
> 2010-06-14 03:58:48,646 (TP-Processor5) [     RequestHandler.java:741:INFO ]
> Rendering View [keywordsearch],
> sessionId=2173C489A0B096AA162A2EFBFD169C0B.jvm1
> 2010-06-14 03:58:48,703 (TP-Processor5) [      ScreenFactory.java:128:INFO ]
> Got 30 screens in 0.054s from:
> file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CatalogScreens.xml
> 2010-06-14 03:58:48,720 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ]
> Expanded keyword [gizmos], got set: []
> 2010-06-14 03:58:48,720 (TP-Processor5) [      ProductSearch.java:272:INFO ]
> Finished initial setup of keywords, doingBothAndOr=false,
> andKeywordFixedSet={%gizmo%}
>  keywordFixedOrSetAndList={}
> 2010-06-14 03:58:48,721 (TP-Processor5) [      ProductSearch.java:625:INFO ]
> topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-06-14 03:58:48.719')
> AND pcm2FromDate < '2010-06-14 03:58:48.719' AND pcm2ProductCategoryId IN
> ('CATALOG1_SEARCH'))
> 2010-06-14 03:58:48,749 (TP-Processor5) [      ProductSearch.java:790:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error getting results from the product search query
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT COUNT(DISTINCT
> TOTAL_RELEVANCY) FROM ((public.PRODUCT PROD LEFT OUTER JOIN
> public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID =
> PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID
> = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON
> PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND
> PK1.KEYWORD LIKE ? AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND
> PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) (ERROR: column
> "total_relevancy" does not exist
>   Position: 23)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: column "total_relevancy" does not exist
>   Position: 23
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: column "total_relevancy" does not
> exist
>   Position: 23
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
> org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1073)
> org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:765)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:960)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)

[Adam Heath-2]

Adam Heath wrote:

> rohit wrote:
>> Hi Adam,
>>
>> Can you please re-check the commit. I am running postgres 8.4 on FC8 and JDK
>> 1.6._17. I am still getting the error as below:
>
> What were you doing at the time?  What was your start page?  What form
> values did you fill out?  Which submit button did you hit?  Please be
> specific, because I did look at this, and couldn't repeat it the last
> time(or did fix a problem).

I've imported data into postgresql 8.4, when to /catalog/control/main,
typed 'widget' into the keyword search box on the left menu, and
didn't get any error.  Got 8 results.

Are you *sure* you are running the latest ofbiz?

>
> <general>
> It's also best to include the series of steps that you have done when
> reporting a problem.  This way anyone else can repeat the issue.
> </general>
>
>> 2010-06-14 03:58:48,600 (TP-Processor5) [     ControlServlet.java:144:INFO ]
>> [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since
>> last(Begin):0.0]]
>> 2010-06-14 03:58:48,604 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ]
>> Expanded keyword [gizmos], got set: []
>> 2010-06-14 03:58:48,605 (TP-Processor5) [     RequestHandler.java:638:INFO ]
>> Ran Event
>> [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride]
>> from [request], result is [success]
>> 2010-06-14 03:58:48,646 (TP-Processor5) [     RequestHandler.java:741:INFO ]
>> Rendering View [keywordsearch],
>> sessionId=2173C489A0B096AA162A2EFBFD169C0B.jvm1
>> 2010-06-14 03:58:48,703 (TP-Processor5) [      ScreenFactory.java:128:INFO ]
>> Got 30 screens in 0.054s from:
>> file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CatalogScreens.xml
>> 2010-06-14 03:58:48,720 (TP-Processor5) [  KeywordSearchUtil.java:235:INFO ]
>> Expanded keyword [gizmos], got set: []
>> 2010-06-14 03:58:48,720 (TP-Processor5) [      ProductSearch.java:272:INFO ]
>> Finished initial setup of keywords, doingBothAndOr=false,
>> andKeywordFixedSet={%gizmo%}
>>  keywordFixedOrSetAndList={}
>> 2010-06-14 03:58:48,721 (TP-Processor5) [      ProductSearch.java:625:INFO ]
>> topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-06-14 03:58:48.719')
>> AND pcm2FromDate < '2010-06-14 03:58:48.719' AND pcm2ProductCategoryId IN
>> ('CATALOG1_SEARCH'))
>> 2010-06-14 03:58:48,749 (TP-Processor5) [      ProductSearch.java:790:ERROR]
>> ---- exception report
>> ----------------------------------------------------------
>> Error getting results from the product search query
>> Exception: org.ofbiz.entity.GenericDataSourceException
>> Message: SQL Exception while executing the following:SELECT COUNT(DISTINCT
>> TOTAL_RELEVANCY) FROM ((public.PRODUCT PROD LEFT OUTER JOIN
>> public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID =
>> PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID
>> = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON
>> PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND
>> PK1.KEYWORD LIKE ? AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND
>> PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) (ERROR: column
>> "total_relevancy" does not exist
>>   Position: 23)
>> ---- cause
>> ---------------------------------------------------------------------
>> Exception: org.postgresql.util.PSQLException
>> Message: ERROR: column "total_relevancy" does not exist
>>   Position: 23
>> ---- stack trace
>> ---------------------------------------------------------------
>> org.postgresql.util.PSQLException: ERROR: column "total_relevancy" does not
>> exist
>>   Position: 23
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
>> org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1073)
>> org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
>> org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:765)
>> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
>> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:960)
>> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
>> Source)
>> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
>> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
>> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
>> KeywordSearch.run(KeywordSearch.groovy:35)
>> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
>> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
>> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
>> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
>> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
>> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
>> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
>> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
>> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
>> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
>> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
>> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
>> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
>> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
>> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
>> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
>> java.lang.Thread.run(Thread.java:619)
>

[rohit]

Hi,

Yes, i tried with the latest svn as on last Sunday.

To be specific, i updated my svn on last sunday, except the changes in the entity config file for the postgres database, there no other changes in the svn code. I then did a ./ant run-install and then started ofbiz. I then went to ecommerce/control/main and searched for the keyword "giz" using the normal search button, the next screen was the error.

I am using JDK 1.6_17 and jdbc 4 Version 8.4-701 with postgres 8.4 on FC - 8 machine. I have pasted the log once again as below. There is one more error introduced which is with the insertion on the keyword into the database. The log says:

2010-06-20 02:54:49,846 (TP-Processor12) [      ProductSearch.java:801:ERROR]
---- exception report ----------------------------------------------------------
Error saving product search result info/stats
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: current transaction is aborted, commands ignored until end of transaction block


I am not sure here, if its a problem with the ofbiz code or a problem of the JDBC and postgres, but these errors did not exist in the ofbiz code in march'10. there was some similar issue as discussed on this link http://ofbiz.135035.n4.nabble.com/jira-Created-OFBIZ-3520-revision-897605-breaks-certain-delegator-find-EntityListIterator-calls-td1571010.html#a1571675, which had given similar errors and later David had to revert the code, which was again later updated.

I hope the above helps, if you need more information please let me know and i will try to provide as much as I can.

Thanks,

Rohit
 




2010-06-20 02:54:44,771 (TP-Processor10) [       SequenceUtil.java:337:INFO ] Got bank of sequenced IDs for [ProductSearchResult]; curSeqId=10070, maxSeqId=10080, bankSize=10
2010-06-20 02:54:46,162 (TP-Processor10) [       ServerHitBin.java:627:INFO ] Visit delegatorName=default, ServerHitBin delegatorName=default
2010-06-20 02:54:46,171 (TP-Processor10) [     ControlServlet.java:327:INFO ] [[[keywordsearch] Request Done- total:1.605,since last([keywordsearch] R...):1.605]]
2010-06-20 02:54:49,735 (TP-Processor12) [     ControlServlet.java:144:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-06-20 02:54:49,775 (TP-Processor12) [    ConfigXMLReader.java:120:INFO ] controller loaded: 0.0040s, 277 requests, 92 views in jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml
2010-06-20 02:54:49,784 (TP-Processor12) [      JkInputStream.java:202:INFO ] Receiving: getting request body chunk 95 95
2010-06-20 02:54:49,799 (TP-Processor12) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [giz], got set: []
2010-06-20 02:54:49,800 (TP-Processor12) [     RequestHandler.java:638:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success]
2010-06-20 02:54:49,800 (TP-Processor12) [     RequestHandler.java:741:INFO ] Rendering View [keywordsearch], sessionId=F47E303819384A19C11D23320B0CD23F.jvm1
2010-06-20 02:54:49,815 (TP-Processor12) [      ScreenFactory.java:128:INFO ] Got 30 screens in 0.012s from: file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CatalogScreens.xml
2010-06-20 02:54:49,819 (TP-Processor12) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [giz], got set: []
2010-06-20 02:54:49,819 (TP-Processor12) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%giz%}
 keywordFixedOrSetAndList={}
2010-06-20 02:54:49,821 (TP-Processor12) [      ProductSearch.java:624:INFO ] topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-06-20 02:54:49.818') AND pcm2FromDate < '2010-06-20 02:54:49.818' AND pcm2ProductCategoryId IN ('CATALOG1_SEARCH'))
2010-06-20 02:54:49,843 (TP-Processor12) [      ProductSearch.java:762:ERROR]
---- exception report ----------------------------------------------------------
Error getting results from the product search query
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT COUNT(DISTINCT TOTAL_RELEVANCY) FROM ((public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND PK1.KEYWORD LIKE ? AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) (ERROR: column "total_relevancy" does not exist
  Position: 23)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: column "total_relevancy" does not exist
  Position: 23
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: column "total_relevancy" does not exist
  Position: 23
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1073)
org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:749)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,845 (TP-Processor12) [   GenericDelegator.java:900:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: current transaction is aborted, commands ignored until end of transaction block
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,846 (TP-Processor12) [    TransactionUtil.java:370:WARN ]
---- exception report ----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:903)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,846 (TP-Processor12) [      ProductSearch.java:801:ERROR]
---- exception report ----------------------------------------------------------
Error saving product search result info/stats
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: current transaction is aborted, commands ignored until end of transaction block
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,847 (TP-Processor12) [    TransactionUtil.java:374:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set.
2010-06-20 02:54:49,858 (TP-Processor12) [      ScreenFactory.java:128:INFO ] Got 16 screens in 0.01s from: file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CommonScreens.xml
2010-06-20 02:54:49,859 (TP-Processor12) [    TransactionUtil.java:151:WARN ]
---- exception report ----------------------------------------------------------
[TransactionUtil.begin] active transaction marked for rollback in place, so no transaction begun; this stack trace shows when the exception began:
Exception: java.lang.Exception
Message: Tx Stack Placeholder
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Tx Stack Placeholder
org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:695)
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:185)
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:131)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:385)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,861 (TP-Processor12) [        ModelScreen.java:408:ERROR] Error rendering screen [component://ecommerce/widget/CommonScreens.xml#main-decorator]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) (Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))). Rolling back transaction.
2010-06-20 02:54:49,862 (TP-Processor12) [    TransactionUtil.java:374:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set.
2010-06-20 02:54:49,863 (TP-Processor12) [    TransactionUtil.java:280:ERROR]
---- exception report ----------------------------------------------------------
Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception
Exception: javax.transaction.RollbackException
Message: Unable to commit: transaction marked for rollback
---- stack trace ---------------------------------------------------------------
javax.transaction.RollbackException: Unable to commit: transaction marked for rollback
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:271)
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:259)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:245)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:423)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,864 (TP-Processor12) [        ModelScreen.java:425:ERROR]
---- exception report ----------------------------------------------------------
Could not commit transaction: org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) (Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)))
Exception: org.ofbiz.entity.transaction.GenericTransactionException
Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) (Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: current transaction is aborted, commands ignored until end of transaction block
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,870 (TP-Processor12) [     ControlServlet.java:230:ERROR]
---- exception report ----------------------------------------------------------
Error in request handler:
Exception: org.ofbiz.widget.screen.ScreenRenderException
Message: Error rendering screen [component://ecommerce/widget/CommonScreens.xml#main-decorator]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) (Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) (Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.transaction.GenericTransactionException
Message: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) (Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: current transaction is aborted, commands ignored until end of transaction block
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-20 02:54:49,872 (TP-Processor12) [     ControlServlet.java:246:ERROR] An error occurred, going to the errorPage: /error/error.jsp
2010-06-20 02:54:49,899 (TP-Processor12) [     ControlServlet.java:253:ERROR] Including errorPage: /error/error.jsp
2010-06-20 02:54:50,864 (TP-Processor12) [       ServerHitBin.java:627:INFO ] Visit delegatorName=default, ServerHitBin delegatorName=default
2010-06-20 02:54:50,974 (TP-Processor12) [     ControlServlet.java:327:INFO ] [[[keywordsearch] Request Done- total:1.238,since last([keywordsearch] R...):1.238]]
2010-06-20 02:56:25,613 (TP-Processor12) [ControlEventListener.java:64 :INFO ] Creating session: 0281804B9BB470662C3E88E062961414.jvm1
2010-06-20 02:56:25,623 (TP-Processor12) [     ControlServlet.java:144:INFO ] [[[product] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-06-20 02:56:25,624 (TP-Processor12) [       VisitHandler.java:232:INFO ] Found visitorId [null] in cookie
2010-06-20 02:56:25,747 (TP-Processor12) [    ConfigXMLReader.java:120:INFO ] controller loaded: 0.01s, 277 requests, 92 views in jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml

[rohit]

the keyword was "gz" and not "giz", but you may try random keywords and you should see the error for a few of them.

[Adam Heath-2]

rohit wrote:
> Hi,
>
> Yes, i tried with the latest svn as on last Sunday.

Sorry, fixed in 957354.  The keyword search I initially did was in the
catalog backend, not in ecommerce.

>
> To be specific, i updated my svn on last sunday, except the changes in the
> entity config file for the postgres database, there no other changes in the
> svn code. I then did a ./ant run-install and then started ofbiz. I then went
> to ecommerce/control/main and searched for the keyword "giz" using the
> normal search button, the next screen was the error.
>
> I am using JDK 1.6_17 and jdbc 4 Version 8.4-701 with postgres 8.4 on FC - 8
> machine. I have pasted the log once again as below. There is one more error
> introduced which is with the insertion on the keyword into the database. The
> log says:

The following is not an error.  Look further up.  At a guess, however,
is that you cleaned/reinstalled the database, which then means the
visitorId cookie you have in your browser is no longer valid, so you
get the following error.  It's not a real problem.

>
> 2010-06-20 02:54:49,846 (TP-Processor12) [    
> ProductSearch.java:801:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error saving product search result info/stats
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: current transaction is aborted, commands ignored until end
> of transaction block
>
>
> I am not sure here, if its a problem with the ofbiz code or a problem of the
> JDBC and postgres, but these errors did not exist in the ofbiz code in
> march'10. there was some similar issue as discussed on this link
> http://ofbiz.135035.n4.nabble.com/jira-Created-OFBIZ-3520-revision-897605-breaks-certain-delegator-find-EntityListIterator-calls-td1571010.html#a1571675,
> which had given similar errors and later David had to revert the code, which
> was again later updated.
>
> I hope the above helps, if you need more information please let me know and
> i will try to provide as much as I can.
>
> Thanks,
>
> Rohit
>  
>
>
>
>
> 2010-06-20 02:54:44,771 (TP-Processor10) [       SequenceUtil.java:337:INFO
> ] Got bank of sequenced IDs for [ProductSearchResult]; curSeqId=10070,
> maxSeqId=10080, bankSize=10
> 2010-06-20 02:54:46,162 (TP-Processor10) [       ServerHitBin.java:627:INFO
> ] Visit delegatorName=default, ServerHitBin delegatorName=default
> 2010-06-20 02:54:46,171 (TP-Processor10) [     ControlServlet.java:327:INFO
> ] [[[keywordsearch] Request Done- total:1.605,since last([keywordsearch]
> R...):1.605]]
> 2010-06-20 02:54:49,735 (TP-Processor12) [     ControlServlet.java:144:INFO
> ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since
> last(Begin):0.0]]
> 2010-06-20 02:54:49,775 (TP-Processor12) [    ConfigXMLReader.java:120:INFO
> ] controller loaded: 0.0040s, 277 requests, 92 views in
> jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml
> 2010-06-20 02:54:49,784 (TP-Processor12) [      JkInputStream.java:202:INFO
> ] Receiving: getting request body chunk 95 95
> 2010-06-20 02:54:49,799 (TP-Processor12) [  KeywordSearchUtil.java:235:INFO
> ] Expanded keyword [giz], got set: []
> 2010-06-20 02:54:49,800 (TP-Processor12) [     RequestHandler.java:638:INFO
> ] Ran Event
> [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride]
> from [request], result is [success]
> 2010-06-20 02:54:49,800 (TP-Processor12) [     RequestHandler.java:741:INFO
> ] Rendering View [keywordsearch],
> sessionId=F47E303819384A19C11D23320B0CD23F.jvm1
> 2010-06-20 02:54:49,815 (TP-Processor12) [      ScreenFactory.java:128:INFO
> ] Got 30 screens in 0.012s from:
> file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CatalogScreens.xml
> 2010-06-20 02:54:49,819 (TP-Processor12) [  KeywordSearchUtil.java:235:INFO
> ] Expanded keyword [giz], got set: []
> 2010-06-20 02:54:49,819 (TP-Processor12) [      ProductSearch.java:271:INFO
> ] Finished initial setup of keywords, doingBothAndOr=false,
> andKeywordFixedSet={%giz%}
>  keywordFixedOrSetAndList={}
> 2010-06-20 02:54:49,821 (TP-Processor12) [      ProductSearch.java:624:INFO
> ] topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-06-20
> 02:54:49.818') AND pcm2FromDate < '2010-06-20 02:54:49.818' AND
> pcm2ProductCategoryId IN ('CATALOG1_SEARCH'))
> 2010-06-20 02:54:49,843 (TP-Processor12) [    
> ProductSearch.java:762:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error getting results from the product search query
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT COUNT(DISTINCT
> TOTAL_RELEVANCY) FROM ((public.PRODUCT PROD LEFT OUTER JOIN
> public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID =
> PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID
> = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON
> PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND
> PK1.KEYWORD LIKE ? AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND
> PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) (ERROR: column
> "total_relevancy" does not exist
>   Position: 23)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: column "total_relevancy" does not exist
>   Position: 23
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: column "total_relevancy" does not
> exist
>   Position: 23
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
> org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1073)
> org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:749)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,845 (TP-Processor12) [  
> GenericDelegator.java:900:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: current transaction is aborted, commands ignored until end
> of transaction block
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,846 (TP-Processor12) [    TransactionUtil.java:370:WARN
> ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Failure in create operation for entity
> [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:903)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,846 (TP-Processor12) [    
> ProductSearch.java:801:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error saving product search result info/stats
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: current transaction is aborted, commands ignored until end
> of transaction block
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,847 (TP-Processor12) [    TransactionUtil.java:374:INFO
> ] [TransactionUtil.setRollbackOnly] transaction rollback only not set,
> rollback only is already set.
> 2010-06-20 02:54:49,858 (TP-Processor12) [      ScreenFactory.java:128:INFO
> ] Got 16 screens in 0.01s from:
> file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CommonScreens.xml
> 2010-06-20 02:54:49,859 (TP-Processor12) [    TransactionUtil.java:151:WARN
> ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.begin] active transaction marked for rollback in place, so
> no transaction begun; this stack trace shows when the exception began:
> Exception: java.lang.Exception
> Message: Tx Stack Placeholder
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Tx Stack Placeholder
> org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:695)
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:185)
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:131)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:385)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,861 (TP-Processor12) [      
> ModelScreen.java:408:ERROR] Error rendering screen
> [component://ecommerce/widget/CommonScreens.xml#main-decorator]:
> org.ofbiz.entity.transaction.GenericTransactionException: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))). Rolling back
> transaction.
> 2010-06-20 02:54:49,862 (TP-Processor12) [    TransactionUtil.java:374:INFO
> ] [TransactionUtil.setRollbackOnly] transaction rollback only not set,
> rollback only is already set.
> 2010-06-20 02:54:49,863 (TP-Processor12) [  
> TransactionUtil.java:280:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Rollback Only was set when trying to commit transaction here; throwing
> rollbackOnly cause exception
> Exception: javax.transaction.RollbackException
> Message: Unable to commit: transaction marked for rollback
> ---- stack trace
> ---------------------------------------------------------------
> javax.transaction.RollbackException: Unable to commit: transaction marked
> for rollback
> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:271)
> org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:259)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:245)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:423)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,864 (TP-Processor12) [      
> ModelScreen.java:425:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Could not commit transaction:
> org.ofbiz.entity.transaction.GenericTransactionException: Roll back error,
> could not commit transaction, was rolled back instead because of: Failure in
> create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)))
> Exception: org.ofbiz.entity.transaction.GenericTransactionException
> Message: Roll back error, could not commit transaction, was rolled back
> instead because of: Failure in create operation for entity
> [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: current transaction is aborted, commands ignored until end
> of transaction block
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,870 (TP-Processor12) [    
> ControlServlet.java:230:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in request handler:
> Exception: org.ofbiz.widget.screen.ScreenRenderException
> Message: Error rendering screen
> [component://ecommerce/widget/CommonScreens.xml#main-decorator]:
> org.ofbiz.entity.transaction.GenericTransactionException: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))) (The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.transaction.GenericTransactionException
> Message: The current transaction is marked for rollback, not beginning a new
> transaction and aborting current operation; the rollbackOnly was caused by:
> Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][createdTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-20
> 02:54:49.843(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10071(java.lang.String)][searchDate,2010-06-20
> 02:54:49.818(java.sql.Timestamp)][secondsTotal,0.024(java.lang.Double)][visitId,10060(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: current transaction is aborted, commands ignored until end
> of transaction block
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:271)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-20 02:54:49,872 (TP-Processor12) [    
> ControlServlet.java:246:ERROR] An error occurred, going to the errorPage:
> /error/error.jsp
> 2010-06-20 02:54:49,899 (TP-Processor12) [    
> ControlServlet.java:253:ERROR] Including errorPage: /error/error.jsp
> 2010-06-20 02:54:50,864 (TP-Processor12) [       ServerHitBin.java:627:INFO
> ] Visit delegatorName=default, ServerHitBin delegatorName=default
> 2010-06-20 02:54:50,974 (TP-Processor12) [     ControlServlet.java:327:INFO
> ] [[[keywordsearch] Request Done- total:1.238,since last([keywordsearch]
> R...):1.238]]
> 2010-06-20 02:56:25,613 (TP-Processor12) [ControlEventListener.java:64 :INFO
> ] Creating session: 0281804B9BB470662C3E88E062961414.jvm1
> 2010-06-20 02:56:25,623 (TP-Processor12) [     ControlServlet.java:144:INFO
> ] [[[product] Request Begun, encoding=[UTF-8]- total:0.0,since
> last(Begin):0.0]]
> 2010-06-20 02:56:25,624 (TP-Processor12) [       VisitHandler.java:232:INFO
> ] Found visitorId [null] in cookie
> 2010-06-20 02:56:25,747 (TP-Processor12) [    ConfigXMLReader.java:120:INFO
> ] controller loaded: 0.01s, 277 requests, 92 views in
> jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml

[Nicolas Malin (Jira)]

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

Atul Vani updated OFBIZ-3789:
-----------------------------

    Attachment: UseGroupByForKeywordSortOnly.patch

Hello All,

I wonder this issue has been fixed completely. Try searching 'gift card' from
http://localhost:8087/ecommerce/control/advancedsearch
and using some other value for 'Sorted by' instead of 'Keyword Relevancy'.

The first time i observed this issue KeywordSort was not working for search keyword 'gift'
(the console log suggested that SELECT got no 'totalRelevancy' column but the GROUPBY has it in the query)
although the KeywordSort was working well for 'gift card'.

All other sorting methods from http://localhost:8087/ecommerce/control/advancedsearch
were working for 'gift' but not 'gift card'.

I think it was before r951553. when i created a quick fix for it. But I am not sure.
I have attached the patch I used.

Thanks & Regards
Atul Vani

> No results when searching with keywords in catalog
> --------------------------------------------------
>
>                 Key: OFBIZ-3789
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3789
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>            Reporter: Erwan de FERRIERES
>            Assignee: Adam Heath
>             Fix For: SVN trunk
>
>         Attachments: UseGroupByForKeywordSortOnly.patch
>
>
> Steps to reproduce :
> go to : https://localhost:8443/catalog/control/keywordsearch
> then in the Keywords textbox, type GZ, then hit enter key.
> No results are shown.
> Log error in the console :
> 2010-05-28 16:03:07,780 (http-0.0.0.0-8443-1) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={%gz%}
>  keywordFixedOrSetAndList={}
> 2010-05-28 16:03:07,849 (http-0.0.0.0-8443-1) [      ProductSearch.java:654:ERROR]
> ---- exception report ----------------------------------------------------------
> Error in product search
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT DISTINCT PK1.RELEVANCY_WEIGHT, PROD.PRODUCT_ID FROM (OFBIZ.PRODUCT PROD LEFT OUTER JOIN OFBIZ.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN OFBIZ.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PK1.KEYWORD LIKE ?) ORDER BY TOTAL_RELEVANCY DESC (Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLSyntaxErrorException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.
> ---- stack trace ---------------------------------------------------------------
> ERROR 42X04: Column 'TOTAL_RELEVANCY' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOTAL_RELEVANCY' is not a column in the target table.

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