Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025593Openbravo ERPA. Platformpublic2014-01-29 12:312014-02-13 12:04
Reportershankarb 
Assigned Toshankarb 
PriorityhighSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025593: API Change Request : Changing constraint to unique index
DescriptionRelated to Issue https://issues.openbravo.com/view.php?id=25557, [^] the constraint has to be removed and an index has to be created so that the same works in Oracle. Since the logic is the same, there is no risk involved.
Steps To ReproduceSame as steps to reproduce for issue https://issues.openbravo.com/view.php?id=25557 [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-01-29 12:31shankarbNew Issue
2014-01-29 12:31shankarbAssigned To => dmitry_mezentsev
2014-01-29 12:31shankarbModules => Core
2014-01-29 12:31shankarbOBNetwork customer => No
2014-01-29 12:31shankarbTriggers an Emergency Pack => No
2014-01-30 10:58dmitry_mezentsevAssigned Todmitry_mezentsev => shankarb
2014-01-30 11:03dmitry_mezentsevNote Added: 0063800
2014-01-30 11:52shankarbReview Assigned To => AugustoMauch
2014-01-30 11:52shankarbIssue Monitored: AugustoMauch
2014-01-30 11:53hgbotCheckin
2014-01-30 11:53hgbotNote Added: 0063804
2014-01-30 11:53hgbotStatusnew => resolved
2014-01-30 11:53hgbotResolutionopen => fixed
2014-01-30 11:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/c008fb1242ed14f14d3a68cf3a24f71635395ea3 [^]
2014-02-13 12:04AugustoMauchStatusresolved => closed
2014-02-13 12:04AugustoMauchFixed in Version => 3.0MP32

Notes
(0063800)
dmitry_mezentsev   
2014-01-30 11:03   
Approved.
(0063804)
hgbot   
2014-01-30 11:53   
Repository: erp/devel/api-checks
Changeset: c008fb1242ed14f14d3a68cf3a24f71635395ea3
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu Jan 30 12:46:53 2014 +0530
URL: http://code.openbravo.com/erp/devel/api-checks/rev/c008fb1242ed14f14d3a68cf3a24f71635395ea3 [^]

Fixes Issue 0025593: Changing constraint to unique index

Is not possible to enter more than one datasource table in ORACLE.
There is a unique constraint called AD_TABLE_CLASSNAME_PACKAGE_UN in AD_TABLE that has the fields: CLASSNAME and AD_PACKAGE_ID.
Changed the constraint to unique index to solve this issue.

---
M model/src-db/database/model/tables/AD_TABLE.xml
---