0033843: useless heavy queries in linked items - Openbravo Issue Tracking System

0033843

Openbravo ERP

A. Platform

public

2016-08-29 16:53

2016-09-02 14:28

Reporter

alostale

Assigned To

NaroaIriarte

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Merge Request Status

Review Assigned To

alostale

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0033843: useless heavy queries in linked items

Description

When linked items section is opened a set of useless and potentially heavy queries is executed.

Steps To Reproduce

-Open Business Partner window and select any row
-Open Linked Items section and check PG queries:
        SELECT C_Bpartner_ID as ID FROM ContMng_Container WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM contmng_container_history WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM ContMng_WorkOrder WHERE C_Bpartner_ID = ?
        SELECT Container_Owner as ID FROM ContMng_WorkOrder WHERE Container_Owner = ?
        SELECT Carriername as ID FROM ContMng_Content WHERE Carriername = ?
        SELECT C_Bpartner_ID as ID FROM ContMng_WorkOrder WHERE C_Bpartner_ID = ?
        SELECT Container_Owner as ID FROM ContMng_WorkOrder WHERE Container_Owner = ?
        SELECT C_BPartner_ID as ID FROM Fact_Acct WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_ValidCombination WHERE C_BPartner_ID = ?
        SELECT SalesRep_ID as ID FROM C_BPartner WHERE SalesRep_ID = ?
        SELECT C_BPartner_ID as ID FROM M_Product WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_Project WHERE C_BPartner_ID = ?
        SELECT Responsible_ID as ID FROM C_Project WHERE Responsible_ID = ?
        SELECT C_BPartner_ID as ID FROM C_AcctSchema_Element WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_BudgetLine WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM Fact_Acct WHERE C_BPartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM GL_Journal WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM GL_JournalLine WHERE C_Bpartner_ID = ?
        SELECT C_BPartner_ID as ID FROM Fact_Acct WHERE C_BPartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM GL_Journal WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM GL_JournalLine WHERE C_Bpartner_ID = ?
        SELECT C_BPartner_ID as ID FROM Fact_Acct WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM A_Asset WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM Fact_Acct WHERE C_BPartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Doubtful_Debt WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Doubtful_Debt WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Doubtful_Debt_Run WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Financial_Account WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM APRM_Finacc_Trx_Full_Acct_V WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM APRM_FinAcc_Transaction_acct_v WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_BankStatementLine WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Finacc_Transaction WHERE C_Bpartner_ID = ?
        SELECT C_BPartner_ID as ID FROM Fact_Acct WHERE C_BPartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Payment WHERE C_Bpartner_ID = ?
        SELECT C_BPartner_ID as ID FROM Fact_Acct WHERE C_BPartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Payment WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Payment_Proposal WHERE C_Bpartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM FIN_Payment_Prop_Detail_V WHERE C_Bpartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_TaxPayment WHERE C_BPartner_ID = ?
        SELECT C_BPartnerCashTrx_ID as ID FROM AD_ClientInfo WHERE C_BPartnerCashTrx_ID = ?
        SELECT C_BPartner_ID as ID FROM AD_OrgInfo WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM AD_User WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_BP_BankAccount WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_BPartner_Discount WHERE C_BPartner_ID = ?
        SELECT SalesRep_ID as ID FROM C_BPartner WHERE SalesRep_ID = ?
        SELECT C_BPartner_ID as ID FROM AD_User WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_BP_SALCATEGORY WHERE C_BPartner_ID = ?
        SELECT SalesRep_ID as ID FROM C_BPartner WHERE SalesRep_ID = ?
        SELECT C_BPartner_ID as ID FROM C_BP_Customer_Acct WHERE C_BPartner_ID = ?
        SELECT SalesRep_ID as ID FROM C_BPartner WHERE SalesRep_ID = ?
        SELECT C_BPartner_ID as ID FROM C_BP_Employee_Acct WHERE C_BPartner_ID = ?
        SELECT C_BPartner_ID as ID FROM C_BPartner_Location WHERE C_BPartner_ID = ?
        SELECT C_Bpartner_ID as ID FROM SUPTEST_Salary WHERE C_Bpartner_ID = ?

Proposed Solution

Additional Information