Forum Discussion

Dearc's avatar
Dearc
Icon for Helper II rankHelper II
6 years ago
Solved

PBRS Oct 2020 encounter errors in scheduled refresh

Hello,  After updated to latest PBRS,  some report show errors after data refresh (MSSQL server)   2020-11-03 14:38:44.6959|INFO|49|Model Refresh: isRefreshActive=False, incoming databaseName=...
data refresh
Oct 2020
  • Dearc's avatar
    Dearc
    6 years ago

    Hello @Petebro ,

    I think i found the problem. In my hybrid models, I have 3 datasource

    1. Xlsx files

    2. SQL server

    3. Some table create by entered data

     

    I replace the entered data table with xlsx files, the refresh problem solved

  • Anonymous's avatar
    Anonymous
    6 years ago

    Issue confirmed here as well.

     

    Recreated by:

    1. Added data source sql server table for import. Tested schedule in PBIRS -> successful refresh

    2. Added small table by "Enter Data" (unrelated to table 1 from sql server). Tested schedule in PBIRS -> error

    3. Tried a combo of SQL Server import source and excel file -> Works fine.

     

    Issue seem to be related to tables generated from "Enter data". Refreshing in PBIRS encounters error, both in manual triggering of schedule and "on-clock" schduled runs. Error message returned is:

     

     

    SessionID: 864f8ded-276d-4fb2-a5f5-8af41c243372
[0] -1056505856: COM error: System.Core, Sequence contains no elements.
[1] -1055784828: The database operation was cancelled because of an earlier failure.

     

     

    This is a very critical issue that is quite hard to find. No upgrader for us unitl this is fixed... 😞

    Crossing our fingers for a buggfix in a relase coming soon. 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello,
I'm still having refresh issues, even installing the patched version of the report server
Errors messages are various but refresh is still not working:

Example 1:
SessionID: 1ac2c341-9031-403f-b2e9-4255696a4a50
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[1] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[2] -1055784828: The database operation was cancelled because of an earlier failure.

Example 2:
SessionID: b96cc89d-c112-4322-b0cd-aa1d8560acb4
[0] -1056505856: COM error: mscorlib, An item with the same key has already been added..
[1] -1055784828: The database operation was cancelled because of an earlier failure.