Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0017019 | Openbravo ERP | 07. Sales management | public | 2011-05-05 10:15 | 2011-05-26 07:46 |
|
| Reporter | maite | |
| Assigned To | alostale | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | 3.0MP0 | Fixed in Version | 3.0MP0 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0017019: Error when trying to filter by Sales Order Line field in Sales Invoice Line window |
| Description | Error when trying to filter by Sales Order Line field in Sales Invoice Line window. See screenshot attached to see error obtained.
|
| Steps To Reproduce | 1. 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 | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  errorGrid.png (129,052) 2011-05-05 10:15
https://issues.openbravo.com/file_download.php?file_id=3942&type=bug
|
|
| 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 | bug_revision_view_page.php?rev_id=1932#r1932 |
| 2011-05-05 10:18 | maite | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=1934#r1934 |
| 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 | |
|
Notes |
|
|
|
|
As of now does not fit RC7 but will be resolved by SLA date. |
|
|
|
|
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
|
|
|
|
|
(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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|