Technical Error: null Checkout

[jsarciniegasg]

Hi Dear SAP Experts,

One of our clients is facing a situation in some of their POS, the error is shown in cco as technical error and it happens creating tables apparently, in the command prompt i have noted a particular error "tried to rollback on inactive transaction!!!677601619:0" but i have not been able to identify what maybe the root cause of the error, but after restarting CCO, the error disappears and it is possible to continue working normally. Here i show you a part of the log

2022-04-01 18:53:07,476 [Atmosphere-Shared-9031] WARN com.sap.scco.ap.pos.dao.CDBSession - tried to rollback on inactive transaction!!!677601619:0

2022-04-01 18:53:07,476 [Atmosphere-Shared-9031] FATAL com.sap.scco.ui.servlets.AbstractController - Technical Error: null

java.lang.reflect.InvocationTargetException: null

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_171]

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_171]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_171]

at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_171]

at com.sap.scco.ui.servlets.AbstractController.handleAction(AbstractController.java:295) [classes/:?]

at com.sap.scco.ui.servlets.AbstractController.processRequest(AbstractController.java:229) [classes/:?]

at com.sap.scco.ui.servlets.AbstractServlet.processPostRequest(AbstractServlet.java:253) [classes/:?]

at com.sap.scco.ui.servlets.AbstractServlet.onRequest(AbstractServlet.java:756) [classes/:?]

at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:225) [atmosphere-runtime-2.4.29.jar:?]

at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:114) [atmosphere-runtime-2.4.29.jar:?]

at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) [atmosphere-runtime-2.4.29.jar:2.4.29]

at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2300) [atmosphere-runtime-2.4.29.jar:?]

at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:594) [atmosphere-runtime-2.4.29.jar:2.4.29]

at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) [atmosphere-runtime-2.4.29.jar:2.4.29]

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_171]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_171]

at java.lang.Thread.run(Unknown Source) [?:1.8.0_171]

Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL181220175521640' defined on 'CONCESSION_TABLE'.

Error Code: 20000

Call: INSERT INTO CCO.CONCESSION_TABLE (OBJECTKEY, CREATEDAT, CREATEDBY, ID, LAST_TABLE_INDEX, MODIFIEDAT, MODIFIEDBY) VALUES (?, ?, ?, ?, ?, ?, ?)

As additional info, the client environment consists 6 CCOM used for different locations and 1 CCOM consolidator, the error is happening only with POS connected to 1 specific CCOM for locations, in the POS connected to other CCOM the issue dos not happen.

CCO Client Version FP 09 PL221737638-error-technicos.jpg

CCOM Version FP 09 PL22

I appreciate any reply.

Thank you

Regards

Jhon Sebastián.

[anderson_schmitt]

Hi Jhon,

I'm doing well, thanks. Hope you too!

The recommended collation is SQL_Latin1_General_CP1_CS_AS

Refer to the documentation for further information

I found a similar issue reported and the cause of the issue was the incorrect database collation.

Regards,
Anderson

[jsarciniegasg]

Hi Anderson,

Hope you are well!

The database collation is Latin1_General_100_CI_AS, is the same as the others unaffected CCOM.

Should i try other collation?.

Thanks for your collaboration.

Regards

Jhon Sebastián.

[anderson_schmitt]

Hi Jhon,

What is the collation used in your SAP Customer Checkout manager database?

Regards,
Anderson