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

Description

getProcessIdForAudit 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 Reproduce

Set 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 Solution

In 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

Tags

No tags attached.

Attached Files

DIE_Config.log [^] (52,187 bytes) 2024-03-20 13:26

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0055010		closed	Rajesh_18	OBPOS2_UpdateTerminalTypeUserConfiguration value should be included in the Types of data to be synchronized in Web POS reference
depends on	backport	0055237	24Q2	closed	SABARINATH P	getProcessIdForAudit for TerminalTypeUserConfigurationLoaderProcessor is returning a value higher than 32 and it fails
depends on	backport	0055238	24Q1.2	closed	SABARINATH 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	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: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	Note Added: 0163123
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