Openbravo Issue Tracking System - POS2
The Data Import Entry related doesn't change to Error and it is always being processed
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
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
| 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 |
DIE_Config.log (52,187) 2024-03-20 13:26https://issues.openbravo.com/file_download.php?file_id=19571&type=bug