Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019499Openbravo ERP02. Master data managementpublic2012-01-16 11:482012-01-28 04:10
Reporterxabiermerino 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP7.1 
Target Version3.0MP8Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket13880
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019499: Error when you create a BP with the functionality 'Create Account for Business Partner' checked
DescriptionWith the functionality 'Create Account for Business Partner' checked you have the following error when you try to create a BP:

Saving failed. ERROR: duplicate key value violates unique constraint "c_elementvalue_value" Where: SQL statement "INSERT INTO C_ElementValue...

This is why fields Account Length and Sub Account Length have incorrect values. The message should inform about the configuration's problem.
Steps To Reproduce-As admin go to organization International F&B International Group >> Org Schema
-check 'Create Account for Business Partner'
-Select a sequence
-Account Length: 0
-Subaccount Length: 10
- Create a new partner with this organization
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00195002.50MP39 closed jecharri Error when you create a BP with the functionality 'Create Account for Business Partner' checked 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-01-16 11:48xabiermerinoNew Issue
2012-01-16 11:48xabiermerinoAssigned To => jonalegriaesarte
2012-01-16 11:48xabiermerinoModules => Core
2012-01-16 11:48xabiermerinoOBNetwork customer => Yes
2012-01-16 11:48xabiermerinoSupport ticket => 13880
2012-01-16 11:48xabiermerinoResolution time => 1329692400
2012-01-16 11:57xabiermerinoIssue Monitored: networkb
2012-01-16 11:59xabiermerinoStatusnew => scheduled
2012-01-16 11:59xabiermerinofix_in_branch => pi
2012-01-16 12:01xabiermerinofix_in_branchpi =>
2012-01-16 12:01xabiermerinoDescription Updatedbug_revision_view_page.php?rev_id=3063#r3063
2012-01-16 12:01xabiermerinoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3065#r3065
2012-01-23 10:27jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-01-25 16:51hgbotCheckin
2012-01-25 16:51hgbotNote Added: 0044573
2012-01-25 17:13jecharriStatusscheduled => resolved
2012-01-25 17:13jecharriFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/f18a19d0e4f2 [^]
2012-01-25 17:13jecharriResolutionopen => fixed
2012-01-26 09:24hgbotCheckin
2012-01-26 09:24hgbotNote Added: 0044594
2012-01-27 12:05xabiermerinoNote Added: 0044634
2012-01-27 12:05xabiermerinoStatusresolved => closed
2012-01-28 04:10hudsonbotCheckin
2012-01-28 04:10hudsonbotNote Added: 0044660
2012-01-28 04:10hudsonbotCheckin
2012-01-28 04:10hudsonbotNote Added: 0044664

Notes
(0044573)
hgbot   
2012-01-25 16:51   
Repository: erp/devel/pi
Changeset: f18a19d0e4f29b06f7875b2deb7a7fcaa8808d88
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Jan 25 16:49:21 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f18a19d0e4f29b06f7875b2deb7a7fcaa8808d88 [^]

Fisex issue 19499: Error when you create a BP
with the functionality 'Create Account for Business Partner' checked.
Now the application check if the account exists and put a clear message

---
M src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0044594)
hgbot   
2012-01-26 09:24   
Repository: erp/devel/pi
Changeset: c124571d1623074e66c560f4c9382d079a918d00
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Jan 26 09:23:06 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c124571d1623074e66c560f4c9382d079a918d00 [^]

issue 19499 and fixes int-dbcons-pqsql.

The problem was that there were 2 white spaces between ';' and --

---
M src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml
---
(0044634)
xabiermerino   
2012-01-27 12:05   
verified
(0044660)
hudsonbot   
2012-01-28 04:10   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8e16ef45b30c [^]

Maturity status: Test
(0044664)
hudsonbot   
2012-01-28 04:10   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8e16ef45b30c [^]

Maturity status: Test