Question Re: Datasphere replication flow Initial load in progress... in Technology Q&A

Datasphere replication flow Initial load in progress (retrying)

Arvind_Sharma1 — Mon, 27 Jan 2025 10:38:51 GMT

Hi Gurus,

We are facing issue with replication flow Initial Load, running for ever with message "Initial load in progress (retrying)". Source is standard CDS view having dataExtraction.enabled: true annotation.

Please let me know if further information is needed. Thanks for your support in advance.

Best Regards
Arvind

Re: Datasphere replication flow Initial load in progress...

EmiliaFij — Mon, 27 Jan 2025 12:59:30 GMT

Hello,

I am having exactly the same issue since 2 days. After the upgrade of Datasphere. Currently having 2025.2.126 version. What is your version ?

Kind regards,

Emilia

Re: Datasphere replication flow Initial load in progress...

Arvind_Sharma1 — Mon, 27 Jan 2025 16:53:48 GMT

Hi, our version is also 2025.2.126. I am getting this issue for some of Replication Flows. Are you getting for all Replication Flows...

Best Regards
Arvind

Re: Datasphere replication flow Initial load in progress...

Vinieth — Wed, 29 Jan 2025 07:09:11 GMT

Same here...we are also getting for only some replication flows..there is a note which seems to point to authorizations..trying to see what happens https://me.sap.com/notes/3553846/E

Re: Datasphere replication flow Initial load in progress...

samuele88 — Thu, 30 Jan 2025 09:14:15 GMT

Hi,

Anyone has any idea/suggestion?

I have a replication flow on top of I_Product cds view running for over 18 hours just to load 5000 records.

Tks

Re: Datasphere replication flow Initial load in progress...

EmiliaFij — Thu, 30 Jan 2025 09:48:35 GMT

i am also getting issues with some RF. But mainly transactional CDS views breaks due to this error. We have opened SAP case.

Re: Datasphere replication flow Initial load in progress...

samuele88 — Fri, 31 Jan 2025 13:20:15 GMT

Hi, Any answer from SAP?

Re: Datasphere replication flow Initial load in progress...

bheemeshRao — Sun, 02 Feb 2025 14:07:30 GMT

Hi All,

In the s/4 system please run note analyzer t-code : CNV_NA_DI

with the new release/upgrade of Datasphere, there will be some new SAP notes that should be implemented

Regards,

Bheemesh

Re: Datasphere replication flow Initial load in progress...

Arvind_Sharma1 — Thu, 06 Feb 2025 10:54:56 GMT

Please implement all Notes, out come from t-code CNV_NA_DI and also all pre-req notes from 3254953 and 3499630.
This also depends on the S4 version.

Best Regards
Arvind

Re: Datasphere replication flow Initial load in progress...

bheemeshRao — Thu, 06 Feb 2025 14:47:19 GMT

please check with your basis team, they can apply the notes that are relevant

Re: Datasphere replication flow Initial load in progress...

Vinieth — Mon, 17 Feb 2025 11:47:11 GMT

We identified the root cause why data is not loading for I_XXXXXXX . This is due to Datasphere Model editor bug which introduced wrong datatype definition for columns IntcoExtActlTransfOfCtrlDteTme, IntcoIntActlTransfOfCtrlDteTme, IntcoExtPlndTransfOfCtrlDteTme, and IntcoExtActlTransfOfCtrlDteTme timestamp columns.

This bug has been fixed in Datasphere version 2025.3.66.

Option 1: Go to Data Builder Replication Flow editor, delete I_XXXXXXX object., add the object. Then deploy. If you do not want to delete the replication object, then follow these manual steps 2-9

2. Go to Data Builder editor

3. Use Edit -> “Export to CSN/JSON File” from the replication flow editor and export the CSN definition of the RF

4. Open the exported file, search for $DYNAMIC.decimal_undefined_undefined under the section “replicationTasks” and replace it with com.sap.core.timestamp. Repeat this for all occurrences of $DYNAMIC.decimal_undefined_undefined in the file and replace with com.sap.core.timestamp

5. After the above changes are made, save the file.

6. Navigate to Data Builder landing page and import the above file using the option Import Objects from CSN/JSON File

7. Deploy the replication flow from the landing page (Please do not deploy the replication flow from the editor)

Please note that when you modify the replication flow definition externally, you should only change the recommended fields as any wrong changes can break the replication flow.

Re: Datasphere replication flow Initial load in progress...

shubham521 — Mon, 11 Aug 2025 08:51:46 GMT

Hi @Arvind_Sharma1 ,

We also had the same issue recently with one of the replication flow. SAP provided some insights on the issue and action points to resolve it. After implementing these, all the replication flows are working fine.

1. Maintain SAP_DHCDC_DISPATCHER, SAP_DHCDC_HOUSEKEEPER scope in STJR_JOBD_SCOPE table : Both of the jobs mentioned are mandatory in ABAP / Datasphere integration scenario . We did this but still the issue was not resolved.

2. Technical user is not authorized to stop recording changes for subscriber RMS. : Please check if your technical user has the required access. We provided the authorization and the initial data started flowing. However, the RF failed after completing 90% of initial load.

3. Increase TRANSFER_MAX_JOBS parameter of /1DH/PUSH_CDS_DELTA job from 1 to 4. : After implementing this change, all the replication flows started working.

Hope this will be helpful in resolving the issue.