Skip to main content

Hi,

I’m getting following error when trying to activate a data mart,
The following error occured while refreshing Information Sources; "Error while refreshing Data Mart Source (GL_TRANSACTION_MVT) - resource busy and acquire with NOWAIT specified or timeout expired"

Is there a way to stop the previous 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

Reply


Terms & ConditionsCookie settings