Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021944Openbravo ERP09. Financial managementpublic2012-10-16 10:122012-10-16 16:42
Reporteregoitz 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version3.0MP16 
Target Version3.0MP18Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket17478
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021944: The modulescript UpdateRecordId2Value takes long to be executed having many values
DescriptionThe modulescript UpdateRecordId2Value takes long to be executed having many values.
The update of the modulescript is execute in every update what it is not needed if it has been previously executed.

Steps To Reproduce-ON an environment with the 358650 rows on the fact_acct and 22138 rows on the c_dept_payment table execute an update.database
-It takes too much to finish. Many of the time is spent on the UpdateRecordId2Value modulescript.
Proposed SolutionReplace that update on the thile modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateRecordId2Value_data.xsql


UPDATE FACT_ACCT SET RECORD_ID2 = NULL
        WHERE NOT EXISTS (SELECT 1 FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT_ID = RECORD_ID2)

with

UPDATE FACT_ACCT SET RECORD_ID2 = NULL
        WHERE NOT EXISTS (SELECT 1 FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT_ID = RECORD_ID2) AND RECORD_ID2 IS NOT NULL
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0021909 closed eduardo_Argal ModuleScript UpdateRecordID2Value can take a very long time, every time it is ran 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-16 10:12egoitzNew Issue
2012-10-16 10:12egoitzAssigned To => dmiguelez
2012-10-16 10:12egoitzModules => Advanced Payables and Receivables Mngmt
2012-10-16 10:12egoitzOBNetwork customer => Yes
2012-10-16 10:12egoitzSupport ticket => 17478
2012-10-16 10:12egoitzResolution time => 1352502000
2012-10-16 12:13egoitzIssue Monitored: networkb
2012-10-16 16:42dmiguelezRelationship addedduplicate of 0021909
2012-10-16 16:42dmiguelezNote Added: 0053376
2012-10-16 16:42dmiguelezStatusnew => closed
2012-10-16 16:42dmiguelezResolutionopen => duplicate

Notes
(0053376)
dmiguelez   
2012-10-16 16:42   
Issue already reported.