SAP Knowledge Base Article - Preview

3248983 - "SOP SQL conversion stored procedure returned with error" error occurs while reading from IBP - SAP Cloud Integration for Data Services

Symptom

  • The following error occurs while reading from IBP in CI-DS task/process:

    DATAFLOW: SOP SQL conversion stored procedure returned with error. details=SOP SQL conversion stored procedure returned with error[Status:'7']. details=one of the period attributes should be requested when requesting TSTFR and TSTTO jobRunID = <run ID> Data Services Engine received error message from server. URL: https://<tenant>.com/DSoD/agentmanager/reader, Error message: Failed to read from HANA Cloud Source DataStore : SOP SQL conversion stored procedure returned with error. details=SOP SQL conversion stored procedure returned with error[Status:'7']. details=one of the period attributes should be requested when requesting TSTFR and TSTTO jobRunID = <run ID>.

  • The same task/process completes successfully on older agent versions.
  • The same task is returning different number of records when it is executed on agent version older than 1.0.11.4888 and executed on agent version 1.0.11.4888 or newer.
  • Task/process reading data from the IBP (source) is not returning the same amount of data as before (could be zero or less data than before) after upgrading the CPI-DS agent


Read more...

Environment

SAP Cloud Integration for Data Services 1.0.11.4888 or newer

Product

SAP Cloud Integration for data services 1.0

Keywords

LOD-HCI-DS, CI-DS, CPI-DS, SCM-IBP-INT-TS-DS, IBP, PERIODID, TSTFR, TSTTO, extraction , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , SCM-IBP-INT-TS-DS , CPI-DS Integration , 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.