Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032282Openbravo ERP00. Application dictionarypublic2016-02-19 08:472016-02-19 09:32
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032282: WhiteList / Ignore Database Validation for Foreign Key constraint in database validation for C_OrderLine columns
DescriptionCreate Whitelist of columns in the c_orderline table that don't need database validation for foreign key contraint
- c_orderline_soporef
- c_orderline_quotation
- c_orderline_bomparentid
Steps To Reproduce- Apply attached fix for Issue 32205.
- ant smartbuild -Dlocal=no
- Whenever we do a export.database next time warning message "NOT A PART OF FOREIGN KEY" are shown while database validation for following columns
   - c_orderline_soporef
   - c_orderline_quotation
   - c_orderline_bomparentid
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0032205 closed collazoandy4 Deleting a line on the order line window takes long on environment with big amount of data 
Attached Filesdiff FixesIssue32205.diff (2,109) 2016-02-19 08:47
https://issues.openbravo.com/file_download.php?file_id=9077&type=bug
diff FixesIssue32282.diff (1,680) 2016-02-19 09:32
https://issues.openbravo.com/file_download.php?file_id=9078&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-02-19 08:47AtulOpenbravoNew Issue
2016-02-19 08:47AtulOpenbravoAssigned To => AtulOpenbravo
2016-02-19 08:47AtulOpenbravoFile Added: FixesIssue32205.diff
2016-02-19 08:47AtulOpenbravoModules => Core
2016-02-19 08:47AtulOpenbravoTriggers an Emergency Pack => No
2016-02-19 08:50AtulOpenbravoRelationship addedblocks 0032205
2016-02-19 09:30AtulOpenbravoStatusnew => scheduled
2016-02-19 09:31AtulOpenbravoNote Added: 0084344
2016-02-19 09:32AtulOpenbravoFile Added: FixesIssue32282.diff
2016-02-19 09:32AtulOpenbravoReview Assigned To => alostale

Notes
(0084344)
AtulOpenbravo   
2016-02-19 09:31   
Test Plan
- Apply attached fix for Issue 32205 & 32282.
- ant smartbuild -Dlocal=no
- Whenever we do a export.database next time, warning message "NOT A PART OF FOREIGN KEY" are not shown any more while database validation for following columns
   - c_orderline_soporef
   - c_orderline_quotation
   - c_orderline_bomparentid