none
Unable to update organization with delpoyement tools

    Question

  • Hi,

    I have this error. I have R8, 2243. I install the last R12v2, and I would like update my organization.

    09:29:28|Verbose| Retrieving database base language code Data Source=CRM-KLEEDEV;Initial Catalog=test_MSCRM;Integrated Security=True;Connect Timeout=60 ...
    09:29:28|   Info| Database base language code: 1036.
    09:29:28|   Info| Installer Start: OrganizationDatabaseHotFixer.Install: operation DatabaseHotFix
    09:29:28|   Info| Executing Install action: Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction
    09:29:28|   Info| Applying slipstream dbUpdates to organization.  Id=2e07654d-6d88-46fa-9419-ee97a7c1fdb4, UniqueName=test.
    09:29:32|   Info| UpdateRevisionForAllOrgs(install = True): revision = 1992.
    09:29:32|   Info| UpdateRevision(): orgId = 2e07654d-6d88-46fa-9419-ee97a7c1fdb4, newRevision = 1992, install = True.
    09:29:32|   Info| Database updates were successfully applied for orgId = 2e07654d-6d88-46fa-9419-ee97a7c1fdb4.
    09:29:32|   Info| Applying latest dbUpdates to organization.  Id=2e07654d-6d88-46fa-9419-ee97a7c1fdb4, UniqueName=test.
    09:29:35|   Info| CrmAction execution time; InstallDatabaseUpdatesAction; 00:00:06.3077401
    09:29:35|  Error| Installer Complete: OrganizationDatabaseHotFixer - Error encountered
    09:29:35|  Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationDatabaseHotFixer: Échec de l'action Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.
    InnerException:
    System.Data.SqlClient.SqlException (0x80131904): La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.
    La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.
    L'instruction a été arrêtée.
    L'instruction a été arrêtée.
       à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       à System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       à System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       à Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout, Boolean disablePool)
       à Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
       à Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
       à Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       à Microsoft.Crm.Setup.Database.DatabaseInstaller.InstallUpdate(String configurationFilePath, Boolean upgradeDatabase)
       à Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ApplyDBUpdates(Guid orgId)
       à Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdatesInternal(Guid orgId, String orgUniqueName, String releaseFilePath, Boolean ignoreErrors)
       à Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdates(Guid orgId, String orgUniqueName, OrganizationOperationType operationType)
       à Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.Do(IDictionary parameters)
       à Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
    ClientConnectionId:317a09ff-2042-4484-9aca-ec4ba407ba6c

    09:29:35|   Info| Setting organization state.  New state = Failed
    09:29:35|  Error| La mise à jour de l’organisation (ID=2e07654d-6d88-46fa-9419-ee97a7c1fdb4) a échoué avec l’exception :
    System.Exception: Échec de l'action Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction. ---> System.Data.SqlClient.SqlException: La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.
    La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.
    L'instruction a été arrêtée.
    L'instruction a été arrêtée.
       à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       à System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       à System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       à Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout, Boolean disablePool)
       à Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
       à Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
       à Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       à Microsoft.Crm.Setup.Database.DatabaseInstaller.InstallUpdate(String configurationFilePath, Boolean upgradeDatabase)
       à Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ApplyDBUpdates(Guid orgId)
       à Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdatesInternal(Guid orgId, String orgUniqueName, String releaseFilePath, Boolean ignoreErrors)
       à Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdates(Guid orgId, String orgUniqueName, OrganizationOperationType operationType)
       à Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.Do(IDictionary parameters)
       à Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- Fin de la trace de la pile d'exception interne ---
       à Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       à Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       à Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       à Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       à Microsoft.Crm.Tools.Admin.OrganizationDatabaseHotFixer.Execute()
       à Microsoft.Crm.Tools.Admin.ApplyDatabaseHotFixInstaller.ApplyDatabaseHotFix(IApplyDatabaseHotFixInfo applyDatabaseHotFixInfo)
    09:29:35|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 3236.


    Wednesday, February 13, 2013 8:39 AM

All replies

  • I Have the Same ERROR. No solutions until now.

    00:14:34|  Error| Installer Complete: OrganizationDatabaseHotFixer - Error encountered
    00:14:34|  Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationDatabaseHotFixer: Error de la acción Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.
    InnerException:
    System.Data.SqlClient.SqlException (0x80131904): La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
    La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
    Se terminó la instrucción.
    Se terminó la instrucción.

    Monday, February 18, 2013 2:14 PM
  • hi

    maybe this is help

    http://social.microsoft.com/Forums/en-US/crmdeployment/thread/c87cc9d2-3c4f-4a18-8a39-ae6c045749e4

    Monday, March 18, 2013 10:44 AM