Openbravo Issue Tracking System - Retail Modules
View Issue Details
0049026Retail ModulesWeb POSpublic2022-04-11 14:012022-05-23 07:21
gowthamveeramuthu 
ranjith_qualiantech_com 
normalmajorrandom
closedfixed 
5
RR19Q3 
RR22Q3 
No
0049026: Log client corrupted in terminals
we have found one problem with some Terminal Log. Its returning error when they are saved in the backoffice:

2022-04-11 08:20:54,165 [Import Entry - 1] ERROR org.openbravo.mobile.core.UserEventLoaderQueriesData - SQL error in query: insert into obmobc_logclient (obmobc_logclient_id, ad_client_id, ad_org_id, isactive,created, createdby,updated, updatedby,tstamp, deviceid, context, msg, loglevel, cache_session_id, isonline) values(?, ?, ?, 'Y', to_timestamp(to_char(?), to_char('DD-MM-YYYY HH24:MI:SS')), ?, to_timestamp(to_char(?), to_char('DD-MM-YYYY HH24:MI:SS')), ?, to_number(?), ?, ?, ?, ?, ?, ?) :org.postgresql.util.PSQLException:
ERROR: invalid byte sequence for encoding "UTF8"

we suspect the problem is with the value "u0000" with the attached json. because whenever this issue occurs the json contains "u0000".
n/a
No tags attached.
? terminallog.json (1,094) 2022-04-11 14:01
https://issues.openbravo.com/file_download.php?file_id=16877&type=bug
Issue History
2022-04-11 14:01gowthamveeramuthuNew Issue
2022-04-11 14:01gowthamveeramuthuAssigned To => Retail
2022-04-11 14:01gowthamveeramuthuFile Added: terminallog.json
2022-04-11 14:01gowthamveeramuthuTriggers an Emergency Pack => No
2022-05-03 14:52ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2022-05-12 13:40nicola_uvaIssue Monitored: nicola_uva
2022-05-12 13:44martinsdanIssue Monitored: martinsdan
2022-05-13 14:06ranjith_qualiantech_comStatusnew => scheduled
2022-05-16 07:23hgbotNote Added: 0137292
2022-05-23 07:21hgbotResolutionopen => fixed
2022-05-23 07:21hgbotStatusscheduled => closed
2022-05-23 07:21hgbotFixed in Version => RR22Q3
2022-05-23 07:21hgbotNote Added: 0137594
2022-05-23 07:21hgbotNote Added: 0137595

Notes
(0137292)
hgbot   
2022-05-16 07:23   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/368 [^]
(0137594)
hgbot   
2022-05-23 07:21   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: 9c0085b74a3132e1cc923682531e5694bc72863a
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 23-05-2022 05:21:26
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/9c0085b74a3132e1cc923682531e5694bc72863a [^]

Fixed ISSUE-49026: Remove NUL Character in keyName when adding Terminal Log Key Event

---
M web/org.openbravo.mobile.core/app/model/business-object/terminal-log/actions/AddKey.js
---
(0137595)
hgbot   
2022-05-23 07:21   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/368 [^]