SAP Knowledge Base Article - Preview

3692260 - IBP: Error "You filtered for property SCNID in $filter more than once" received when using /IBP/EXTRACT_ODATA_SRV service

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

SAP Analytics Cloud all versions ; SAP Integrated Business Planning all versions

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.