CRM 3.0 to 4.0 upgrade fails > There is already an object named 'AttributeTypes' in the database

Mark Smyth

unread,

Feb 19, 2008, 3:35:49 AM2/19/08

to

Hi all
We have a CRM3.0 installation that we are trying to upgrade to version 4.0.
This work is being carried out in a virtual environment mirroring our live
environment for testing before we try the 'real thing'.

The error we are getting at the 'Installing and configuring Microsoft
Dynamics CRM databases' section is as below.

Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed.
There is already an object named 'AttributeTypes' in the database.

I have tried the installation twice now and got the same error each time.

Environment
Server 1 > Windows 2003 Standard x86 SP2 will ALL windows updates except
IE7.
CRM3.0 update rollup 2

Server 2 > Windows 2003 R2 Standard x64 SP2 running SQL2005 standard with
ALL windows SQL updates except IE7.

Any ideas?

Imran-mscrmexpert

unread,

Feb 19, 2008, 7:17:02 AM2/19/08

to

Dear see this

http://support.microsoft.com/kb/946590/en-us

Also see common upgrade issues on support forum

--
Regards,
Imran
MS CRM Certified Professional

http://microsoftcrm3.blogspot.com

Chat with me on MSN / Gmail / Skype : ID Is :.. mscrm...@gmail.com

Markus Schmidt

unread,

Feb 25, 2008, 10:08:56 AM2/25/08

to

I got the same message!
... and I hate Newsgroup where you'll find only problem without solutions!

Article http://support.microsoft.com/kb/946590/en-us does NOT solve this
problem because it's related to replication which I have never ever used.

Also, the message is different to the one mentioned in the KB-Article - "There

is already an object named 'AttributeTypes' in the database".

Is there a solution for that?
Markus

Leo Lopes @ L3

unread,

Apr 23, 2008, 2:06:36 PM4/23/08

to

Hey Mark and Markus,

Haven't you got any timeout error during setup inside the log?

Regards,
Leo Lopes @ L3

Alexandra

unread,

May 7, 2008, 7:44:01 PM5/7/08

to

Hi Mark,

Could you resolved this issue??

Alexandra

Aamir

unread,

May 8, 2008, 4:59:44 AM5/8/08

to

can you post the logfile here . I was having the same problem and it
was driving me crazy. I realized that database was missing "full text
search". I enabled full text search and created sql job manually. Then
it went smooth.

If you past the logfile then it will help us to see the root of
problem.

/Aamir

Alexandra

unread,

May 8, 2008, 12:59:13 PM5/8/08

to

Hi Aami:

this is my log:

System.Reflection.TargetInvocationException: Exception has been thrown by
the target of an invocation. --->

System.Data.SqlClient.SqlException: Cannot open database
"Pfizer_Venezuela_SA_MSCRM" requested by the login. The login

failed.
Login failed for user 'DEMODOMAIN\Administrator'.
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.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.CreateNonPooledConnection(DbConnection owningConnection,

DbConnectionPoolGroup poolGroup)
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.Crm.CrmDbConnection.Open()
at Microsoft.Crm.SqlExecutionContext.OnBeginRequest(Boolean
startTransaction, IsolationLevel isoLevel)
at Microsoft.Crm.SqlExecutionContext.OnBeginRequest(Boolean
startTransaction)
at
Microsoft.Crm.Workflow.Upgrade.WorkflowSaveData.CopyCurrentStepIdValues()
at Microsoft.Crm.Workflow.Upgrade.WorkflowSaveData.Save()
--- 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

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

Aamir

unread,

May 8, 2008, 5:47:58 PM5/8/08

to

Hi,

It seems that the installation went ahead from the logon issue

"
System.Data.SqlClient.SqlException: Cannot open database
"Pfizer_Venezuela_SA_MSCRM" requested by the login. The login

failed.
Login failed for user 'DEMODOMAIN\Administrator'.
"

AND

then it thrown exception on

"

Someone was having the same issue and i asked the user to restore the
CRM 3.0 and then check the SQL jobs . Its nice if you have another CRM
3.0 , so you can compare SQL jobs , their properties and everything.

/Aamir

Alexandra Fernandez

unread,

May 13, 2008, 2:43:01 PM5/13/08

to

Hi,
I checked the SQL jobs, but i dont have anyone. Neither CRM 3.0

Regards,

Aamir

unread,

May 13, 2008, 3:09:00 PM5/13/08

to

Hi,

i tell you the way i did .

1 = install CRM with the organization name as Test . You will get
Test_MSCRM and Test_Metabase .It will create the SQL jobs on your
production SQL server .

2 = uninstall the Test CRM .

3 = restore CRM 3,0 (production )

4 = at SQL jobs , change the name of Test to the name of Production
CRM . Make it sure you have changed properties and everything . You
need to manually select production_MSCRM instead of Test_MSCRM.

5 = enable full text index. Just enabling is not enough , you need to
use "Document "table to select parameters.

6 = run the SQL jobs to see if they are working properly

Now you upgrade the CRM server

/Aamir

myste...@gmail.com

unread,

May 14, 2008, 5:34:11 AM5/14/08

to

Hi Amir,
This is very interesting for me - I've been stuck on this problem for
a while.
Could you explain the stage where you write: "you need to

use "Document "table to select parameters."

I am not completely clear what you mean here.
Thanks in advance

Aamir

unread,

May 14, 2008, 6:52:11 AM5/14/08

to

I have added the screen shots here .

http://danishmscrm.blogspot.com/2008/05/crm-30-upgrade-issue-there-is-already.html

/Aamir

mysteryn11

unread,

May 14, 2008, 9:40:48 AM5/14/08

to

This has been a massive help to me and the organisation I am working
with.
I thank you so much.

On May 14, 12:52 pm, Aamir <whatels...@gmail.com> wrote:
> I have added the screen shots here .
>

> http://danishmscrm.blogspot.com/2008/05/crm-30-upgrade-issue-there-is...
>
> /Aamir

Aamir

unread,

May 15, 2008, 4:49:30 AM5/15/08

to

Great !!

Mostly when we move databases from one SQL server to the another SQL
server then it doesnt automatically create the SQL jobs .

/Aamir

Bjorn

unread,

May 24, 2008, 7:52:17 AM5/24/08

to

I'v got the same problem, here is the setup log.

Solve this and I'll jump through the .....
regards
bjorn

13:43:50| Error| System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->

System.Reflection.TargetInvocationException: Exception has been thrown by the

target of an invocation. ---> System.Data.SqlClient.SqlException: The object
'AK1_PluginType' is dependent on column 'FriendlyName'.
ALTER TABLE ALTER COLUMN FriendlyName failed because one or more objects
access this column.

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.CrmDbConnection.InternalExecuteNonQuery(IDbCommand
command)
at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command,
Boolean impersonate)
at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command)
at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper
helper, IDbCommand sqlCommand)
at
Microsoft.Crm.Metadata.AttributeUpdateAction.AlterColumn(MetadataBusinessEntity existingAttributeInfo, String tableName, String attributePhysicalName)
at Microsoft.Crm.Metadata.AttributeUpdateAction.DatabaseOperation()
at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation)

--- End of inner exception stack trace ---, Error, RetryCancel, Option1

--- End of inner exception stack trace ---, Error, RetryCancel, Option1

Aamir

unread,

May 25, 2008, 11:22:16 AM5/25/08

to

if you click on the link i gave and go through from the post then
check if the full text search is enabled on CRM 3.0 database?

/Aamir

Bjorn

unread,

May 26, 2008, 1:18:03 AM5/26/08

to

These are the steps performed before upgrade.

1. Restored production databases to test server
2. Manually created jobs (scripted from production server)
3. Enabled full-text search according to your blog
4. Run all jobs to check if Ok.
5. Installed CRM 3.0,
6. Rollup 2 installed

7. Upgrade to 4.0

Should also mention that I had some 3rd. party software installed on
production server. mscrm-addons.com / Celenia Navision -> CRM sync. These
were uninstalled, and I manually removed all custumization for Celenia
Navision -> CRM sync. ( I think.)

However as I get error saying AK1_pluginType is dependent on colum
'FriendlyName', I assum my uninstall was not complete.

Aamir

unread,

May 26, 2008, 4:16:19 AM5/26/08

to

I have even upgraded with mscrm-addons and one another vendor. There
was no problem with them . But you should check with Celenia . I
believe that they have callout for synchronization and you ou should
ask their developers about it.

"'AK1_PluginType' is dependent on column 'FriendlyName'.
ALTER TABLE ALTER COLUMN FriendlyName failed because one or more
objects
access this column ".

/Aamir

Geir

unread,

Jun 6, 2008, 6:04:09 PM6/6/08

to

Hello Bjorn

I got the exact same problem, have you found a solution yet? We have used
the C360 wordmailmerge. But that is uninstalled, and there should not be any
callouts.

Regards,
Geir

Engvik

unread,

Jul 30, 2008, 7:21:01 AM7/30/08

to

Hi Aamir...

What do you mean by 2 = uninstall the Test CRM ?

Delete the database?

Thanks!

Aamir Bashir

unread,

Jul 30, 2008, 8:01:01 AM7/30/08

to

Yes because you dont need the Test database ,but keep the SQL agent
jobs and you need to modify them, so they excute for Production
database.

http://mscrmsupport.wordpress.com/2008/05/14/crm-30-upgrade-issue-there-is-already-an-object-named-attributetypes-in-the-database/

------
Aamir

Blog = http://mscrmsupport.wordpress.com/

Message has been deleted

Engvik

unread,

Jul 31, 2008, 10:14:02 AM7/31/08

to

Hi.

Still no luck with this.. I get the same error over and over again...

I tried this multiple times now.

Pointed the SQL JOBS to the production DB after reinstall
3.0(TEST)/Uninstall 3.0 (TEST) and install 3.0 (Production) + Installing
1/2/3 Rollup.

The SQL Jobs Execute on the production DB but no luck with the upgrade
process...

I'm wondering about the step 2 in jour blog: Step2 = Manully add the
following columns.

If I go to the properties og Full-Text Index, all of the collums are
allready selected. Is this the place I get this wrong? Could you please
explain this in more detail?

Thanks...

nostra...@gmail.com

unread,

Sep 10, 2008, 2:13:29 AM9/10/08

to

On Aug 1, 12:14 am, Engvik <Eng...@discussions.microsoft.com> wrote:
> Hi.
>
> Still no luck with this.. I get the same error over and over again...
>
> I tried this multiple times now.
>
> Pointed the SQL JOBS to the production DB after reinstall
> 3.0(TEST)/Uninstall 3.0 (TEST) and install 3.0 (Production) + Installing
> 1/2/3 Rollup.
>
> The SQL Jobs Execute on the production DB but no luck with the upgrade
> process...
>
> I'm wondering about the step 2 in jour blog: Step2 = Manully add the
> following columns.
>
> If I go to the properties og Full-Text Index, all of the collums are
> allready selected. Is this the place I get this wrong? Could you please
> explain this in more detail?
>
> Thanks...
>
>
>
> "Aamir Bashir" wrote:
> > Yes because you dont need the Test database ,but keep the SQL agent
> > jobs and you need to modify them, so they excute for Production
> > database.
>

> >http://mscrmsupport.wordpress.com/2008/05/14/crm-30-upgrade-issue-the...
>
> > ------
> > Aamir
>
> > Blog =http://mscrmsupport.wordpress.com/- Hide quoted text -
>
> - Show quoted text -

Hi,

The link stated earlier does not work anymore, unfortunately as I
believe it could help me right now.... Is there a new location you
can provide for your screenshots?

Non working link:
http://danishmscrm.blogspot.com/2008/05/crm-30-upgrade-issue-there-is...

Cheers.