Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Import Failure in Dyna...
Customer experience | Sales, Customer Insights,...
Unanswered

Import Failure in Dynamics 365 9.1

(0) ShareShare
ReportReport
Posted on by mhooper 20

It looks like there may be other issues with the code migration from Online to On-Premise. At least one function seems to be expecting SQL Server Enterprise.

 

We are setting up a new environment for a client who will be migrating from Dynamics 365 8.2 to 9.1. Using Windows Server 2019 Standard for the CRM server and Windows Server 2019 Standard / Microsoft SQL Server 2016 Standard, with Service Pack 2 for the SQL server.  The CRM server was installed using the RTM Dynamics 365 Server, version 9.0 with Dynamics 365 Server Service Pack 1, version 9.1 (9.1.1.914) slipstreamed.

 

After the server was set up we were going to use the default organization to test the installation. Manually creating accounts and contacts was functioning well, so we decided to import sample data to have something for testing forms, views, and dashboards.

 

Hitting the gear icon > Advanced Settings and then navigating to Settings > Data Management > Sample Data > Install Sample Data.

 pastedimage1624988797416v1.png

Navigating to Data Management > Imports showed that all of the Sample Data import steps failed almost instantly.

 pastedimage1624988819636v2.png

Opening the Sample Data Lead import and then navigating to System Jobs showed the Sample Data process failed.

 pastedimage1624988838547v3.png

Opening the process and clicking on Details returned: Online index operations can only be performed in Enterprise edition of SQL Server.

pastedimage1624988852509v4.png

Log File:

[View:/cfs-file/__key/communityserver-discussions-components-files/117/SampleDataSystemJobError.txt]

Thinking this might be an issue with the Sample Data process, I exported an Account Template for Data Import, populated it with Test Account 1 to 20, and attempted to import that, with the same result as above.


I think we might be opening a case with Microsoft, but has anyone encountered this and found a workaround?

Regards,

  • Shahis Profile Picture
    Shahis 170 on at
    RE: Import Failure in Dynamics 365 9.1

    This has been fixed in the 9.1.3 update.

    support.microsoft.com/.../service-update-1-3-for-microsoft-dynamics-crm-on-premises-9-1-4f9cb846-6c00-4fc1-9c13-bc0bbe733009

  • Peterji Profile Picture
    Peterji 5 on at
    RE: Import Failure in Dynamics 365 9.1

    I logged a support ticket with Microsoft about 3 weeks ago and they confirmed it is a known bug. They gave me an early access fix for the issue, CRM9.1-Server-KB9120004-ENU-Amd64.zip. I guess you'll need to contact them to get the fix until they do a general release. In case it is helpful, my case number is 2107070040006429.

    I can also upload it somewhere if you give me a spot.

  • InvalidURL Profile Picture
    InvalidURL 15 on at
    RE: Import Failure in Dynamics 365 9.1

    I can confirm this has no change. Updated 2 separate environments to 9.1.2.2 and still get:

    "<Message>Exception output:: System.Data.SqlClient.SqlException (0x80131904): Online index operations can only be performed in Enterprise edition of SQL Server....."

  • Joe Woltering Profile Picture
    Joe Woltering 12,161 on at
    RE: Import Failure in Dynamics 365 9.1

    FYI, there's a new update for 9.1 (9.1.2.2). Release notes don't say anything about imports though.

    https://support.microsoft.com/en-us/topic/-service-update-1-2-for-microsoft-dynamics-365-9-1-d03e59fb-ebaa-412f-a859-277c30ab2185

    I'll let someone else try it first ;P

  • InvalidURL Profile Picture
    InvalidURL 15 on at
    RE: Import Failure in Dynamics 365 9.1

    Hi all.

    I'm also seeing this issue come up now. We have rebuilt a few environments and the issue is coming up when we are importing data (entity does not matter) via "Import Data" and using a CSV file.

    This is only being seen when the environment is patched to 9.1.1.914.

    https://support.microsoft.com/en-us/topic/dynamics-365-server-service-pack-1-version-9-1-cf784c7a-76ca-4e61-9aeb-2be9ac4a8b7d 

    Prior to this the imports work fine. 

  • Joe Woltering Profile Picture
    Joe Woltering 12,161 on at
    RE: Import Failure in Dynamics 365 9.1

    I wasn't even able to apply the Service Pack for 9.0. All sorts of .NET assembly errors. Had to do a full system and db restore. Clearly this thing is half-baked. 

  • mhooper Profile Picture
    mhooper 20 on at
    RE: Import Failure in Dynamics 365 9.1

    No solution yet Daniel.

  • dieter.m Profile Picture
    dieter.m 25 on at
    RE: Import Failure in Dynamics 365 9.1

    Same problem here.

    With the update 9.1.1.914 and SQL Server Standard it is actually not possible to import (Excel) files

  • Daniel Schumacher Profile Picture
    Daniel Schumacher 40 on at
    RE: Import Failure in Dynamics 365 9.1

    Hi,

    I've got the same issue. Did you find a solution/workaround?

  • mhooper Profile Picture
    mhooper 20 on at
    RE: Import Failure in Dynamics 365 9.1

    It looks like the log file did not attach. Here is the content:

    Unhandled exception:

    Exception type: System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]

    Message:  Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 1712Detail:

    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">

     <ActivityId>45dbeeb2-0338-46c4-a2a4-1c94d154f875</ActivityId>

     <ErrorCode>-2147204784</ErrorCode>

     <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />

     <HelpLink>go.microsoft.com/.../

     <Message> Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 1712</Message>

     <Timestamp>2021-06-29T16:39:06.9389957Z</Timestamp>

     <ExceptionRetriable>false</ExceptionRetriable>

     <ExceptionSource i:nil="true" />

     <InnerFault>

       <ActivityId>45dbeeb2-0338-46c4-a2a4-1c94d154f875</ActivityId>

       <ErrorCode>-2147220970</ErrorCode>

       <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />

       <HelpLink i:nil="true" />

       <Message>Exception output:: System.Data.SqlClient.SqlException (0x80131904): Online index operations can only be performed in Enterprise edition of SQL Server.

    Online index operations can only be performed in Enterprise edition of SQL Server.

    Online index operations can only be performed in Enterprise edition of SQL Server.

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Crm.CrmDbConnection.LockConnectionAndExecuteMethod[TResult](IDbConnection connection, Func`1 executeMethod)

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

      at Microsoft.Crm.CrmDbConnection.<>c__DisplayClass159_0.<InternalExecuteNonQuery>b__0()

      at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)

      at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)

      at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteNonQuery(IDbCommand command, String& databaseName)

      at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)

      at Microsoft.Crm.Asynchronous.ImportDataAccess.<>c__DisplayClass24_0.<ExecuteSqlCommandWithNoExpectedRecords>b__0()

      at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)

      at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)

      at Microsoft.Crm.Asynchronous.ImportDataAccess.<>c__DisplayClass28_0.<CreateIndexOnParsedTable>b__0()

      at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)

      at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)

      at Microsoft.Crm.Asynchronous.ImportOperationParse.<>c__DisplayClass16_0.<ParseFile>b__0()

      at Microsoft.Crm.Asynchronous.ImportOperation.<>c__DisplayClass26_0`2.<Execute>b__0()

      at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)

      at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)

      at Microsoft.Crm.Asynchronous.ImportOperationParse.ParseFile(KeyValuePair`2 kvp_importfile, Guid organizationId, Guid importId)

      at Microsoft.Crm.Asynchronous.ImportOperationParse.<>c__DisplayClass15_0.<ExecuteImportOperation>b__0()

      at Microsoft.Crm.Asynchronous.ImportOperation.<>c__DisplayClass26_0`2.<Execute>b__0()

      at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)

      at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)

      at Microsoft.Crm.Asynchronous.ImportOperationParse.ExecuteImportOperation(Guid organizationId, Guid importId, Int32 operationType)

      at Microsoft.Crm.Asynchronous.ImportSampleData.DoImport(Guid organizationId, Guid importId)

      at Microsoft.Crm.Asynchronous.ImportSampleData.<>c__DisplayClass8_0.<ExecuteImportOperation>b__0()

      at Microsoft.Crm.Asynchronous.ImportOperation.<>c__DisplayClass26_0`2.<Execute>b__0()

      at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)

      at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)

      at Microsoft.Crm.Asynchronous.ImportSampleData.ExecuteImportOperation(Guid organizationId, Guid importId, Int32 operationType)

      at Microsoft.Crm.Asynchronous.ImportOperation.<>c__DisplayClass31_0.<InternalExecute>b__0()

    ClientConnectionId:6c81c54c-3f74-4bf4-9693-746243703179

    Error Number:1712,State:1,Class:16

    Error(s) details:

    Class: 0x10

    LineNumber: 1

    Message: Online index operations can only be performed in Enterprise edition of SQL Server.

    Number: 1712

    Procedure:

    Server: XXXXXXX (server name removed)

    Source: .Net SqlClient Data Provider

    State: 1

    ToString(): System.Data.SqlClient.SqlError: Online index operations can only be performed in Enterprise edition of SQL Server.

    --

    Class: 0x10

    LineNumber: 2

    Message: Online index operations can only be performed in Enterprise edition of SQL Server.

    Number: 1712

    Procedure:

    Server: XXXXXXX (server name removed)

    Source: .Net SqlClient Data Provider

    State: 1

    ToString(): System.Data.SqlClient.SqlError: Online index operations can only be performed in Enterprise edition of SQL Server.

    --

    Class: 0x10

    LineNumber: 3

    Message: Online index operations can only be performed in Enterprise edition of SQL Server.

    Number: 1712

    Procedure:

    Server: XXXXXXX (server name removed)

    Source: .Net SqlClient Data Provider

    State: 1

    ToString(): System.Data.SqlClient.SqlError: Online index operations can only be performed in Enterprise edition of SQL Server.

    --

    : Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #C6BCD246</Message>

       <Timestamp>2021-06-29T16:39:06.9389957Z</Timestamp>

       <ExceptionRetriable>false</ExceptionRetriable>

       <ExceptionSource i:nil="true" />

       <InnerFault i:nil="true" />

       <OriginalException i:nil="true" />

       <TraceText i:nil="true" />

     </InnerFault>

     <OriginalException i:nil="true" />

     <TraceText i:nil="true" />

    </OrganizationServiceFault>

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans