web
You’re offline. This is a read only version of the page.
close
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 / Finance | Project Operations, Human Resources, ... / Publishing data entity...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Publishing data entity failed when option "Create clustered column store Indexes" is on

(0) ShareShare
ReportReport
Posted on by julian.wu.cn 10

Hi All,

I am trying to export a built-in data entity in D365 F&O to a BYOD database (Azure SQL DB of P1), it could be published successfully if the option "Create clustered column store Indexes" is off on the data source, but it will failed when the option is on, the error message is as below.

Kindly please help.

pastedimage1610761889385v1.png

Here is the version of D365.

pastedimage1610761928441v2.png

I have the same question (0)
  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi julian.wu.cn,

    Can you publish other entities without issues? Have you tried to regenerate mapping for the entity (Data management - Entity list - Find entity - Modify target mapping - Generate mapping?

    As a workaround, you can publish an entity without a column store index and create a clustered column store index manually.

  • julian.wu.cn Profile Picture
    julian.wu.cn 10 on at

    Thank you Sergei.

    I tried what you adised, however it still does not work. I am not sure if there is any other special settings of the data entities themselves in order to support the columnstore indexes.

    The workaround is definitely an option, we have about 150 customized data entities, maybe just manaully create the columnstore indexes on the top ones.

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi julian.wu.cn,

    There is only one checkbox to control columnstore index creation for BYOD located under the Entity store list.

    Are you sure if BYOD has a P1 tier?  If you press Validate button on the entity store form, do you see it in the infolog? Can you, please, also check if you can create columnstore index manually in BYOD?

  • julian.wu.cn Profile Picture
    julian.wu.cn 10 on at

    Yes, it  is P1.

    We have columnstore indexes on the fact tables. however we would like to create the columnstore indexes on the big staging tables (from 1GB to 50GB).

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi julian.wu.cn,

    Are you using devbox or sandbox? In devbox you can check event logs for more details.

    If it's the sandbox you can create a ticket to MS to investigate the issue.

  • julian.wu.cn Profile Picture
    julian.wu.cn 10 on at

    It is a sandbox, however I tried it on a devbox which has the exact the same version, it got the same error message. And I see the same issue on the version as below.

    Installed product version : 10.0.14 (10.0.605.20013)Installed platform version : Update38 (7.0.5778.41503)

    And here is the log from the event viewer. Is it that possible a D365 FO bug?

    EventData

     EventName ExceptionDetails

     d365EnvironmentId {6DF1CF2A-B220-453E-B38E-D28E88115B31}

     ActivityId {85534398-CE53-0000-BF19-558553CED601}

     dixfActivityId {85534398-CE53-0000-BF19-558553CED601}

     executionID  

     dataProject  

     source ExceptionHelper.GetExceptionDetails

     entityName  

     targetEntityName  

     message  

     executionContext  

     exceptionDetails Source: Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper HResult: 0x80004003 Details: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntityDBHelper.PublishSchema(String targetConnectionString, String sourceConnectionString, String stagingTable, Dictionary`2 additionalColumns, Boolean isDataArea, Boolean forceUpdate, Boolean isColumnStoreIndex, String[] targetXMLFields) at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.PublishSchemaWithLock(DMFEntityDBHelper entityDBHelper)  

     SqlQuery  

     details { "ErrorCode": "" }

     parameters

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi julian.wu.cn,

    I checked if I can publish 1099 fields entity on version 10.0.14 and I didn't get any issue. Do you have another instance of BYOD to connect and test?

  • julian.wu.cn Profile Picture
    julian.wu.cn 10 on at

    Yes, that is a totally different environment.

    Which is pricing tier of your BYOD database?

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi julian.wu.cn,

    It's a P2. But column store indexes are supported from S3 and for all databases in P-tier.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 659 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 533 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 289 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans