Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000525 | Openbravo ERP | 01. General setup | public | 2008-06-02 17:09 | 2008-07-01 17:56 |
| Reporter | psarobe | ||||
| Assigned To | gorkaion | ||||
| Priority | urgent | Severity | critical | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | 2.40alpha-r2 | ||||
| Target Version | 2.40 | Fixed in Version | 2.40alpha-r3 | ||
| 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 | 0000525: Due to Clean-up project Conversion rates window crash | ||||
| Description | Steps: 1. Go to General setup->Application->Conversion rate 2. Click new Please see the log: Error of SQL in query: SELECT td0.C_Currency_ID AS ID, (TO_CHAR(td0.ISO_Code)) AS NAME, '' AS DESCRIPTION FROM C_Currency td0 WHERE td0.AD_Client_ID IN (0,1000000) AND td0.AD_Org_ID IN (0,1000001,1000000) AND td0.IsEMUMember='N' AND (td0.isActive = 'Y' OR td0.C_Currency_ID = (?) ) ORDER BY td0.ISO_CodeException:java.sql.SQLException: ORA-00904: "TD0"."ISEMUMEMBER": identificador no válido | ||||
| Steps To Reproduce | |||||
| Proposed Solution | The column isEMUMember is not longer present in the table C_CURRENCY but the problem has to do with the column C_Currency in table C_CONVERSION_RATE. Taht column is defined as Table with reference search key "C_Conversion_Rate Currencies". This reference has associated a "SQL Where Clause=C_Currency.IsEMUMember='N'" in Table reference tab. Please remove this SQL Where Clause The same problem happens with column C_Currency_ID_To in the same table | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-06-02 17:09 | psarobe | New Issue | |||
| 2008-06-02 17:09 | psarobe | Assigned To | => gorkaion | ||
| 2008-06-02 17:09 | psarobe | OBNetwork customer | => N | ||
| 2008-06-02 17:10 | psarobe | Status | new => scheduled | ||
| 2008-06-03 13:15 | svnbot | Checkin | |||
| 2008-06-03 13:15 | svnbot | Note Added: 0000420 | |||
| 2008-06-03 13:15 | svnbot | Status | scheduled => resolved | ||
| 2008-06-03 13:15 | svnbot | Resolution | open => fixed | ||
| 2008-06-03 13:15 | svnbot | svn_revision | => 4751 | ||
| 2008-06-11 12:46 | cromero | Target Version | => 2.40 | ||
| 2008-06-11 14:33 | cromero | Fixed in Version | => 2.40alpha r3 | ||
| 2008-06-19 11:26 | plujan | Status | resolved => closed | ||
| 2008-07-01 17:56 | anonymous | sf_bug_id | 0 => 2007918 | ||
| Notes | |||||
|
|
|||||
|
|
||||