Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041118Retail ModulesWeb POSpublic2019-06-18 12:232023-07-11 08:51
Reportergorka_gil 
Assigned ToRetail 
PrioritynormalSeveritymajorReproducibilityN/A
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
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
Summary0041118: Column "em_obpos_applications_id" of "c_import_entry" not filled by "OBMOBC_TerminalLog" or "OBCFR_TerminalMonitor"
DescriptionWhen any retail application uses the c_import_entry it should fill the the column "em_obpos_applications_id".
Steps To ReproduceIn a web pos terminal with modules do:
- cashup
- open the till
- login
- create a ticket

Then in the db execute this query:
  select * from c_import_entry order by created desc limit 10

You will see that "Order" , "POSS_OpenSessionPOS" or "OBPOS_App_Cashup" fills the "em_obpos_applications_id" column.

But "OBMOBC_TerminalLog" or "OBCFR_TerminalMonitor" left the column with null value.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0039360 closed gorka_gil Terminal Log : Improve log client with cashier actions and processes start/end info 
related to defect 0038759 closed rqueralta No Terminal is set in the session record in Data Import Entry window: It can generate DeadLock database error 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-06-18 12:23gorka_gilNew Issue
2019-06-18 12:23gorka_gilAssigned To => Retail
2019-06-18 12:23gorka_gilTriggers an Emergency Pack => No
2019-06-18 12:29gorka_gilRelationship addedrelated to 0038759
2019-06-18 12:31gorka_gilRelationship addedrelated to 0039360
2019-06-18 15:41hgbotCheckin
2019-06-18 15:41hgbotNote Added: 0112865
2019-07-10 09:20ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2019-07-10 09:43ranjith_qualiantech_comStatusnew => scheduled
2023-07-11 08:51ranjith_qualiantech_comAssigned Toranjith_qualiantech_com => Retail

Notes
(0112865)
hgbot   
2019-06-18 15:41   
Repository: tools/automation/pi-mobile
Changeset: e4e055fe43f3a14506828c6e69d3d305c1af7cf7
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Tue Jun 18 13:11:50 2019 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/e4e055fe43f3a14506828c6e69d3d305c1af7cf7 [^]

Related to issue 38759 and issue 41118: Improve test I38759_VerifySessionDataAfterOpenTill
- to not fail with nullPointer
- and only check the import entries of open till, if not it was checking the
entries of terminal instead the ones reported in the issue

Note: this test before the change has help to found the issue 41118,
so probably for issue 41118 interesting to do a test that check that
nothing of retail in c_import_entry has an empty terminal id

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/sessions/openstoretill/I38759_VerifySessionDataAfterOpenTill.java
---