web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Exception when upgrading organization from crm 4 to 2011- invalid column names

(0) ShareShare
ReportReport
Posted on by 245

In development and QA environments we've upgraded dozens of organizations from dynamics v.4 to v. 2011 without a hitch.

Naturally, when we try to upgrade our first prod organization, we run into a previously unseen error during the import process.

It seems like the new schema for the 'Organization' table contains several new columns, which, for some reason, are not being created in that database, therefore failing the whole upgrade process. We've tried this several times, with the same result every time.

Those columns are created correctly in other upgrades that we've made.

From the import log:

13:46:05|  Error| Installer Complete: OrganizationUpgrader - Error encountered

13:46:05|  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.Data.SqlClient.SqlException: Invalid column name 'UseSkypeProtocol'.

Invalid column name 'IsUserAccessAuditEnabled'.

Invalid column name 'IsDefaultCountryCodeCheckEnabled'.

Invalid column name 'YammerGroupId'.

Invalid column name 'EnableBingMapsIntegration'.

Invalid column name 'YammerOAuthAccessTokenExpired'.

Invalid column name 'QuickFindRecordLimitEnabled'.

Invalid column name 'DefaultCountryCode'.

Invalid column name 'YammerNetworkPermalink'.

Invalid column name 'YammerPostMethod'.

Invalid column name 'UserAccessAuditingInterval'.

Invalid column name 'AllowUserFormModePreference'.

Invalid column name 'UseReadForm'.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

  at System.Data.SqlClient.SqlDataReader.get_MetaData()

  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

  at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

  at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)

  at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)

  at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieve(BusinessEntityMoniker moniker, BusinessEntity entity, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.TryRetrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget, BusinessEntity& businessEntity)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)

  at Microsoft.Crm.Caching.OrganizationSettingsCacheLoader.LoadCacheData(Guid key, ExecutionContext context)

  at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)

  at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.CreateEntry(TKey key, IOrganizationContext context)

  at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.LookupEntry(TKey key, IOrganizationContext context)

  at Microsoft.Crm.Metadata.LocalizationHelper.GetLabelsForResource(String resourceName, Guid objectId, String objectColumnName, LabelTypeCode labelTypeCode, String collectionName, String labelName, IOrganizationContext context)

  at Microsoft.Crm.DataUpgrade.PartnerAuthenticationAuditingFieldsUpgrade.CreateAuditAttributeInternal(MetadataBusinessEntity entity, String attributeName, MetadataHelper metadataHelper, ExecutionContext context)

  at Microsoft.Crm.DataUpgrade.PartnerAuthenticationAuditingFieldsUpgrade.CreateAuditingFields(MetadataBusinessEntity entity, MetadataHelper metadataHelper, ExecutionContext context)

  at Microsoft.Crm.DataUpgrade.PartnerAuthenticationAuditingFieldsUpgrade.UpgradeImpersonationAuditingFields()

  --- 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(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.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)

InnerException:

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UseSkypeProtocol'.

Invalid column name 'IsUserAccessAuditEnabled'.

Invalid column name 'IsDefaultCountryCodeCheckEnabled'.

Invalid column name 'YammerGroupId'.

Invalid column name 'EnableBingMapsIntegration'.

Invalid column name 'YammerOAuthAccessTokenExpired'.

Invalid column name 'QuickFindRecordLimitEnabled'.

Invalid column name 'DefaultCountryCode'.

Invalid column name 'YammerNetworkPermalink'.

Invalid column name 'YammerPostMethod'.

Invalid column name 'UserAccessAuditingInterval'.

Invalid column name 'AllowUserFormModePreference'.

Invalid column name 'UseReadForm'.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

  at System.Data.SqlClient.SqlDataReader.get_MetaData()

  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

  at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

  at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)

  at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)

  at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieve(BusinessEntityMoniker moniker, BusinessEntity entity, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.TryRetrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget, BusinessEntity& businessEntity)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode)

  at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)

  at Microsoft.Crm.Caching.OrganizationSettingsCacheLoader.LoadCacheData(Guid key, ExecutionContext context)

  at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)

  at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.CreateEntry(TKey key, IOrganizationContext context)

  at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.LookupEntry(TKey key, IOrganizationContext context)

  at Microsoft.Crm.Metadata.LocalizationHelper.GetLabelsForResource(String resourceName, Guid objectId, String objectColumnName, LabelTypeCode labelTypeCode, String collectionName, String labelName, IOrganizationContext context)

  at Microsoft.Crm.DataUpgrade.PartnerAuthenticationAuditingFieldsUpgrade.CreateAuditAttributeInternal(MetadataBusinessEntity entity, String attributeName, MetadataHelper metadataHelper, ExecutionContext context)

  at Microsoft.Crm.DataUpgrade.PartnerAuthenticationAuditingFieldsUpgrade.CreateAuditingFields(MetadataBusinessEntity entity, MetadataHelper metadataHelper, ExecutionContext context)

  at Microsoft.Crm.DataUpgrade.PartnerAuthenticationAuditingFieldsUpgrade.UpgradeImpersonationAuditingFields()

ClientConnectionId:0d6f5dcb-b9cf-4d1f-b3e7-1b0d30ed8e6b

13:46:05|   Info| Setting organization state.  New state = Failed

*This post is locked for comments

I have the same question (0)
  • AaronRic Profile Picture
    10,035 on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    Are the versions the same within your production and QA orgs?

  • apostol1979@gmail.com Profile Picture
    105 on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    yes , it is the same.

    Also created a new organisation from Deployment Manager and after that i tried to open but without success.

    I get this errors on trace

    at BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context)

    at BusinessProcessObject.DoRetrieve(BusinessEntityMoniker moniker, BusinessEntity entity, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

    at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

    at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode)

    at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)

    at OrganizationSettingsCacheLoader.LoadCacheData(Guid key, ExecutionContext context)

    at ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)

    at CrmMultiOrgCache`2.CreateEntry(TKey key, IOrganizationContext context)

    at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)

    at SecurityLibrary.IsOrganizationSpecialUser(Guid organizationId, Guid userId, ExecutionContext context)

    at UserDataCacheLoader.LoadCacheData(Guid key, ExecutionContext context)

    at ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)

    at CrmMultiOrgCache`2.CreateEntry(TKey key, IOrganizationContext context)

    at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)

    at SecurityLibrary.GetUserInfoCommon(IOrganizationContext context, Guid userGuid, LocatorServiceContext locatorServiceContext)

    at SecurityLibrary.GetCallerAndBusinessGuidsFromThread(WindowsIdentity identity, Guid organizationId, LocatorServiceContext locatorServiceContext)

    at CrmWindowsIdentity..ctor(WindowsIdentity innerIdentity, Boolean publishCrmUser, Guid organizationId)

    at WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity)

    at AuthenticationStep.Authenticate(HttpApplication application)

    at AuthenticationPipeline.Authenticate(HttpApplication application)

    at AuthenticationEngine.Execute(Object sender, EventArgs e)

    at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    at ApplicationStepManager.ResumeSteps(Exception error)

    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)

    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)

    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

    >Exception when executing query: select

    "organization0".IsAuditEnabled as "isauditenabled"

    , "organization0".TimeFormatString as "timeformatstring"

    , "organization0".GetStartedPaneContentEnabled as "getstartedpanecontentenabled"

    , "organization0".UseReadForm as "usereadform"

    , "organization0".DateFormatCode as "dateformatcode"

    , "organization0".CurrentContractNumber as "currentcontractnumber"

    , "organization0".EnablePricingOnCreate as "enablepricingoncreate"

    , "organization0".LocaleId as "localeid"

    , "organization0".IsAppMode as "isappmode"

    , "organization0".SqlAccessGroupId as "sqlaccessgroupid"

    , "organization0".CurrentInvoiceNumber as "currentinvoicenumber"

    , "organization0".NegativeCurrencyFormatCode as "negativecurrencyformatcode"

    , "organization0".CreatedOnBehalfBy as "createdonbehalfby"

    , "organization0".IsDuplicateDetectionEnabledForOfflineSync as "isduplicatedetectionenabledforofflinesync"

    , "organization0".KbPrefix as "kbprefix"

    , "organization0".DateFormatString as "dateformatstring"

    , "organization0".CurrentParsedTableNumber as "currentparsedtablenumber"

    , "organization0".IsDisabled as "isdisabled"

    , "organization0".OrgDbOrgSettings as "orgdborgsettings"

    , "organization0".InitialVersion as "initialversion"

    , "organization0".AllowMarketingEmailExecution as "allowmarketingemailexecution"

    , "organization0".ISVIntegrationCode as "isvintegrationcode"

    , "organization0".BusinessClosureCalendarId as "businessclosurecalendarid"

    , "organization0".CurrencyFormatCode as "currencyformatcode"

    , "organization0".CreatedBy as "createdby"

    , "organization0".LongDateFormatCode as "longdateformatcode"

    , "organization0".ModifiedOnBehalfBy as "modifiedonbehalfby"

    , "organization0".OrganizationId as "organizationid"

    , "organization0".ContractPrefix as "contractprefix"

    , "organization0".GrantAccessToNetworkService as "grantaccesstonetworkservice"

    , "organization0".IsUserAccessAuditEnabled as "isuseraccessauditenabled"

    , "organization0".PrivReportingGroupName as "privreportinggroupname"

    , "organization0".NextTrackingNumber as "nexttrackingnumber"

    , "organization0".CurrentOrderNumber as "currentordernumber"

    , "organization0".TagPollingPeriod as "tagpollingperiod"

    , "organization0".BaseCurrencyPrecision as "basecurrencyprecision"

    , "organization0".FiscalPeriodType as "fiscalperiodtype"

    , "organization0".CurrencyDecimalPrecision as "currencydecimalprecision"

    , "organization0".CurrentKbNumber as "currentkbnumber"

    , "organization0".DecimalSymbol as "decimalsymbol"

    , "organization0".RecurrenceExpansionSynchCreateMax as "recurrenceexpansionsynchcreatemax"

    , "organization0".SiteMapXml as "sitemapxml"

    , "organization0".CalendarType as "calendartype"

    , "organization0".SampleDataImportId as "sampledataimportid"

    , "organization0".AllowOutlookScheduledSyncs as "allowoutlookscheduledsyncs"

    , "organization0".MinOfflineSyncInterval as "minofflinesyncinterval"

    , "organization0".FiscalYearFormatPrefix as "fiscalyearformatprefix"

    , "organization0".TimeSeparator as "timeseparator"

    , "organization0".IsDuplicateDetectionEnabledForImport as "isduplicatedetectionenabledforimport"

    , "organization0".WeekStartDayCode as "weekstartdaycode"

    , "organization0".NumberGroupFormat as "numbergroupformat"

    , "organization0".DateSeparator as "dateseparator"

    , "organization0".ShareToPreviousOwnerOnAssign as "sharetopreviousowneronassign"

    , "organization0".ParsedTablePrefix as "parsedtableprefix"

    , "organization0".GoalRollupFrequency as "goalrollupfrequency"

    , "organization0".QuotePrefix as "quoteprefix"

    , "organization0".ShowWeekNumber as "showweeknumber"

    , "organization0".MinAddressBookSyncInterval as "minaddressbooksyncinterval"

    , "organization0".ParsedTableColumnPrefix as "parsedtablecolumnprefix"

    , "organization0".TrackingPrefix as "trackingprefix"

    , "organization0".BlockedAttachments as "blockedattachments"

    , "organization0".TimeFormatCode as "timeformatcode"

    , "organization0".SqlAccessGroupName as "sqlaccessgroupname"

    , "organization0".UniqueSpecifierLength as "uniquespecifierlength"

    , "organization0".FullNameConventionCode as "fullnameconventioncode"

    , "organization0".CurrentCampaignNumber as "currentcampaignnumber"

    , "organization0".PastExpansionWindow as "pastexpansionwindow"

    , "organization0".RecurrenceExpansionJobBatchInterval as "recurrenceexpansionjobbatchinterval"

    , "organization0".EnableSmartMatching as "enablesmartmatching"

    , "organization0".Name as "name"

    , "organization0".SupportUserId as "supportuserid"

    , "organization0".TrackingTokenIdBase as "trackingtokenidbase"

    , "organization0".MaxAppointmentDurationDays as "maxappointmentdurationdays"

    , "organization0".IsDefaultCountryCodeCheckEnabled as "isdefaultcountrycodecheckenabled"

    , "organization0".YearStartWeekCode as "yearstartweekcode"

    , "organization0".CurrencySymbol as "currencysymbol"

    , "organization0".FiscalPeriodFormat as "fiscalperiodformat"

    , "organization0".FiscalYearFormatSuffix as "fiscalyearformatsuffix"

    , "organization0".SchemaNamePrefix as "schemanameprefix"

    , "organization0".AllowWebExcelExport as "allowwebexcelexport"

    , "organization0".AMDesignator as "amdesignator"

    , "organization0".ModifiedOn as "modifiedon"

    , "organization0".BaseCurrencyId as "basecurrencyid"

    , "organization0".PricingDecimalPrecision as "pricingdecimalprecision"

    , "organization0".UTCConversionTimeZoneCode as "utcconversiontimezonecode"

    , "organization0".FiscalYearPeriodConnect as "fiscalyearperiodconnect"

    , "organization0".DefaultRecurrenceEndRangeType as "defaultrecurrenceendrangetype"

    , "organization0".HashMaxCount as "hashmaxcount"

    , "organization0".IsFiscalPeriodMonthBased as "isfiscalperiodmonthbased"

    , "organization0".CurrentQuoteNumber as "currentquotenumber"

    , "organization0".IsDuplicateDetectionEnabledForOnlineCreateUpdate as "isduplicatedetectionenabledforonlinecreateupdate"

    , "organization0".HashFilterKeywords as "hashfilterkeywords"

    , "organization0".OrderPrefix as "orderprefix"

    , "organization0".AllowClientMessageBarAd as "allowclientmessagebarad"

    , "organization0".BaseCurrencySymbol as "basecurrencysymbol"

    , "organization0".CreatedOn as "createdon"

    , "organization0".RenderSecureIFrameForEmail as "rendersecureiframeforemail"

    , "organization0".NumberSeparator as "numberseparator"

    , "organization0".EnableBingMapsIntegration as "enablebingmapsintegration"

    , "organization0".CurrentBulkOperationNumber as "currentbulkoperationnumber"

    , "organization0".FiscalYearFormat as "fiscalyearformat"

    , "organization0".GoalRollupExpiryTime as "goalrollupexpirytime"

    , "organization0".IsRegistered as "isregistered"

    , "organization0".PrivilegeUserGroupId as "privilegeusergroupid"

    , "organization0".FiscalSettingsUpdated as "fiscalsettingsupdated"

    , "organization0".FutureExpansionWindow as "futureexpansionwindow"

    , "organization0".CampaignPrefix as "campaignprefix"

    , "organization0".UserAccessAuditingInterval as "useraccessauditinginterval"

    , "organization0".TagMaxAggressiveCycles as "tagmaxaggressivecycles"

    , "organization0".ExpireSubscriptionsInDays as "expiresubscriptionsindays"

    , "organization0".MaxRecordsForLookupFilters as "maxrecordsforlookupfilters"

    , "organization0".InvoicePrefix as "invoiceprefix"

    , "organization0".ModifiedBy as "modifiedby"

    , "organization0".PMDesignator as "pmdesignator"

    , "organization0".FiscalYearFormatYear as "fiscalyearformatyear"

    , "organization0".NegativeFormatCode as "negativeformatcode"

    , "organization0".AllowAddressBookSyncs as "allowaddressbooksyncs"

    , "organization0".IsDuplicateDetectionEnabled as "isduplicatedetectionenabled"

    , "organization0".RequireApprovalForUserEmail as "requireapprovalforuseremail"

    , "organization0".SortId as "sortid"

    , "organization0".RequireApprovalForQueueEmail as "requireapprovalforqueueemail"

    , "organization0".SQMEnabled as "sqmenabled"

    , "organization0".DisabledReason as "disabledreason"

    , "organization0".BulkOperationPrefix as "bulkoperationprefix"

    , "organization0".CurrencyDisplayOption as "currencydisplayoption"

    , "organization0".SystemUserId as "systemuserid"

    , "organization0".AllowEntityOnlyAudit as "allowentityonlyaudit"

    , "organization0".IsSOPIntegrationEnabled as "issopintegrationenabled"

    , "organization0".ReportScriptErrors as "reportscripterrors"

    , "organization0".CasePrefix as "caseprefix"

    , "organization0".Picture as "picture"

    , "organization0".IntegrationUserId as "integrationuserid"

    , "organization0".PinpointLanguageCode as "pinpointlanguagecode"

    , "organization0".QuickFindRecordLimitEnabled as "quickfindrecordlimitenabled"

    , "organization0".IsPresenceEnabled as "ispresenceenabled"

    , "organization0".MaximumTrackingNumber as "maximumtrackingnumber"

    , "organization0".MaxRecordsForExportToExcel as "maxrecordsforexporttoexcel"

    , "organization0".FiscalYearDisplayCode as "fiscalyeardisplaycode"

    , "organization0".DefaultCountryCode as "defaultcountrycode"

    , "organization0".NumberFormat as "numberformat"

    , "organization0".TrackingTokenIdDigits as "trackingtokeniddigits"

    , "organization0".MinOutlookSyncInterval as "minoutlooksyncinterval"

    , "organization0".AllowAutoUnsubscribeAcknowledgement as "allowautounsubscribeacknowledgement"

    , "organization0".AllowOfflineScheduledSyncs as "allowofflinescheduledsyncs"

    , "organization0".HashMinAddressCount as "hashminaddresscount"

    , "organization0".AllowAutoResponseCreation as "allowautoresponsecreation"

    , "organization0".ReportingGroupId as "reportinggroupid"

    , "organization0".RecurrenceExpansionJobBatchSize as "recurrenceexpansionjobbatchsize"

    , "organization0".HashDeltaSubjectCount as "hashdeltasubjectcount"

    , "organization0".CurrentCaseNumber as "currentcasenumber"

    , "organization0".PrivReportingGroupId as "privreportinggroupid"

    , "organization0".RecurrenceDefaultNumberOfOccurrences as "recurrencedefaultnumberofoccurrences"

    , "organization0".TimeZoneRuleVersionNumber as "timezoneruleversionnumber"

    , "organization0".ReferenceSiteMapXml as "referencesitemapxml"

    , "organization0".EmailSendPollingPeriod as "emailsendpollingperiod"

    , "organization0".CurrentImportSequenceNumber as "currentimportsequencenumber"

    , "organization0".FiscalCalendarStart as "fiscalcalendarstart"

    , "organization0".FiscalPeriodFormatPeriod as "fiscalperiodformatperiod"

    , "organization0".FeatureSet as "featureset"

    , "organization0".ReportingGroupName as "reportinggroupname"

    , "organization0".AllowUserFormModePreference as "allowuserformmodepreference"

    , "organization0".UserGroupId as "usergroupid"

    , "organization0".MaxUploadFileSize as "maxuploadfilesize"

    , "organization0".IgnoreInternalEmail as "ignoreinternalemail"

    , "organization0".LanguageCode as "languagecode"

    , "organization0".AllowUnresolvedPartiesOnEmailSend as "allowunresolvedpartiesonemailsend"

    , "organization0".TokenExpiry as "tokenexpiry"

    , "organization0".AcknowledgementTemplateId as "acknowledgementtemplateid"

    , "organization0".AllowAutoUnsubscribe as "allowautounsubscribe"

    , "organization0".V3CalloutConfigHash as "v3calloutconfighash"

    , "organization0".CreatedOnBehalfByYomiName as "createdonbehalfbyyominame"

    , "organization0".CreatedOnBehalfByName as "createdonbehalfbyname"

    , "organization0".CreatedByYomiName as "createdbyyominame"

    , "organization0".CreatedByName as "createdbyname"

    , "organization0".ModifiedOnBehalfByYomiName as "modifiedonbehalfbyyominame"

    , "organization0".ModifiedOnBehalfByName as "modifiedonbehalfbyname"

    , "organization0".BaseCurrencyIdName as "basecurrencyidname"

    , "organization0".ModifiedByYomiName as "modifiedbyyominame"

    , "organization0".ModifiedByName as "modifiedbyname"

    , "organization0".AcknowledgementTemplateIdName as "acknowledgementtemplateidname"

    from

    Organization as "organization0"

    where

    ("organization0".OrganizationId = '88b0c00f-84d1-40a4-8e98-a06ca09f56e3') Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDefaultCountryCodeCheckEnabled'.

    Invalid column name 'EnableBingMapsIntegration'.

    Invalid column name 'DefaultCountryCode'.

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

    at System.Data.SqlClient.SqlDataReader.get_MetaData()

    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

    at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)

    at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)

    at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)

    at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context)

    ClientConnectionId:1d749284-57f2-4707-ad92-846261025414

  • AaronRic Profile Picture
    10,035 on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    Do you still have questions on this?

  • strepan Profile Picture
    on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    Hi

    i'm having exactly the same issue with a new organisation created this morning. organisation version is 5.0.9660.3557 and the server binnary deployed version is also 5.0.9660.3557.  rollup 14

    Error Found in event Log:

    Host xDMON010999: A Microsoft Dynamics CRM Asynchronous Processing Service operation of type 27 has failed

    Organization ID: 1e4799c9-6178-e311-93ca-005056be1ee1

    Organization Unique Name: Study1

    Error code: 80040216

    Error description: Invalid column name 'UseReadForm'.

    Invalid column name 'UseSkypeProtocol'.

    Invalid column name 'IsDefaultCountryCodeCheckEnabled'.

    Invalid column name 'YammerNetworkPermalink'.

    Invalid column name 'YammerGroupId'.

    Invalid column name 'YammerOAuthAccessTokenExpired'.

    Invalid column name 'EnableBingMapsIntegration'.

    Invalid column name 'QuickFindRecordLimitEnabled'.

    Invalid column name 'DefaultCountryCode'.

    Invalid column name 'YammerPostMethod'.

    Invalid column name 'AllowUserFormModePreference'.

    restarted IIS with IISRESET many time

    can you tell me if anyone found a solution a that issue

    Thanks!

  • AaronRic Profile Picture
    10,035 on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    Are you able to try applying UR 15 to this as a test?

  • Tim Klooster Profile Picture
    40 on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    I'm also having this problem with invalid columns names on an import from a v4 org.  We did this successfully in the past.  We are on UR15.  Unfortunately, we found this the night before our first 2011 release.

  • Suggested answer
    Tim Klooster Profile Picture
    40 on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    Rebooting all CRM servers fixed the import.  Given that it just started to happen without doing any server updates I don't have any confidence this is the fix though.

  • strepan Profile Picture
    on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    We are no allowed to go ur15 at this time. This is our only DEV and Support server for the Production. i rebooted both server but that did not fixed the problem.

    I’m looking for a way to reapply UR14. The setup does not have a Repair install (Accessed from uninstall program)

    Does anybody have a “relatively safe” procedure to reapply/Repair Ur14 update. Since it is my only support server I want to be careful.

  • Raffaele Sorra Profile Picture
    472 on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    Rebooting the Servers solved the Problem. Thanks!!

  • Community Member Profile Picture
    on at
    RE: Exception when upgrading organization from crm 4 to 2011- invalid column names

    We also solved this issue by Rebooting all Servers. i.e. 1. CRM Web Server 2. SQL Server and 3. Reporting Server

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans