Unable to update organization with delpoyement tools

Unanswered Unable to update organization with delpoyement tools

  • Wednesday, February 13, 2013 8:39 AM
     
     

    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.


    • Edited by romsworld Wednesday, February 13, 2013 8:40 AM
    •  

All Replies

  • Monday, February 18, 2013 2:14 PM
     
     

    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, March 18, 2013 10:44 AM
     
     

    hi

    maybe this is help

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