Forum Discussion

Dearc's avatar
Dearc
Icon for Helper II rankHelper II
5 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
    5 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
    5 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. 🙂

YonghunLee's avatar
YonghunLee
Icon for Helper I rankHelper I
5 years ago

But In my case, after removing the "enter data", still there is error on refreshing on the server.

 

error message is like this.

 

no problem with previous version.     and desktop update with new version

 

SessionID: a31e4ae3-8034-47af-b979-c4ee6756dc1c
[0] -1055784932: Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.