Skip to main content
Solved

Data Mart Source Error on Refresh

  • January 31, 2021
  • 2 replies
  • 333 views
R
Superhero (Partner)
Forum|alt.badge.img+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

Best answer by Nisansala Liyanage

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

This topic has been closed for replies.

2 replies

Yasas Kasthuriarachchi
Superhero (Employee)
Forum|alt.badge.img+30

Hi @johnw66,

Is this  a duplicate of following or a different scenario?

Thanks & Best Regards,
Yasas

N
Hero (Partner)
Forum|alt.badge.img+9

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 settingsAccessibility statement