none
Microsoft Dynamics CRM 2013 beta organization import fails with System.IndexOutOfRangeException: HasIdsTable

    Question

  •         

    We joined the Microsoft Dynamics CRM 2013 beta program and successfully migrated a CRM 2011 organization to CRM 2013 Beta. Now I'm trying to import this migrated organization database into the final CRM 2013 RTM version, but when doing this the following error occurs during the migrating/update process:

    System.IndexOutOfRangeException: HasIdsTable

    Does anybody know how to solve this? It looks like a missing column or record or something. Below the full stacktraces:

    Crm Exception: Message: Update Organization with Id=290dd397-411f-e111-8b0b-005056890008 failed with Exception:
    System.IndexOutOfRangeException: HasIdsTable
       at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
       at System.Data.SqlClient.SqlDataReader.get_Item(String name)
       at Microsoft.Crm.Metadata.EntityDescription.FillPropertiesFromDataReader(IDataReader reader)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.LoadDescriptions(Boolean isSystemDataLoaded, CrmDbConnection connection, IDbTransaction transaction, MetadataContainer systemContainer, MetadataContainer aggregateContainer, TableFillPropertiesMultiOrg properties, CounterList counter)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.LoadContainerData(Boolean isSystemDataLoaded, Boolean isSystemLanguageDataLoaded, CrmDbConnection connection, IDbTransaction transaction, MetadataContainer systemContainer, MetadataContainer aggregateContainer, List`1 fillProperties, CounterList counter)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.BuildMetadataContainerFromDatabase(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction, CounterList counter)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.<>c__DisplayClass1.<LoadMetadataContainerFromDatabase>b__0(CrmDbConnection sqlConn, IDbTransaction sqlTrans)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadMetadataContainerFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId, CounterList counter, BuildMetadataContainerFromDatabaseTemplate buildMetadataContainerFromDatabase, Nullable`1 optionalVersionNumberToFilterResults)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadMetadataContainerFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId, CounterList counter, Nullable`1 optionalVersionNumberToFilterResults)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, IOrganizationContext context, CounterList counter)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context, CounterList counter)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
       at Microsoft.Crm.Metadata.MetadataCache.LoadCache(IOrganizationContext context, Boolean fileOnlyIfExists)
       at Microsoft.Crm.Metadata.MetadataCache.GetInstance(IOrganizationContext context)
       at Microsoft.Crm.Query.EntityExpression.Init(String entityPlatformName)
       at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.UpdateOrganizationInOrgDB(Guid organizationId, String friendlyName)
       at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.Update(Guid organizationId, String friendlyName, String sqlServerName, Uri reportingUrl), ErrorCode: -2147176447, InnerException: System.IndexOutOfRangeException: HasIdsTable
       at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
       at System.Data.SqlClient.SqlDataReader.get_Item(String name)
       at Microsoft.Crm.Metadata.EntityDescription.FillPropertiesFromDataReader(IDataReader reader)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.LoadDescriptions(Boolean isSystemDataLoaded, CrmDbConnection connection, IDbTransaction transaction, MetadataContainer systemContainer, MetadataContainer aggregateContainer, TableFillPropertiesMultiOrg properties, CounterList counter)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.LoadContainerData(Boolean isSystemDataLoaded, Boolean isSystemLanguageDataLoaded, CrmDbConnection connection, IDbTransaction transaction, MetadataContainer systemContainer, MetadataContainer aggregateContainer, List`1 fillProperties, CounterList counter)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.BuildMetadataContainerFromDatabase(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction, CounterList counter)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.<>c__DisplayClass1.<LoadMetadataContainerFromDatabase>b__0(CrmDbConnection sqlConn, IDbTransaction sqlTrans)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadMetadataContainerFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId, CounterList counter, BuildMetadataContainerFromDatabaseTemplate buildMetadataContainerFromDatabase, Nullable`1 optionalVersionNumberToFilterResults)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadMetadataContainerFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId, CounterList counter, Nullable`1 optionalVersionNumberToFilterResults)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, IOrganizationContext context, CounterList counter)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context, CounterList counter)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
       at Microsoft.Crm.Metadata.MetadataCache.LoadCache(IOrganizationContext context, Boolean fileOnlyIfExists)
       at Microsoft.Crm.Metadata.MetadataCache.GetInstance(IOrganizationContext context)
       at Microsoft.Crm.Query.EntityExpression.Init(String entityPlatformName)
       at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.UpdateOrganizationInOrgDB(Guid organizationId, String friendlyName)
       at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.Update(Guid organizationId, String friendlyName, String sqlServerName, Uri reportingUrl)

    And

    [2013-11-13 16:15:05.731] Process:  mmc |Organization:00000000-0000-0000-0000-000000000000 |Thread:   26(Async/Worker-thread.) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId:  | DynamicMetadataCacheLoader.LoadMetadataContainerFromDatabaseInternal  ilOffset = 0x148
    >Exception while loading Metadata Cache from Database with LoadMasks = OData, All using new connection and new transaction. Exception: System.IndexOutOfRangeException: HasIdsTable
       at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
       at System.Data.SqlClient.SqlDataReader.get_Item(String name)
       at Microsoft.Crm.Metadata.EntityDescription.FillPropertiesFromDataReader(IDataReader reader)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.LoadDescriptions(Boolean isSystemDataLoaded, CrmDbConnection connection, IDbTransaction transaction, MetadataContainer systemContainer, MetadataContainer aggregateContainer, TableFillPropertiesMultiOrg properties, CounterList counter)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.LoadContainerData(Boolean isSystemDataLoaded, Boolean isSystemLanguageDataLoaded, CrmDbConnection connection, IDbTransaction transaction, MetadataContainer systemContainer, MetadataContainer aggregateContainer, List`1 fillProperties, CounterList counter)
       at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.BuildMetadataContainerFromDatabase(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction, CounterList counter)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.<>c__DisplayClass1.<LoadMetadataContainerFromDatabase>b__0(CrmDbConnection sqlConn, IDbTransaction sqlTrans)
       at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadMetadataContainerFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId, CounterList counter, BuildMetadataContainerFromDatabaseTemplate buildMetadataContainerFromDatabase, Nullable`1 optionalVersionNumberToFilterResults)


    Wednesday, November 13, 2013 4:02 PM

All replies