Openbravo Issue Tracking System - POS2
View Issue Details
0058324POS2POSpublic2025-03-24 17:372025-03-28 14:27
hector_hernaez 
Sathishkumar 
highmajorsometimes
closedduplicate 
5
 
 
No
No
0058324: It is not possible to see the prices in prices subtab of Commercial Operations window
When the customer tries to check the prices subtab in the Commercial Operations window, several times the error 'Operation Timed Out' appears and they are not able to check anything.
The query attached has the parameters replaced by the values of one example that took more than 13 minutes to be executed and finished with the error mentioned previously.

Go to Commercial operations window
Select a record
Go to Prices subtab
It remains loading and the error appears
No tags attached.
? query Commercial Operations (78,632) 2025-03-24 17:37
https://issues.openbravo.com/file_download.php?file_id=21076&type=bug
Issue History
2025-03-24 17:37hector_hernaezNew Issue
2025-03-24 17:37hector_hernaezAssigned To => Triage Omni OMS
2025-03-24 17:37hector_hernaezFile Added: query Commercial Operations
2025-03-24 17:37hector_hernaezOBNetwork customer => No
2025-03-24 17:37hector_hernaezTriggers an Emergency Pack => No
2025-03-25 06:35jonaeNote Added: 0177191
2025-03-25 06:35jonaeAssigned ToTriage Omni OMS => Sathishkumar
2025-03-25 18:16hector_hernaezNote Added: 0177246
2025-03-27 08:52AugustoMauchAssigned ToSathishkumar => igor_trebol
2025-03-27 09:38jonaeAssigned Toigor_trebol => Sathishkumar
2025-03-28 14:27priyamNote Added: 0177672
2025-03-28 14:27priyamStatusnew => closed
2025-03-28 14:27priyamResolutionopen => duplicate

Notes
(0177191)
jonae   
2025-03-25 06:35   
Jira - https://openbravo.atlassian.net/browse/RM-23802 [^]
(0177246)
hector_hernaez   
2025-03-25 18:16   
After adding this index, the performance has improved a bit
create index concurrently aux_OBCOMOP_Com_Oper_PP on OBCOMOP_Com_Oper_ProdPri(obcomop_com_operation_id);
(0177672)
priyam   
2025-03-28 14:27   
Issue exported to Jira: https://openbravo.atlassian.net/browse/RM-23802 [^]