« New Wiki, and SBL LaTeX Papers Revisited | Main | New Gradle Plugin: DepNames »

MSQuery Error When Refreshing the Pivot Cache

Posted by: Robert Fischer on 05/07/2010

Cannot run 'MSQUERY.EXE'. The program or one of its components is damaged or missing.

Run-time error '1004'.

Sharing for the sake of desperate googlers struggling with this problem…

If you’re working in MS Excel 2007 and you’re programmatically updating PivotCaches, but you get an error about “Cannot run ‘MSQUERY.EXE’.” despite the fact that MS Query seems to be running just fine all the other times, your problem may well be because of the asynchronous updates: if two pivot caches attempt to use MS Query at the same time, the second one explodes with this error. The solution is to set pvtCache.BackgroundQuery to false, which makes the cache refresh synchronous.

This post was by Robert Fischer, written on May 7, 2010.
Comment on this post: http://enfranchisedmind.com/blog/posts/msquery-error-pivotcache/#respond
Public Permalink: http://enfranchisedmind.com/blog/posts/msquery-error-pivotcache/

This article was a post on the EnfranchisedMind blog. EnfranchisedMind Blog by Robert Fischer, Brian Hurt, and Other Authors is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.

Robert Fischer's complete blog can be found at: http://enfranchisedmind.com/blog

About Robert Fischer

Robert Fischer is a multi-language open source developer currently specializing in Groovy in Grails. In the past, his specialties have been in Perl, Java, Ruby, and OCaml. In the future, his specialty will probably be F# or (preferably) a functional JVM language like Scala or Clojure.

Robert is the author of Grails Persistence in GORM and GSQL, a regular contributor to GroovyMag and JSMag, the founder of the JConch Java concurrency library, and the author/maintainer of Liquibase-DSL and the Autobase database migration plugin for Grails.

More About Robert »