Symptom
Data load from SAP IBP to SAC fails when multiple versions are added in the filter parameter within one request.
Error message:
- "Couldn't create <PLANNINGAREA> query job."
- "Response from external server has status code of 400."
<... > "/IBP/CX_BO_EXTR_FILTER_TREE"
<... > "You filtered for property SCNID in $filter more than once; delete the recurrences\\\\\"},\\\\\"innererror\\\\\":{\\\\\"application\\\\\":{\\\\\"component_id\\\\\":\\\\\"SCM-IBP-INT-ODT\\\\\",\\\\\"service_namespace\\\\\":\\\\\"/IBP/\\\\\",\\\\\"service_id\\\\\":\\\\\"EXTRACT_ODATA_SRV\\\\\",\\\\\"service_version\\\\\":\\\\\"0001\\\\\"},\\\\\"transactionid\\\\\":\\\\\"<transactionid>\\\\\",\\\\\"timestamp\\\\\":\\\\\"<timestamp>\\\\\",\\\\\"Error_Resolution\\\\\":{\\\\\"SAP_Transaction\\\\\":\\\\\"For backend administrators: use ADT feed reader \\\\\\\\\\\\\"SAP Gateway Error Log\\\\\\\\\\\\\" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details\\\\\",\\\\\"SAP_Note\\\\\":\\\\\"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)\\\\\"},<...>
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP Integrated Business Planning
- SAP Analytics Cloud
Product
Keywords
ibp, sac, data load issue, extract_odata_srv, multiple version filter, version-scenario, plugin_error, response from external server, status code 400, couldn't create query job, filter recurrences, master data, transactional data, ibp to sac, scnid, data transfer, extraction, filtering, multiple, several, more, api, odata service, issue , KBA , SCM-IBP-INT-ODT , IBP Master Data and Transactional Data API services , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview