Datasphere replication flow Initial load in progress (retrying)

[Arvind_Sharma1]

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

[EmiliaFij · Accepted solution]

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 

[Arvind_Sharma1 · Accepted solution]

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

[Vinieth · Accepted solution]

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

[EmiliaFij · Accepted solution]

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

[samuele88 · Accepted solution]

Hi, Any answer from SAP?

[Vinieth · Accepted solution]

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.

[shubham521]

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. 

[Arvind_Sharma1]

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  

[bheemeshRao]

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

[bheemeshRao]

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

[samuele88]

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