Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010722 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 02. Master data management | minor | always | 2009-09-23 18:11 | 2009-10-01 10:56 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.35MP15 | |||
| Status | closed | Fix in branch | 2.3x | Fixed in SCM revision | 34b558e62dc2 | |||
| Projection | none | ETA | none | Target Version | 2.35MP15 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.35MP13 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010722: Error "ORA-00918: column ambiguously defined" when you access to tab "price" | |||||||
| Description | when you access to tab "price" in product window in relation mode, a error appears in log file: ERROR org.openbravo.erpCommon.utility.ExecuteQuery - SQL error in query: SELECT M_ProductPrice.M_PriceList_Version_ID AS ID .... Exception:java.sql.SQLException: ORA-00918: column ambiguously defined | |||||||
| Steps To Reproduce | relation mode in . Master Data Management || Product || Product >> Price a error appears in log file | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0020326) rafaroda (viewer) 2009-09-24 06:55 |
Stefan, Can you please comment on this issue? It seems very similar to 0008191 which was fixed in pi and 2.40 but not in 2.3x. Thanks. |
|
(0020328) shuehner (administrator) 2009-09-24 11:00 |
Confirmed to happen in 2.35MP14 on oracle. Exception visible in log because of bad generated sql however no user visible error message is shown. Checking cause now.. |
|
(0020330) shuehner (administrator) 2009-09-24 11:17 |
The fix committed in issue 7285 for pi and 2.40 fixes the SQL error reported here. |
|
(0020332) hgbot (developer) 2009-09-24 11:19 |
Repository: erp/stable/2.3x Changeset: 34b558e62dc2e0e492ecf4b6ac51d75bea8fdb38 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Thu Sep 24 11:19:31 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.3x/rev/34b558e62dc2e0e492ecf4b6ac51d75bea8fdb38 [^] Fixed 10722: Fix ambigous column error on oracle By applying patch committed into issue 7285. --- M src/org/openbravo/erpCommon/utility/TableSQLData.java --- |
|
(0020621) arunkumar (viewer) 2009-10-01 10:56 |
This issue has been fixed. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-23 18:11 | networkb | New Issue | |
| 2009-09-23 18:11 | networkb | Assigned To | => rafaroda |
| 2009-09-23 18:11 | networkb | OBNetwork customer | => Yes |
| 2009-09-24 06:55 | rafaroda | Note Added: 0020326 | |
| 2009-09-24 06:55 | rafaroda | Assigned To | rafaroda => shuehner |
| 2009-09-24 06:55 | rafaroda | Proposed Solution updated | |
| 2009-09-24 10:08 | networkb | Target Version | 2.35MP14 => 2.35MP15 |
| 2009-09-24 11:00 | shuehner | Note Added: 0020328 | |
| 2009-09-24 11:16 | shuehner | Relationship added | related to 0007285 |
| 2009-09-24 11:17 | shuehner | Note Added: 0020330 | |
| 2009-09-24 11:19 | hgbot | Checkin | |
| 2009-09-24 11:19 | hgbot | Note Added: 0020332 | |
| 2009-09-24 11:19 | hgbot | Status | new => resolved |
| 2009-09-24 11:19 | hgbot | Resolution | open => fixed |
| 2009-09-24 11:19 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.3x/rev/34b558e62dc2e0e492ecf4b6ac51d75bea8fdb38 [^] |
| 2009-09-24 11:31 | rafaroda | Issue cloned | 0010734 |
| 2009-09-24 11:31 | rafaroda | Relationship added | depends on 0010734 |
| 2009-09-24 11:31 | rafaroda | Type | defect => backport |
| 2009-09-24 11:31 | rafaroda | fix_in_branch | => 2.3x |
| 2009-09-24 11:32 | rafaroda | Relationship replaced | blocks 0010734 |
| 2009-10-01 10:56 | arunkumar | Status | resolved => closed |
| 2009-10-01 10:56 | arunkumar | Note Added: 0020621 | |
| 2009-10-01 10:56 | arunkumar | Fixed in Version | => 2.35MP15 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |