Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0050039Retail ModulesRetail APIpublic2022-08-23 16:042022-11-08 15:39
Reporterazzeddine_meftoh 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0050039: Check Constraint(m_storage_detail_check1) violation when we try to integrate physical inventory by API for some products
Descriptionin mantis 49991 a correction has been done but there are still cases where we get this error

Inventory is not imported.
Following error appears in console:
ERROR: new row for relation "m_storage_detail" violates check constraint "m_storage_detail_check1"
Steps To Reproducecan be reproduced on our customer environment
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0049991 closed prakashmurugesan88 Retail Modules Check Constraint(m_storage_detail_check1) violation when we try to integrate physical inventory by API for some products 
related to defect 0050776 closed Triage Omni WMS Openbravo ERP Error in InventoryCountProcess - constraint "m_storage_detail_check1" violation 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-08-23 16:04azzeddine_meftohNew Issue
2022-08-23 16:04azzeddine_meftohAssigned To => Triage Platform Conn
2022-08-23 16:04azzeddine_meftohTriggers an Emergency Pack => No
2022-08-24 08:22vmromanosRelationship addedrelated to 0049991
2022-08-24 08:23vmromanosAssigned ToTriage Platform Conn => prakashmurugesan88
2022-08-24 08:23vmromanosNote Added: 0140332
2022-08-24 17:07rafarodaOBNetwork customer => Gold
2022-08-24 17:07rafarodaSeveritymajor => critical
2022-09-01 13:31marvintmSeveritycritical => major
2022-09-09 10:17vmromanosAssigned Toprakashmurugesan88 => AtulOpenbravo
2022-09-13 05:44AtulOpenbravoStatusnew => scheduled
2022-09-19 11:44vmromanosNote Added: 0141220
2022-09-19 11:44vmromanosStatusscheduled => closed
2022-09-19 11:44vmromanosResolutionopen => unable to reproduce
2022-11-08 15:39rafarodaRelationship addedrelated to 0050776

Notes
(0140332)
vmromanos   
2022-08-24 08:23   
A DB dump and the concrete scenario where is failing is needed. Please provide it to the developer by email
(0141220)
vmromanos   
2022-09-19 11:44   
It was a configuration problem in the customer's environment