Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0019499Openbravo ERP02. Master data managementpublic2012-01-16 11:482012-01-28 04:10
xabiermerino 
jecharri 
urgentmajoralways
closedfixed 
5
3.0MP7.1 
3.0MP8 
Core
No
0019499: Error when you create a BP with the functionality 'Create Account for Business Partner' checked
With 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.
-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
No tags attached.
depends on backport 00195002.50MP39 closed jecharri Error when you create a BP with the functionality 'Create Account for Business Partner' checked 
Issue History
2012-01-16 11:48xabiermerinoNew Issue
2012-01-16 11:48xabiermerinoAssigned To => jonalegriaesarte
2012-01-16 11:48xabiermerinoModules => Core
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