Tech Support > Microsoft Windows > Windows CRM > Upgrade 3.0 to 4.0 failed: object named 'Attributetypes' already i
Upgrade 3.0 to 4.0 failed: object named 'Attributetypes' already i
Posted by adrianh on May 1st, 2008


Setup failed with 2 errors of which the first appeared to be ignored on a
retry but then the second would not continue.

Now what?

Log is:
16:53:55| Info| Metadata xml upgrade: pass 1
16:53:55| Info| Metadata xml upgrade: pass 1
16:54:34| Info| Metadata xml upgrade: pass 2
16:54:34| Info| Metadata xml upgrade: pass 2
16:54:55| Info| Updating metadata for custom many-to-many relationships
16:54:55| Info| Updating metadata for custom many-to-many relationships
16:54:59| Info| Upgrading the views in the MSCRM database
16:54:59| Info| Upgrading the views in the MSCRM database
16:55:44| Info| The metadata for the custom entities is being upgraded
16:55:44| Info| The metadata for the custom entities is being upgraded
16:55:59| Error| System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Reflection.TargetInvocationException: Exception has been thrown by the
target of an invocation. ---> System.ArgumentException: parsing
"(\\(PayX:[0-9]+)" - Not enough )'s.
at System.Text.RegularExpressions.RegexParser.ScanReg ex()
at System.Text.RegularExpressions.RegexParser.Parse(S tring re,
RegexOptions op)
at System.Text.RegularExpressions.Regex..ctor(String pattern,
RegexOptions options, Boolean useCache)
at System.Text.RegularExpressions.Regex..ctor(String pattern,
RegexOptions options)
at
Microsoft.Crm.Caching.OrganizationSettings.InitTra ckingPrefixes(ICacheEntityWrapper organization)
at
Microsoft.Crm.Caching.OrganizationSettings.Initial ize(ICacheEntityWrapper
organization, Dictionary`2 organizationLanguages)
at
Microsoft.Crm.Caching.OrganizationSettingsCacheLoa der.LoadCacheData(Guid key,
ExecutionContext context)
at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.Loa dCacheData(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.GetLabel sForResource(String
resourceName, Guid objectId, String objectColumnName, String collectionName,
String labelName, IOrganizationContext context)
at
Microsoft.Crm.Metadata.MigrationAttributeHelper.Cr eateImportSequenceNumberField(Guid entityId, MetadataHelper metadataHelper, ExecutionContext context)
at
Microsoft.Crm.DataUpgrade.MigrationFieldsUpgrade.M igrationFieldsUpgradeDriver.UpgradeCustomEntitiesF orMigration()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(Objec t 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.Execu te()
at
Microsoft.Crm.Setup.Database.DatabaseInstaller.Exe cuteReleases(ReleaseCollection releases, Int32 currentProgress)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ins tallInternal()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Ins tall(Int32
languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.D o(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Ac tion action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---, Error, RetryCancel, Option1
17:00:24| Info| InputResult: Retry
17:00:24| Info| Dropping v3 sql jobs
17:00:24| Info| Dropping v3 sql jobs
17:00:24| Info| Dropping v3 sql jobs
17:00:24| Info| Creating v3.0 metabase tables in database
17:00:24| Info| Creating v3.0 metabase tables in database
17:00:24| Info| Creating v3.0 metabase tables in database
17:00:24| 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(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.Crm.Setup.Database.DatabaseUtility.Execu teSql(InstallDatabase
database, String sql, Int32 timeout)
at Microsoft.Crm.Setup.Database.SqlScriptAction.Execu te(DatabaseUtility
dbUtility)
at
Microsoft.Crm.Setup.Database.DatabaseInstaller.Exe cuteReleases(ReleaseCollection releases, Int32 currentProgress)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ins tallInternal()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Ins tall(Int32
languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.D o(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Ac tion action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---, Error, RetryCancel, Option1
17:00:38| Info| InputResult: Retry
17:00:38| Info| Dropping v3 sql jobs
17:00:38| Info| Dropping v3 sql jobs
17:00:38| Info| Dropping v3 sql jobs
17:00:38| Info| Dropping v3 sql jobs

Posted by Carlos Martinez on May 8th, 2008


Hi, I have the same error. I see that the upgrade process bring to the firt
step "Dropping v3 sql jobs"
Because this objects already exists the upgrade process issue an error. Like
you I am loooking for an answer about this.


"adrianh" wrote:

Posted by Aamir on May 8th, 2008


The first thing is that you need to restore back to CRM 3.0 AND then
check if the SQL jobs in your production systems are there and working
fine. If you have doubt then install a test CRM 3.0 system and
compare the sql jobs of production CRM with the test one . Remember to
open the jobs and check properties and everything. make it sure full
text search is working on database and specificlly to a table ( I
think the table name is document as i dont have CRM infront of me .
Make it sure that the options are checked for search).


I gone through from same pain .

/Aamir