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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0055011
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] POSmajorunable to reproduce2024-03-20 13:062024-04-12 07:21
ReporterngarciaView Statuspublic 
Assigned ToSABARINATH P 
PriorityurgentResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
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 scheduledRajesh_18 OBPOS2_UpdateTerminalTypeUserConfiguration value should be included in the Types of data to be synchronized in Web POS reference 

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

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2563 [^]

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker