Thursday, August 23, 2007

SQL query syntax invalid or unsupported - solution

Here is a solution to a problem that is described more in detail in this thread: http://discussion.autodesk.com/thread.jspa?threadID=603521

The problem is related to deployment of AutoCAD 2008 using group policy (GPO). The event error is having ID 107 and the description "Software Installation was unable to read the MSI file \\path\acad.msi. The following error was encountered: SQL query syntax invalid or unsupported." ERROR_BAD_QUERY_SYNTAX 1615 might also show up in some logs.

The solution is to use Orca that can edit the MSI file.

Download the free Orca from http://go.microsoft.com/fwlink?linkid=55774

Orca is a GUI .msi file editor that is provided with the Windows Installer
SDK. It provides full access to the Windows Installer database tables.

A set of Help files are provided with Orca. To obtain the orca.exe and Orca
documentation you must download and install the Windows Installer SDK, which
is provided as an Orca.msi file. After you install the Microsoft Windows
Software Development Kit (SDK), double click the Orca.msi file to install
Orca. (Installing the SDK can take quite a long time, up to 30 minutes. Make sure to deactivate your antivirus during the installation. You can also only install the minimum needed that includes Orca.msi.)

image

Orca.Msi is then typically found here:
C:\Program Files\Microsoft SDKs\Windows\v6.0\Bin

Run Orca and open the MSI file
Select Tables>Add table>select and add the Upgrade table.
Save the MSI file

That's it.

Trivia. Did you know that that Orca is the acronym for One Really Cool App. The story of Orca.

1 comment:

  1. Restored comments

    Anonymous said...

    Thanks for the tip on this!
    Do we know why it occurs (it's not 100% of the time, as some deployments worked fine and some didn't.
    April 04, 2008

    JTB World said...

    I don't know why it happens or I have forgot it.
    April 04, 2008

    ReplyDelete