Problem with CCO Manager API Call

[cseijas]

Hello, any help will be appreciated with the following problem that we are facing with Customer Checkout API Calls.

When we try to post a Customer via API call (POST /internal/sync/businesspartners/bulk) we obtain a HTTP 500 error with "errorCode": "1", "errorMessage": "Internal Error. Please refer to log @ Sat Mar 05 13:37:34 CET 2022".

In "Inbound call monitoring app" we only obtain a generic error entry with "Error message": "Internal error".

In Apps "Master Data Queue" and "Master Data Results" there are no entries for Business Partners, however, we notice that the number range of customer is incremented with 1.

We have found in cco_error.txt files an exception like this:

ERROR com.sap.scco.cs.webapp.DefaultExceptionMapper - Exception occured:

org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction "rolled back" because transaction was set to RollbackOnly.

at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:571) ~[spring-orm-5.3.7.jar:5.3.7]

...

Caused by: javax.persistence.RollbackException: Transaction "rolled back" because transaction was set to RollbackOnly.

at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:145) ~[eclipselink-2.7.7.jar:2.7.7.v20200504-69f2c2b80d]

at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562) ~[spring-orm-5.3.7.jar:5.3.7]

... 110 more

I attach an example of the exception log found and the request that we are using.

log-example.txt

request-example.txt

[gunther_sandtner2]

Dear cseijas_minsait_2020,

Is your CCO manager running on a HANA database?

And is your CCO manager on version 2.0 FP12?

The SAP Customer Checkout team is aware of this issue. We are working to get this fixed. We will provide an update in the coming days when the fix gets finalized.

Kind regards,

Gunther

[gunther_sandtner2 · Accepted solution]

Dear cseijas_minsait_2020,

It affects installations running on HANA database.

The cause of this error is that the MASTER_DATA_PAYLOAD_MATERIAL.DATA column has type NVARCHAR. The solution is to extend the datatype from NVARCHAR to NCLOB.

• In a new installation the fix is available in CCO manager 2.0 FP12 PL09 (released already)
• In an updated installation the fix is planned for CCO manager 2.0 FP12 PL10 (yet to get released)

Kind regards,

Gunther

[former_member771346]

Hi gunther.sandtner2, just wanted to say thanks for the fix of the problem.

The following data type change was enough to be able to perform my requests:

ALTER TABLE <Database>."MASTER_DATA_PAYLOAD_MATERIAL" ALTER ("DATA" NCLOB);

Regards,

João Ferreira.

[arunparthan]

How about for PL19

[cseijas]

Hello,

Yes, this is the case. We have Hana Database with CCO manager 2.0 FP12.

Best regards,

César Seijas.