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 / Microsoft Dynamics AX (Archived) / Data base Synchronizat...
Microsoft Dynamics AX (Archived)

Data base Synchronization error -

(0) ShareShare
ReportReport
Posted on by Community Member

When I am trying to synchronize database (AX2012 R2 + CU6), I am getting following error.

A default full-text catalog does not exist in database "MicrosoftDynamicsAX' or user does not have permission to perform this action.

Cannot execute 'Create full text index on vendtable (Accountnum) key INDEX I_505RECID

Does anyone has seen this issue? Appreciate any pointer around this error. 

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,878 Most Valuable Professional on at

    It's more about SQL Server than AX. Review permissions of the AOS service account and the setup of full-text indexing. If it's all right, try to create a new default catalog.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Please review following link if you follow all the required thing related to Full Text search

    msdn.microsoft.com/.../gg845129.aspx

    Please verify and update with your findings

  • Davide Lelli Profile Picture
    Davide Lelli 5 on at

    I have the same problem with Inventtable Error SQL: CREATE FULLTEXT INDEX ON INVENTTABLE (NAMEALIAS) KEY INDEX I_175RECID.

    I think, it's not a problem to the full-text indexing.

    Accountnum index it's not the I_505RECID it's the I_xxxAccountnum

    In my case NAMEALIAS have the I_xxxNamealis index and not the I_175RECID.

    Something break in AOT

    Someone other had the same problem and the solution?

    Thanks

    DVL

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans