Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Error on Scheduled Refresh: Postgre DB Dataflow

Hi,

 

As the title implies, the scheduled refresh of the data flow which connects to Postgre DB performs inconsistently.

Sometimes, the error message goes away after the manual refresh, but I am not able to resolve it completely.

The below message is the error shown in the downloaded refresh history file.

 

PostgreSQL: 40001: canceling statement due to conflict with recovery.

 

Please share if there are any similar experiences/ know solutions. Thank you in advance!

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    This issue has been submitted internally.(Internal ICM ID: 266454462)

    Please be patient to wait for fixing. If there is any news, I will update it here.

     

    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Hi Anonymous !

     

    It seems your Postgre DB is in recovery state. Please verify if the DB is online & then manually kick off the scheduled refresh from Power BI Service.

     

    If the manual kick off completes successfully than monitor the next scheduled run.

     

    Regards,

    Hasham

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    This issue has been submitted internally.(Internal ICM ID: 266454462)

    Please be patient to wait for fixing. If there is any news, I will update it here.

     

    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.