Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045163Retail ModulesWeb POSpublic2020-09-30 12:392020-10-06 08:58
Reportermaite 
Assigned Toprakashmurugesan88 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR21Q1 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket18057
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045163: Login timeout with huge volume of characteristics
DescriptionServer timeout is raised, due to CharacteristicValue model in an environment with:

select count(*) from m_product
629672
select count(*) from M_Product_Ch_Value
5037312
select count(*) from M_Ch_Value
166361
select count(*) from M_Characteristic
8

30k product in the assortment of the store
Steps To Reproduce- Log in the terminal
- MasterData Loading Error will be raised
Proposed SolutionCreate the following index:

CREATE INDEX M_Char_Useonwebpos
  ON public.M_Characteristic
  USING btree
  (EM_Obpos_Useonwebpos COLLATE pg_catalog."default");
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-09-30 12:39maiteNew Issue
2020-09-30 12:39maiteAssigned To => Retail
2020-09-30 12:39maiteOBNetwork customer => Gold
2020-09-30 12:39maiteSupport ticket => 18057
2020-09-30 12:39maiteResolution time => 1603231200
2020-09-30 12:39maiteTriggers an Emergency Pack => No
2020-09-30 13:08egoitzProposed Solution updated
2020-09-30 13:32prakashmurugesan88Assigned ToRetail => prakashmurugesan88
2020-10-05 08:29prakashmurugesan88Statusnew => scheduled
2020-10-05 11:26hgbotMerge Request Status => open
2020-10-05 11:26hgbotNote Added: 0123527
2020-10-06 08:58hgbotMerge Request Statusopen => approved
2020-10-06 08:58hgbotResolutionopen => fixed
2020-10-06 08:58hgbotStatusscheduled => closed
2020-10-06 08:58hgbotNote Added: 0123567
2020-10-06 08:58hgbotFixed in Version => RR21Q1
2020-10-06 08:58hgbotNote Added: 0123568

Notes
(0123527)
hgbot   
2020-10-05 11:26   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/122 [^]
(0123567)
hgbot   
2020-10-06 08:58   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/122 [^]
(0123568)
hgbot   
2020-10-06 08:58   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 3287436fb26d88f17c97c7c72b30cee9b4fc2024
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-06T06:58:49+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/3287436fb26d88f17c97c7c72b30cee9b4fc2024 [^]

Fixed BUG-45163: Created index for M_Characteristic-EM_OBPOS_USEONWEBPOS
* Included index as login timeout occurs with huge volume of characteristics

---
M src-db/database/model/modifiedTables/M_CHARACTERISTIC.xml
---