Error:This replication task needs a long time to be executed. Please check the Data Provisioning Monitoring UI for further status updates

Updated May 18, 2018

Hey SAP Experts

While creating a replication task for a large source table using HANA SDI an error “This replication task needs a long time to be executed. Please check the Data Provisioning Monitoring UI for further status updates.” appearing on my screen.

Please help me to resolve this problem.

Comments

09 Sep 2016 6:11 pm Nitesh Singh Best Answer
The error is because HANA is out of memory while processing the Initial Load for the Replication Task. It can be resolved by partitioning Initial Load on HANA memory for Replication Task.
Please follow the below steps for partitioning Initial Load:
1.Create and Save (do not execute) the replication task as needed
2.Check your source data to find out the best column for partitioning (limited number of values with relatively equal distribution)
3.Edit the stored procedure generated as a result of reptask creation . It will be like sap.hana::<reptask name>.START_REPLICATION
4.Remove the START TASK statement and add INSERT statements based on 'WHERE' clauses after the QUEUE command.
5.Partition the data according the required numbers of groups, but always keep in mind that atleast one exists as a default
Example:
- INSERT INTO "<schema name>"."<physical table name>" (SELECT * FROM "<schema>"."<virtual table name>" WHERE fisc_year='2009');
- INSERT INTO "<schema name>"."<physical table name>" (SELECT * FROM "<schema>"."<virtual table name>" WHERE fisc_year='2010');
- INSERT INTO "<schema name>"."<physical table name>" (SELECT * FROM "<schema>"."<virtual table name>" WHERE fisc_year='2011');
- INSERT INTO "<schema name>"."<physical table name>" (SELECT * FROM "<schema>"."<virtual table name>" WHERE fisc_year!='2011', '2010','2009');
6.At last save and execute the replication task stored procedure