Build 1707 causes PivotTableCache.Refresh() to throw protected memory error

Chuck Vigeant
Occasional Visitor

We have a Com Add-In for Excel as part of our product, used by thousands, that has caused havoc since Version 1707 arrived, begining with build 8326.2058 and still a problem with build 8326.2087 


We have used this code untouched for a few years without fail, and works thru build 8229.2103 (last build of Version 1706)


For now a rollback satisfies customers, but it prevents anybody from using our demo product, as we can find no workaround.


The issue:

In short we declare/load/change variables to contain sql statements which change upon user choices, etc. and run thru a connection string "OLEDB;DSN=QQubeUser"

When we now run this command:

We get this error:

System.Reflection.TargetInvocationException occurred
  Message=Exception has been thrown by the target of an invocation.
       at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       Message=Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
System.AccessViolationException occurred
  Message=Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
       at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)

We saw another post that you guys fixed for 1707, and it may be relevant: https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/Analysis-Services-connector-ruined-in-...    You fixed their issue in build 8326.2073 but it didn't fix our situation (again through build 8326.2087)


Can you please advise on what we can do to get this bug fixed?  This is is very painful for our business, and the second bug affecting our business in the last several months. (and yes we just survived Hurrican Harvey in Houston).






Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies