Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
ID | |||||||||||
0017287 | |||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
design defect | [Openbravo ERP] A. Platform | minor | N/A | 2011-05-19 19:06 | 2022-02-01 08:08 | ||||||
Reporter | rafademiguel | View Status | public | ||||||||
Assigned To | Triage Platform Base | ||||||||||
Priority | normal | Resolution | open | Fixed in Version | |||||||
Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
Projection | none | ETA | none | Target Version | |||||||
OS | Any | Database | Any | Java version | |||||||
OS Version | Database version | Ant version | |||||||||
Product Version | 3.0RC6.1 | SCM revision | |||||||||
Merge Request Status | |||||||||||
Review Assigned To | |||||||||||
OBNetwork customer | No | ||||||||||
Web browser | |||||||||||
Modules | Core | ||||||||||
Support ticket | |||||||||||
Regression level | |||||||||||
Regression date | |||||||||||
Regression introduced in release | |||||||||||
Regression introduced by commit | |||||||||||
Triggers an Emergency Pack | No | ||||||||||
Summary | 0017287: There is a Unique Index for "Name" in table "AD_Package" called AD_PACKAGE_NAME but Name don't have to start with the prefix | ||||||||||
Description | There is a Unique Index for column "Name" in table "AD_Package" called AD_PACKAGE_NAME but Name don't have to start with the prefix so if two people use the same name (although have differences package name) the update database crash. [java] 63654 ERROR - Error while inserting into the database: ERROR: llave duplicada viola restricción de unicidad «ad_package_name» [java] Detail: Ya existe la llave (name)=(Data). [java] org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ad_package_name» [java] Detail: Ya existe la llave (name)=(Data). I propose or eliminate the unique index or force the column name to start with OBPREFIX. (It had occurred with name "data" in a real situation) | ||||||||||
Tags | No tags attached. | ||||||||||
Attached Files | |||||||||||
![]() |
|
![]() |
|
(0052444) AugustoMauch (administrator) 2012-09-24 21:18 |
Effort: 1 Impact: mid Plan: mid |
![]() |
|||
Date Modified | Username | Field | Change |
2011-05-19 19:06 | rafademiguel | New Issue | |
2011-05-19 19:06 | rafademiguel | Assigned To | => alostale |
2011-05-19 19:06 | rafademiguel | Modules | => Core |
2011-05-19 19:06 | rafademiguel | OBNetwork customer | => No |
2011-05-23 08:14 | alostale | Status | new => scheduled |
2011-11-23 10:37 | alostale | Type | defect => design defect |
2012-09-24 21:18 | AugustoMauch | Note Added: 0052444 | |
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 |