Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032677Openbravo ERPA. Platformpublic2016-04-15 11:562017-09-21 16:49
Reporteregoitz 
Assigned Tocollazoandy4 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032677: Deleting a line on the shipment/receipt line tab takes long on environment with big amount of data
DescriptionDeleting a line on the shipment line tab takes long on environment with big amount of data.
Steps To Reproduce-On an environment with thousends of order, invoices and shipment create a goods shipement, then create a line and finally remove the line.

It takes more than 1 minute


Contact ECA for an environment where that is reproducible
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032205 closed collazoandy4 Deleting a line on the order line window takes long on environment with big amount of data 
related to defect 0036804 closed Triage Omni OMS Deleting a line on the shipment/receipt line tab takes long on environment with big amount of data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-04-15 11:56egoitzNew Issue
2016-04-15 11:56egoitzAssigned To => AtulOpenbravo
2016-04-15 11:56egoitzModules => Core
2016-04-15 11:56egoitzResolution time => 1460930400
2016-04-15 11:56egoitzTriggers an Emergency Pack => No
2016-04-15 11:56egoitzIssue generated from0032205
2016-04-15 11:56egoitzRelationship addedrelated to 0032205
2016-04-15 11:59egoitzNote Added: 0085663
2016-04-15 12:25aferrazAssigned ToAtulOpenbravo => Triage Finance
2016-04-15 14:33aferrazSeveritymajor => minor
2016-04-15 14:33aferrazNote Added: 0085671
2016-04-15 14:33aferrazResolution time1460930400 =>
2016-04-15 14:34aferrazFile Added: 32677.diff
2017-07-31 11:07aferrazAssigned ToTriage Finance => collazoandy4
2017-08-01 17:22collazoandy4Statusnew => scheduled
2017-08-02 08:33aferrazFile Deleted: 32677.diff
2017-08-03 13:56hgbotCheckin
2017-08-03 13:56hgbotNote Added: 0098370
2017-08-03 13:56hgbotStatusscheduled => resolved
2017-08-03 13:56hgbotResolutionopen => fixed
2017-08-03 13:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8cb1e05233d4c6cc3456476266240a83ae6da1d1 [^]
2017-08-03 14:00aferrazReview Assigned To => aferraz
2017-08-03 14:00aferrazNote Added: 0098373
2017-08-03 14:00aferrazStatusresolved => closed
2017-08-03 14:00aferrazFixed in Version => 3.0PR17Q4
2017-09-07 12:16JONHMRelationship addedrelated to 0036804
2017-09-21 16:49hudsonbotCheckin
2017-09-21 16:49hudsonbotNote Added: 0099296

Notes
(0085663)
egoitz   
2016-04-15 11:59   
The 2 seq scans don on the m_inoutline table:

'SELECT ? FROM ONLY "public"."m_inoutline" x WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "bom_parent_id"::pg_catalog.text FOR KEY SHARE OF x'
'SELECT ? FROM ONLY "public"."m_inoutline" x WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "canceled_inoutline_id"::pg_catalog.text FOR KEY SHARE OF x''SELECT ? FROM ONLY "public"."m_inoutline" x WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "bom_parent_id"::pg_catalog.text FOR KEY SHARE OF x'
'SELECT ? FROM ONLY "public"."m_inoutline" x WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "canceled_inoutline_id"::pg_catalog.text FOR KEY SHARE OF x'
(0085671)
aferraz   
2016-04-15 14:33   
Updated to minor and deleted resolution time.
Attached patch provided to the customer.
(0098370)
hgbot   
2017-08-03 13:56   
Repository: erp/devel/pi
Changeset: 8cb1e05233d4c6cc3456476266240a83ae6da1d1
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue Aug 01 12:07:16 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/8cb1e05233d4c6cc3456476266240a83ae6da1d1 [^]

Fixes issue 32677: Deleting a line on the shipment/receipt line tab takes long

When deleting a line on the shipment/receipt takes more than 1 minute on
enviroment with big amount of data.

Two new partial indexes were created to improve the performance on a huge
enviroment.

---
M src-db/database/model/tables/M_INOUTLINE.xml
---
(0098373)
aferraz   
2017-08-03 14:00   
Code review OK
(0099296)
hudsonbot   
2017-09-21 16:49   
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/9750b78d3e5c [^]
Maturity status: Test