Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0032707 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] K. Packaging | minor | always | 2016-04-19 12:14 | 2016-06-17 19:37 | |||
| Reporter | yogaskarnik | View Status | public | |||||
| Assigned To | NaroaIriarte | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR16Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 31f0af79e203 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | alostale | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 41527 | |||||||
| Regression level | Production - Confirmed Stable | |||||||
| Regression date | 2015-08-19 | |||||||
| Regression introduced in release | 3.0PR15Q4 | |||||||
| Regression introduced by commit | http://code.openbravo.com/erp/devel/pi/rev/243b29f38be260b5dec6743eebe89e5adbbafb24 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0032707: java.sql.SQLSyntaxErrorException: ORA-00918 while packaging module | |||||||
| Description | Using an Oracle database, when a module with at least one table is being packaged the following error is shown: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined. | |||||||
| Steps To Reproduce | 1- Create a module with at least one table. 2- Try to package it executing the following command: ant package.module -Dmodule=<module name> 3- Realize that the "ORA-00918: column ambiguously defined." error message is shown. | |||||||
| Proposed Solution | In Oracle it is not possible to do the validation, but the module can be exported. This is the workaround: ant package.module -Dmodule=<module name> -Dobx.export.validate=false | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0085900) hgbot (developer) 2016-04-22 15:04 |
Repository: erp/devel/dbsm-main Changeset: 87275e76980ecc9f5877b74426faa9f5a96eddc3 Author: Naroa Iriarte <naroa.iriarte <at> openbravo.com> Date: Wed Apr 20 15:02:08 2016 +0200 URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/87275e76980ecc9f5877b74426faa9f5a96eddc3 [^] Fixed issue 32707: ORA-00918 error was get while packaging module When a module was being packed in oracle, that error was shown. This means that a column in ambiguously created. The problem was in a query. It was trying to execute a query where there were two tables with a column with the same name. TABLE_NAME was being exectued insetad of U.TABLE_NAME (with the alias of the table), and as that column exists in the two tables, that error was raised. --- M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java --- |
|
(0085901) hgbot (developer) 2016-04-22 15:04 |
Repository: erp/devel/pi Changeset: 31f0af79e203487fc562dd4993e6aa9598a578bb Author: Naroa Iriarte <naroa.iriarte <at> openbravo.com> Date: Wed Apr 20 15:20:32 2016 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/31f0af79e203487fc562dd4993e6aa9598a578bb [^] Fixed issue 32707: ORA-00918 error was got while packaging module When a module was being packed in oracle, that error was shown. This means that a column in ambiguously created. The problem was in a query. It was trying to execute a query where there were two tables with a column with the same name. TABLE_NAME was being exectued insetad of U.TABLE_NAME (with the alias of the table), and as that column exists in the two tables, that error was raised. --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0086083) alostale (viewer) 2016-04-29 14:12 |
code reviewed + tested |
|
(0087486) hudsonbot (viewer) 2016-06-17 19:37 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-04-19 12:14 | yogaskarnik | New Issue | |
| 2016-04-19 12:14 | yogaskarnik | Assigned To | => shuehner |
| 2016-04-19 12:14 | yogaskarnik | OBNetwork customer | => Yes |
| 2016-04-19 12:14 | yogaskarnik | Modules | => Core |
| 2016-04-19 12:14 | yogaskarnik | Support ticket | => 41527 |
| 2016-04-19 12:14 | yogaskarnik | Triggers an Emergency Pack | => No |
| 2016-04-19 12:17 | yogaskarnik | Resolution time | => 1464213600 |
| 2016-04-19 13:36 | shuehner | Assigned To | shuehner => platform |
| 2016-04-19 16:24 | NaroaIriarte | Assigned To | platform => NaroaIriarte |
| 2016-04-19 16:24 | NaroaIriarte | Status | new => acknowledged |
| 2016-04-19 16:24 | NaroaIriarte | Status | acknowledged => scheduled |
| 2016-04-20 15:38 | NaroaIriarte | Relationship added | caused by 0030179 |
| 2016-04-20 15:43 | NaroaIriarte | Regression level | => Production - Confirmed Stable |
| 2016-04-20 15:43 | NaroaIriarte | Regression date | => 2015-08-19 |
| 2016-04-20 15:43 | NaroaIriarte | Regression introduced in release | => 3.0PR15Q4 |
| 2016-04-20 15:43 | NaroaIriarte | Regression introduced by commit | => http://code.openbravo.com/erp/devel/pi/rev/243b29f38be260b5dec6743eebe89e5adbbafb24 [^] |
| 2016-04-20 15:56 | NaroaIriarte | Status | scheduled => feedback |
| 2016-04-20 15:57 | NaroaIriarte | Status | feedback => new |
| 2016-04-20 16:00 | NaroaIriarte | Severity | major => minor |
| 2016-04-20 16:00 | NaroaIriarte | Proposed Solution updated | |
| 2016-04-20 16:01 | NaroaIriarte | Status | new => scheduled |
| 2016-04-22 14:57 | NaroaIriarte | Description Updated | View Revisions |
| 2016-04-22 14:57 | NaroaIriarte | Steps to Reproduce Updated | View Revisions |
| 2016-04-22 15:04 | hgbot | Checkin | |
| 2016-04-22 15:04 | hgbot | Note Added: 0085900 | |
| 2016-04-22 15:04 | hgbot | Status | scheduled => resolved |
| 2016-04-22 15:04 | hgbot | Resolution | open => fixed |
| 2016-04-22 15:04 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/dbsm-main/rev/87275e76980ecc9f5877b74426faa9f5a96eddc3 [^] |
| 2016-04-22 15:04 | hgbot | Checkin | |
| 2016-04-22 15:04 | hgbot | Note Added: 0085901 | |
| 2016-04-22 15:04 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/dbsm-main/rev/87275e76980ecc9f5877b74426faa9f5a96eddc3 [^] => http://code.openbravo.com/erp/devel/pi/rev/31f0af79e203487fc562dd4993e6aa9598a578bb [^] |
| 2016-04-29 14:12 | alostale | Review Assigned To | => alostale |
| 2016-04-29 14:12 | alostale | Note Added: 0086083 | |
| 2016-04-29 14:12 | alostale | Status | resolved => closed |
| 2016-04-29 14:12 | alostale | Fixed in Version | => 3.0PR16Q3 |
| 2016-06-17 19:37 | hudsonbot | Checkin | |
| 2016-06-17 19:37 | hudsonbot | Note Added: 0087486 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |