on 2022 Nov 18 4:59 PM
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.
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
19 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.