Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022049Openbravo ERP07. Sales managementpublic2012-10-23 08:482013-03-06 17:19
Reportersureshbabu 
Assigned ToAugustoMauch 
PrioritylowSeverityminorReproducibilityrandom
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version3.0MP16 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesOpenbravo 3.0
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022049: [Reliability] system throws error while creating sales order "Null value in column "record_id" violates not-null constraint"
DescriptionIn sales order, in grid view i clicked ctrl + i to create a new order, then with out entering hte BP details i clicked the Enter key, one more sales order row gets inserted.
Then with out doing anything i clicked the Edit in form view icon then i tried to enter the BP details and i moved to lines tab and enter the line details.
when i tried to Book the order, system throws the error as.

ERROR: Null value in column "record_id" violates not-null constraint
Steps To ReproduceIn sales order, in grid view i clicked ctrl + i to create a new order
Then with out entering the BP details i clicked the Enter key, one more sales order row gets inserted.
Then with out doing anything i clicked the Edit in form view icon then i tried to enter the BP details and i moved to lines tab and enter the line details.
when i tried to Book the order, system throws the error as.

ERROR: Null value in column "record_id" violates not-null constraint
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0021715 acknowledged Triage Platform Base Opening a new record in form while editing a record in grid generates inconsistencies 
related to defect 00250723.0PR14Q2 closed AugustoMauch Error message when validating a work effort if the header is created in grid view 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-23 08:48sureshbabuNew Issue
2012-10-23 08:48sureshbabuAssigned To => dmiguelez
2012-10-23 08:48sureshbabuWeb browser => Google Chrome
2012-10-23 08:48sureshbabuModules => Openbravo 3.0
2012-10-23 08:50sureshbabuWeb browserGoogle Chrome => Google Chrome
2012-10-23 08:50sureshbabuSummary[Reliability] => [Reliability] system throws error while creating sales order
2012-10-23 08:50sureshbabuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3968#r3968
2012-10-23 10:20dmiguelezWeb browserGoogle Chrome => Google Chrome
2012-10-23 10:20dmiguelezAssigned Todmiguelez => AugustoMauch
2012-10-24 09:57sureshbabuWeb browserGoogle Chrome => Google Chrome
2012-10-24 09:57sureshbabuSummary[Reliability] system throws error while creating sales order => [Reliability] system throws error while creating sales order "Null value in column "record_id" violates not-null constraint"
2013-03-06 17:19AugustoMauchRelationship addedduplicate of 0021715
2013-03-06 17:19AugustoMauchNote Added: 0057106
2013-03-06 17:19AugustoMauchStatusnew => closed
2013-03-06 17:19AugustoMauchResolutionopen => duplicate
2013-11-04 16:06caristuRelationship addedrelated to 0025072

Notes
(0057106)
AugustoMauch   
2013-03-06 17:19   
This issue is a duplicate of 21715. In both issues the root cause of the problem is the same: there are inconsistencies when a record is opened in form view while it is already opened in edit mode in grid view.