Skip to Content
0
Aug 29, 2023 at 01:23 PM

SAC to IBP - Filter on IBP Value in query panel errors

98 Views

We have a connection to IBP from our SAC tenant which all works correctly.

However, when filtering on any measures within the query it fails with and error during the data refresh. If we remove the filter 'measure > 0' (as an example) the import or refresh works fine.

This seems to be a new error as our models have refreshed successfully for several months.

Example error message below -

The following error message comes from the external data service: SAC request UUID: ec31b3cb200c49a4ba656a7196b78385, IBP Query UUID: nullstatus: 400 body: {"error":{"code":"/IBP/CX_BO_EXTR_FILTER_TREE","message":{"lang":"en","value":"Error in $filter formulation"},"innererror":{"application":{"component_id":"SCM-IBP-INT-ODT","service_namespace":"/IBP/","service_id":"EXTRACT_ODATA_SRV","service_version":"0001"},"transactionid":"CDFDD495EC500180E0064EDC8C5C58CC","timestamp":"","Error_Resolution":{"SAP_Transaction":"","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"ContentID":"","code":"/IBP/CX_BO_EXTR_FILTER_TREE","message":"Error in $filter formulation","propertyref":"","severity":"error","transition":false,"target":""},{"ContentID":"","code":"/IBP/CX_BO_EXTR_KF_ASYNC_READ","message":"An exception was raised","propertyref":"","severity":"error","transition":false,"target":""},{"ContentID":"","code":"/IBP/CX_BO_EXTR_KF_ASYNC_READ","message":"An exception was raised","propertyref":"","severity":"error","transition":false,"target":""},{"ContentID":"","code":"/IWBEP/CX_MGW_BUSI_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","transition":false,"target":""}]}}}

Has anyone in the community come across this issue and found a fix?