Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorrandom2018-11-13 08:592018-12-11 20:22
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q1
StatusclosedFix in branchFixed in SCM revision6323b569fcbb
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0039614: random unique constraint violation message

DescriptionWhen a database unique constraint is violated, Openbravo produces a user readable message indicating for the table where the constraint is which are the columns that must be unique.

This message can sometimes not be accurate because the names columns are randomly picked from any element (AD_Element) with that same column name.
Steps To Reproduce1. Execute org.openbravo.test.system.ErrorTextParserIntegrationTest.testUniqueSingleField()
  -> Randomly it can fail with:
org.junit.ComparisonFailure: expected:<...lient with the same [Name.] Name must be unique...> but was:<...lient with the same [Commercial Name. Commercial] Name must be unique...>
    at org.junit.Assert.assertEquals(
    at org.junit.Assert.assertEquals(
    at org.openbravo.test.system.ErrorTextParserIntegrationTest.doErrorTextParserTest(
    at org.openbravo.test.system.ErrorTextParserIntegrationTest.testUniqueSingleField(
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.lang.reflect.Method.invoke(
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(
    at org.junit.internal.runners.statements.RunBefores.evaluate(
    at org.junit.internal.runners.statements.RunAfters.evaluate(
    at org.junit.rules.TestWatcher$1.evaluate(
    at org.junit.rules.RunRules.evaluate(
    at org.junit.runners.ParentRunner.runLeaf(
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(
    at org.junit.runners.ParentRunner$
    at org.junit.runners.ParentRunner$1.schedule(
    at org.junit.runners.ParentRunner.runChildren(
    at org.junit.runners.ParentRunner.access$000(
    at org.junit.runners.ParentRunner$2.evaluate(
    at org.junit.internal.runners.statements.RunBefores.evaluate(
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
hgbot (developer)
2018-11-13 09:54

Repository: erp/devel/pi
Changeset: 6323b569fcbb097b412b21ca26e8b8530434c1f0
Author: Asier Lostalé <asier.lostale <at>>
Date: Tue Nov 13 09:24:05 2018 +0100
URL: [^]

fixed bug 39614: random unique constraint violation message

  Get name to generate error message from actual element associated to the column
  in the table we are looking for instead of getting it from any element with that
  same name assuming it is unique.

M src/org/openbravo/erpCommon/utility/
M src/org/openbravo/erpCommon/utility/
M src/org/openbravo/erpCommon/utility/ErrorTextParser_data.xsql
caristu (developer)
2018-11-27 12:17

hudsonbot (developer)
2018-12-11 20:22

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2018-11-13 08:59 alostale New Issue
2018-11-13 08:59 alostale Assigned To => platform
2018-11-13 08:59 alostale Modules => Core
2018-11-13 08:59 alostale Triggers an Emergency Pack => No
2018-11-13 09:44 alostale Assigned To platform => alostale
2018-11-13 09:44 alostale Status new => acknowledged
2018-11-13 09:44 alostale Review Assigned To => caristu
2018-11-13 09:54 hgbot Checkin
2018-11-13 09:54 hgbot Note Added: 0107870
2018-11-13 09:54 hgbot Status acknowledged => resolved
2018-11-13 09:54 hgbot Resolution open => fixed
2018-11-13 09:54 hgbot Fixed in SCM revision => [^]
2018-11-27 12:17 caristu Note Added: 0108122
2018-11-27 12:17 caristu Status resolved => closed
2018-11-27 12:17 caristu Fixed in Version => 3.0PR19Q1
2018-12-11 20:22 hudsonbot Checkin
2018-12-11 20:22 hudsonbot Note Added: 0108462

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker