Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017019Openbravo ERP07. Sales managementpublic2011-05-05 10:152011-05-26 07:46
Reportermaite 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP0Fixed in Version3.0MP0 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017019: Error when trying to filter by Sales Order Line field in Sales Invoice Line window
DescriptionError when trying to filter by Sales Order Line field in Sales Invoice Line window. See screenshot attached to see error obtained.

Steps To Reproduce1. Login as System Administrator
2. Go to Windows, tabs and fields: search for sales invoice window. Go to Lines tab and search for Sales Order Lines field. Check it as "show in grid view"
3. Login as International Group Admin
4. Create Sales Invoice Header and sales invoice line. In grid view, fill "Sales Order Line" field to try to filter by it and you will obtain the error.

(If you show "Description" field and try to filter in grid there is no problem. So seems related with kind of field.)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng errorGrid.png (129,052) 2011-05-05 10:15
https://issues.openbravo.com/file_download.php?file_id=3942&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-05-05 10:15maiteNew Issue
2011-05-05 10:15maiteAssigned To => adrianromero
2011-05-05 10:15maiteFile Added: errorGrid.png
2011-05-05 10:15maiteModules => Core
2011-05-05 10:15maiteOBNetwork customer => Yes
2011-05-05 10:16maiteAssigned Toadrianromero => alostale
2011-05-05 10:18maiteDescription Updatedbug_revision_view_page.php?rev_id=1932#r1932
2011-05-05 10:18maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1934#r1934
2011-05-05 10:49maiteTarget Version => 3.0RC7
2011-05-05 17:19dmitry_mezentsevTarget Version3.0RC7 => 3.0MP0
2011-05-05 17:19dmitry_mezentsevNote Added: 0036404
2011-05-16 11:13alostaleNote Added: 0037007
2011-05-16 11:13alostaleStatusnew => scheduled
2011-05-16 11:13alostalefix_in_branch => pi
2011-05-17 09:15iperdomoPriorityurgent => normal
2011-05-17 13:41iperdomoPrioritynormal => urgent
2011-05-24 13:44hgbotCheckin
2011-05-24 13:44hgbotNote Added: 0037385
2011-05-24 13:44hgbotStatusscheduled => resolved
2011-05-24 13:44hgbotResolutionopen => fixed
2011-05-24 13:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dd0fc0ef1fd162c72ebc5ba491e5d05e7d7f53dd [^]
2011-05-24 16:44hgbotCheckin
2011-05-24 16:44hgbotNote Added: 0037395
2011-05-24 18:22hgbotCheckin
2011-05-24 18:22hgbotNote Added: 0037404
2011-05-24 18:22hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/dd0fc0ef1fd162c72ebc5ba491e5d05e7d7f53dd [^] => http://code.openbravo.com/erp/devel/pi/rev/5b76fe654308c36a401e3a43cc41f451cee4b418 [^]
2011-05-25 17:40maiteNote Added: 0037441
2011-05-25 17:40maiteStatusresolved => closed
2011-05-25 17:40maiteFixed in Version => 3.0MP0
2011-05-26 07:46hudsonbotCheckin
2011-05-26 07:46hudsonbotNote Added: 0037541
2011-05-26 07:46hudsonbotCheckin
2011-05-26 07:46hudsonbotNote Added: 0037545
2011-05-26 07:46hudsonbotCheckin
2011-05-26 07:46hudsonbotNote Added: 0037548

Notes
(0036404)
dmitry_mezentsev   
2011-05-05 17:19   
As of now does not fit RC7 but will be resolved by SLA date.
(0037007)
alostale   
2011-05-16 11:13   
11240858 [http-8880-6] ERROR org.hibernate.hql.PARSER - <AST>:0:0: unexpected AST node: ||
11240858 [http-8880-6] ERROR org.openbravo.base.exception.OBException - Exception when creating query select e from InvoiceLine as e where ( ( upper(((COALESCE(to_char(e.salesOrderLine.salesOrder.documentNo),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.salesOrder.orderDate),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.salesOrder.grandTotalAmount),'')) || ' - ' || COALESCE(to_char(e.salesOrderLine.lineNo),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.lineNetAmount),'')).id) like :alias_0 escape '|' and e.invoice.id = :alias_1 )) and e.organization.id in ('0', '4F68EB1C1B734E79B27DE9D2DF56089F', '0D8E225ADA6E425E98EAA0F34E5912D7', 'B9C7088AB859483A9B1FB342AC2BE17A', '90A1F59849E84AFABD04814B3D15A691', '378AF0EAE1A2479EAAA33436645E9433', '3C816D72B14D4BBCB8571404B794AB84', '7A8E888A4B4C4E638CD5EB3A41A3289A') and e.client.id in ('FF8080812AFBCB14012AFBD3E373001F', '0')
java.lang.NullPointerException
    at org.hibernate.hql.ast.HqlSqlWalker.lookupProperty(HqlSqlWalker.java:560)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:4774)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1326)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4471)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalker.java:2583)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1404)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4471)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4088)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2047)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:831)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:617)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
    at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
    at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
    at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
    at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
    at org.openbravo.dal.service.OBQuery.createQuery(OBQuery.java:227)
    at org.openbravo.dal.service.OBQuery.list(OBQuery.java:112)
    at org.openbravo.service.json.DataEntityQueryService.list(DataEntityQueryService.java:91)
    at org.openbravo.service.json.DefaultJsonDataService.fetch(DefaultJsonDataService.java:132)
    at org.openbravo.service.datasource.DefaultDataSourceService.fetch(DefaultDataSourceService.java:57)
    at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:217)
    at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:496)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:456)
    at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:89)
    at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:65)
    at org.openbravo.service.datasource.DataSourceServlet.service(DataSourceServlet.java:116)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)
11240859 [http-8880-6] ERROR org.openbravo.service.json.DefaultJsonDataService - Exception when creating query select e from InvoiceLine as e where ( ( upper(((COALESCE(to_char(e.salesOrderLine.salesOrder.documentNo),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.salesOrder.orderDate),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.salesOrder.grandTotalAmount),'')) || ' - ' || COALESCE(to_char(e.salesOrderLine.lineNo),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.lineNetAmount),'')).id) like :alias_0 escape '|' and e.invoice.id = :alias_1 )) and e.organization.id in ('0', '4F68EB1C1B734E79B27DE9D2DF56089F', '0D8E225ADA6E425E98EAA0F34E5912D7', 'B9C7088AB859483A9B1FB342AC2BE17A', '90A1F59849E84AFABD04814B3D15A691', '378AF0EAE1A2479EAAA33436645E9433', '3C816D72B14D4BBCB8571404B794AB84', '7A8E888A4B4C4E638CD5EB3A41A3289A') and e.client.id in ('FF8080812AFBCB14012AFBD3E373001F', '0')
org.openbravo.base.exception.OBException: Exception when creating query select e from InvoiceLine as e where ( ( upper(((COALESCE(to_char(e.salesOrderLine.salesOrder.documentNo),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.salesOrder.orderDate),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.salesOrder.grandTotalAmount),'')) || ' - ' || COALESCE(to_char(e.salesOrderLine.lineNo),'') || ' - ' || COALESCE(to_char(e.salesOrderLine.lineNetAmount),'')).id) like :alias_0 escape '|' and e.invoice.id = :alias_1 )) and e.organization.id in ('0', '4F68EB1C1B734E79B27DE9D2DF56089F', '0D8E225ADA6E425E98EAA0F34E5912D7', 'B9C7088AB859483A9B1FB342AC2BE17A', '90A1F59849E84AFABD04814B3D15A691', '378AF0EAE1A2479EAAA33436645E9433', '3C816D72B14D4BBCB8571404B794AB84', '7A8E888A4B4C4E638CD5EB3A41A3289A') and e.client.id in ('FF8080812AFBCB14012AFBD3E373001F', '0')
    at org.openbravo.dal.service.OBQuery.createQuery(OBQuery.java:237)
    at org.openbravo.dal.service.OBQuery.list(OBQuery.java:112)
    at org.openbravo.service.json.DataEntityQueryService.list(DataEntityQueryService.java:91)
    at org.openbravo.service.json.DefaultJsonDataService.fetch(DefaultJsonDataService.java:132)
    at org.openbravo.service.datasource.DefaultDataSourceService.fetch(DefaultDataSourceService.java:57)
    at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:217)
    at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:496)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:456)
    at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:89)
    at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:65)
    at org.openbravo.service.datasource.DataSourceServlet.service(DataSourceServlet.java:116)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NullPointerException
    at org.hibernate.hql.ast.HqlSqlWalker.lookupProperty(HqlSqlWalker.java:560)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:4774)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1326)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4471)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalker.java:2583)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1404)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4471)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4088)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2047)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:831)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:617)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
    at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
    at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
    at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
    at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
    at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
    at org.openbravo.dal.service.OBQuery.createQuery(OBQuery.java:227)
    ... 36 more
(0037385)
hgbot   
2011-05-24 13:44   
Repository: erp/devel/pi
Changeset: dd0fc0ef1fd162c72ebc5ba491e5d05e7d7f53dd
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue May 24 13:43:32 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/dd0fc0ef1fd162c72ebc5ba491e5d05e7d7f53dd [^]

fixed bug 17019: Old search references where not usable in new grid and filter

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0037395)
hgbot   
2011-05-24 16:44   
Repository: erp/devel/pi
Changeset: 983998780371cecd9274c192f6ecb4c0691d7a00
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue May 24 16:43:47 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/983998780371cecd9274c192f6ecb4c0691d7a00 [^]

backed out dd0fc0ef1fd1 issue 17019

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0037404)
hgbot   
2011-05-24 18:22   
Repository: erp/devel/pi
Changeset: 5b76fe654308c36a401e3a43cc41f451cee4b418
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue May 24 18:21:46 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5b76fe654308c36a401e3a43cc41f451cee4b418 [^]

fixed bug 17019: old selectors didn't work in new grid

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
M src/org/openbravo/erpCommon/ad_actionButton/InsertAcces.java
---
(0037441)
maite   
2011-05-25 17:40   
verified
(0037541)
hudsonbot   
2011-05-26 07:46   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/728387046be6 [^]

Maturity status: Test
(0037545)
hudsonbot   
2011-05-26 07:46   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/728387046be6 [^]

Maturity status: Test
(0037548)
hudsonbot   
2011-05-26 07:46   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/728387046be6 [^]

Maturity status: Test