Forum Discussion

RemiOvstebo's avatar
RemiOvstebo
Brass Contributor
Aug 01, 2017
Solved

Analysis Services connector ruined in 1707? Crashes every time

After updating to Version 1707 (8326.2052) today Excel crashes when trying to connect to OLAP cubes (SSAS - Analysis Services). 

 

We have tried creating new connections with no luck. Excel crashes every time. We have tested on several lenovo models, 450s, X1 Carbon, X1 Yoga. All crashes. 

 

Anyone else experienced or able to confirm the existance of this bug? 

 

26 Replies

  • Olaf Hubel's avatar
    Olaf Hubel
    Iron Contributor

    Thank you for reporting it, will sent it to the right people and keep you updated. 

     
  • Thomas Dooley's avatar
    Thomas Dooley
    Copper Contributor

    Hello all,

     

    We have also had to downgrade for now. We have been looking at this with Microsoft premier support and after numerous attempts at a fix we have only been left with either downgrading or changing from Current Channel to Elite Ring which we did not want to do because of the huge jump in versions.

     

    We have however been assured a hotfix is being worked on as we speak by the MS product group and will be released soon. I pointed my MS premier support advisor towards this discussion also and its been added to the case.

     

    If I hear when the hotfix is out I will update again.


    All the best.

  • Robin Henry's avatar
    Robin Henry
    Copper Contributor

    Same issue here since latest update.
    Downgraded to previous office version as mentioned previously and it worked.

    "C:\Program Files\Common Files\microsoft shared\ClickToRun\officec2rclient.exe" /update user updatetoversion=16.0.8229.2073

    • Rafael Jimenez's avatar
      Rafael Jimenez
      Copper Contributor

      Thanks Robin, works flawlesly

       

      Now the big question, how we could know when this issue will be solved?

       

       

    • Jason Page's avatar
      Jason Page
      Copper Contributor

      run as user or run as admin? we don't generally allow office updates as is deployed through system centre. will this still work?

      • Robin Henry's avatar
        Robin Henry
        Copper Contributor
        I've admin rights on my machine although I didn't need to run the cmd as admin
  • Jason Page's avatar
    Jason Page
    Copper Contributor

    Any feedback on this. Analysis Cubes still not working, yet somehow inconsistent. we have many users that did update to the 1707 version that do not have issues. there is no similarities between the ones that are not working and the ones that are. 

  • We've got the same problem today. Excel crashes after connecting/updating data from SSAS.

     

    Crash report from the Windows Eventlog:

     

    Faulting application name: EXCEL.EXE, version: 16.0.8326.2052, time stamp: 0x596eb1b1
    Faulting module name: ntdll.dll, version: 10.0.15063.447, time stamp: 0xd51d5c5e
    Exception code: 0xc000071f
    Fault offset: 0x00093517
    Faulting process id: 0x3ad8
    Faulting application start time: 0x01d30ad4b449283d
    Faulting application path: C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
    Faulting module path: C:\WINDOWS\SYSTEM32\ntdll.dll
    Report Id: a8d02573-0ee8-455c-85ce-af4745ddc9b8
    Faulting package full name:
    Faulting package-relative application ID:

     

    The problem exists on X64 and X86. 

     

    What we've tried:

    New Connections

    Other User

    New Office Install (X86 and X64)

    Disabling Addins 

    Excel Safemode

     

    • Thomas Dooley's avatar
      Thomas Dooley
      Copper Contributor

      We have the same here even with the latest update 8326.2062. We can create Analysis Service data sources ok but soon as these are refreshed Excel closes with the same event log error. 

       

      Can you guys see if you get the same still on the very latest 2062? We are on current channel updates.

      • Thomas Dooley's avatar
        Thomas Dooley
        Copper Contributor
        Just to add we have raised this with our premier support Microsoft TAM so will update this as we get any headway.

Resources