Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0017019
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2011-05-05 10:152011-05-26 07:46
ReportermaiteView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version3.0MP0
StatusclosedFix in branchpiFixed in SCM revision5b76fe654308
ProjectionnoneETAnoneTarget Version3.0MP0
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017019: 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.)
TagsNo tags attached.
Attached Filespng file icon errorGrid.png [^] (129,052 bytes) 2011-05-05 10:15

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0036404)
dmitry_mezentsev (developer)
2011-05-05 17:19

As of now does not fit RC7 but will be resolved by SLA date.
(0037007)
alostale (manager)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2011-05-25 17:40

verified
(0037541)
hudsonbot (developer)
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 (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2011-05-05 10:15 maite New Issue
2011-05-05 10:15 maite Assigned To => adrianromero
2011-05-05 10:15 maite File Added: errorGrid.png
2011-05-05 10:15 maite Modules => Core
2011-05-05 10:16 maite Assigned To adrianromero => alostale
2011-05-05 10:18 maite Description Updated View Revisions
2011-05-05 10:18 maite Steps to Reproduce Updated View Revisions
2011-05-05 10:49 maite Target Version => 3.0RC7
2011-05-05 17:19 dmitry_mezentsev Target Version 3.0RC7 => 3.0MP0
2011-05-05 17:19 dmitry_mezentsev Note Added: 0036404
2011-05-16 11:13 alostale Note Added: 0037007
2011-05-16 11:13 alostale Status new => scheduled
2011-05-16 11:13 alostale fix_in_branch => pi
2011-05-17 09:15 iperdomo Priority urgent => normal
2011-05-17 13:41 iperdomo Priority normal => urgent
2011-05-24 13:44 hgbot Checkin
2011-05-24 13:44 hgbot Note Added: 0037385
2011-05-24 13:44 hgbot Status scheduled => resolved
2011-05-24 13:44 hgbot Resolution open => fixed
2011-05-24 13:44 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dd0fc0ef1fd162c72ebc5ba491e5d05e7d7f53dd [^]
2011-05-24 16:44 hgbot Checkin
2011-05-24 16:44 hgbot Note Added: 0037395
2011-05-24 18:22 hgbot Checkin
2011-05-24 18:22 hgbot Note Added: 0037404
2011-05-24 18:22 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/dd0fc0ef1fd162c72ebc5ba491e5d05e7d7f53dd [^] => http://code.openbravo.com/erp/devel/pi/rev/5b76fe654308c36a401e3a43cc41f451cee4b418 [^]
2011-05-25 17:40 maite Note Added: 0037441
2011-05-25 17:40 maite Status resolved => closed
2011-05-25 17:40 maite Fixed in Version => 3.0MP0
2011-05-26 07:46 hudsonbot Checkin
2011-05-26 07:46 hudsonbot Note Added: 0037541
2011-05-26 07:46 hudsonbot Checkin
2011-05-26 07:46 hudsonbot Note Added: 0037545
2011-05-26 07:46 hudsonbot Checkin
2011-05-26 07:46 hudsonbot Note Added: 0037548


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker