Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0017287Openbravo ERPA. Platformpublic2011-05-19 19:062022-02-01 08:08
rafademiguel 
Triage Platform Base 
normalminorN/A
acknowledgedopen 
5
3.0RC6.1 
 
No
Core
No
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
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)

No tags attached.
Issue History
2011-05-19 19:06rafademiguelNew Issue
2011-05-19 19:06rafademiguelAssigned To => alostale
2011-05-19 19:06rafademiguelModules => Core
2011-05-19 19:06rafademiguelOBNetwork customer => No
2011-05-23 08:14alostaleStatusnew => scheduled
2011-11-23 10:37alostaleTypedefect => design defect
2012-09-24 21:18AugustoMauchNote Added: 0052444
2017-03-31 14:36alostaleStatusscheduled => acknowledged
2017-04-10 14:34alostaleAssigned Toalostale => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0052444)
AugustoMauch   
2012-09-24 21:18   
Effort: 1
Impact: mid
Plan: mid