cancel
Showing results for 
Search instead for 
Did you mean: 

CCO Manager API - Unable to perform request "/internal/sync/materials/bulk"

former_member771346
Participant
0 Kudos
358

For a simple test in order to develop a B1if scenario to POST data into CCO Manager with the API, i'm unable to update an existing material info (or to create a new one) using the "/internal/sync/materials/bulk".

I'm getting the following error (not very detailed) :

I've already checked error log file, unfortunately it doesn't enlighten me in any way...
I followed SAP Note 3014950 in order to perform authentication and was able to retrieve data with request GET "/internal/sync/materials".

I tried the payload given in the example of the API as well the one present in file "internalsyncmaterialsbulk Call OK.txt" of SAP Note referred above.

I'm currently running out of ideas for troubleshooting, would appreciate any feedback on the issue.

CCO Manager version is 2.0 FP12.


Note: I found a similar post of baigalmaa but unfortunately it's already closed, otherwise i would ask there.

Regards, João Ferreira.

Accepted Solutions (1)

Accepted Solutions (1)

former_member771346
Participant
0 Kudos

Hi everyone, i was able to solve my problem after a deep look into the logs (something basic went over my reading).


After looking at the error given in the logs and searching about it, i came accross with the followin post.

This error occurs on Hana systems, where a field "DATA" at table "MASTER_DATA_PAYLOAD_MATERIAL" column is set to NVARCHAR(255) and must be set as NLOB.

A simple data type change of the column solve the error:
ALTER TABLE <Database>."MASTER_DATA_PAYLOAD_MATERIAL" ALTER ("DATA" NCLOB);


The result of the request came in as expected:


Hope this post helps anyone with similar problems.

Regards,

João Ferreira.

Answers (0)