Error: Installing msi on windows host

  • name: Installing MSSQL Command Line Utilities

hosts: windows

tasks:

  • name: Install MSSQLCmdLnUtils

win_package:

path: C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi
state: present

fatal: [10.0.1.183]: FAILED! => {“changed”: false, “log”: "=== Verbose logging started: 7/2/2022 3:01:42 Build type: SHIP UNICODE 5.00.10011.00 Calling process: C:\Windows\System32\msiexec.exe ===\r\nMSI (c) (B0:2C)[03:01:42:821]: Resetting cached policy values\r\nMSI (c) (B0:2C)
[03:01:42:821]: Machine policy value ‘Debug’ is 0\r\nMSI (c) (B0:2C) [03:01:42:821]: ******* RunEngine:\r\n ******* Product: C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi\r\n ******* Action: \r\n ******* CommandLine: **********\r\nMSI (c) (B0:2C) [03:01:42:822]: Client-side and UI is none or basic: Running entire install on the server.\r\nMSI (c) (B0:2C)
[03:01:42:822]: Grabbed execution mutex.\r\nMSI (c) (B0:2C) [03:01:42:831]: Cloaking enabled.\r\nMSI (c) (B0:2C)
[03:01:42:831]: Attempting to enable all disabled privileges before calling Install on Server\r\nMSI (c) (B0:2C) [03:01:42:841]: Incrementing counter to disable shutdown. Counter after increment: 0\r\nMSI (s) (74:8C)
[03:01:42:853]: Running installation inside multi-package transaction C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi\r\nMSI (s) (74:8C)
[03:01:42:853]: Grabbed execution mutex.\r\nMSI (s) (74:C4)
[03:01:42:858]: Resetting cached policy values\r\nMSI (s) (74:C4)
[03:01:42:858]: Machine policy value ‘Debug’ is 0\r\nMSI (s) (74:C4)
[03:01:42:858]: ******* RunEngine:\r\n ******* Product: C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi\r\n ******* Action: \r\n ******* CommandLine: **********\r\nMSI (s) (74:C4) [03:01:42:860]: Machine policy value ‘DisableUserInstalls’ is 0\r\nMSI (s) (74:C4) [03:01:42:864]: Note: 1: 2203 2: C:\Windows\Installer\inprogressinstallinfo.ipi 3: -2147287038 \r\nMSI (s) (74:C4)
[03:01:42:867]: SRSetRestorePoint skipped for this transaction.\r\nMSI (s) (74:C4) [03:01:42:868]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer 3: 2 \r\nMSI (s) (74:C4)
[03:01:42:869]: File will have security applied from OpCode.\r\nMSI (s) (74:C4) [03:01:42:895]: SOFTWARE RESTRICTION POLICY: Verifying package → ‘C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi’ against software restriction policy\r\nMSI (s) (74:C4)
[03:01:42:898]: SOFTWARE RESTRICTION POLICY: C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi has a digital signature\r\nMSI (s) (74:C4)
[03:01:42:971]: SOFTWARE RESTRICTION POLICY: C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi is permitted to run at the ‘unrestricted’ authorization level.\r\nMSI (s) (74:C4) [03:01:42:971]: MSCOREE not loaded loading copy from system32\r\nMSI (s) (74:C4) [03:01:42:981]: End dialog not enabled\r\nMSI (s) (74:C4)
[03:01:42:981]: Original package ==> C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi\r\nMSI (s) (74:C4)
[03:01:42:981]: Package we’re running from ==> C:\Windows\Installer\e097d78.msi\r\nMSI (s) (74:C4)
[03:01:42:983]: APPCOMPAT: Compatibility mode property overrides found.\r\nMSI (s) (74:C4)
[03:01:42:984]: APPCOMPAT: looking for appcompat database entry with ProductCode ‘{EDA3FABE-E481-4E69-A7B0-E845DF0FEC22}’.\r\nMSI (s) (74:C4)
[03:01:42:984]: APPCOMPAT: no matching ProductCode found in database.\r\nMSI (s) (74:C4) [03:01:42:992]: Machine policy value ‘TransformsSecure’ is 1\r\nMSI (s) (74:C4) [03:01:42:993]: Machine policy value ‘DisablePatch’ is 0\r\nMSI (s) (74:C4) [03:01:42:993]: Machine policy value ‘AllowLockdownPatch’ is 0\r\nMSI (s) (74:C4) [03:01:42:993]: Machine policy value ‘DisableLUAPatching’ is 0\r\nMSI (s) (74:C4) [03:01:42:993]: Machine policy value ‘DisableFlyWeightPatching’ is 0\r\nMSI (s) (74:C4) [03:01:42:994]: APPCOMPAT: looking for appcompat database entry with ProductCode ‘{EDA3FABE-E481-4E69-A7B0-E845DF0FEC22}’.\r\nMSI (s) (74:C4)
[03:01:42:994]: APPCOMPAT: no matching ProductCode found in database.\r\nMSI (s) (74:C4)
[03:01:42:994]: Transforms are not secure.\r\nMSI (s) (74:C4) [03:01:42:995]: PROPERTY CHANGE: Adding MsiLogFileLocation property. Its value is ‘C:\Users\ansible\AppData\Local\Temp\ansible-moduletmp-133012045020634992-865739083\msiexec.log’.\r\nMSI (s) (74:C4) [03:01:42:995]: Command Line: REBOOT=ReallySuppress CURRENTDIRECTORY=C:\Users\ansible CLIENTUILEVEL=3 CLIENTPROCESSID=7600 \r\nMSI (s) (74:C4)
[03:01:42:995]: PROPERTY CHANGE: Adding PackageCode property. Its value is ‘{BAB5A660-3BB3-433E-A7AA-1451377BED75}’.\r\nMSI (s) (74:C4) [03:01:42:995]: Product Code passed to Engine.Initialize: ‘’\r\nMSI (s) (74:C4) [03:01:42:995]: Product Code from property table before transforms: ‘{EDA3FABE-E481-4E69-A7B0-E845DF0FEC22}’\r\nMSI (s) (74:C4) [03:01:42:995]: Product Code from property table after transforms: ‘{EDA3FABE-E481-4E69-A7B0-E845DF0FEC22}’\r\nMSI (s) (74:C4) [03:01:42:995]: Product not registered: beginning first-time install\r\nMSI (s) (74:C4) [03:01:42:995]: Product {EDA3FABE-E481-4E69-A7B0-E845DF0FEC22} is not managed.\r\nMSI (s) (74:C4)
[03:01:42:995]: MSI_LUA: Credential prompt not required, user is an admin\r\nMSI (s) (74:C4)
[03:01:42:995]: PROPERTY CHANGE: Adding ProductState property. Its value is ‘-1’.\r\nMSI (s) (74:C4) [03:01:42:995]: Entering CMsiConfigurationManager::SetLastUsedSource.\r\nMSI (s) (74:C4)
[03:01:42:995]: User policy value ‘SearchOrder’ is ‘nmu’\r\nMSI (s) (74:C4) [03:01:42:995]: Adding new sources is allowed.\r\nMSI (s) (74:C4) [03:01:42:995]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is ‘1’.\r\nMSI (s) (74:C4) [03:01:42:996]: Package name extracted from package path: ‘MsSqlCmdLnUtils.msi’\r\nMSI (s) (74:C4)
[03:01:42:996]: Package to be registered: ‘MsSqlCmdLnUtils.msi’\r\nMSI (s) (74:C4) [03:01:42:997]: Note: 1: 2262 2: AdminProperties 3: -2147287038 \r\nMSI (s) (74:C4) [03:01:42:998]: Machine policy value ‘DisableMsi’ is 1\r\nMSI (s) (74:C4) [03:01:42:998]: Machine policy value ‘AlwaysInstallElevated’ is 0\r\nMSI (s) (74:C4) [03:01:42:998]: User policy value ‘AlwaysInstallElevated’ is 0\r\nMSI (s) (74:C4) [03:01:42:998]: Product installation will be elevated because user is admin and product is being installed per-machine.\r\nMSI (s) (74:C4)
[03:01:42:998]: Running product ‘{EDA3FABE-E481-4E69-A7B0-E845DF0FEC22}’ with elevated privileges: Product is assigned.\r\nMSI (s) (74:C4) [03:01:42:998]: PROPERTY CHANGE: Adding REBOOT property. Its value is ‘ReallySuppress’.\r\nMSI (s) (74:C4) [03:01:42:998]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is ‘C:\Users\ansible’.\r\nMSI (s) (74:C4) [03:01:42:998]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is ‘3’.\r\nMSI (s) (74:C4)
[03:01:42:998]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is ‘7600’.\r\nMSI (s) (74:C4) [03:01:42:998]: Machine policy value ‘DisableAutomaticApplicationShutdown’ is 0\r\nMSI (s) (74:C4)
[03:01:43:001]: PROPERTY CHANGE: Adding MsiRestartManagerSessionKey property. Its value is ‘b9668d273e9da84a841318e01fcfefe8’.\r\nMSI (s) (74:C4)
[03:01:43:001]: RESTART MANAGER: Session opened.\r\nMSI (s) (74:C4)
[03:01:43:001]: PROPERTY CHANGE: Adding MsiSystemRebootPending property. Its value is ‘1’.\r\nMSI (s) (74:C4)
[03:01:43:001]: TRANSFORMS property is now: \r\nMSI (s) (74:C4) [03:01:43:001]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is ‘405’.\r\nMSI (s) (74:C4)
[03:01:43:004]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\r\nMSI (s) (74:C4)
[03:01:43:006]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\Favorites\r\nMSI (s) (74:C4)
[03:01:43:007]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Network Shortcuts\r\nMSI (s) (74:C4)
[03:01:43:009]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\Documents\r\nMSI (s) (74:C4)
[03:01:43:011]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Printer Shortcuts\r\nMSI (s) (74:C4)
[03:01:43:013]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Recent\r\nMSI (s) (74:C4)
[03:01:43:015]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\SendTo\r\nMSI (s) (74:C4)
[03:01:43:017]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Templates\r\nMSI (s) (74:C4)
[03:01:43:017]: SHELL32::SHGetFolderPath returned: C:\ProgramData\r\nMSI (s) (74:C4)
[03:01:43:019]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Local\r\nMSI (s) (74:C4)
[03:01:43:021]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\Pictures\r\nMSI (s) (74:C4)
[03:01:43:025]: SHELL32::SHGetFolderPath returned: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools\r\nMSI (s) (74:C4)
[03:01:43:026]: SHELL32::SHGetFolderPath returned: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup\r\nMSI (s) (74:C4)
[03:01:43:028]: SHELL32::SHGetFolderPath returned: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\r\nMSI (s) (74:C4) [03:01:43:030]: SHELL32::SHGetFolderPath returned: C:\ProgramData\Microsoft\Windows\Start Menu\r\nMSI (s) (74:C4)
[03:01:43:032]: SHELL32::SHGetFolderPath returned: C:\Users\Public\Desktop\r\nMSI (s) (74:C4) [03:01:43:035]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Administrative Tools\r\nMSI (s) (74:C4)
[03:01:43:038]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup\r\nMSI (s) (74:C4)
[03:01:43:039]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\r\nMSI (s) (74:C4)
[03:01:43:041]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Start Menu\r\nMSI (s) (74:C4)
[03:01:43:043]: SHELL32::SHGetFolderPath returned: C:\Users\ansible\Desktop\r\nMSI (s) (74:C4)
[03:01:43:046]: SHELL32::SHGetFolderPath returned: C:\ProgramData\Microsoft\Windows\Templates\r\nMSI (s) (74:C4)
[03:01:43:047]: SHELL32::SHGetFolderPath returned: C:\Windows\Fonts\r\nMSI (s) (74:C4)
[03:01:43:047]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 \r\nMSI (s) (74:C4) [03:01:43:056]: MSI_LUA: Setting MsiRunningElevated property to 1 because the install is already running elevated.\r\nMSI (s) (74:C4)
[03:01:43:056]: PROPERTY CHANGE: Adding MsiRunningElevated property. Its value is ‘1’.\r\nMSI (s) (74:C4)
[03:01:43:056]: PROPERTY CHANGE: Adding Privileged property. Its value is ‘1’.\r\nMSI (s) (74:C4) [03:01:43:056]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Microsoft\MS Setup (ACME)\User Info 3: 2 \r\nMSI (s) (74:C4)
[03:01:43:057]: PROPERTY CHANGE: Adding USERNAME property. Its value is ‘EC2’.\r\nMSI (s) (74:C4) [03:01:43:057]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Microsoft\MS Setup (ACME)\User Info 3: 2 \r\nMSI (s) (74:C4) [03:01:43:057]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is ‘Amazon.com’.\r\nMSI (s) (74:C4) [03:01:43:057]: PROPERTY CHANGE: Adding DATABASE property. Its value is ‘C:\Windows\Installer\e097d78.msi’.\r\nMSI (s) (74:C4) [03:01:43:057]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is ‘C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi’.\r\nMSI (s) (74:C4) [03:01:43:057]: Machine policy value ‘MsiDisableEmbeddedUI’ is 0\r\nMSI (s) (74:C4) [03:01:43:057]: EEUI - Disabling MsiEmbeddedUI for service because it’s not a quiet/basic install\r\nMSI (s) (74:C4) [03:01:43:057]: Note: 1: 2205 2: 3: PatchPackage \r\nMSI (s) (74:C4) [03:01:43:058]: Machine policy value ‘DisableRollback’ is 0\r\nMSI (s) (74:C4) [03:01:43:058]: User policy value ‘DisableRollback’ is 0\r\nMSI (s) (74:C4) [03:01:43:058]: PROPERTY CHANGE: Adding UILevel property. Its value is ‘2’.\r\n=== Logging started: 7/2/2022 3:01:43 ===\r\nMSI (s) (74:C4) [03:01:43:059]: Note: 1: 2203 2: C:\Windows\Installer\inprogressinstallinfo.ipi 3: -2147287038 \r\nMSI (s) (74:C4) [03:01:43:059]: APPCOMPAT: [DetectVersionLaunchCondition] Launch condition already passes.\r\nMSI (s) (74:C4) [03:01:43:061]: PROPERTY CHANGE: Adding ACTION property. Its value is ‘INSTALL’.\r\nMSI (s) (74:C4) [03:01:43:061]: Doing action: INSTALL\r\nAction start 3:01:43: INSTALL.\r\nMSI (s) (74:C4) [03:01:43:062]: Running ExecuteSequence\r\nMSI (s) (74:C4) [03:01:43:062]: Doing action: SetSqlProgramMenuFolder\r\nMSI (s) (74:C4) [03:01:43:063]: PROPERTY CHANGE: Adding ProgramMenuFolder.Sql property. Its value is ‘C:\ProgramData\Microsoft\Windows\Start Menu\Programs\’.\r\nAction start 3:01:43: SetSqlProgramMenuFolder.\r\nMSI (s) (74:C4) [03:01:43:064]: Doing action: LaunchConditions\r\nAction ended 3:01:43: SetSqlProgramMenuFolder. Return value 1.\r\nAction start 3:01:43: LaunchConditions.\r\nMSI (s) (74:C4) [03:01:43:065]: Doing action: FindRelatedProducts\r\nAction ended 3:01:43: LaunchConditions. Return value 1.\r\nAction start 3:01:43: FindRelatedProducts.\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: CA_ErrorDifferentLang (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: CA_SetRefCountNewerFoundFlag (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound_64 (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound_64 (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound_64 (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound_64 (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound_64 (condition is false)\r\nMSI (s) (74:C4) [03:01:43:067]: Doing action: AppSearch\r\nAction ended 3:01:43: FindRelatedProducts. Return value 1.\r\nAction start 3:01:43: AppSearch.\r\nMSI (s) (74:C4) [03:01:43:069]: Doing action: MSSQLODBC17_64\r\nAction ended 3:01:43: AppSearch. Return value 1.\r\nAction start 3:01:43: MSSQLODBC17_64.\r\nMSI (s) (74:C4) [03:01:43:071]: Product: Microsoft Command Line Utilities 15 for SQL Server – Setup is missing an installation prerequisite:\r\n -Microsoft ODBC Driver 17 for SQL Server. To continue, install Microsoft ODBC Driver 17 for SQL Server and \r\nthen run the Setup operation again\r\n\r\nSetup is missing an installation prerequisite:\r\n -Microsoft ODBC Driver 17 for SQL Server. To continue, install Microsoft ODBC Driver 17 for SQL Server and \r\nthen run the Setup operation again\r\nAction ended 3:01:43: MSSQLODBC17_64. Return value 3.\r\nAction ended 3:01:43: INSTALL. Return value 3.\r\nProperty(S): DiskPrompt = [1]\r\nProperty(S): UpgradeCode = {11E5CC67-2ECA-41A1-8775-5EA0B51CCBAA}\r\nProperty(S): WelcomeBmp = WelcomeBmp\r\nProperty(S): OPENREADME = 1\r\nProperty(S): ErrorIcon = ErrorIco\r\nProperty(S): AgreeToLicense = No\r\nProperty(S): _IsMaintenance = Reinstall\r\nProperty(S): RepairIcon = RepairIco\r\nProperty(S): RemoveIcon = RemoveIco\r\nProperty(S): Interrupted = 0\r\nProperty(S): SetupIcon = SetupIco\r\nProperty(S): ProgramMenuFolder.Sql = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\\r\nProperty(S): SAPBINOTEPAD = Notepad.exe\r\nProperty(S): ProgramFiles64Folder = C:\Program Files\\r\nProperty(S): VersionNT = 603\r\nProperty(S): Privileged = 1\r\nProperty(S): Manufacturer = Microsoft Corporation\r\nProperty(S): ProductCode = {EDA3FABE-E481-4E69-A7B0-E845DF0FEC22}\r\nProperty(S): ProductLanguage = 1033\r\nProperty(S): ProductName = Microsoft Command Line Utilities 15 for SQL Server\r\nProperty(S): ProductVersion = 15.0.2000.5\r\nProperty(S): ProductShortName = Microsoft Command Line Utilities 15 for SQL Server\r\nProperty(S): PlatformExtension = _64\r\nProperty(S): PlatformId = x64\r\nProperty(S): AppGuidRegKey = Redist_Uninstall_RegKey\r\nProperty(S): ARPPRODUCTICON = ARPIco\r\nProperty(S): ARPHELPLINK = https://go.microsoft.com/fwlink/?LinkId=90955\r\nProperty(S): PIDTemplate = 53934<====`````>@@@@@\r\nProperty(S): PROMPTROLLBACKCOST = P\r\nProperty(S): INSTALLLEVEL = 100\r\nProperty(S): ALLUSERS = 1\r\nProperty(S): InstallMode = Typical\r\nProperty(S): SuccessIcon = SuccessIco\r\nProperty(S): WarningIcon = WarningIco\r\nProperty(S): LicenseIcon = LicenseIco\r\nProperty(S): CompleteIcon = CompleteIco\r\nProperty(S): CustomIcon = CustomIco\r\nProperty(S): ModifyIcon = ModifyIco\r\nProperty(S): NewIcon = NewIco\r\nProperty(S): UpIcon = UpIco\r\nProperty(S): DialogBanner = BannerBmp\r\nProperty(S): Details = 0\r\nProperty(S): ReinstallModeText = omus\r\nProperty(S): Display_IsBitmapDlg = 1\r\nProperty(S): ISENABLEDWUSFINISHDIALOG = 1\r\nProperty(S): SQLServerText1 = 0\r\nProperty(S): SQLServerVersionText1 = 0\r\nProperty(S): SQLServerVersionText2 = 0\r\nProperty(S): SQLServerVersionText3 = 0\r\nProperty(S): CA_ERRORCOUNT = 0\r\nProperty(S): CA_WARNINGCOUNT = 0\r\nProperty(S): CA_SUCCESSCOUNT = 0\r\nProperty(S): UI_SHOWCOPYRIGHT = yes\r\nProperty(S): ShowUserRegistrationDlg = 1\r\nProperty(S): ButtonTextStyle = {\ButtonTextStyle}\r\nProperty(S): DlgTextStyle = {\DlgTextStyle}\r\nProperty(S): DlgTextStyleB = {\DlgTextStyleB}\r\nProperty(S): DlgTitleStyle = {\DlgTitleStyle}\r\nProperty(S): DlgTitleStyleB = {\DlgTitleStyleB}\r\nProperty(S): FixedStyle = {\FixedStyle}\r\nProperty(S): Error_UninstallDependant = 1\r\nProperty(S): DefaultUIFont = Tahoma8\r\nProperty(S): ProductFeaturesDefined = 1\r\nProperty(S): InstallWelcomeDlg_Next = LicenseAgreementDlg\r\nProperty(S): LicenseAgreementDlg_Back = InstallWelcomeDlg\r\nProperty(S): LicenseAgreementDlg_Next = ReadyToInstallDlg\r\nProperty(S): ReadyToInstallDlg_NotInstalled_Back = LicenseAgreementDlg\r\nProperty(S): ReadyToInstallDlg_Installed_Back = MaintenanceTypeDlg\r\nProperty(S): MaintenanceWelcomeDlg_Next = MaintenanceTypeDlg\r\nProperty(S): ReadyToRemoveDlg_Back = MaintenanceTypeDlg\r\nProperty(S): ModuleID_REDISTBASE = SQLBASE_Redist_64\r\nProperty(S): ErrorDialog = ErrorDlg\r\nProperty(S): SecureCustomProperties = NEWERFOUND_64;OLDERFOUND_64;OLDERFOUND2_64\r\nProperty(S): MsiLogFileLocation = C:\Users\ansible\AppData\Local\Temp\ansible-moduletmp-133012045020634992-865739083\msiexec.log\r\nProperty(S): PackageCode = {BAB5A660-3BB3-433E-A7AA-1451377BED75}\r\nProperty(S): ProductState = -1\r\nProperty(S): PackagecodeChanging = 1\r\nProperty(S): REBOOT = ReallySuppress\r\nProperty(S): CURRENTDIRECTORY = C:\Users\ansible\r\nProperty(S): CLIENTUILEVEL = 3\r\nProperty(S): CLIENTPROCESSID = 7600\r\nProperty(S): MsiRestartManagerSessionKey = b9668d273e9da84a841318e01fcfefe8\r\nProperty(S): VersionDatabase = 405\r\nProperty(S): MsiSystemRebootPending = 1\r\nProperty(S): VersionMsi = 5.00\r\nProperty(S): VersionNT64 = 603\r\nProperty(S): WindowsBuild = 9600\r\nProperty(S): ServicePackLevel = 0\r\nProperty(S): ServicePackLevelMinor = 0\r\nProperty(S): MsiNTProductType = 3\r\nProperty(S): MsiNTSuiteDataCenter = 1\r\nProperty(S): WindowsFolder = C:\Windows\\r\nProperty(S): WindowsVolume = C:\\r\nProperty(S): System64Folder = C:\Windows\system32\\r\nProperty(S): SystemFolder = C:\Windows\SysWOW64\\r\nProperty(S): RemoteAdminTS = 1\r\nProperty(S): TempFolder = C:\Users\ansible\AppData\Local\Temp\\r\nProperty(S): ProgramFilesFolder = C:\Program Files (x86)\\r\nProperty(S): CommonFilesFolder = C:\Program Files (x86)\Common Files\\r\nProperty(S): CommonFiles64Folder = C:\Program Files\Common Files\\r\nProperty(S): AppDataFolder = C:\Users\ansible\AppData\Roaming\\r\nProperty(S): FavoritesFolder = C:\Users\ansible\Favorites\\r\nProperty(S): NetHoodFolder = C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Network Shortcuts\\r\nProperty(S): PersonalFolder = C:\Users\ansible\Documents\\r\nProperty(S): PrintHoodFolder = C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Printer Shortcuts\\r\nProperty(S): RecentFolder = C:\Users\ansible\AppData\Roaming\Microsoft\Windows\Recent\\r\nProperty(S): SendToFolder = C:\Users\ansible\AppData\Roaming\Microsoft\Windows\SendTo\\r\nProperty(S): TemplateFolder = C:\ProgramData\Microsoft\Windows\Templates\\r\nProperty(S): CommonAppDataFolder = C:\ProgramData\\r\nProperty(S): LocalAppDataFolder = C:\Users\ansible\AppData\Local\\r\nProperty(S): MyPicturesFolder = C:\Users\ansible\Pictures\\r\nProperty(S): AdminToolsFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools\\r\nProperty(S): StartupFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup\\r\nProperty(S): ProgramMenuFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\\r\nProperty(S): StartMenuFolder = C:\ProgramData\Microsoft\Windows\Start Menu\\r\nProperty(S): DesktopFolder = C:\Users\Public\Desktop\\r\nProperty(S): FontsFolder = C:\Windows\Fonts\\r\nProperty(S): GPTSupport = 1\r\nProperty(S): OLEAdvtSupport = 1\r\nProperty(S): ShellAdvtSupport = 1\r\nProperty(S): MsiAMD64 = 6\r\nProperty(S): Msix64 = 6\r\nProperty(S): Intel = 6\r\nProperty(S): PhysicalMemory = 16384\r\nProperty(S): VirtualMemory = 15518\r\nProperty(S): AdminUser = 1\r\nProperty(S): MsiTrueAdminUser = 1\r\nProperty(S): LogonUser = ansible\r\nProperty(S): UserSID = S-1-5-21-2389696941-1547632363-1832267186-1013\r\nProperty(S): UserLanguageID = 1033\r\nProperty(S): ComputerName = EC2AMAZ-2D1CCJO\r\nProperty(S): SystemLanguageID = 1033\r\nProperty(S): ScreenX = 1024\r\nProperty(S): ScreenY = 768\r\nProperty(S): CaptionHeight = 23\r\nProperty(S): BorderTop = 1\r\nProperty(S): BorderSide = 1\r\nProperty(S): TextHeight = 16\r\nProperty(S): TextInternalLeading = 3\r\nProperty(S): ColorBits = 32\r\nProperty(S): TTCSupport = 1\r\nProperty(S): Time = 3:01:43\r\nProperty(S): Date = 7/2/2022\r\nProperty(S): MsiNetAssemblySupport = 4.8.3761.0\r\nProperty(S): MsiWin32AssemblySupport = 6.3.17763.1\r\nProperty(S): RedirectedDllSupport = 2\r\nProperty(S): MsiRunningElevated = 1\r\nProperty(S): USERNAME = EC2\r\nProperty(S): COMPANYNAME = Amazon.com\r\nProperty(S): DATABASE = C:\Windows\Installer\e097d78.msi\r\nProperty(S): OriginalDatabase = C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi\r\nProperty(S): UILevel = 2\r\nProperty(S): ACTION = INSTALL\r\nMSI (s) (74:C4) [03:01:43:134]: Note: 1: 1708 \r\nMSI (s) (74:C4)

[03:01:43:134]: Product: Microsoft Command Line Utilities 15 for SQL Server – Installation failed.\r\n\r\nMSI (s) (74:C4)
[03:01:43:135]: Windows Installer installed the product. Product Name: Microsoft Command Line Utilities 15 for SQL Server. Product Version: 15.0.2000.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Installation success or error status: 1603.\r\n\r\nMSI (s) (74:C4)
[03:01:43:137]: Deferring clean up of packages/files, if any exist\r\nMSI (s) (74:C4) [03:01:43:138]: MainEngineThread is returning 1603\r\nMSI (s) (74:8C)
[03:01:43:142]: RESTART MANAGER: Session closed.\r\nMSI (s) (74:8C)
[03:01:43:142]: No System Restore sequence number for this installation.\r\n=== Logging stopped: 7/2/2022 3:01:43 ===\r\nMSI (s) (74:8C)
[03:01:43:144]: User policy value ‘DisableRollback’ is 0\r\nMSI (s) (74:8C)
[03:01:43:144]: Machine policy value ‘DisableRollback’ is 0\r\nMSI (s) (74:8C) [03:01:43:144]: Incrementing counter to disable shutdown. Counter after increment: 0\r\nMSI (s) (74:8C)
[03:01:43:144]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 \r\nMSI (s) (74:8C)
[03:01:43:144]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 \r\nMSI (s) (74:8C)
[03:01:43:145]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1\r\nMSI (c) (B0:2C)
[03:01:43:146]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1\r\nMSI (c) (B0:2C)
[03:01:43:147]: MainEngineThread is returning 1603\r\n=== Verbose logging stopped: 7/2/2022 3:01:43 ===\r\n\r\n", “msg”: “unexpected rc from ‘C:\Windows\System32\msiexec.exe /i "C:\Users\Administrator\Downloads\BancWare Data Integration 2021.2.0\x64\Microsoft SQL Server Redistributable_x64\MsSqlCmdLnUtils.msi" /L*V C:\Users\ansible\AppData\Local\Temp\ansible-moduletmp-133012045020634992-865739083\msiexec.log /qn /norestart’: see rc, stdout, and stderr for more details”, “rc”: 1603, “reboot_required”: false, “stderr”: “”, “stderr_lines”: , “stdout”: “”, “stdout_lines”: }

PLAY RECAP *********************************************************************
10.0.1.183 : ok=1 changed=0 unreachable=0 failed=1 skipped=0 rescued=0 ignored=0

Please help me out with error

Two suggestions

When seeing a msi or installer 1603 error.
Reboot the machine and try again afterwards.

Or login to machine and try the install manually and check what it reports directly.

Urs

Manually it is installing all msi’s and like Apache server it is installing properly. only MSSQLCmdLnUtlits,OLEDB Driver,ODBC not installing through ansible playbook.

The manual OLE DB driver is installed, but with ansibleplaybook its problem. How to install MSI files using Ansible playbook.