Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016867Openbravo ERP00. Application dictionarypublic2011-04-20 16:502011-05-08 20:19
Reporterlumination 
Assigned Toalostale 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS30OS VersionCommunity
Product Version3.0RC5 
Target VersionFixed in Version3.0RC7 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016867: Missing "order by" clause from generated tabs migrated from, and working in, 2.50MP4
DescriptionWhen 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 ReproduceThese 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)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0001653 closed iperdomo Esquema contable > contabilidad general tab, fiels as * 
Attached Fileszip com.retailingwireless.core.zip (208,910) 2011-04-20 16:50
https://issues.openbravo.com/file_download.php?file_id=3890&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-04-20 16:50luminationNew Issue
2011-04-20 16:50luminationAssigned To => alostale
2011-04-20 16:50luminationFile Added: com.retailingwireless.core.zip
2011-04-20 16:50luminationModules => Core
2011-05-02 11:16alostaleOBNetwork customer => No
2011-05-02 11:16alostaleTarget Version => 3.0RC7
2011-05-02 11:16alostaleStatusnew => scheduled
2011-05-02 11:16alostalefix_in_branch => pi
2011-05-06 19:28dmitry_mezentsevNote Added: 0036533
2011-05-06 19:28dmitry_mezentsevStatusscheduled => feedback
2011-05-06 19:29dmitry_mezentsevNote Added: 0036534
2011-05-06 19:29dmitry_mezentsevTarget Version3.0RC7 =>
2011-05-06 19:29dmitry_mezentsevfix_in_branchpi =>
2011-05-08 20:19mtaalStatusfeedback => scheduled
2011-05-08 20:19mtaalNote Added: 0036537
2011-05-08 20:19mtaalfix_in_branch => pi
2011-05-08 20:19mtaalRelationship addedduplicate of 0001653
2011-05-08 20:19mtaalNote Added: 0036538
2011-05-08 20:19mtaalStatusscheduled => closed
2011-05-08 20:19mtaalResolutionopen => duplicate
2011-05-08 20:19mtaalFixed in Version => 3.0RC7

Notes
(0036533)
dmitry_mezentsev   
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   
2011-05-06 19:29   
Target version depends on where issue is.
(0036537)
mtaal   
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   
2011-05-08 20:19   
https://code.openbravo.com/erp/devel/pi/rev/36fe7542df646c1cc04fcf3978c17919793bb69d [^]