Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051841Retail ModulesWeb POSpublic2023-03-13 12:332023-07-10 11:11
Reportersofidossant 
Assigned Toranjith_qualiantech_com 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0051841: ERROR with Chrome: 111.0.5563.64
DescriptionWe have detected that with Chrome version: 111.0.5563.64 (official build) (64 bits) the WebPOS cannot be accessed via IP.

We have tried with two different clients, one in version 22Q1 and the other in version 22Q2, and we get the same error.

Entering through localhost or 127.0.0.1 there is no problem but if we try it through another computer and through IP we get the following error (attached)
Steps To Reproduce- Use a enviroment local
- Checked the version of chrome 111.0.5563.64 (official build) (64 bits)
- Open the webPos
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0052939RR23Q3 closed ranjith_qualiantech_com ERROR with Chrome: 111.0.5563.64 
depends on backport 0052940RR23Q2.3 closed ranjith_qualiantech_com ERROR with Chrome: 111.0.5563.64 
depends on backport 0052941RR23Q1.4 closed ranjith_qualiantech_com ERROR with Chrome: 111.0.5563.64 
causes defect 0054593 closed ranjith_qualiantech_com Login and sales can not be done with remote customer enabled in offline 
Attached Filespng image.png (156,052) 2023-03-13 12:33
https://issues.openbravo.com/file_download.php?file_id=18256&type=bug
png

diff issue51841_20Q4_posterminal.diff (8,983) 2023-06-29 14:02
https://issues.openbravo.com/file_download.php?file_id=18704&type=bug
diff issue51841_20Q4_core.diff (113,976) 2023-06-29 16:36
https://issues.openbravo.com/file_download.php?file_id=18705&type=bug
diff issue51841_21Q1_core.diff (113,773) 2023-06-29 16:59
https://issues.openbravo.com/file_download.php?file_id=18706&type=bug
diff issue51841_21Q1_posterminal.diff (9,384) 2023-06-29 16:59
https://issues.openbravo.com/file_download.php?file_id=18707&type=bug
Issue History
Date ModifiedUsernameFieldChange
2023-03-13 12:33sofidossantNew Issue
2023-03-13 12:33sofidossantAssigned To => Retail
2023-03-13 12:33sofidossantFile Added: image.png
2023-03-13 12:33sofidossantTriggers an Emergency Pack => No
2023-03-13 12:33sofidossantPriorityurgent => high
2023-03-13 13:15PracticsIssue Monitored: Practics
2023-03-24 09:11marvintmNote Added: 0147933
2023-03-30 14:19sofidossantNote Added: 0148119
2023-03-31 11:22guillermogilNote Added: 0148156
2023-03-31 11:31radhakrishnanAssigned ToRetail => radhakrishnan
2023-03-31 11:32radhakrishnanStatusnew => scheduled
2023-04-13 16:46sofidossantNote Added: 0148444
2023-04-27 16:27sofidossantNote Added: 0149025
2023-05-06 07:21hgbotNote Added: 0149377
2023-05-08 07:54hgbotNote Added: 0149416
2023-05-10 08:52ranjith_qualiantech_comAssigned Toradhakrishnan => ranjith_qualiantech_com
2023-05-15 08:28marvintmSeveritycritical => major
2023-05-15 17:21sofidossantNote Added: 0149711
2023-05-18 08:52hgbotNote Added: 0149917
2023-05-18 08:52hgbotNote Added: 0149918
2023-05-18 08:52hgbotNote Added: 0149919
2023-05-18 08:52hgbotNote Added: 0149920
2023-05-18 08:52hgbotNote Added: 0149921
2023-05-19 13:01ranjith_qualiantech_comNote Added: 0149975
2023-06-29 14:02migueldejuanaFile Added: issue51841_20Q4_core.diff
2023-06-29 14:02migueldejuanaFile Added: issue51841_20Q4_posterminal.diff
2023-06-29 14:12sofidossantNote Added: 0151846
2023-06-29 16:36migueldejuanaFile Deleted: issue51841_20Q4_core.diff
2023-06-29 16:36migueldejuanaFile Added: issue51841_20Q4_core.diff
2023-06-29 16:59migueldejuanaFile Added: issue51841_21Q1_core.diff
2023-06-29 16:59migueldejuanaFile Added: issue51841_21Q1_posterminal.diff
2023-06-30 07:01hgbotNote Added: 0151921
2023-06-30 12:11hgbotNote Added: 0151951
2023-07-05 15:11sofidossantNote Added: 0152146
2023-07-10 09:51hgbotNote Added: 0152230
2023-07-10 09:51hgbotResolutionopen => fixed
2023-07-10 09:51hgbotStatusscheduled => closed
2023-07-10 09:51hgbotFixed in Version => RR23Q4
2023-07-10 09:51hgbotNote Added: 0152231
2023-07-10 09:51hgbotNote Added: 0152232
2023-07-10 09:51hgbotNote Added: 0152233
2023-07-10 09:51hgbotNote Added: 0152234
2023-07-10 09:51hgbotNote Added: 0152235
2023-07-10 09:51hgbotNote Added: 0152236
2023-07-10 09:51hgbotNote Added: 0152237
2023-07-10 09:51hgbotNote Added: 0152238
2023-07-10 09:51hgbotNote Added: 0152239
2023-07-10 09:52hgbotNote Added: 0152240
2023-07-10 09:52hgbotNote Added: 0152241
2023-07-10 09:52hgbotNote Added: 0152242
2023-07-10 09:52hgbotNote Added: 0152243
2023-07-10 09:59hgbotNote Added: 0152244
2023-07-10 09:59hgbotNote Added: 0152245
2023-07-10 09:59hgbotNote Added: 0152246
2023-07-10 09:59hgbotNote Added: 0152247
2023-07-10 11:10ranjith_qualiantech_comNote Added: 0152265
2023-07-10 11:10ranjith_qualiantech_comStatusclosed => new
2023-07-10 11:10ranjith_qualiantech_comResolutionfixed => open
2023-07-10 11:10ranjith_qualiantech_comFixed in VersionRR23Q4 =>
2023-07-10 11:10ranjith_qualiantech_comStatusnew => scheduled
2023-07-10 11:11ranjith_qualiantech_comStatusscheduled => closed
2023-07-10 11:11ranjith_qualiantech_comResolutionopen => no change required
2024-02-21 14:12ranjith_qualiantech_comRelationship addedrelated to 0054593
2024-02-23 07:29ranjith_qualiantech_comRelationship deletedrelated to 0054593
2024-02-23 07:30ranjith_qualiantech_comRelationship addedcauses 0054593

Notes
(0147933)
marvintm   
2023-03-24 09:11   
This problem happens because WebSQL has been removed in non-secure contexts. We don't really have any control on this, but we are discussing internally if we should still keep the WebSQL infrastructure as we don't need it anymore for AWO, and chances of customers using it in external modules in an IndexedDB release don't seem to be very high.

A decision on this topic will be made soon, and if the infrastructure is finally removed, then this error will no longer happen. However, this should not be taken as an indication that we want to support the execution of the application in non-secure contexts. Usage of the application in non-secure contexts is strongly discouraged, and should never be attempted in general.
(0148119)
sofidossant   
2023-03-30 14:19   
Any news?
(0148156)
guillermogil   
2023-03-31 11:22   
It will be needed to remove all the init WebSQL references in mobile.core (init database, init models, delete old tables, etc..), Ob-dal is not needed to be removed.
We need to ensure there are no direct references to WebSQL API on POS Code
(0148444)
sofidossant   
2023-04-13 16:46   
Any news?
(0149025)
sofidossant   
2023-04-27 16:27   
Any news?
(0149377)
hgbot   
2023-05-06 07:21   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.servicesequence/-/merge_requests/2 [^]
(0149416)
hgbot   
2023-05-08 07:54   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts.discountmatrixmanagement/-/merge_requests/9 [^]
(0149711)
sofidossant   
2023-05-15 17:21   
Any news?
(0149917)
hgbot   
2023-05-18 08:52   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/523 [^]
(0149918)
hgbot   
2023-05-18 08:52   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/50 [^]
(0149919)
hgbot   
2023-05-18 08:52   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/77 [^]
(0149920)
hgbot   
2023-05-18 08:52   
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/292 [^]
(0149921)
hgbot   
2023-05-18 08:52   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1198 [^]
(0149975)
ranjith_qualiantech_com   
2023-05-19 13:01   
Merge Request created: https://gitlab.com/openbravo/ci/context_definitions/-/merge_requests/49 [^]
(0151846)
sofidossant   
2023-06-29 14:12   
Any news?
(0151921)
hgbot   
2023-06-30 07:01   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.trainingmode/-/merge_requests/15 [^]
(0151951)
hgbot   
2023-06-30 12:11   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.giftcards/-/merge_requests/250 [^]
(0152146)
sofidossant   
2023-07-05 15:11   
Any news?
(0152230)
hgbot   
2023-07-10 09:51   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/523 [^]
(0152231)
hgbot   
2023-07-10 09:51   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: 511ed74e96e4a5ecfca661f1ca4bab6f92fe97ce
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 10-07-2023 09:42:59
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/511ed74e96e4a5ecfca661f1ca4bab6f92fe97ce [^]

Fixed ISSUE-51841: Removed WebSQL Database initialize when loading POS
* Removed unused DAL function

---
M web/org.openbravo.mobile.core/source/data/ob-dal.js
M web/org.openbravo.mobile.core/source/data/ob-datasource.js
M web/org.openbravo.mobile.core/source/data/ob-requestrouter.js
M web/org.openbravo.mobile.core/source/data/ob-windowmodel.js
M web/org.openbravo.mobile.core/source/main.js
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
(0152232)
hgbot   
2023-07-10 09:51   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: bf715451e1e01ab150e2122d73aecc0fe0d98720
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 10-07-2023 09:45:15
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/bf715451e1e01ab150e2122d73aecc0fe0d98720 [^]

Related to ISSUE-51841: Removed DAL loadModel reference

---
A web/org.openbravo.retail.posterminal/app/model/business-object/ticket-list/actions/DeleteTicket.js
M src/org/openbravo/retail/posterminal/OBPOSComponentProvider.java
M web/org.openbravo.retail.posterminal/js/components/modal-pay-open-tickets.js
M web/org.openbravo.retail.posterminal/js/data/windowmodel.js
M web/org.openbravo.retail.posterminal/js/login/model/login-model.js
M web/org.openbravo.retail.posterminal/js/main.js
M web/org.openbravo.retail.posterminal/js/utils/ticketListUtils.js
---
(0152233)
hgbot   
2023-07-10 09:51   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1198 [^]
(0152234)
hgbot   
2023-07-10 09:51   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts.discountmatrixmanagement/-/merge_requests/9 [^]
(0152235)
hgbot   
2023-07-10 09:51   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts.discountmatrixmanagement [^]
Changeset: 7cfbcbcfa8d27698e49454aeb9beb314c06e0668
Author: Radhakrishnan Seeman <radhakrishnan@qualiantech.com>
Date: 27-06-2023 11:53:01
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts.discountmatrixmanagement/-/commit/7cfbcbcfa8d27698e49454aeb9beb314c06e0668 [^]

Related to ISSUE-51841: Added indexedDB support

---
A web/org.openbravo.retail.discounts.discountmatrixmanagement/app/model/masterdata/RoleDiscountsModel.js
M src/org/openbravo/retail/discounts/discountmatrixmanagement/DiscountsComponentProvider.java
M src/org/openbravo/retail/discounts/discountmatrixmanagement/master/RoleDiscounts.java
M web/org.openbravo.retail.discounts.discountmatrixmanagement/js/hookRoleDiscounts.js
M web/org.openbravo.retail.discounts.discountmatrixmanagement/js/modelRoleDiscounts.js
---
(0152236)
hgbot   
2023-07-10 09:51   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.trainingmode [^]
Changeset: 8bb85b8be5c4263c679e0f29aecb2b1a46a8ef5c
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 28-06-2023 13:36:46
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.trainingmode/-/commit/8bb85b8be5c4263c679e0f29aecb2b1a46a8ef5c [^]

Related to ISSUE-51841: Removed Unused DeleteOrder hook

---
M src/org/openbravo/retail/trainingmode/OBRTMComponentProvider.java
R web/org.openbravo.retail.trainingmode/js/predeleteorder.js
---
(0152237)
hgbot   
2023-07-10 09:51   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.trainingmode/-/merge_requests/15 [^]
(0152238)
hgbot   
2023-07-10 09:51   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.servicesequence [^]
Changeset: 1849e28fcdcae686834574642a671b6855f6a7e8
Author: Radhakrishnan Seeman <radhakrishnan@qualiantech.com>
Date: 30-06-2023 10:30:45
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.servicesequence/-/commit/1849e28fcdcae686834574642a671b6855f6a7e8 [^]

Related to ISSUE-51841: Added indexedDB support

---
A src/org/openbravo/retail/servicesequence/master/ServiceSequence.java
A web/org.openbravo.retail.servicesequence/app/model/masterdata/ServiceSequenceModel.js
A web/org.openbravo.retail.servicesequence/app/model/masterdata/SynchronizeServiceSequence.js
M src/org/openbravo/retail/servicesequence/OBRETSSComponentProvider.java
M src/org/openbravo/retail/servicesequence/master/OBRETSSSequenceProperties.java
M web/org.openbravo.retail.servicesequence/js/model/sequenceModel.js
M web/org.openbravo.retail.servicesequence/js/preOrderSaveHook.js
R web/org.openbravo.retail.servicesequence/js/model/obretssDataSyncModel.js
---
(0152239)
hgbot   
2023-07-10 09:51   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.servicesequence/-/merge_requests/2 [^]
(0152240)
hgbot   
2023-07-10 09:52   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.giftcards/-/merge_requests/250 [^]
(0152241)
hgbot   
2023-07-10 09:52   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.giftcards [^]
Changeset: f70f4ff988ac9e6a1f9e7b9bf0f960db5bd29702
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 10-07-2023 08:22:20
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.giftcards/-/commit/f70f4ff988ac9e6a1f9e7b9bf0f960db5bd29702 [^]

Related to ISSUE-51841: MultiOrder payment should be validated in GiftCertificate popup

---
M web/org.openbravo.retail.giftcards/js/components/GiftCardDetails.js
---
(0152242)
hgbot   
2023-07-10 09:52   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: b9f841b58f776c6f565e6e6392a218df82b75f95
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 10-07-2023 09:47:31
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/b9f841b58f776c6f565e6e6392a218df82b75f95 [^]

Related to ISSUE-51841: Updated test TerminalUpdateTestMasterdataChange

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/loginout/TerminalUpdateTestMasterdataChange.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I35778_VerifyPayOpenTicketPayments.java
---
(0152243)
hgbot   
2023-07-10 09:52   
Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/292 [^]
(0152244)
hgbot   
2023-07-10 09:59   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 60e81ba7adfeebd03ef3e404173172367692ee0b
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 02-07-2023 12:42:44
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/60e81ba7adfeebd03ef3e404173172367692ee0b [^]

Related to ISSUE-51841: Removed sampledata for unused loyalty module

---
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_PAYMENT_TYPE.xml
---
(0152245)
hgbot   
2023-07-10 09:59   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/77 [^]
(0152246)
hgbot   
2023-07-10 09:59   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/50 [^]
(0152247)
hgbot   
2023-07-10 09:59   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata [^]
Changeset: 24ea8cfcd13546d8b36c9989d7b2ef303d9dfb28
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 02-07-2023 12:42:36
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/commit/24ea8cfcd13546d8b36c9989d7b2ef303d9dfb28 [^]

Related to ISSUE-51841: Removed sampledata for unused loyalty module

---
M referencedata/sampledata/Retail_Test/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/Retail_Test/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/Retail_Test/OBPOS_APP_PAYMENT_TYPE.xml
---
(0152265)
ranjith_qualiantech_com   
2023-07-10 11:10   
Reopening issue for creating backports