Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016867 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | minor | always | 2011-04-20 16:50 | 2011-05-08 20:19 | |||
| Reporter | lumination | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | high | Resolution | duplicate | Fixed in Version | 3.0RC7 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | OpenJDK 64-Bit Server VM (build | |||
| OS Version | Community | Database version | 8.4.7-1ubuntu1 | Ant version | 1.8.1-1 | |||
| Product Version | 3.0RC5 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0016867: Missing "order by" clause from generated tabs migrated from, and working in, 2.50MP4 | |||||||
| Description | When viewing a tab, a red error message box shows above the tab: "Exception when creating query select e from RC_SYSTEM_CREDENTIALS as e where ( ( e.bpartner.id = :alias_0 ) ) and e.organization.id in ('0', '6B3C6669E32B43E1A1B14788C0CD0146', 'C65ADE5AFC5942B39D0544076A5618B4') and e.client.id in ('2C908AA22CBD1292012CBD1733590021', '0')order by" Following is output from openbravo.log: 10:12:46 [http-8080-1] ERROR org.openbravo.service.json.DefaultJsonDataService - Exception when creating query select e from RC_SYSTEM_CREDENTIALS as e where ( ( e.bpartner.id = :alias_0 ) ) and e.organization.id in ('0', '6B3C6669E32B43E1A1B14788C0CD0146', 'C65ADE5AFC5942B39D0544076A5618B4') and e.client.id in ('2C908AA22CBD1292012CBD1733590021', '0')order by org.openbravo.base.exception.OBException: Exception when creating query select e from RC_SYSTEM_CREDENTIALS as e where ( ( e.bpartner.id = :alias_0 ) ) and e.organization.id in ('0', '6B3C6669E32B43E1A1B14788C0CD0146', 'C65ADE5AFC5942B39D0544076A5618B4') and e.client.id in ('2C908AA22CBD1292012CBD1733590021', '0')order by 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:134) at org.openbravo.service.datasource.DefaultDataSourceService.fetch(DefaultDataSourceService.java:55) at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:211) at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:478) 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:110) 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:857) 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:679) Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: null near line 1, column 259 [select e from RC_SYSTEM_CREDENTIALS as e where ( ( e.bpartner.id = :alias_0 ) ) and e.organization.id in ('0', '6B3C6669E32B43E1A1B14788C0CD0146', 'C65ADE5AFC5942B39D0544076A5618B4') and e.client.id in ('2C908AA22CBD1292012CBD1733590021', '0')order by ] at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31) at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24) at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623) at org.openbravo.dal.service.OBQuery.createQuery(OBQuery.java:227) ... 36 more | |||||||
| Steps To Reproduce | These are modules that were designed for Openbravo ERP 2.50MP4 and work in that version. All of our tabs are not working, and are generated tabs. The tab I have chosen to report in this bug report is a tab under the BusinessPartner window. I've attached the entire source for the module in which the table and tab resides as well as the openbravo/src-gen folder for the same module. All of the generated models in this module have associated tabs, none of which are working. In the SystemCredentials tab, I've also tried manually defining an HQL Order By Clause of both "e.SearchKey" and "searchKey", neither of which work and both of which produce the same error (with the orderby missing from the query) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  com.retailingwireless.core.zip [^] (208,910 bytes) 2011-04-20 16:50 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0036533) dmitry_mezentsev (viewer) 2011-05-06 19:28 |
Hi lumination, Could you please check and report if your module works on the latest generally available 2.50 version - 2.50MP27EU1. http://wiki.openbravo.com/wiki/ERP/2.50/Release_Notes/2.50MP27EU1 [^] The point is that in 2.50 there were also changes that could make your module not to work any longer. So this test will allow us to localize the problem better - understand if it is sth in 2.50 or 3.0. Thanks. |
|
(0036534) dmitry_mezentsev (viewer) 2011-05-06 19:29 |
Target version depends on where issue is. |
|
(0036537) mtaal (viewer) 2011-05-08 20:19 |
Duplicate of other issue which was solved and will be released for rc7: https://issues.openbravo.com/view.php?id=16543 [^] |
|
(0036538) mtaal (viewer) 2011-05-08 20:19 |
https://code.openbravo.com/erp/devel/pi/rev/36fe7542df646c1cc04fcf3978c17919793bb69d [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-04-20 16:50 | lumination | New Issue | |
| 2011-04-20 16:50 | lumination | Assigned To | => alostale |
| 2011-04-20 16:50 | lumination | File Added: com.retailingwireless.core.zip | |
| 2011-04-20 16:50 | lumination | Modules | => Core |
| 2011-05-02 11:16 | alostale | OBNetwork customer | => No |
| 2011-05-02 11:16 | alostale | Target Version | => 3.0RC7 |
| 2011-05-02 11:16 | alostale | Status | new => scheduled |
| 2011-05-02 11:16 | alostale | fix_in_branch | => pi |
| 2011-05-06 19:28 | dmitry_mezentsev | Note Added: 0036533 | |
| 2011-05-06 19:28 | dmitry_mezentsev | Status | scheduled => feedback |
| 2011-05-06 19:29 | dmitry_mezentsev | Note Added: 0036534 | |
| 2011-05-06 19:29 | dmitry_mezentsev | Target Version | 3.0RC7 => |
| 2011-05-06 19:29 | dmitry_mezentsev | fix_in_branch | pi => |
| 2011-05-08 20:19 | mtaal | Status | feedback => scheduled |
| 2011-05-08 20:19 | mtaal | Note Added: 0036537 | |
| 2011-05-08 20:19 | mtaal | fix_in_branch | => pi |
| 2011-05-08 20:19 | mtaal | Relationship added | duplicate of 0001653 |
| 2011-05-08 20:19 | mtaal | Note Added: 0036538 | |
| 2011-05-08 20:19 | mtaal | Status | scheduled => closed |
| 2011-05-08 20:19 | mtaal | Resolution | open => duplicate |
| 2011-05-08 20:19 | mtaal | Fixed in Version | => 3.0RC7 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |