locked
Migration from CRM 4.0 to CRM 2011 failed RRS feed

  • Question

  • Hi,

    we have CRM 4.0 with rollup 12 running. A few months ago i migrated our 4.0 dev version to CRM 2011 beta. We used a new DB and app server. I installed first 2011 on the new servers, thne i brought my organization_MSCRM DB to the new server and used the deployment manager to migrate. All went fine and easy.

    Now we are ready to move to CRM 2011.  Idid the saem approach, but this time with CRM 2011 latest version. I installed rollup 1 and 2. I strarted the migration process from CRM 4.0 rollup 12 to CRM 2011.

    It wnet almost totally through till i got at the end eror message adn migration failed. One part was becasue of our custom trigger. I took them out but still failed. We even dleeted all our custom SP and custom tables which were doen outside the CRM UI. Still failed.

    We have many custom fields and workflows but they are all done through CRM UI therefore there should not be an issue, or? Especially that the upgrade worked just fine with CRM 2011 beta. And help would be appreciated.

    ror| Installer Complete: OrganizationUpgrader - Error encountered
    15:24:30|  Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed.
    InnerException:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.Reporting.SRSReport.ConvertDatasetBack(XmlNode dataset, Hashtable commandTextHash)
       at Microsoft.Crm.Reporting.SRSReport.ConvertReportBack(BusinessEntity report, String defaultFilter, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.DownloadReportEntityDefinition(BusinessEntity report, Boolean includeFilters, ExecutionContext context)
       at Microsoft.Crm.DataUpgrade.ReportUpgradeDriver.OriginalBodyTextUpgrade()
       --- End of inner exception stack trace ---

    15:24:30|   Info| Setting organization state.  New state = Failed
    15:24:30|  Error| Upgrade Organization with Id=7096e443-d903-4852-99b2-267eadcb262f failed with Exception:
    System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.Reporting.SRSReport.ConvertDatasetBack(XmlNode dataset, Hashtable commandTextHash)
       at Microsoft.Crm.Reporting.SRSReport.ConvertReportBack(BusinessEntity report, String defaultFilter, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.DownloadReportEntityDefinition(BusinessEntity report, Boolean includeFilters, ExecutionContext context)
       at Microsoft.Crm.DataUpgrade.ReportUpgradeDriver.OriginalBodyTextUpgrade()

    15:24:30|  Error| An error occurred when trying import and upgrade organization database 100IT016.Triad2011_MSCRM:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=7096e443-d903-4852-99b2-267eadcb262f failed with Exception:
    System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.Reporting.SRSReport.ConvertDatasetBack(XmlNode dataset, Hashtable commandTextHash)
       at Microsoft.Crm.Reporting.SRSReport.ConvertReportBack(BusinessEntity report, String defaultFilter, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.DownloadReportEntityDefinition(BusinessEntity report, Boolean includeFilters, ExecutionContext context)
       at Microsoft.Crm.DataUpgrade.ReportUpgradeDriver.OriginalBodyTextUpgrade()
       --- End of inner exception stack trace ---
      
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo) ---> System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.Reporting.SRSReport.ConvertDatasetBack(XmlNode dataset, Hashtable commandTextHash)
       at Microsoft.Crm.Reporting.SRSReport.ConvertReportBack(BusinessEntity report, String defaultFilter, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.DownloadReportEntityDefinition(BusinessEntity report, Boolean includeFilters, ExecutionContext context)
       at Microsoft.Crm.DataUpgrade.ReportUpgradeDriver.OriginalBodyTextUpgrade()
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType 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(ReleaseInfo releaseInfo, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)


    15:24:30|  Error| Import Organization (Name=Triad, Id=7096e443-d903-4852-99b2-267eadcb262f) failed with Exception:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=7096e443-d903-4852-99b2-267eadcb262f failed with Exception:
    System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.Reporting.SRSReport.ConvertDatasetBack(XmlNode dataset, Hashtable commandTextHash)
       at Microsoft.Crm.Reporting.SRSReport.ConvertReportBack(BusinessEntity report, String defaultFilter, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.DownloadReportEntityDefinition(BusinessEntity report, Boolean includeFilters, ExecutionContext context)
       at Microsoft.Crm.DataUpgrade.ReportUpgradeDriver.OriginalBodyTextUpgrade()
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType 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(ReleaseInfo releaseInfo, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo) ---> System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.Reporting.SRSReport.ConvertDatasetBack(XmlNode dataset, Hashtable commandTextHash)
       at Microsoft.Crm.Reporting.SRSReport.ConvertReportBack(BusinessEntity report, String defaultFilter, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.DownloadReportEntityDefinition(BusinessEntity report, Boolean includeFilters, ExecutionContext context)
       at Microsoft.Crm.DataUpgrade.ReportUpgradeDriver.OriginalBodyTextUpgrade()
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType 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(ReleaseInfo releaseInfo, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)

    Wednesday, June 8, 2011 12:19 PM

All replies

  • Based on the error log, it looks like the problem is when the upgrade process is attempting to convert on or more RS reports. The error doesn't give any more information than this, but I'd suggest removing any custom reports if possible, and retrying the upgrade.

    If any reports use the custom SQL objects (e.g. tables or stored procedures) that you've removed, then this could be another reason for the upgrade to fail 


    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Wednesday, June 8, 2011 2:14 PM
    Moderator
  • can you please reensure that you have removed the custom SPs and you do not use deletionstatecode, as this is not present in ms crm 2011 at all.
    yes.sudhanshu

    http://bproud2banindian.blogspot.com
    http://ms-crm-2011-beta.blogspot.com
    Thursday, July 21, 2011 6:49 AM