Ending A Windows Installer Transaction Event Id 1042

 admin

If you are on SQL Server 2012 SP1 (11.0.3000) and you notice the Windows Application log filling up with MSI Installer events:

Ending a windows installer transaction event id 1042 code

The Windows Installer windows just comes up then disappears. Event Viewer shows: Event ID 1040: Beginning a Windows Installer transaction: D:DocumentsdownloadstmpEDMarketConnectorwin210.msi. Client Process Id: 1516. Event ID 1042: Ending a Windows Installer transaction. May 05, 2019 Ending A Windows Installer Transaction Event Id 1042 Posted on 5/5/2019 by admin BULLDOZERS –TRACKED- OVAL DRIVE Bulldozers are used to push soil, rocks, trees, and other materials with its large front blade. 1.2.3.1.

Windows
  • Information / Event ID 10000 / RestartManager / Starting session 0 – YYYY-MM-DDTHH:mm:sss.xxxxxxxxxxxxxxxxxx.
  • Information / Event ID 11724 / MsiInstaller / Product: SQL Server 2012 Management Studio — Install started.
  • Information / Event ID 11728 / MsiInstaller / Product: SQL Server 2012 Management Studio — Configuration completed successfully.
  • Information / Event ID 1035 / MsiInstaller / Windows Installer reconfigured the product. Product Name: SQL Server 2012 Management Studio. Product Version: 11.1.3000.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 0.
  • Information / Event ID 1040 / MsiInstaller / Beginning a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: XXXX.
  • Information / Event ID 1042 / MsiInstaller / Ending a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: XXXXX.
  • Information / Event ID 10001 / RestartManager / Ending session 0 started YYYY-MM-DDTHH:mm:sss.xxxxxxxxxxxxxxxxxx.
  • Warning / Event ID 1004 / MsiInstaller / Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’, component ‘{0CECE655-2A0F-4593-AF4B-EFC31D622982}’ failed. The resource ” does not exist.
  • Warning / Event ID 1001 / MsiInstaller / Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’ failed during request for component ‘{6E985C15-8B6D-413D-B456-4F624D9C11C2}’

If you have the above symptoms, please look at this non-security hotfix KB download: http://www.microsoft.com/en-us/download/details.aspx?id=36215.

Do not install if you have already applied any post SP1 hotfixes, such as SP1 CU1.

Installing that fix will bring your SQL version to 11.0.3128, fix the problem with the MSI installer, and it should drop your CPU consumption a bit as well.

Ending A Windows Installer Transaction Event Id 1042 Program

Ending A Windows Installer Transaction Event Id 1042

Ending A Windows Installer Transaction Event Id 1042 2017


If you are SQL Server 2012 is running with SP1 (11.0.3000) you may encounter the below error messages in the windows application event log and it may cause high cpu pressure on the machine
In Windows Event Viewer
SQL_Tools_ANS component failed, The resource doesn't exist
SQL_Tools_ANS failed during request for component
Event ID 1004 MSIInstaller / Detection of Product {xxxxxx} feature
Event ID 1040 MSIInstaller / Beginning a windows installer transaction {xxxxxxxxx}
Event ID 1042 MSIInstaller / Ending a windows installer transaction {xxxxxxxxx}
Resolution
Please install CU1 on top of SQL Server 2012 SP1, Build No - 11.0.3128 will fix the MSIInstaller issue and high cpu issue.