I'm trying to install OME 1.2.0 for a good many hours now, but it won't succeed. I use installation manual "Dell OpenManage Essentials Install - Aug 2013.pdf" as a guide. A couple of months ago, I installed OME on a test server and everything worked fine. Now I'm trying to install it on a live server running Windows Server 2008 r2 with SQL Server 2008 r2. The installation rolls back at step "Publishing Essentials application in IIS". It's busy for a little while and then rolls back the installation. Windows Eventlog displays a couple of errors:
And:
Seems to be related to .net framework, so I re-installed .net Framework 4.0. Makes no difference. Where do I start looking for a solution?
The log file "MgmtSt_15_52_40.log" doesn't contain anything useful, as far as I can tell. A snipped of the log just before it starts the roll back:
-----------snip----------
SYSTEMSMANAGEMENT: Installing Essentials DB
Action 15:53:19: . Populating Essentials database tables…
SYSTEMSMANAGEMENT: The set failure action task for Essentials services is successfully completed.
SYSTEMSMANAGEMENT: The set failure action task for Essentials services is successfully completed.
MSI (s) (60:7C) [15:53:21:269]: Executing op: ActionStart(Name=caRollbackMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4,,)
Action 15:53:21: caRollbackMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4.
MSI (s) (60:7C) [15:53:21:269]: Executing op: CustomActionSchedule(Action=caRollbackMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4,ActionType=1281,Source=BinaryData,Target=caRollbackMsWebDeploy,)
MSI (s) (60:7C) [15:53:21:269]: Executing op: ActionStart(Name=caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4,,)
Action 15:53:21: caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4.
MSI (s) (60:7C) [15:53:21:269]: Executing op: CustomActionSchedule(Action=caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4,ActionType=1025,Source=BinaryData,Target=caMsWebDeploy,)
MSI (s) (60:DC) [15:53:21:269]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI4CCB.tmp, Entrypoint: caMsWebDeploy
Action 15:53:21: . Publishing Essentials application in IIS…
CustomAction caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 15:53:43: InstallExecute. Return value 3.
MSI (s) (60:7C) [15:53:43:889]: User policy value 'DisableRollback' is 0
MSI (s) (60:7C) [15:53:43:889]: Machine policy value 'DisableRollback' is 0
MSI (s) (60:7C) [15:53:43:905]: Executing op: Header(Signature=1397708873,Version=500,Timestamp=1130659492,LangId=0,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (60:7C) [15:53:43:905]: Executing op: DialogInfo(Type=0,Argument=0)
MSI (s) (60:7C) [15:53:43:905]: Executing op: DialogInfo(Type=1,Argument=Dell OpenManage Essentials)
MSI (s) (60:7C) [15:53:43:905]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
Action 15:53:43: Rollback. Rolling back action:
Rollback: caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4
MSI (s) (60:7C) [15:53:43:905]: Executing op: ActionStart(Name=caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4,,)
MSI (s) (60:7C) [15:53:43:905]: Executing op: ProductInfo(ProductKey={714F1E68-A700-40A5-903D-631B2485C2C6},ProductName=Dell OpenManage Essentials,PackageName=Essentials.msi,Language=0,Version=16908288,Assignment=1,ObsoleteArg=0,ProductIcon=ARPPRODUCTICON.exe,PackageMediaPath=\ManagementStation\windows\ManagementStation\,PackageCode={662A285C-4F65-4673-B3E7-71FA4C216333},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0,ProductDeploymentFlags=3)
Rollback: caRollbackMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4
MSI (s) (60:7C) [15:53:43:905]: Executing op: ActionStart(Name=caRollbackMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4,,)
MSI (s) (60:7C) [15:53:43:905]: Executing op: CustomActionRollback(Action=caRollbackMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4,ActionType=1281,Source=BinaryData,Target=caRollbackMsWebDeploy,)
MSI (s) (60:10) [15:53:43:905]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIA538.tmp, Entrypoint: caRollbackMsWebDeploy
Action 15:53:44: . Removing Essentials application from IIS…
Rollback: caCreateSchema.674D7E1A_589B_4C7E_8307_2DB62F9596E4
MSI (s) (60:7C) [15:54:50:921]: Executing op: ActionStart(Name=caCreateSchema.674D7E1A_589B_4C7E_8307_2DB62F9596E4,,)
Rollback: caRollbackCreateSchema.674D7E1A_589B_4C7E_8307_2DB62F9596E4
MSI (s) (60:7C) [15:54:50:921]: Executing op: ActionStart(Name=caRollbackCreateSchema.674D7E1A_589B_4C7E_8307_2DB62F9596E4,,)
MSI (s) (60:7C) [15:54:50:921]: Executing op: CustomActionRollback(Action=caRollbackCreateSchema.674D7E1A_589B_4C7E_8307_2DB62F9596E4,ActionType=1281,Source=BinaryData,Target=caRollbackCreateSchema,)
MSI (s) (60:64) [15:54:50:921]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIAB03.tmp, Entrypoint: caRollbackCreateSchema
SYSTEMSMANAGEMENT: Restoring Essentials DB
SYSTEMSMANAGEMENT: Using 64 bit sqlcmd to remove Essentials DB
Action 15:54:50: . Removing Essentials tables from database…
Rollback: Publishing product information
-----------snip----------
Rollback: caOMILPreInstall
MSI (s) (60:7C) [15:54:56:786]: Executing op: ActionStart(Name=caOMILPreInstall,,)
Rollback: caOMILPreInstallRollback
MSI (s) (60:7C) [15:54:56:786]: Executing op: ActionStart(Name=caOMILPreInstallRollback,,)
MSI (s) (60:7C) [15:54:56:786]: Executing op: CustomActionRollback(Action=caOMILPreInstallRollback,ActionType=1281,Source=BinaryData,Target=caOMILPreInstallRollback,)
MSI (s) (60:10) [15:54:56:786]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIC1ED.tmp, Entrypoint: caOMILPreInstallRollback
SYSTEMSMANAGEMENT: SUPPORTDIR = C:\Users\dell_ome\AppData\Local\Temp\{714F1E68-A700-40A5-903D-631B2485C2C6}
SYSTEMSMANAGEMENT: INSTALLDIR = C:\Program Files (x86)\Dell\SysMgt
SYSTEMSMANAGEMENT: CP_TEMPDIR = C:\Users\dell_ome\AppData\Local\Temp\omiltmpms
SYSTEMSMANAGEMENT: TEMPINIDIR folder is C:\Program Files (x86)\tempini
SYSTEMSMANAGEMENT: Installing feature Essentials
Rollback: ISSQLServerRollback
MSI (s) (60:7C) [15:54:56:880]: Executing op: ActionStart(Name=ISSQLServerRollback,,)
MSI (s) (60:7C) [15:54:56:880]: Executing op: CustomActionRollback(Action=ISSQLServerRollback,ActionType=1281,Source=BinaryData,Target=ISSQLServerRollback,CustomActionData=t:\temp\~F2A9.tmp)
MSI (s) (60:20) [15:54:56:880]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIC24C.tmp, Entrypoint: ISSQLServerRollback
1: Processing the SQL connection 'NewSQLConnection1'...
1: Determining if there is at least one SQL script scheduled to execute under the connection...
1: No SQL scripts scheduled to execute under the connection...Skip.
1: Skip the SQL connection 'NewSQLConnection1'. There is no script to execute under this connection.
Rollback: ISSQLServerRollbackLoginInfo
MSI (s) (60:7C) [15:54:56:911]: Executing op: ActionStart(Name=ISSQLServerRollbackLoginInfo,,)
MSI (s) (60:7C) [15:54:56:911]: Executing op: CustomActionRollback(Action=ISSQLServerRollbackLoginInfo,ActionType=3329,Source=BinaryData,Target=ISSQLServerRollbackLoginInfo,CustomActionData=t:\temp\~F2A9.tmp)
MSI (s) (60:30) [15:54:56:911]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIC26C.tmp, Entrypoint: ISSQLServerRollbackLoginInfo
MSI (s) (60:7C) [15:54:56:942]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (60:7C) [15:54:56:942]: Error in rollback skipped. Return: 5
MSI (s) (60:7C) [15:54:56:942]: Note: 1: 2318 2:
MSI (s) (60:7C) [15:54:56:942]: No System Restore sequence number for this installation.
MSI (s) (60:7C) [15:54:56:942]: Unlocking Server
MSI (s) (60:7C) [15:54:56:958]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 15:54:56: INSTALL. Return value 3.
-----------snip----------
MSI (s) (60:7C) [15:54:56:989]: MainEngineThread is returning 1603
MSI (s) (60:90) [15:54:56:989]: No System Restore sequence number for this installation.
MSI (s) (60:90) [15:54:56:989]: User policy value 'DisableRollback' is 0
MSI (s) (60:90) [15:54:56:989]: Machine policy value 'DisableRollback' is 0
MSI (s) (60:90) [15:54:56:989]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (60:90) [15:54:56:989]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (60:90) [15:54:56:989]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (60:90) [15:54:56:989]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (60:90) [15:54:56:989]: Restoring environment variables
MSI (s) (60:90) [15:54:56:989]: Destroying RemoteAPI object.
MSI (s) (60:38) [15:54:56:989]: Custom Action Manager thread ending.
MSI (c) (B4:50) [15:54:57:005]: Back from server. Return value: 1603
MSI (c) (B4:50) [15:54:57:005]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B4:50) [15:54:57:005]: PROPERTY CHANGE: Deleting SECONDSEQUENCE property. Its current value is '1'.
Action ended 15:54:57: ExecuteAction. Return value 3.
MSI (c) (B4:50) [15:54:57:005]: Doing action: SetupCompleteError
Action 15:54:57: SetupCompleteError.
Action start 15:54:57: SetupCompleteError.
Action 15:54:57: SetupCompleteError. Dialog created
MSI (c) (B4:B4) [16:02:45:718]: Doing action: caOMILDeleteTempPath
Action 16:02:45: caOMILDeleteTempPath.
Action start 16:02:45: caOMILDeleteTempPath.
MSI (c) (B4:04) [16:02:45:718]: Invoking remote custom action. DLL: C:\Users\dell_ome\AppData\Local\Temp\MSIE938.tmp, Entrypoint: caOMILDeleteTempPath
Action ended 16:02:45: caOMILDeleteTempPath. Return value 1.
MSI (c) (B4:B4) [16:02:45:750]: Doing action: ISSetupFilesCleanup
Action 16:02:45: ISSetupFilesCleanup.
Action start 16:02:45: ISSetupFilesCleanup.
MSI (c) (B4:14) [16:02:45:750]: Invoking remote custom action. DLL: C:\Users\dell_ome\AppData\Local\Temp\MSIE958.tmp, Entrypoint: SFCleanupEx
Action ended 16:02:45: ISSetupFilesCleanup. Return value 1.
Action ended 16:02:45: SetupCompleteError. Return value 2.
Action ended 16:02:45: INSTALL. Return value 3.
MSI (c) (B4:50) [16:02:45:843]: Destroying RemoteAPI object.
MSI (c) (B4:F4) [16:02:45:843]: Custom Action Manager thread ending.
-----------snip----------
�
Hi there Simon and thanks for the post.
You might first check to run all windows updates on that box.
The problem could be in the Microsoft .net framework.
http://support.microsoft.com/kb/2640103
Download the hotfix here:
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2640103
Google this to find a number of people with the same issue.
"CLR.dll" "0xc0000005"
�
Hope this helps,
Rob
DELL-Rob C
Social Media Support
#IWork4Dell
Hi - I am experiencing the same issue although the reason must be different.
I am not getting any faulting application errors in Windows event log, but the installation goes to the same exact point then Rolls back.
This is this moment what I can see in the instal log:
Action 15:16:11: . Publishing Essentials application in IIS…
CustomAction caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 15:16:26: InstallExecute. Return value 3.
MSI (s) (BC:50) [15:16:26:838]: User policy value 'DisableRollback' is 0
MSI (s) (BC:50) [15:16:26:838]: Machine policy value 'DisableRollback' is 0
MSI (s) (BC:50) [15:16:26:854]: Executing op: Header(Signature=1397708873,Version=500,Timestamp=1130723840,LangId=0,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (BC:50) [15:16:26:854]: Executing op: DialogInfo(Type=0,Argument=0)
MSI (s) (BC:50) [15:16:26:854]: Executing op: DialogInfo(Type=1,Argument=Dell OpenManage Essentials)
MSI (s) (BC:50) [15:16:26:854]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (BC:50) [15:16:26:854]: Executing op: RegisterBackupFile(File=C:\Config.Msi\2964e.rbf)
MSI (s) (BC:50) [15:16:26:854]: Executing op: RegisterBackupFile(File=C:\Config.Msi\2964f.rbf)
MSI (s) (BC:50) [15:16:26:854]: Executing op: RegisterBackupFile(File=C:\Config.Msi\29650.rbf)
MSI (s) (BC:50) [15:16:26:854]: Executing op: RegisterBackupFile(File=C:\Config.Msi\29651.rbf)
MSI (s) (BC:50) [15:16:26:854]: Executing op: RegisterBackupFile(File=C:\Config.Msi\29652.rbf)
Action 15:16:26: Rollback. Rolling back action:
Rollback: caMsWebDeploy.674D7E1A_589B_4C7E_8307_2DB62F9596E4
Hi there,
It's hard to tell from this snippet if it is the same issue. We'd need to see more of the installutil.log file. Or you can open a ticket at 800-945-3355 to review the logs. Be sure you review the install whitepaper if you've not had a chance to look at it.
Was this an existing IIS install? Or did you let OME install/configure IIS? Can you describe the permissions characteristics of the account you used to install?
Thanks,
Rob
DELL-Rob C
Social Media Support
#IWork4Dell
Hi Rob,
I could not find any INSTALLUTIL log file
The one I traced being created during setup is MgmtSt_<time>.log in the %TEMP% folder - which is 15MB I guess you don't want me to paste it all here.
BTW - would be nice if installer could leave a message "Installation failed - for details see MgmtSt_ log file"
But I found this installation error has more to do with database on remote SQL server then local IIS.
This is what happens:
OS is W2K8 R2
I tried it both from OME service account - and using Domain Admin account.
Ok,
Did you look under c:\windows\temp?
thx
Rob
DELL-Rob C
Social Media Support
#IWork4Dell
You got me Rob... I was only looking in Temp folders...
This is the reason I found in C:\Windows\Temp\InstallUtil.log
* The .Net SqlClient Data Provider has received a severity 16, state 1 error number 5069 on line 4 of procedure '' on server 'PL-SQL1': ALTER DATABASE statement failed.
ALTER DATABASE [OMEssentials] SET READ_WRITE; ALTER DATABASE [OMEssentials] SET ANSI_NULLS ON, ANSI_NULL_DEFAULT OFF, ANSI_PADDING ON, ANSI_WARNINGS ON, ARITHABORT ON, AUTO_CLOSE OFF, AUTO_CREATE_STATISTICS ON, AUTO_SHRINK ON, AUTO_UPDATE_STATISTICS ON, AUTO_UPDATE_STATISTICS_ASYNC OFF, CONCAT_NULL_YIELDS_NULL ON, NUMERIC_ROUNDABORT OFF, QUOTED_IDENTIFIER ON, RECOVERY SIMPLE, CURSOR_CLOSE_ON_COMMIT OFF, CURSOR_DEFAULT LOCAL, RECURSIVE_TRIGGERS OFF WITH ROLLBACK IMMEDIATE; ALTER DATABASE [OMEssentials] SET PAGE_VERIFY NONE WITH ROLLBACK IMMEDIATE;
Undefined exception occurred: System.Data.SqlClient.SqlException (0x80131904): The operation cannot be performed on database "OMEssentials" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. ALTER DATABASE statement failed.
Indeed our new SQL server is configured with Availability Groups.
So I removed OME DB from AG, then the upgrade process went without issues
So far so good, rebooted the OME server just to make sure... and guess what - I am left with blank DB version 1.2 (...oh God give me patience...)
All my Devices, Discovery Ranges, Alerts are gone....
Maybe you can tell what happened I see in log it detects corruption ??
Database.Install(...)
Database.UnzipDataScripts() - C:\Windows\TEMP\OMEssentials 2013-11-06 00.02.23 - DatabaseAdd.sql - UpgradeOMEssentials, 1.0.0.30.sql - UpgradeOMEssentials, 1.0.1.1253.sql - UpgradeOMEssentials, 1.1.0.6063.sql
MigrateDatabase()
MigrateDatabase(Registry64)
MigrateDatabase(Registry32) Target Server: PL-SQL1 Target SQL Server Instance: Target Database: OMEssentials Source Server: PL-SQL1 Source SQL Server Instance: Source Database: OMEssentials
MigrateDatabase(...) No Migration: The old database is not local
LoadSqlLogin()
Clearing out the corrupted [OMEssentials] database. Website unzip complete.
Database.LoadServerPaths(...)
Server Name: PL-SQL1 Database Name: OMEssentials Script: C:\Windows\TEMP\OMEssentials 2013-11-06 00.02.23\DatabaseAdd.sql SQL Login: No
Database.ExecuteSqlFile(...) Changed database context to 'OMEssentials'. Changed database context to 'master'. Changed database context to 'OMEssentials'. Dropping all views... Dropping all views complete Dropping all functions and stored procedures... Dropping all functions and stored procedures complete.
Hi again,
after spending another day on this I finally got it working.
The problem was with remote SQL server version 2012.
Even when I removed OME db from Availability group - the upgrade proces was destructive.
When I tried that with another remote SQL server version 2008 R2 - all went fine and smooth.
The same output from Installutil.log file shows all OK, no corruption:
Database.Install(...)
Database.UnzipDataScripts() - C:\Windows\TEMP\OMEssentials 2013-11-06 14.57.55 - DatabaseAdd.sql - UpgradeOMEssentials, 1.0.0.30.sql - UpgradeOMEssentials, 1.0.1.1253.sql - UpgradeOMEssentials, 1.1.0.6063.sql
MigrateDatabase()
MigrateDatabase(Registry64)
MigrateDatabase(Registry32) Target Server: PL-SQL04 Target SQL Server Instance: Target Database: OMEssentials Source Server: PL-SQL04 Source SQL Server Instance: Source Database: OMEssentials
MigrateDatabase(...) No Migration: The old database is not local
LoadSqlLogin()
Database.LoadServerPaths(...)
Server Name: PL-SQL04 Database Name: OMEssentials Script: C:\Windows\TEMP\OMEssentials 2013-11-06 14.57.55\UpgradeOMEssentials, 1.1.0.6063.sql SQL Login: No
Database.ExecuteSqlFile(...) Changed database context to 'OMEssentials'. Changed database context to 'master'. Changed database context to 'OMEssentials'. Dropping all views... Dropping all views complete Website unzip complete. Dropping all functions and stored procedures... Dropping all functions and stored procedures complete.
Installed the hotfix, rebooted machine, ran Windows Update (no updates found), but the error installing OME is the same. Removed .net Framework 4.0 and let the OME-installer take care of it. Error persists.
Searching for "CLR.dll" "0xc0000005" results in lots of hits, but they all point to the earlier mentioned hotfix.... I'm stuck....
Simon
Hmmm...ok, well if the database is seen to be corrupted it is wiped and a new one is created for the install. Question is what happened during the upgrade process to clobber the db.
Do you have a backup of the database? If so, we might be able to use the re-targetting process. I might have to suggest you use the support number from my previous post.
Thanks,
Rob
DELL-Rob C
Social Media Support
#IWork4Dell