Skip to main content

When trying to refresh 3 data mart sources either individually or together  we receive the following message:

Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired

Error while refreshing Data Mart Source (CONSOL_PER_DET_BAL_MVT) - resource busy and acquire with NOWAIT specified or timeout expired

Error while refreshing Data Mart Source (CONSOL_PERIOD_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired

 

At the time of refreshing I was the only one logged int.

 

Regards

 

John

Hi @johnw66,

Is this  a duplicate of following or a different scenario?

Thanks & Best Regards,
Yasas

Hi @johnw66 ,

This scenario has been addressed in patch 154698. which is released with UPD9. In which UPD version are you in? 

The workaround given in this patch is to do a full refresh instead of an incremental refresh. You can change the load type in ‘Entity Info - Incremental Load’ window.

Best Regards,
Nisansala

Terms & ConditionsCookie settings