Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021273 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2012-08-01 02:16 | 2012-08-01 15:11 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | caristu | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | a3f4acecdb1b | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | Automated tests | |||||||
| Regression date | 2012-07-30 | |||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/f2a6e4598a05b0877b79700b659bdf2bbc2aeb27#l3.16 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0021273: Invoice Line tab does not show the Product combo in Form mode | |||||||
| Description | Using Oracle database, after completing an invoice, the Product selector in Form mode is blank. It works fine when using Postgres. See steps. | |||||||
| Steps To Reproduce | 1. Log in as QAAdmin 2. Go to Sales Invoice 3. Create a New record for Customer A 4. Create a Line for Final Goods A 5. Complete the Invoice 6. Check that the Product field shows the correct value 7. Change record to Form mode. Check that the Product field is blank (see screenshot) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Openbravo Sales Invoice I 47 01 08 2....png [^] (88,412 bytes) 2012-08-01 02:16
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0051061) dmiguelez (viewer) 2012-08-01 14:03 |
The Issue is related to the sql for gl item combo: : c988d094 74421410 [http-8080-4] ERROR org.openbravo.erpCommon.utility.ComboTableData - Error of SQL in query: SELECT td0.C_Glitem_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),'')),'')) AS NAME, '' AS DESCRIPTION FROM C_Glitem td0 WHERE td0.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td0.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') AND EnableInFinInvoices = 'Y' AND (td0.isActive = 'Y' OR td0.C_Glitem_ID = (?) ) ORDER BY AD_Org_ID = ? DESCException:java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended c988d094 74421453 [http-8080-4] ERROR org.openbravo.base.exception.OBException - Error while computing combo data java.lang.Exception: @CODE=933@ORA-00933: SQL command not properly ended at org.openbravo.erpCommon.utility.ComboTableData.select(ComboTableData.java:1102) at org.openbravo.client.kernel.reference.UIDefinition.getValueInComboReference(UIDefinition.java:443) at org.openbravo.client.kernel.reference.FKComboUIDefinition.getFieldProperties(FKComboUIDefinition.java:49) at org.openbravo.client.application.window.FormInitializationComponent.computeColumnValues(FormInitializationComponent.java:551) at org.openbravo.client.application.window.FormInitializationComponent.execute(FormInitializationComponent.java:227) at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:71) at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:193) at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:104) at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:177) 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:428) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87) at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:63) 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.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71) 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:128) 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:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:662) c988d094 74421461 [http-8080-4] ERROR org.openbravo.base.exception.OBException - Couldn't get data for column Account_ID org.openbravo.base.exception.OBException: Error while computing combo data at org.openbravo.client.kernel.reference.UIDefinition.getValueInComboReference(UIDefinition.java:493) at org.openbravo.client.kernel.reference.FKComboUIDefinition.getFieldProperties(FKComboUIDefinition.java:49) at org.openbravo.client.application.window.FormInitializationComponent.computeColumnValues(FormInitializationComponent.java:551) at org.openbravo.client.application.window.FormInitializationComponent.execute(FormInitializationComponent.java:227) at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:71) at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:193) at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:104) at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:177) 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:428) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87) at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:63) 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.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71) 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:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.. |
|
(0051062) dmiguelez (viewer) 2012-08-01 14:04 |
Mind Order by clause: ORDER BY AD_Org_ID = ? DESC |
|
(0051064) plujan (viewer) 2012-08-01 14:19 |
The order by clause is wrong in this commit: https://code.openbravo.com/erp/devel/pi/rev/f2a6e4598a05b0877b79700b659bdf2bbc2aeb27#l3.16 [^] |
|
(0051068) caristu (viewer) 2012-08-01 14:48 |
This issue was fixed in SCM revision: https://code.openbravo.com/erp/devel/pi/rev/a3f4acecdb1b [^] |
|
(0051070) dmiguelez (viewer) 2012-08-01 15:11 |
Code Reviewed + Testing OK |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-08-01 02:16 | plujan | New Issue | |
| 2012-08-01 02:16 | plujan | Assigned To | => mirurita |
| 2012-08-01 02:16 | plujan | File Added: Openbravo Sales Invoice I 47 01 08 2....png | |
| 2012-08-01 02:16 | plujan | Modules | => Core |
| 2012-08-01 02:16 | plujan | OBNetwork customer | => No |
| 2012-08-01 02:16 | plujan | Regression level | => Automated tests |
| 2012-08-01 02:29 | plujan | Description Updated | View Revisions |
| 2012-08-01 14:02 | dmiguelez | Assigned To | mirurita => marvintm |
| 2012-08-01 14:03 | dmiguelez | Note Added: 0051061 | |
| 2012-08-01 14:04 | dmiguelez | Note Added: 0051062 | |
| 2012-08-01 14:09 | dmiguelez | Assigned To | marvintm => caristu |
| 2012-08-01 14:19 | plujan | Regression date | => 2012-07-30 |
| 2012-08-01 14:19 | plujan | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/f2a6e4598a05b0877b79700b659bdf2bbc2aeb27#l3.16 [^] |
| 2012-08-01 14:19 | plujan | Note Added: 0051064 | |
| 2012-08-01 14:46 | caristu | Status | new => scheduled |
| 2012-08-01 14:46 | caristu | fix_in_branch | => pi |
| 2012-08-01 14:47 | caristu | Status | scheduled => resolved |
| 2012-08-01 14:47 | caristu | Fixed in SCM revision | => a3f4acecdb1b |
| 2012-08-01 14:47 | caristu | Resolution | open => fixed |
| 2012-08-01 14:48 | caristu | Note Added: 0051068 | |
| 2012-08-01 15:11 | dmiguelez | Note Added: 0051070 | |
| 2012-08-01 15:11 | dmiguelez | Status | resolved => closed |
| 2012-08-01 15:11 | dmiguelez | Fixed in Version | => pi |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |