Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032707Openbravo ERPK. Packagingpublic2016-04-19 12:142016-06-17 19:37
Reporteryogaskarnik 
Assigned ToNaroaIriarte 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2015-08-19
Regression introduced in release3.0PR15Q4
Regression introduced by commithttp://code.openbravo.com/erp/devel/pi/rev/243b29f38be260b5dec6743eebe89e5adbbafb24 [^]
Triggers an Emergency PackNo
Summary0032707: java.sql.SQLSyntaxErrorException: ORA-00918 while packaging module
DescriptionUsing 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 Reproduce1- 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 SolutionIn 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
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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 12:17yogaskarnikResolution time => 1464213600
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