0044831: Connection is lost when searching characteristic value in webpos

Description

When trying to search characteristic value in the webpos the connection lost with a warning message:
"The connection was lost. You can continue working in offline mode. Transactions made in offline mode will be synchronized when the connection is restored."

Steps To Reproduce

Backoffice prequisite:
1. Define the preference: Enable Remote for Product and value: Y and Organization: vallblanca store
2. Verify the number of records in the Assortment >> Product table must be more than 80K
(select count(*) from OBRETCO_Prol_Product where ad_client_id='39363B0921BB4293B48383844325E84C' > 80K for the client The White Valley Group)

1. Log in the webpos terminal VBS-1 with vallbalnca/openbravo.
2. Go to the search tab and click on any Characteristic and after few minutes, a warning message: "The connection was lost. You can continue working in offline mode. Transactions made in offline mode will be synchronized when the connection is restored."
3. Go to the Menu option and check for the connection status and will find it as offline.
4. Still no characteristic values is populated

Expected Behaviour: When click on the characteristic then a pop up with all the available characteristic values must be displayed.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0122338) marvintm (manager) 2020-08-25 07:49	Unfortunately, this is a known performance problem related to using remote mode with a large number of characteristics. It was analysed before, and all known performance optimisations were applied, but the query is still slow if no other filters are provided. The only solution we have right now (which at the moment we are proposing not to implement, but we can discuss if needed) would be to restrict this simple filter, and require the user to add more filters before we execute the query.

Issue History
Date Modified	Username	Field	Change
2020-08-17 15:41	a_singh	New Issue
2020-08-17 15:41	a_singh	Assigned To	=> Retail
2020-08-17 15:41	a_singh	Resolution time	=> 1599429600
2020-08-17 15:41	a_singh	Triggers an Emergency Pack	=> No
2020-08-25 07:49	marvintm	Resolution time	1599429600 =>
2020-08-25 07:49	marvintm	Note Added: 0122338
2020-08-25 07:49	marvintm	Type	defect => design defect