Troubleshooting Qlik Replicate Error: Capture Loop Failure Fetching data from SAP ODP.

[MrunalsinhP]

"Hello Team,

I'm encountering an error in Qlik Replicate while attempting to fetch data from SAP ODP. The error message states 'Capture loop failed: Failed to fetch ODP data for '2LIS_13_VDITM'.

We have 'apply changes' and 'store changes' enabled for this task, with full load turned off.

The error details include:
- Return type: E, Return row: 0, ID: SODQ, number: 013, Message: Error while accessing
- Return type: E, Return row: 0, ID: RODPS_SAPI, number: 010, Message: Error with extractor call RSC1_INIT_BIW_GET
- Return type: E, Return row: 0, ID: SODQ, number: 666, Message: An exception with the type CX_SY_DYN_CALL_ILLEGAL_FUNC was raised, but was not handled locally or declared in a RAISING clause.
- Return type: E, Return row: 0, ID: SODQ, number: 666, Message: Function call failed; could not find the function as source sap odp

Could you please advise on steps to resolve this issue? Additionally, what actions can be taken to ensure successful data retrieval from SAP using Qlik Replicate?

Thank you for your assistance."

[MrunalsinhP]

TLDR:

Can you help me specify where exactly the error lies? is it in the SAP Side?( SAP Hana BW / SAP ODP Framework  ).we tried redoing pre requisities and havent found anything missing

Context:

We are using SAP ODP as source  and Google BigQuery as target and we want to Load the table source  '2LIS_13_VDITM'.

we tried performing full load tasks and it successfully loads the table but when we do 'Apply Changes' and 'Store Changes' Task we are facing the above error:

Can you help me specify where exactly the error lies? is it in the SAP Hana BW / SAP ODP Framework 

Notes: We have followed all pre requisities given in the qlik documentation November 2023.

[DesmondWOO]

Hi @MrunalsinhP ,

Return type: E, Return row: 0, ID: SODQ, number: 666, Message: Function call failed; could not find the function as source sap odp.

Could you check with SAP administrator whether the function module exists in your system and is activated?

If problem still persists, I would recommend submitting a support ticket.

Regards,
Desmond

[Bill_Steinagle]

@mru1 

Thank you for the post to QDI Forums. When you run in an issue with the SAP ODP Endpoint you can ask the SAP Admin to check the Subscription for the Task to check the Job Log of the request to see what the error is. Once the issue is checked the as noted from Desomnd the SAP Admin should be able to help address. From looking this over this looks to be a Delta issue if you are trying to do CDC from SAP ODP Table/Object and if its not Delta enabled in SAP an error can occur. 

As in general if you are using the SAP ODP Endpoint and a Task runs into an issue you want to engage the SAP Admin to have the Task which shows in SAP ODQMON with the job information of the Task from Replicate. Hope this is helpful before you open a case with Support.

Regards,

Bill Steinagle

[Chirag_]

Hello Team, 

we are using the same environment settings and we are facing latency issues when we are running APPLY CHANGES Tasks:

Following Screen snip shows how latency is increasing  steadily without incoming transaction that  on Target Side.

Any insights on this problem would be helpful:

 

Thanks in advance,

Chirag