Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0032707Openbravo ERPK. Packagingpublic2016-04-19 12:142016-06-17 19:37
yogaskarnik 
NaroaIriarte 
normalminoralways
closedfixed 
5
 
3.0PR16Q3 
alostale
Core
Production - Confirmed Stable
2015-08-19
3.0PR15Q4
http://code.openbravo.com/erp/devel/pi/rev/243b29f38be260b5dec6743eebe89e5adbbafb24 [^]
No
0032707: java.sql.SQLSyntaxErrorException: ORA-00918 while packaging module
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.
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.
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
No tags attached.
depends on backport 00327353.0PR16Q2 closed NaroaIriarte java.sql.SQLSyntaxErrorException: ORA-00918 while packaging module 
depends on backport 00327363.0PR16Q1.2 closed NaroaIriarte java.sql.SQLSyntaxErrorException: ORA-00918 while packaging module 
depends on backport 00327373.0PR15Q4.6 closed NaroaIriarte java.sql.SQLSyntaxErrorException: ORA-00918 while packaging module 
caused by feature request 00301793.0PR15Q4 closed AugustoMauch DBSourceManager support indexes with functions 
Issue History
2016-04-19 12:14yogaskarnikNew Issue
2016-04-19 12:14yogaskarnikAssigned To => shuehner
2016-04-19 12:14yogaskarnikModules => Core
2016-04-19 12:14yogaskarnikTriggers an Emergency Pack => No
2016-04-19 13:36shuehnerAssigned Toshuehner => platform
2016-04-19 16:24NaroaIriarteAssigned Toplatform => NaroaIriarte
2016-04-19 16:24NaroaIriarteStatusnew => acknowledged
2016-04-19 16:24NaroaIriarteStatusacknowledged => scheduled
2016-04-20 15:38NaroaIriarteRelationship addedcaused by 0030179
2016-04-20 15:43NaroaIriarteRegression level => Production - Confirmed Stable
2016-04-20 15:43NaroaIriarteRegression date => 2015-08-19
2016-04-20 15:43NaroaIriarteRegression introduced in release => 3.0PR15Q4
2016-04-20 15:43NaroaIriarteRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/243b29f38be260b5dec6743eebe89e5adbbafb24 [^]
2016-04-20 15:56NaroaIriarteStatusscheduled => feedback
2016-04-20 15:57NaroaIriarteStatusfeedback => new
2016-04-20 16:00NaroaIriarteSeveritymajor => minor
2016-04-20 16:00NaroaIriarteProposed Solution updated
2016-04-20 16:01NaroaIriarteStatusnew => scheduled
2016-04-22 14:57NaroaIriarteDescription Updatedbug_revision_view_page.php?rev_id=11836#r11836
2016-04-22 14:57NaroaIriarteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11838#r11838
2016-04-22 15:04hgbotCheckin
2016-04-22 15:04hgbotNote Added: 0085900
2016-04-22 15:04hgbotStatusscheduled => resolved
2016-04-22 15:04hgbotResolutionopen => fixed
2016-04-22 15:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/dbsm-main/rev/87275e76980ecc9f5877b74426faa9f5a96eddc3 [^]
2016-04-22 15:04hgbotCheckin
2016-04-22 15:04hgbotNote Added: 0085901
2016-04-22 15:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/dbsm-main/rev/87275e76980ecc9f5877b74426faa9f5a96eddc3 [^] => http://code.openbravo.com/erp/devel/pi/rev/31f0af79e203487fc562dd4993e6aa9598a578bb [^]
2016-04-29 14:12alostaleReview Assigned To => alostale
2016-04-29 14:12alostaleNote Added: 0086083
2016-04-29 14:12alostaleStatusresolved => closed
2016-04-29 14:12alostaleFixed in Version => 3.0PR16Q3
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087486

Notes
(0085900)
hgbot   
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   
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   
2016-04-29 14:12   
code reviewed + tested
(0087486)
hudsonbot   
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