Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0045710 | Retail Modules | Web POS | public | 2021-01-11 17:44 | 2021-01-15 08:32 |
|
| Reporter | egoitz | |
| Assigned To | Sandrahuguet | |
| Priority | normal | Severity | critical | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR21Q2 | |
| Merge Request Status | approved |
| Review Assigned To | |
| OBNetwork customer | Gold |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0045710: Query to get characteristics model is taking more than 10 minutes. |
| Description | When executing a full refresh, on an environment with thousands of characteristics, the query is taking more than 10 minutes.
Model: Characteristic Value
Query:
select characteri0_.M_Ch_Value_ID as col_0_0_, characteri0_.Name as col_1_0_, characteri1_.M_Characteristic_ID as col_2_0_, adtreenode2_.Parent_ID as col_3_0_, characteri0_.IsSummary as col_4_0_, characteri0_.Name as col_5_0_, characteri0_.Isactive as col_6_0_, characteri1_.Name as col_7_0_ from M_Ch_Value characteri0_ inner join M_Characteristic characteri1_ on characteri0_.M_Characteristic_ID=characteri1_.M_Characteristic_ID cross join AD_TreeNode adtreenode2_ where characteri1_.AD_Tree_ID=adtreenode2_.AD_Tree_ID and characteri0_.M_Ch_Value_ID=adtreenode2_.Node_ID and characteri0_.IsSummary='N' and (exists (select 1 from M_Product_Ch_Value productcha3_ cross join OBRETCO_Prol_Product obretco_pr4_ where productcha3_.M_Product_ID=obretco_pr4_.M_Product_ID and productcha3_.M_Ch_Value_ID=characteri0_.M_Ch_Value_ID and (obretco_pr4_.Obretco_Productlist_ID in ($1)))) and characteri0_.Isactive='Y' and adtreenode2_.IsActive='Y' and 1=1 and 1=1 and (characteri0_.AD_Client_ID in ('ED6E1C1132D840E2AC6A9932603E09B0' , '0')) and characteri1_.EM_Obpos_Useonwebpos='Y' and characteri0_.Isactive='Y' and (exists (select 1 from AD_Org organizati5_ where (organizati5_.AD_Org_ID in ($2)) and ad_org_isinnaturaltree(characteri0_.AD_Org_ID, organizati5_.AD_Org_ID, characteri0_.AD_Client_ID)='Y')) order by characteri0_.Name, characteri0_.M_Ch_Value_ID limit $3
|
| Steps To Reproduce | -Execute a full refresh on an environment with thousandss of products and characteristcs values. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2021-01-11 17:44 | egoitz | New Issue | |
| 2021-01-11 17:44 | egoitz | Assigned To | => Retail |
| 2021-01-11 17:44 | egoitz | OBNetwork customer | => Gold |
| 2021-01-11 17:44 | egoitz | Resolution time | => 1610665200 |
| 2021-01-11 17:44 | egoitz | Triggers an Emergency Pack | => No |
| 2021-01-11 17:44 | egoitz | Severity | major => critical |
| 2021-01-11 17:47 | malsasua | Description Updated | bug_revision_view_page.php?rev_id=22023#r22023 |
| 2021-01-12 12:28 | adrianromero | Assigned To | Retail => prakashmurugesan88 |
| 2021-01-12 12:33 | prakashmurugesan88 | Status | new => scheduled |
| 2021-01-14 18:09 | hgbot | Merge Request Status | => open |
| 2021-01-14 18:09 | hgbot | Note Added: 0125472 | |
| 2021-01-15 08:28 | hgbot | Merge Request Status | open => approved |
| 2021-01-15 08:28 | hgbot | Resolution | open => fixed |
| 2021-01-15 08:28 | hgbot | Status | scheduled => closed |
| 2021-01-15 08:28 | hgbot | Fixed in Version | => RR21Q2 |
| 2021-01-15 08:28 | hgbot | Note Added: 0125475 | |
| 2021-01-15 08:28 | hgbot | Note Added: 0125476 | |
| 2021-01-15 08:32 | Sandrahuguet | Assigned To | prakashmurugesan88 => Sandrahuguet |