Forum Discussion

WithwindOK's avatar
WithwindOK
Advocate I
9 months ago
Solved

Data refresh error

In the September 2025 version, during data refresh, multiple reports randomly reported errors similar to the following: SessionID: fb9f202c-e4cf-4504-b604-0f52f95b86ab [0] 0: Couldn't find database:...
Report
  • v-dineshya's avatar
    v-dineshya
    9 months ago

    Hi WithwindOK ,

    Please try the troubleshooting steps, which i was suggested in my previous response. In addition to that, Colud you please try the below steps to fix the issue.

     

    1. Please check the RSPortal, RSService, and AS logs at the time of the failure. check for memory pressure, timeouts, or model loading errors.

     

    2. Check the server hosting PBIRS has sufficient RAM and CPU. Increase the MaxMemoryLimit setting in RSHostingService.config.

     

    3. If multiple reports are refreshing simultaneously, try to refresh one by one report to reduce load.

     

    4. Use the latest PBIRS version. Sometimes bugs in older versions cause intermittent issues.


    5. Large models may fail to load under constrained resources. remove unused columns and aggregate the data.

     

    6. Re-upload the affected reports to PBIRS. Validate that the model loads correctly in PBIRS after upload.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

tayloramy's avatar
tayloramy
Super User
9 months ago

Hi WithwindOK, 

 

Can you share screenshots of the error?  

 

Is this error happening in desktop, or only once you upload it to report server? 

What are your data sources? 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

WithwindOK's avatar
WithwindOK
Advocate I
9 months ago

This error only occurs when uploading to PBIRS; refreshing in Desktop works fine. The data source is Oracle Database 19c, and a manual refresh can complete successfully.

    • WithwindOK's avatar
      WithwindOK
      Advocate I
      9 months ago

      The Oracle client is installed correctly. Please note that the refresh fails randomly—not every time—and the reports that fail are also random.

      • tayloramy's avatar
        tayloramy
        Super User
        9 months ago

        Hi WithwindOK, 

         

        Right, I forgot that this was an intermittent issue, which are usually the worst kind of issues to troubleshoot. 

         

        Ensuring that the client is installed and the server can conect to the Oracle database is about the limit of my Oracle troubleshooting abilities, I work in a SQL Server shop. 

         

        Are there any error logs on the Oracle side when a refresh fails? Is there a failed connection attempt or something? 

        Are there more detailed logs generated on the report server? Those should exist for sure, which might also give us some more details into what is actually happening. 


        I generally like to blame intermittent network issues like this on DNS issues, so I would also start investigating that, but I have no basis for that claim.