Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029211Openbravo ERP04. Warehouse managementpublic2015-03-10 09:572015-03-18 00:03
Reporterngarcia 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2014-10-21
Regression introduced in release3.0PR15Q1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/c1d30f85a429d63b04ee6470072ec5b1742acc5e [^]
Triggers an Emergency PackNo
Summary0029211: Cannot complete a goods receipt with a line without attribute set value if it has a related prereservation
DescriptionCannot complete a goods receipt with a line without attribute set value if it has a related prereservation
Steps To ReproduceAs group admin role:
   Create a Product and set it as Stocked
   Add a purchase and sales price to it
   Create a Sales Order and include the already created product
   Create a Purchase Order and include the already created product too
   Generate a Preservation and process it
   Create a Goods Receipt from the Purchase Order by Create Lines From process
   Try to complete it and check you get the following error message:
      "null value in column "m_attributesetinstance_id" violates not-null constraint"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00293013.0PR15Q1.2 closed eduardo_Argal Cannot complete a goods receipt with a line without attribute set value if it has a related prereservation 
caused by defect 0027713 closed eduardo_Argal slow post of goods shipment if there are many storage detail for that product 
caused by defect 0027712 closed eduardo_Argal slow goods receipt batch insertion 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-10 09:57ngarciaNew Issue
2015-03-10 09:57ngarciaAssigned To => eduardo_Argal
2015-03-10 09:57ngarciaModules => Core
2015-03-10 09:57ngarciaResolution time => 1428616800
2015-03-10 09:57ngarciaRegression level => Production - QA Approved
2015-03-10 09:57ngarciaRegression date => 2014-10-21
2015-03-10 09:57ngarciaRegression introduced in release => 3.0PR15Q1
2015-03-10 09:57ngarciaRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/c1d30f85a429d63b04ee6470072ec5b1742acc5e [^]
2015-03-10 09:57ngarciaTriggers an Emergency Pack => No
2015-03-10 09:58ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=7912#r7912
2015-03-10 09:58ngarciaIssue Monitored: networkb
2015-03-10 09:59ngarciaRelationship addedcaused by 0027713
2015-03-10 09:59ngarciaRelationship addedcaused by 0027712
2015-03-10 13:58eduardo_ArgalStatusnew => scheduled
2015-03-16 18:40hgbotCheckin
2015-03-16 18:40hgbotNote Added: 0075651
2015-03-16 18:40hgbotStatusscheduled => resolved
2015-03-16 18:40hgbotResolutionopen => fixed
2015-03-16 18:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9cb33bf7fc7900a3bf8bb25d100cc6620f7925ce [^]
2015-03-16 18:40hgbotCheckin
2015-03-16 18:40hgbotNote Added: 0075652
2015-03-16 18:43aferrazStatusresolved => new
2015-03-16 18:43aferrazResolutionfixed => open
2015-03-16 18:43aferrazStatusnew => scheduled
2015-03-16 18:44aferrazStatusscheduled => resolved
2015-03-16 18:44aferrazResolutionopen => fixed
2015-03-16 18:48aferrazReview Assigned To => aferraz
2015-03-16 18:48aferrazNote Added: 0075654
2015-03-16 18:48aferrazStatusresolved => closed
2015-03-18 00:03hudsonbotCheckin
2015-03-18 00:03hudsonbotNote Added: 0075709
2015-03-18 00:03hudsonbotCheckin
2015-03-18 00:03hudsonbotNote Added: 0075710

Notes
(0075651)
hgbot   
2015-03-16 18:40   
Repository: erp/devel/pi
Changeset: 9cb33bf7fc7900a3bf8bb25d100cc6620f7925ce
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Mar 10 13:58:57 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9cb33bf7fc7900a3bf8bb25d100cc6620f7925ce [^]

Fixes issue 29211
Cannot complete a goods receipt with a line without attribute set value if it has a related prereservation.
Added coalesce when inserting to get default value

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0075652)
hgbot   
2015-03-16 18:40   
Repository: erp/devel/pi
Changeset: 1c38281215d7f9d40dcd4a12cc4c259d30f770ff
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Mar 16 18:39:38 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1c38281215d7f9d40dcd4a12cc4c259d30f770ff [^]

Related to issue 29211: Update copyright

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0075654)
aferraz   
2015-03-16 18:48   
Code review + Testing OK
(0075709)
hudsonbot   
2015-03-18 00:03   
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/2e3cf56c8f15 [^]
Maturity status: Test
(0075710)
hudsonbot   
2015-03-18 00:03   
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/2e3cf56c8f15 [^]
Maturity status: Test