Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0010246 | Openbravo ERP | 09. Financial management | public | 2009-08-12 10:32 | 2009-08-19 00:00 |
|
| Reporter | mgerke | |
| Assigned To | vinothbabu | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | rPath Linux |
| Product Version | 2.50MP2 | |
| Target Version | | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0010246: missing unique constraint on c_elemenvalue.value |
| Description | In 2.50 MP1 there was a unique constraint on c_elemenvalue.value
In MP2 it was proposed to delete the unique constraint and add an unique index, see
http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.accounting.coa/C_ElementValue#Indexes [^]
and
http://www.mail-archive.com/openbravo-commits@lists.sourceforge.net/msg03514.html [^]
The unique constraint was deleted, but the unique index was not inserted
Now it is possible to insert 2 or more accounts with the same value (=searchkey). This behavior violates the accounting rules e.g. in Germany. |
| Steps To Reproduce | see DB with pgAdmin or C_ELEMENTVALUE.xml
|
| Proposed Solution | Add the unique index |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0010313 | | closed | vinothbabu | API check build 112 fails - part2 |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-08-12 10:32 | mgerke | New Issue | |
| 2009-08-12 10:32 | mgerke | Assigned To | => rafaroda |
| 2009-08-13 13:28 | rafaroda | Note Added: 0018934 | |
| 2009-08-13 13:28 | rafaroda | Assigned To | rafaroda => vinothbabu |
| 2009-08-13 13:28 | rafaroda | Priority | normal => urgent |
| 2009-08-13 13:28 | rafaroda | Severity | critical => major |
| 2009-08-13 13:28 | rafaroda | Status | new => scheduled |
| 2009-08-13 18:54 | hgbot | Checkin | |
| 2009-08-13 18:54 | hgbot | Note Added: 0018938 | |
| 2009-08-13 18:54 | hgbot | Status | scheduled => resolved |
| 2009-08-13 18:54 | hgbot | Resolution | open => fixed |
| 2009-08-13 18:54 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0711d379842ee1f28f4a05a1c34632bf6f7861f5 [^] |
| 2009-08-18 09:09 | sureshbabu | Status | resolved => closed |
| 2009-08-18 09:09 | sureshbabu | Note Added: 0018988 | |
| 2009-08-18 09:09 | sureshbabu | Fixed in Version | => pi |
| 2009-08-18 15:06 | rafaroda | Relationship added | related to 0010313 |
| 2009-08-19 00:00 | anonymous | sf_bug_id | 0 => 2839904 |