Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

MOSS SP2 Upgrade

  Asked By: Rachelle    Date: Sep 04    Category: MOSS    Views: 1582

I am just looking for feed back. I was wondering how long did your upgrade
to SP2 take. If you can provide details about your environment it would be
great. Things such as # of web apps, # of content DBs, average size of DBs.

I have performed the upgrade on several environments but each environment has
taken a different amount of time, so I am trying to see if I can see any pattern
or come up with some type of guideline since Microsoft does not seem to have an
estimated time.

I know this all depends on hardware, DBs and DB sizes but just trying to see.

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Lane Trujillo     Answered On: Sep 04

I have applied MOSS SP2 by following Microsoft's instruction and I am getting
the following error in the Log file.

LOG:
PManager] [INFO] [10/3/2009 8:02:46 PM]: Resetting the status of
PersistedUpgradableObject: SPWebApplication Name=PIPS Parent=SPWebService to
Online.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: ReflexiveUpgrade [SPWebApplication
Name=PIPS Parent=SPWebService] failed.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: Cannot open database
"Training_Published" requested by the login. The login failed.
Login failed for user 'PIPCNZ\svcMOSSFarmDB'.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
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, Int64 timerExpire,
SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, 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.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, 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 Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand
command)
at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.GetVersion(Guid id,
Version defaultVersion, SqlSession session, SPDatabaseSequence sequence)
at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.GetVersion(Guid id,
Version defaultVersion)
at
Microsoft.Office.Project.Server.Upgrade.ProjectDatabaseSequence.get_BuildVersion\
()
at Microsoft.SharePoint.Upgrade.SPSequence.get_CanUpgrade()
at Microsoft.SharePoint.Upgrade.SPManager.CanUpgrade(Object o)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.get_CanUpgrade()
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveCanUpgrade(Object o)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
[SPManager] [INFO] [10/3/2009 8:02:46 PM]: Resetting the status of
PersistedUpgradableObject: SPWebServiceInstance Parent=SPServer Name=DILBERT to
Online.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: ReflexiveUpgrade
[SPWebServiceInstance Parent=SPServer Name=DILBERT] failed.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: Cannot open database
"Training_Published" requested by the login. The login failed.
Login failed for user 'PIPCNZ\svcMOSSFarmDB'.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
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, Int64 timerExpire,
SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, 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 Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand
command)
at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.GetVersion(Guid id,
Version defaultVersion, SqlSession session, SPDatabaseSequence sequence)
at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.GetVersion(Guid id,
Version defaultVersion)
at
Microsoft.Office.Project.Server.Upgrade.ProjectDatabaseSequence.get_BuildVersion\
()
at Microsoft.SharePoint.Upgrade.SPSequence.get_CanUpgrade()
at Microsoft.SharePoint.Upgrade.SPManager.CanUpgrade(Object o)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.get_CanUpgrade()
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveCanUpgrade(Object o)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
[SPManager] [INFO] [10/3/2009 8:02:46 PM]: Resetting the status of
PersistedUpgradableObject: SPServer Name=DILBERT Parent=SPFarm
Name=MOSSConfiguration to Online.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: ReflexiveUpgrade [SPServer
Name=DILBERT Parent=SPFarm Name=MOSSConfiguration] failed.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: Cannot open database
"Training_Published" requested by the login. The login failed.
Login failed for user 'PIPCNZ\svcMOSSFarmDB'.
[SPManager] [ERROR] [10/3/2009 8:02:46 PM]: at

at
Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean
recursively)
at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean
bRecurse)
[SPManager] [INFO] [10/3/2009 8:02:46 PM]: Resetting the status of
PersistedUpgradableObject: SPFarm Name=MOSSConfiguration to Online.
[SPManager] [INFO] [10/3/2009 8:02:46 PM]: Inplace upgrade  session finishes.
root object = SPFarm Name=MOSSConfiguration, recursive = True. 8 errors and 0
warnings encountered.
[SPManager] [DEBUG] [10/3/2009 8:02:46 PM]: Removing exclusive upgrade regkey by
setting the mode to none
[SPManager] [DEBUG] [10/3/2009 8:02:48 PM]: SyncUpgradeTimerJob: Upgrade timer
job failed. Return -1.

*I have tried uprgading using STSADM, PSCONFIG commands also, but no such luck.
Also used forced upgrade.

*What I am shocked is that login is failing for a database that has been
deleted. I am unsure where to look for other references for this database
(Training_Published).

* I have also got 'b2b upgrader timer job failed'.

Any suggestions?

 
Answer #2    Answered By: Rafael Willis     Answered On: Sep 04

Is this for one of your SSP databases?
I have seen where the ssp needs to be reconfigured after this upgrade..
You might want to go and check your ssp configuration.

 
Answer #3    Answered By: Richard Davis     Answered On: Sep 04

I have managed to sort this out.

 
Answer #4    Answered By: Mason Davis     Answered On: Sep 04

I wanted to see if anyone has ran into this issue. I upgraded our farm to
SP2 and everything was working fine. Recently I was researching an issue and I
noticed that it seems that our sharepoint version changed. We have 2 WFE & 1 App
server. One of the WFE still shows the version 12.0.0.6510 but the other WFE and
APP server both show the version 12.0.0.6335.

I verified the servers showing version 12.0.0.6335 and they are patched
identical to the other WFE showing version 12.0.0.6510.

Has anyone seen this before?

 
Answer #5    Answered By: Savannah Pena     Answered On: Sep 04

You really should start a new thread for your issue:

www.myriadtech.com.au/.../Post.aspx?ID=24

 
Didn't find what you were looking for? Find more on MOSS SP2 Upgrade Or get search suggestion and latest updates.




Tagged: