SAP Customer checkout - cutting derby database

[former_member304491]

Hello,

We have some performance problems on compuers running Customer checkout. The number of receipts in one station is about 30.000.

Is there any chance to cut the local derby database and let's say delete some old receipts? We don't really need them localy, they are already posted in SAP Business One.

Best regards

Daniel

[anderson_schmitt · Accepted solution]

Hello Daniel,

There is a feature in the CCO that allows you to delete sales data from the database.

You can find it under Configuration > About > Destruction of data

Using this option, you can delete the sales data.
For further information, please, review the documentation below

https://help.sap.com/viewer/71570024ae3843f08a10d68054192d3d/2.0.7/en-US/75f2970a52db44fc9f17827e158...

If your question in answered, kindly select the answer as "Right Answer". This helps other member of the community to follow and easily locate answers.

Regards,
Anderson

[former_member304491 · Accepted solution]

Hello Aderson,

Thanks for the tip, I must have missed that somehow.

Unfortunately I get following error when I try to delete reciepts by "Destruction of data". Any Idea?

"Deleting of data failed

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.1.v20171221-bd47e8f): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: DELETE on table 'RECEIPT' caused a violation of foreign key constraint 'RCPTPRDCLSNGFKRCPT' for key (22b23c7a-66cf-4d6b-98df-9157d8141694). The statement has been rolled back.

Error Code: 20000"

Regards,

Daniel

[anderson_schmitt]

Hello Daniel,

I suggest you to open an incident to SAP Support.

If you are a SAP BusinessOne partner/customer, then you can create the ticket from SAP Business One Portal: Component SBO-INT-CCO

If you are not using SAP BusinessOne, you can report tickets directly from the SAP Incident reporting system: Component IS-SE-CCO

However, you also have the possibility to access the CCO database and check it. Review this documentation to access the CCO Database.
https://partneredge.sap.com/en/library/assets/products/cust_mng/scc/implement/scc_using_b1/tr_p_feat...

Before you execute any SQL statements, create a backup of the database.

Regards,

Anderson