Data Mart : Stop Previous Refresh Job

Hi ​@himasha.abeywickrama 
Are you getting this error when refreshing through the scheduled job or when directly refreshing in “entity-info incremental load” page?
If there is an background job for the scheduled task in “executing” state you can kill that.
Also check the “Refresh in Progress” flag in “entity-info incremental load” page. If that is “yes” and a refresh is not ongoing you can change the status using “Reset Refresh Status” command.

Best regards,

Subash

Hi ​@subashfestus,

I’m getting this error when trying to refresh the entity through entity info incremental load page. I reset the Refresh Status but i’m still getting the error. I believe the oracle session is still intact even after the refresh status is reset.

Thanks and best regards,
Himasha Abeywickrama

Hello, 

Did Get a solution for this issue ? i have the same Issue and can’t resolve it :(

Hi ​@jzouaoui 
Are you also getting the “resource busy” issue?

Are you doing the refresh through a background job or through the “entity-info incremental load” page?

Refreshing facts with considerable amount of data is not recommended through the “refresh” command. You should always go for a background job based refresh using a data mart refresh category.

Follow these steps..

• If there is an background job for the scheduled task in “executing” state you can kill that.
• Also check the “Refresh in Progress” flag in “entity-info incremental load” page. If that is “yes” and a refresh is not ongoing you can change the status using “Reset Refresh Status” command.
• After that try to schedule the refresh and check.
• Good to have the “incremental load log” enabled, so that we can see how far the refresh job progresses.

BR,

Subash