error: 1615 on entering records to MsiAssembly and MsiAssemblyName tables in msi database

Question

I am facing problem: while adding entries to MsiAssembly and MsiAssemblyName Table of msi database using MsiOpenDatabaseView() method it is justing failing with the error code - 1615. This is the case with only these two tables. At First I thought It would be due to the reason that I dint change the Application Type to .NET. but after changing that also it is not working. Then I tried updating _Validation table for the entries of MsiAssembly and MsiAssemblyName tables. It too dint work out. Probably I am missing some dependency which is hindering the records to be entered in MsiAssembly and MsiAssembly Tables. can u give me some clue or hint about this problem?????? thanks.

Answer 1

Error 1615 is "SQL query syntax invalid or unsupported". Without seeing your query, my first guesses would be that the table is not present in the .msi file you are trying to edit, or you are trying to do something that the Windows Installer SQL syntax does not properly support. (For complicated queries I prefer using record-based updates through MsiVewModify() wherever possible.)

For the insert in your error message you can verify the table exists by verifying

MsiDatabaseIsTablePersistent(hDatabase, TEXT("MsiAssembly")) == MSICONDITION_TRUE

If it does not, you can add it, either though a call to MsiDatabaseImport (pass it a file created from MsiDatabaseExport), or through the correct CREATE TABLE ... SQL query.

Then I would prefer insert code along the lines of the following (error checking elided for clarity). It can provide error information at several steps along the way instead of lumped all into the MsiViewExecute call of the raw SQL approach.

PMSIHANDLE hView, hRec;
MsiDatabaseOpenView(hDatabase, TEXT("SELECT * FROM `MsiAssembly`"), &hView);
MsiViewExecute(hView, NULL);
hRec = MsiCreateRecord(5);
MsiRecordSetString(hRec, 1, TEXT("Abc.dll"));
MsiRecordSetString(hRec, 2, TEXT("MainApp"));
MsiRecordSetString(hRec, 3, TEXT("Abc"));
MsiRecordSetString(hRec, 4, TEXT(""));
MsiRecordSetInteger(hRec, 5, 0);
// note: if modifying during installation, use MSIMODIFY_INSERT_TEMPORARY instead
MsiViewModify(hView, MSIMODIFY_INSERT, hRec);