OME will not upgrade from ITA 8.9

2013-02-26 02:45:51 PM

"C:\Program Files (x86)\Dell\SysMgt\Essentials\bin\WebInstall\InstallUtil.exe"  -DatabaseOptions 384 -i -WebsitePath "C:\Program Files (x86)\Dell\SysMgt\Essentials\WWWRoot\Essentials" -WebsitePort "2607"

Website unzip started...

Website un-install started...

Website un-install completed.

HostServiceInstaller.Uninstall()

Database.Install(...)

Database.UnzipDataScripts()

- C:\Windows\TEMP\OMEssentials 2013-02-26 14.45.52

- DatabaseAdd.sql

- UpgradeITAssist.sql

- UpgradeOMEssentials, 1.0.0.30.sql

LoadSqlLogin()

Using the current user to access SQL Server.

LoadMixedMode(...)

SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer, [LoginMode]

Handled SqlException #233.0

System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParserStateObject.WriteSni()

  at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)

  at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()

  at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at Helpers.Extensions.SqlConnectionHelper.Verify(SqlConnection sqlConnection, TimeSpan commandTimeout)

  at InstallUtil.Installers.Database.Database.LoadMixedMode(SqlConnection sqlConnection)

Website unzip complete.

LoadSqlLogin(...)

Adding the [OmeService] account.

Setting permissions on the [OmeService] account.

Dropping the existing [OMEssentials] database.

No database found.

Database.LoadServerPaths(...)

Database.UpgradeITAssist(...)

BACKUP DATABASE ITAssist TO DISK = N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ITAssist 02-46-05.24 PM.bak';

RESTORE DATABASE OMEssentials FROM DISK = N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ITAssist 02-46-05.24 PM.bak' WITH FILE = 1, MOVE N'ITAssist' TO N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\OMEssentials.MDF', MOVE N'ITAssist_Log' TO N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\OMEssentials_1.LDF',  NOUNLOAD,  STATS = 10

Unable to restore the a new [OMEssentials] database using the [ITAssist] backup file.

UpgradeErrorITAssistRestoreFailure

InstallUtil.InstallException: Undefined Installation Error ---> System.Data.SqlClient.SqlException: Logical file 'ITAssist' is not part of database 'OMEssentials'. Use RESTORE FILELISTONLY to list the logical file names.

RESTORE DATABASE is terminating abnormally.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at InstallUtil.Installers.Database.Database.UpgradeITAssist(SqlConnection sqlConnection)

  --- End of inner exception stack trace ---

  at InstallUtil.Installers.Database.Database.UpgradeITAssist(SqlConnection sqlConnection)

  at InstallUtil.Installers.Database.Database.Install(DatabaseOptions databaseOptions)

  at InstallUtil.Program.RunInstall(CommandLineArgumentsDictionary arguments)

  at InstallUtil.Program.Main(String[] args)

2013-02-26 02:46:06 PM

"C:\Program Files (x86)\Dell\SysMgt\Essentials\bin\WebInstall\InstallUtil.exe" -u

Uninstall()

Exception thrown while uninstalling our windows security groups.

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "OMEssentials" requested by the login. The login failed.

Login failed for user 'OMEService'.

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

  at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)

  at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)

  at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

  at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

  at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

  at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

  at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

  at System.Data.SqlClient.SqlConnection.Open()

  at InstallUtil.Installers.Database.Database.OpenSqlConnection(String initialDatabaseName)

  at InstallUtil.Installers.Database.Database.Uninstall(Nullable`1 databaseOptions)

Deleting Database [OMEssentials]

RemoveRegistryKeys()

Website un-install started...

Website un-install completed.

HostServiceInstaller.Uninstall()

Hi Ken, thanks for the post.

This scenario should certainly work....

A few things.  There is an install log under c:\windows\temp.  You may review/post that and that could give us a clue.

Also, OME 1.1 (w/ 1.1.1 ptach) is the latest on www.delltechcenter.com/ome and may be worth a try.  Be sure to always backup your existing ITA db before upgrading.

BTW, you may also try the Dell Troubleshooting tool (carried on OME install or d/l from DTC/OME) and try to see why you are having trouble with those servers.

Regards,

Rob

Rob, I did use the troubleshooting tool in ITA and that's where I'm saying the communications I need to the 3 problem children is all good.

I do have the 1.1.1 patch downloaded, but doesn't seem to me that's going to help if I can't get OME to install at all.

I'll get that install log up here shortly.

Not PS, you have to run it from within Studio (link in above post).  But feel free to just open a ticket if you don't want to bother with it.

Thx

Rob

Interesting...

Unable to restore the a new [OMEssentials] database using the [ITAssist] backup file.

During upgrade it creates an ITAssist backup file and restores it to a new OMEssentials

then it upgrades the copy.  This part if failing.

1.1 probably won't behave any better in this case.

Two options:

1. Call and open a ticket.  Then the sppt team can have access to the DB and see what is up.

2. If you are the adventurous type, log into SQL Mgt Studio (or the free one that is available for SQL Express) and type in the command below.  That will give us more info on what went wrong.

Will likely still need a ticket (800-945-3355).

Other idea is to upgrade to SQL 2012 and then try OME 1.1 install.  But I'm not sure if you are at that point yet.

Thanks,

Rob

--

This is the command we call during upgrade:

RESTORE DATABASE OMEssentials FROM DISK = N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ITAssist 02-46-05.24 PM.bak' WITH FILE = 1, MOVE N'ITAssist' TO N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\OMEssentials.MDF', MOVE N'ITAssist_Log' TO N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\OMEssentials_1.LDF', NOUNLOAD, STATS = 10

--

www.microsoft.com/.../details.aspx

Do you run that from Powershell?  I'm not a SQL type by any stretch of the imagination.

I'll probably do that tomorrow.  Either that or see if one of my DBA friends here will lend a hand.