Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021911Openbravo ERP04. Warehouse managementpublic2012-10-11 12:442012-11-26 15:52
Reportermaite 
Assigned ToioritzCia 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP18Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021911: Wrong error when processing inventory
DescriptionWhen trying to process an inventory, user receives following error "could not execute update query". Looking at log you realize that real error is "@20111@" (launched by m_transaction trigger when trying to insert line).
Steps To Reproduce1. Create Physical Inventory header
2. Add physical inventory line for "Cerveza Ale" product. Don't process inventory.
3. Access "Cerveza Ale" product and change UOM value from Unit to Liter
4. Come back to Physical Inventory and try to process inventory count
Proposed SolutionProper error should be raised specifying which product is suffering unit mismatch problem
Additional Information
TagsNo tags attached.
Relationships
related to defect 00391493.0PR18Q4 closed Triage Finance Error message thrown by Oracle trigger after Hibernate upgrade [Oracle only] 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-11 12:44maiteNew Issue
2012-10-11 12:44maiteAssigned To => dmiguelez
2012-10-11 12:44maiteModules => Core
2012-10-11 13:13maiteTarget Version => 3.0MP17
2012-10-11 13:13maiteIssue Monitored: networkb
2012-10-11 13:36dmiguelezAssigned Todmiguelez => jonalegriaesarte
2012-10-20 08:44jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2012-10-30 16:02jonalegriaesarteTarget Version3.0MP17 => 3.0MP18
2012-11-22 10:21jonalegriaesarteNote Added: 0054449
2012-11-22 10:21jonalegriaesarteSeveritymajor => minor
2012-11-23 14:24hgbotCheckin
2012-11-23 14:24hgbotNote Added: 0054484
2012-11-23 14:24hgbotStatusnew => resolved
2012-11-23 14:24hgbotResolutionopen => fixed
2012-11-23 14:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3c7ebbf742db1dd81ca8ae534514441dc9a0ab7f [^]
2012-11-23 23:13hudsonbotCheckin
2012-11-23 23:13hudsonbotNote Added: 0054490
2012-11-26 15:52maiteNote Added: 0054495
2012-11-26 15:52maiteStatusresolved => closed
2018-08-20 13:20caristuRelationship addedrelated to 0039149

Notes
(0054449)
jonalegriaesarte   
2012-11-22 10:21   
A message error can not be major. Changed to minor.
(0054484)
hgbot   
2012-11-23 14:24   
Repository: erp/devel/pi
Changeset: 3c7ebbf742db1dd81ca8ae534514441dc9a0ab7f
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Fri Nov 23 09:22:24 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3c7ebbf742db1dd81ca8ae534514441dc9a0ab7f [^]

Fixes issue 21911: Wrong error when processing inventory.

---
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/materialmgmt/InventoryCountProcess.java
---
(0054490)
hudsonbot   
2012-11-23 23:13   
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/5ae348efc931 [^]

Maturity status: Test
(0054495)
maite   
2012-11-26 15:52   
verified