Solved

Data Mart Source Error on Refresh

  • 31 January 2021
  • 2 replies
  • 255 views
R
Rank
Userlevel 7
Badge +18

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

icon

Best answer by Nisansala Liyanage 28 April 2021, 14:15

View original
This topic has been closed for comments

2 replies

Yasas Kasthuriarachchi
Rank
Userlevel 7
Badge +30

Hi @johnw66,

Is this  a duplicate of following or a different scenario?

Thanks & Best Regards,
Yasas

N
Rank
Userlevel 4
Badge +8

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