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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0055011
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] POSmajorunable to reproduce2024-03-20 13:062024-04-18 12:42
ReporterngarciaView Statuspublic 
Assigned ToSABARINATH P 
PriorityurgentResolutionfixedFixed in Version24Q3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Statusapproved
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket92350
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0055011: getProcessIdForAudit for TerminalTypeUserConfigurationLoaderProcessor is returning a value higher than 32 and it fails

DescriptiongetProcessIdForAudit for TerminalTypeUserConfigurationLoaderProcessor is returning a value higher than 32 and it fails.

The Data Import Entry related doesn't change to Error and it is always being processed
Steps To ReproduceSet the SessionInfo to debug

Audit the following tables:

OBPOS_TerminalAccess
Organization
POSS_Terminal_Sessions

Change the configuration of the Terminal from Light mode to Black mode

Check a Data Import Entry of OBPOS2_UpdateTerminalTypeUserConfiguration type is created and it is not processed, it remains an Initial

The log shows:

DEBUG org.openbravo.database.SessionInfo - saving DB context info 4FBFAA553E184EEEA3A60CA1B7DE232D - null - IE - OBPOS2_UpdateTerminalTypeUserConfiguration


org.postgresql.util.PSQLException: ERROR: value too long for type character varying(32)
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) ~[postgresql-42.5.0.jar:42.5.0]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) ~[postgresql-42.5.0.jar:42.5.0]
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) ~[postgresql-42.5.0.jar:42.5.0]
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) ~[postgresql-42.5.0.jar:42.5.0]
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) ~[postgresql-42.5.0.jar:42.5.0]
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190) ~[postgresql-42.5.0.jar:42.5.0]
    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:152) ~[postgresql-42.5.0.jar:42.5.0]
    at jdk.internal.reflect.GeneratedMethodAccessor227.invoke(Unknown Source) ~[?:?]
    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
    at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
    at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc.jar:?]
    at com.sun.proxy.$Proxy70.executeUpdate(Unknown Source) ~[?:?]
    at org.openbravo.database.SessionInfo.saveContextInfoIntoDB(SessionInfo.java:262) ~[openbravo-core.jar:?]
    at org.openbravo.dal.service.OBDal.flush(OBDal.java:263) ~[classes/:?]
    at org.openbravo.dal.core.SessionHandler.flushRemainingChanges(SessionHandler.java:700) ~[classes/:?]
    at org.openbravo.dal.core.SessionHandler.commitAndClose(SessionHandler.java:607) ~[classes/:?]
    at org.openbravo.dal.service.OBDal.commitAndClose(OBDal.java:228) ~[classes/:?]
    at org.openbravo.service.importprocess.ImportEntryManager.setImportEntryErrorIndependent(ImportEntryManager.java:550) ~[classes/:?]
    ... 8 more
Proposed SolutionIn modules/org.openbravo.pos2/src/org/openbravo/pos2/importprocess/TerminalTypeUserConfigurationLoaderProcessor.java

change the return of the getProcessIdForAudit function to a value lower than 32 characters

Modify also the code in charge of setting the Data Import Entry to Error in this case
TagsNo tags attached.
Attached Fileslog file icon DIE_Config.log [^] (52,187 bytes) 2024-03-20 13:26

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0055010 closedRajesh_18 OBPOS2_UpdateTerminalTypeUserConfiguration value should be included in the Types of data to be synchronized in Web POS reference 
depends on backport 005523724Q2 closedSABARINATH P getProcessIdForAudit for TerminalTypeUserConfigurationLoaderProcessor is returning a value higher than 32 and it fails 
depends on backport 005523824Q1.2 closedSABARINATH P getProcessIdForAudit for TerminalTypeUserConfigurationLoaderProcessor is returning a value higher than 32 and it fails 

-  Notes
(0163123)
hgbot (developer)
2024-04-12 07:21

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2563 [^]
(0163363)
hgbot (developer)
2024-04-18 12:23

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2563 [^]
(0163364)
hgbot (developer)
2024-04-18 12:23

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: afd0f828f30651b5fa87c61fc6cf73564f3277e7
Author: Sabarinath <sabarinath.palanisamy.ext@openbravo.com>
Date: 18-04-2024 10:23:22
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/afd0f828f30651b5fa87c61fc6cf73564f3277e7 [^]

Fixed ISSUE-55011: Reduced OBPOS2_UpdateTerminalTypeUserConfiguration to 32 characters

---
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/pos2/importprocess/TerminalTypeUserConfigurationLoaderProcessor.java
M src/org/openbravo/pos2/process/TerminalTypeUserConfigurationLoader.java
M web-jspack/org.openbravo.pos2/src/model/setting/hooks/UpdateTerminalTypeUserConfiguration.js
---

- Issue History
Date Modified Username Field Change
2024-03-20 13:06 ngarcia New Issue
2024-03-20 13:06 ngarcia Assigned To => Retail
2024-03-20 13:06 ngarcia OBNetwork customer => Gold
2024-03-20 13:06 ngarcia Triggers an Emergency Pack => No
2024-03-20 13:07 ngarcia Relationship added related to 0005501
2024-03-20 13:07 ngarcia Relationship deleted related to 0005501
2024-03-20 13:07 ngarcia Relationship added related to 0055010
2024-03-20 13:07 ngarcia Support ticket => 92350
2024-03-20 13:26 ngarcia File Added: DIE_Config.log
2024-03-26 15:17 guilleaer Status new => acknowledged
2024-03-27 09:51 SABARINATH P Assigned To Retail => SABARINATH P
2024-03-27 12:35 SABARINATH P Status acknowledged => scheduled
2024-04-12 07:21 hgbot Merge Request Status => open
2024-04-12 07:21 hgbot Note Added: 0163123
2024-04-18 12:23 hgbot Merge Request Status open => approved
2024-04-18 12:23 hgbot Note Added: 0163363
2024-04-18 12:23 hgbot Resolution open => fixed
2024-04-18 12:23 hgbot Status scheduled => closed
2024-04-18 12:23 hgbot Fixed in Version => 24Q3
2024-04-18 12:23 hgbot Note Added: 0163364
2024-04-18 12:41 marvintm Status closed => new
2024-04-18 12:41 marvintm Resolution fixed => open
2024-04-18 12:41 marvintm Fixed in Version 24Q3 =>
2024-04-18 12:42 marvintm Status new => acknowledged
2024-04-18 12:42 marvintm Status acknowledged => scheduled
2024-04-18 12:42 marvintm Status scheduled => resolved
2024-04-18 12:42 marvintm Fixed in Version => 24Q3
2024-04-18 12:42 marvintm Resolution open => fixed
2024-04-18 12:42 marvintm Review Assigned To => marvintm
2024-04-18 12:42 marvintm Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker