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?
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
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
Haven't you got any timeout error during setup inside the log?
Regards,
Leo Lopes @ L3
Could you resolved this issue??
Alexandra
If you past the logfile then it will help us to see the root of
problem.
/Aamir
this is my log:
19:17:52| Info| Metadata xml upgrade: pass 1
19:17:52| Info| Metadata xml upgrade: pass 1
19:24:52| Info| Saving workflow data
19:24:52| Info| Saving workflow data
19:24:56| Error| System.Exception: Error de la acción
Microsoft.Crm.Setup.Server.InstallDatabaseAction. --->
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
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
19:26:22| Info| InputResult: Retry
19:26:26| Info| Dropping v3 sql jobs
19:26:26| Info| Dropping v3 sql jobs
19:26:26| Info| Dropping v3 sql jobs
19:26:27| Info| Creating v3.0 metabase tables in database
19:26:27| Info| Creating v3.0 metabase tables in database
19:26:27| Info| Creating v3.0 metabase tables in database
19:26:29| Error| System.Exception: Error de la acción
Microsoft.Crm.Setup.Server.InstallDatabaseAction. --->
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
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
"
--- End of inner exception stack trace ---, Error, RetryCancel,
Option1
19:26:22| Info| InputResult: Retry
19:26:26| Info| Dropping v3 sql jobs
19:26:26| Info| Dropping v3 sql jobs
19:26:26| Info| Dropping v3 sql jobs
19:26:27| Info| Creating v3.0 metabase tables in database
19:26:27| Info| Creating v3.0 metabase tables in database
19:26:27| Info| Creating v3.0 metabase tables in database
19:26:29| Error| System.Exception: Error de la acción
Microsoft.Crm.Setup.Server.InstallDatabaseAction. --->
"
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
Regards,
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
http://danishmscrm.blogspot.com/2008/05/crm-30-upgrade-issue-there-is-already.html
/Aamir
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
Mostly when we move databases from one SQL server to the another SQL
server then it doesnt automatically create the SQL jobs .
/Aamir
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
13:45:42| Info| InputResult: Retry
13:45:42| Info| Avbryter v3 SQL-jobber
13:45:42| Info| Avbryter v3 SQL-jobber
13:45:42| Info| Avbryter v3 SQL-jobber
13:45:42| Info| Oppretter v3.0-metabasetabeller i databasen
13:45:42| Info| Oppretter v3.0-metabasetabeller i databasen
13:45:42| Info| Oppretter v3.0-metabasetabeller i databasen
13:45:42| Error| System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Data.SqlClient.SqlException: There is already an object named
'AttributeTypes' in the database.
--- End of inner exception stack trace ---, Error, RetryCancel, Option1
13:45:44| Info| InputResult: Retry
13:45:44| Info| Avbryter v3 SQL-jobber
13:45:44| Info| Avbryter v3 SQL-jobber
13:45:44| Info| Avbryter v3 SQL-jobber
13:45:44| Info| Avbryter v3 SQL-jobber
/Aamir
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.
"'AK1_PluginType' is dependent on column 'FriendlyName'.
ALTER TABLE ALTER COLUMN FriendlyName failed because one or more
objects
access this column ".
/Aamir
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
What do you mean by 2 = uninstall the Test CRM ?
Delete the database?
Thanks!
------
Aamir
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...
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.