Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How To Troubleshoot Unexpected Error Live Connect to SSAS OLAP Database

My team is having a hard time getting all of our cubes to be able to be used in Power BI.  Many work just fine but when we try to connect to others in the desktop we get "An error occurred while loading the model for the item or data source 'QuerySystemError'. Verify that the connection information is correct and that you have permissions to access the data source.

 

Our DBAs setup a profiler session trying to see if there was anything to give a hint as to why we are getting the error message.

 

1) Here is the event ID raised on the SSAS server in the Application log at the OS level:

 

Log Name:      Application

Source:        MSSQLServerOLAPService

Date:          12/27/2017 9:18:29 AM

Event ID:      22

Task Category: (256)

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      XXX

Description:

The description for Event ID 22 from source MSSQLServerOLAPService cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

 

If the event originated on another computer, the display information had to be saved with the event.

 

The following information was included with the event:

 

Internal error: An unexpected exception occurred.

 

the message resource is present but the message is not found in the string/message table

 

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="MSSQLServerOLAPService" />

    <EventID Qualifiers="49408">22</EventID>

    <Level>2</Level>

    <Task>256</Task>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2017-12-27T15:18:29.000000000Z" />

    <EventRecordID>475867</EventRecordID>

    <Channel>Application</Channel>

    <Computer>XXX</Computer>

    <Security />

  </System>

  <EventData>

    <Data>Internal error: An unexpected exception occurred.</Data>

  </EventData>

</Event>

 

 

2) Here is the error text logged to the msmdsrv.log file on the SSAS server:

 

(12/27/2017 9:18:30 AM) Message:  (Source: \\?\Z:\SQLMountPoint\SQLTLogs\ASLogs\msmdsrv.log, Type: 3, Category: 256, Event ID: 0xC1000016)

 

  

3) The file FlightRecorder_20171222.trc was capture and the DBAs noticed Error # -1056964586 while the connection was trying to be made from Power BI Desktop.

 

What can we do to try to figure out what Power BI doesn't like about this cube?

 

Thanks

 

11 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

     

    Please refer to this documention that solves the exact same issue with yours. It seems your DBA needs to upgrade the SQL Server or applies a workaround.

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

      I will have our DBAs check our current SP levels for the SSAS 2012 servers we are accessing.  Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable

        So SP4 for SSAS 2012 was applied and we are still getting the same error message when trying to connect to the cube from the Power BI Desktop.  Running traces again.