Openbravo Issue Tracking System - Retail Modules
View Issue Details
0045163Retail ModulesWeb POSpublic2020-09-30 12:392020-10-06 08:58
maite 
prakashmurugesan88 
urgentmajoralways
closedfixed 
5
 
RR21Q1 
No
0045163: Login timeout with huge volume of characteristics
Server 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
- Log in the terminal
- MasterData Loading Error will be raised
Create the following index:

CREATE INDEX M_Char_Useonwebpos
  ON public.M_Characteristic
  USING btree
  (EM_Obpos_Useonwebpos COLLATE pg_catalog."default");
No tags attached.
Issue History
2020-09-30 12:39maiteNew Issue
2020-09-30 12:39maiteAssigned To => Retail
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:26hgbotNote Added: 0123527
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
---