Question Status

Unanswered
david@kemedia.net asked a question on 10 Mar 2015 1:09 AM

I cannot create a new organization with the CRM Deployment Manager.  i get the error:

Error;ActionFailed

Microsoft.CRM.Tools.Admin.CreateDatabaseAction 

The log file indicates that it is a password complexity issue, but each of the accountys I created to setup and deploy CRM were complex.  Also, SQL Server shows that the a new DB has been created.  Does anyone have any advice?

The log file indicates :

Error| Installer Complete: OrganizationCreator - Error encountered
01:24:14| Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationCreator: Error.ActionFailed Microsoft.Crm.Tools.Admin.CreateDatabaseAction
InnerException:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Password validation failed. The password does not meet the requirements of the password filter DLL.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
at Microsoft.Crm.SqlCellLevelEncryption.BasicEncryptionOperations.ExecuteNonQuery(String commandFormat, Object[] args)
at Microsoft.Crm.SqlCellLevelEncryption.BasicEncryptionOperations.CreateSymmetricKeyByPassword(String symmetricKeyName, String keySource, String password, String identityValue)
at Microsoft.Crm.SqlCellLevelEncryption.OrgDBEncryptionImplementationBase.CreateSymmetricKeyByPassword(String symmetricKeySource, Boolean throwIfExistAlready)
at Microsoft.Crm.SqlCellLevelEncryption.OrgDBPrimaryEncryption.RestoreEncryptionKey(String symmetricKeySource, Boolean forceDeleteExistingEncryptionChain)
at Microsoft.Crm.SqlCellLevelEncryption.EncryptionExecutor.ExecuteOnSingleReplica(Tuple`2 encryptionForDB, ExecuteEncryption executeEncryption)
at Microsoft.Crm.DataUpgrade.SetSqlCellLevelEncryptionAction.Execute(Boolean isOnlineProvisioningOrganization)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
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(Guid organizationId)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
InnerException:
System.Data.SqlClient.SqlException (0x80131904): Password validation failed. The password does not meet the requirements of the password filter DLL.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
at Microsoft.Crm.SqlCellLevelEncryption.BasicEncryptionOperations.ExecuteNonQuery(String commandFormat, Object[] args)
at Microsoft.Crm.SqlCellLevelEncryption.BasicEncryptionOperations.CreateSymmetricKeyByPassword(String symmetricKeyName, String keySource, String password, String identityValue)
at Microsoft.Crm.SqlCellLevelEncryption.OrgDBEncryptionImplementationBase.CreateSymmetricKeyByPassword(String symmetricKeySource, Boolean throwIfExistAlready)
at Microsoft.Crm.SqlCellLevelEncryption.OrgDBPrimaryEncryption.RestoreEncryptionKey(String symmetricKeySource, Boolean forceDeleteExistingEncryptionChain)
at Microsoft.Crm.SqlCellLevelEncryption.EncryptionExecutor.ExecuteOnSingleReplica(Tuple`2 encryptionForDB, ExecuteEncryption executeEncryption)
at Microsoft.Crm.DataUpgrade.SetSqlCellLevelEncryptionAction.Execute(Boolean isOnlineProvisioningOrganization)
ClientConnectionId:46452fd0-edb6-439f-b71f-3d3fd11375d4
Error Number:15119,State:1,Class:16

01:24:14| Info| Setting organization state. New state = Failed
01:24:14| Error| Create new Organization (Name=39c112a1-e5c6-e411-810e-0c84dccc85c9, Id=KEM) failed with Exception:
System.Exception: Error.ActionFailed Microsoft.Crm.Tools.Admin.CreateDatabaseAction ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Password validation failed. The password does not meet the requirements of the password filter DLL.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
at Microsoft.Crm.SqlCellLevelEncryption.BasicEncryptionOperations.ExecuteNonQuery(String commandFormat, Object[] args)
at Microsoft.Crm.SqlCellLevelEncryption.BasicEncryptionOperations.CreateSymmetricKeyByPassword(String symmetricKeyName, String keySource, String password, String identityValue)
at Microsoft.Crm.SqlCellLevelEncryption.OrgDBEncryptionImplementationBase.CreateSymmetricKeyByPassword(String symmetricKeySource, Boolean throwIfExistAlready)
at Microsoft.Crm.SqlCellLevelEncryption.OrgDBPrimaryEncryption.RestoreEncryptionKey(String symmetricKeySource, Boolean forceDeleteExistingEncryptionChain)
at Microsoft.Crm.SqlCellLevelEncryption.EncryptionExecutor.ExecuteOnSingleReplica(Tuple`2 encryptionForDB, ExecuteEncryption executeEncryption)
at Microsoft.Crm.DataUpgrade.SetSqlCellLevelEncryptionAction.Execute(Boolean isOnlineProvisioningOrganization)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
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(Guid organizationId)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---
at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
at Microsoft.Crm.Setup.Shared.Installer.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationCreator.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
at Microsoft.Crm.Tools.Admin.OrganizationCreator.Execute()
at Microsoft.Crm.Tools.Admin.CreateOrganizationInstaller.Create(ICreateOrganizationInfo organizationInfo)
01:24:14| Info| Found the older table DBUpdateInstallInfo_V5, updating new table and deleting
01:24:14| Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 6.1.0002.0112.

Reply
Shailaja Mahajan responded on 15 Mar 2015 6:12 PM

Hello David,

 

Verify that CRM admin shold be a part of PrivUser Groups in AD.

Change the AutoGroupManagementOff registry key from 0 to 1 in the following hive on the CRM Server: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM.

Perform an IISRESET by going to Start > Run, type IISreset and click OK, and try to import the organization again.

Thank you.

Reply
david@kemedia.net responded on 16 Mar 2015 12:47 AM

I tried these suggestions and still got the same error.  Any further insight?  Maybe I should uninstall/reinstall? Please help.  I would love to use Dynamis CRM.

Reply
Mansoor Sulaiman responded on 25 Mar 2015 3:59 AM

Can you please change deployment admin password and then give a try?

Mansoor

Reply
Bruno Lucas responded on 25 Mar 2015 4:53 AM

you can also find the "deployment administrator" login though this:

ronaldlemmen.blogspot.co.nz/.../find-out-deployment-administrators.html

this is  how you can add an deployment  "administrator" blogs.msdn.com/.../6-steps-to-add-a-deployment-administrator-in-microsoft-dynamics-crm-2011.aspx

Bruno Lucas, Senior CRM Consultant

DynamicDay CRM Blog 

Please mark my post as "Verified" If it helped to solve your problem 

Reply