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?
Question
Data Mart : Stop Previous Refresh Job
Hi
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.