Hi All,
I have observed this a couple of times now. Here’s what happens
-
I have scheduled incremental refresh on datasets in place
-
At times the incremental refresh fails due to issues in the underlying database
-
Once I consult with the DBA and have resolved the issue, I want to re-run the incremental refresh through the Refresh Now > Incremental Refresh option.
-
When I do that the refresh does not trigger
-
What I end up doing is to create a one-time incremental refresh schedule, which runs at the time scheduled and once that completes I delete this temp schedule
I think this is some sort of bug that needs to be resolved. I don’t see any logic why the manual refresh should not get started.
Hi
Have you configured the incremental properties properly for incremental refresh?
For more details please see follow the link.
Yes. Incremental refresh properties are setup correctly. The refresh fails due to an issue in the database. I then try to refresh manually using Refresh Now > Incremental Refresh option and that never gets triggered for some reason.
Have you tried deleting and reconfiguring the incremental refresh? First, edit the dataset and complete a full refresh. After that, you will be able to reconfigure the incremental refresh.
@Giridhar.Prabhu ,
I would recommend you log a support ticket. I tested the scenario where the refresh has not failed , and the manual incremental refresh did complete.
Another test where I renamed a table, the incremental refresh was scheduled to run at a specific time. It did fail as expected. Renamed the table and then did a manual refresh which worked.
Kind regards,
Koushik
1 Like
Thanks @Koushik_Muthanna for looking into this.
I will go ahead and raise a ticket with AWS.
