Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0014085
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformmajoralways2010-07-29 12:042022-02-01 08:08
ReporterdalsasuaView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6.0_14
OS VersionUbuntu 9.04Database version11.1.0.6.0 SEAnt version1.7.1
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014085: Inconsistent unique restriction in AD_PACKAGE table

DescriptionThere exists a unique restriction in src-db/database/model/tables/AD_PACKAGE.xml:
      <unique name="AD_PACKAGE_NAME">
        <unique-column name="NAME"/>
      </unique>
This makes that two modules that have two AD_PACKAGE rows with same name (but different java package name) makes the compilation to fail.
Steps To ReproduceInstall two modules
Change src-db/database/model/tables/AD_PACKAGE.xml of one of them, so both have same name (and different java package name)
Run ant smartbuild -Dlocal=no -Dapply.on.create=true -Dforce=true
You will obtain error:

     [java] 272959 ERROR - Error while inserting into the database: ERROR: llave duplicada viola restricción de unicidad «ad_package_name»
     [java] org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ad_package_name»
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1576)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.upsert(PlatformImplBase.java:1489)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:756)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:168)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
...
Proposed SolutionRemove the restriction, if possible
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0052487)
AugustoMauch (manager)
2012-09-24 23:32

Impact: low
Plan: mid

- Issue History
Date Modified Username Field Change
2010-07-29 12:04 dalsasua New Issue
2010-07-29 12:04 dalsasua Assigned To => alostale
2010-08-02 08:12 alostale Status new => scheduled
2010-08-02 08:12 alostale fix_in_branch => pi
2012-04-02 15:29 alostale Type defect => design defect
2012-04-02 15:29 alostale fix_in_branch pi =>
2012-09-24 23:32 AugustoMauch Note Added: 0052487
2012-09-24 23:32 AugustoMauch Priority urgent => normal
2017-03-31 14:36 alostale Status scheduled => acknowledged
2017-04-10 14:34 alostale Assigned To alostale => platform
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker