locked
CRM 3.0 to 4.0 Upgrade Error RRS feed

  • Question

  • Received the error "Could not find GUID for server" when trying to upgrade our test server from version 3.0 to version 4.0.

     

    Any insight would be appreciated.

     

    Relevant log portion follows:

     

     

    13:55:45|   Info| Metadata xml upgrade: pass 1
    13:55:45|   Info| Metadata xml upgrade: pass 1
    13:56:00|   Info| Metadata xml upgrade: pass 2
    13:56:00|   Info| Metadata xml upgrade: pass 2
    13:56:10|   Info| Updating metadata for custom many-to-many relationships
    13:56:10|   Info| Updating metadata for custom many-to-many relationships
    13:56:12|   Info| Upgrading the views in the MSCRM database
    13:56:12|   Info| Upgrading the views in the MSCRM database
    13:56:24|   Info| The metadata for the custom entities is being upgraded
    13:56:24|   Info| The metadata for the custom entities is being upgraded

    13:56:26|  Error| System.Exception: Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.BusinessEntities.CrmSecurityException: Could not find GUID for server: CRMSERVER$
       at Microsoft.Crm.BusinessEntities.SecurityUtils.GetGuidFromServerName(String serverName)
       at Microsoft.Crm.BusinessEntities.SecurityUtils.GetLocalSystemGuid()
       at Microsoft.Crm.Caching.OrganizationSettingsCacheLoader.LoadCacheData(Guid key, ExecutionContext context)
       at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)
       at Microsoft.Crm.Caching.BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context)
       at Microsoft.Crm.Caching.BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
       at Microsoft.Crm.Metadata.LocalizationHelper.GetLabelsForResource(String resourceName, Guid objectId, String objectColumnName, String collectionName, String labelName, IOrganizationContext context)
       at Microsoft.Crm.Metadata.MigrationAttributeHelper.CreateImportSequenceNumberField(Guid entityId, MetadataHelper metadataHelper, ExecutionContext context)
       at Microsoft.Crm.DataUpgrade.MigrationFieldsUpgrade.MigrationFieldsUpgradeDriver.UpgradeCustomEntitiesForMigration()
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Crm.Setup.Database.DllMethodAction.Execute()
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection releases, Int32 currentProgress)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal()
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
       at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    14:05:08|   Info| InputResult: Retry
    14:05:08|   Info| Dropping v3 sql jobs
    14:05:08|   Info| Dropping v3 sql jobs
    14:05:08|   Info| Dropping v3 sql jobs
    14:05:08|   Info| Creating v3.0 metabase tables in database
    14:05:08|   Info| Creating v3.0 metabase tables in database
    14:05:08|   Info| Creating v3.0 metabase tables in database
    14:05:08|  Error| System.Exception: Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. ---> System.Data.SqlClient.SqlException: There is already an object named 'AttributeTypes' in the database.
       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(TdsParserStateObject stateObj)
       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 Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout)
       at Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection releases, Int32 currentProgress)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal()
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
       at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    14:05:13|   Info| InputResult: Retry
    14:05:13|   Info| Dropping v3 sql jobs
    14:05:13|   Info| Dropping v3 sql jobs
    14:05:13|   Info| Dropping v3 sql jobs
    14:05:13|   Info| Dropping v3 sql jobs
    14:05:13|   Info| Creating v3.0 metabase tables in database
    14:05:13|   Info| Creating v3.0 metabase tables in database
    14:05:13|   Info| Creating v3.0 metabase tables in database
    14:05:13|   Info| Creating v3.0 metabase tables in database
    14:05:13|  Error| System.Exception: Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. ---> System.Data.SqlClient.SqlException: There is already an object named 'AttributeTypes' in the database.
       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(TdsParserStateObject stateObj)
       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 Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout)
       at Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection releases, Int32 currentProgress)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal()
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
       at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    14:05:15|   Info| InputResult: Cancel
    14:05:15|  Error| Install exception.System.Exception: Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. ---> System.Data.SqlClient.SqlException: There is already an object named 'AttributeTypes' in the database.
       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(TdsParserStateObject stateObj)
       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 Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout)
       at Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection releases, Int32 currentProgress)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal()
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
       at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Setup.Server.DatabaseInstaller.Install(IDictionary stateSaver)
       at Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary stateSaver)
       at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary stateSaver)
       at Microsoft.Crm.Setup.Server.ServerSetup.Upgrade(IDictionary data)
       at Microsoft.Crm.Setup.Server.ServerSetup.Run()
    14:05:15|   Info| Microsoft Dynamics CRM Server upgrade Failed.
    14:05:15|   Info| Microsoft Dynamics CRM Server Setup did not complete successfully.

    Friday, June 13, 2008 3:04 PM

All replies

  • Jason,

     

    It looks to me like an AD issue.

     

    Are you using Domain Admin to upgrade the server? Is so, try run adsiedit.msc to check the computer matchs it's GUID.

     

    Jim

     

     

     

    Sunday, June 15, 2008 10:30 AM
    Moderator
  • here is common upgrade issues

     

    http://support.microsoft.com/kb/947061

     

    you can check your business unit

     

    Regards,

    Imran

     

    http://microsoftcrm3.blogspot.com

     

     

    Monday, June 16, 2008 7:43 AM
    Moderator
  • I a using a domain admin account to upgrade.

     

    In ADSIEdit in the objectGUID which form of the value am I looking at (Hexadecimal...etc)  and where am I comparing it to?

     

    Monday, June 16, 2008 2:24 PM
  • Hello,

    I currently have exactly the same problem. Is there any help?

    I tried to compare the objectGUID of the machine stored in AD with the one reported as machineGUID for the local machine - but they're not identical for any of my machines in the AD so this could not be the point.


    Thank you in advance!
    Monday, August 17, 2009 2:53 PM