Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0049026
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorrandom2022-04-11 14:012022-05-23 07:21
ReportergowthamveeramuthuView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in VersionRR22Q3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionRR19Q3SCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0049026: 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
TagsNo tags attached.
Attached Files? file icon terminallog.json [^] (1,094 bytes) 2022-04-11 14:01

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0137292)
hgbot (developer)
2022-05-16 07:23

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/368 [^]
(0137594)
hgbot (developer)
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 (developer)
2022-05-23 07:21

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/368 [^]

- Issue History
Date Modified Username Field Change
2022-04-11 14:01 gowthamveeramuthu New Issue
2022-04-11 14:01 gowthamveeramuthu Assigned To => Retail
2022-04-11 14:01 gowthamveeramuthu File Added: terminallog.json
2022-04-11 14:01 gowthamveeramuthu Triggers an Emergency Pack => No
2022-05-03 14:52 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2022-05-12 13:40 nicola_uva Issue Monitored: nicola_uva
2022-05-12 13:44 martinsdan Issue Monitored: martinsdan
2022-05-13 14:06 ranjith_qualiantech_com Status new => scheduled
2022-05-16 07:23 hgbot Note Added: 0137292
2022-05-23 07:21 hgbot Resolution open => fixed
2022-05-23 07:21 hgbot Status scheduled => closed
2022-05-23 07:21 hgbot Fixed in Version => RR22Q3
2022-05-23 07:21 hgbot Note Added: 0137594
2022-05-23 07:21 hgbot Note Added: 0137595


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker