Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015446 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2010-12-15 18:08 | 2011-10-28 17:27 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | out of date | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0015446: DataGrid.getColumnTotals fails in Financial Account->Reconciliation tab | |||||||
| Description | Hovering with mouse over a numeric column in this tab fails on oracle giving sql-exception: Example: 204913 [http-8080-5] ERROR org.openbravo.erpCommon.utility.ExecuteQuery - SQL error in query: SELECT SUM(APRM_Reconciliation_v.Payment_No) AS TOTAL FROM APRM_Reconciliation_v left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID WHERE (APRM_Reconciliation_v.Aprm_Reconciliation_V_ID, APRM_Reconciliation_v.FIN_Reconciliation_ID) IN (SELECT Aprm_Reconciliation_V_ID, FIN_Reconciliation_ID FROM APRM_Reconciliation_v left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID WHERE APRM_Reconciliation_v.AD_Client_ID IN ('0','1000000') AND APRM_Reconciliation_v.AD_Org_ID IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000008','1000009','1000007') AND APRM_Reconciliation_v.FIN_Financial_Account_ID = ? AND APRM_Reconciliation_v.Aprm_Reconciliation_V_ID IN ('FF8081812CEAF7A5012CEAFA3B330053') ) Exception:java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined javax.servlet.ServletException: @CODE=918@ORA-00918: column ambiguously defined at org.openbravo.erpCommon.utility.ExecuteQuery.select(ExecuteQuery.java:314) at org.openbravo.erpCommon.utility.DataGrid.getColumnTotals(DataGrid.java:471) at org.openbravo.erpCommon.utility.DataGrid.doPost(DataGrid.java:99) | |||||||
| Steps To Reproduce | Go to: Financial Account Tab: Reconciliation Go to grid view Move over a numeric column like: REconciled Items | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0042272) dmitry_mezentsev (developer) 2011-10-28 17:27 |
What I can see is that at the moment it is not failing in the Reconciliations tab in OB3. It is true that this Tab was redesigned. So for the user issue does not exist but maybe still there is sth to do in the Platfrom. Then please report another issue. Thanks. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-12-15 18:08 | shuehner | New Issue | |
| 2010-12-15 18:08 | shuehner | Assigned To | => alostale |
| 2010-12-15 18:08 | shuehner | Modules | => Core |
| 2010-12-15 18:12 | shuehner | Relationship added | related to 0015217 |
| 2010-12-20 08:46 | alostale | Status | new => scheduled |
| 2011-10-28 17:27 | dmitry_mezentsev | Note Added: 0042272 | |
| 2011-10-28 17:27 | dmitry_mezentsev | Status | scheduled => closed |
| 2011-10-28 17:27 | dmitry_mezentsev | Resolution | open => out of date |
| 2011-10-28 17:27 | dmitry_mezentsev | Fixed in Version | => pi |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |