Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049026Retail ModulesWeb POSpublic2022-04-11 14:012022-05-23 07:21
Reportergowthamveeramuthu 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product VersionRR19Q3 
Target VersionFixed in VersionRR22Q3 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket40774
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049026: Log client corrupted in terminals
Descriptionwe 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".
Steps To Reproducen/a
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? terminallog.json (1,094) 2022-04-11 14:01
https://issues.openbravo.com/file_download.php?file_id=16877&type=bug
Issue History
Date ModifiedUsernameFieldChange
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:01gowthamveeramuthuOBNetwork customer => Gold
2022-04-11 14:01gowthamveeramuthuSupport ticket => 40774
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:23hgbotMerge Request Status => open
2022-05-16 07:23hgbotNote Added: 0137292
2022-05-23 07:21hgbotMerge Request Statusopen => approved
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 [^]