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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / 10.0.26 Quality update...
Supply chain | Supply Chain Management, Commerce
Unanswered

10.0.26 Quality update error

(0) ShareShare
ReportReport
Posted on by Pankaj_93 396

Hi All,

Hope all are doing well !!!

While deploying the 10.0.26 quality update to the devlopment environement getting the below error.

System.Management.Automation.MethodInvocationException: Exception calling "ExecuteSqlText" with "1" argument(s): "Couldn't complete full-text operation because full-text key for table or indexed view 'ax.ECORESPRODUCTTRANSLATION' is offline. Near statement:
ALTER FULLTEXT INDEX ON [ax].[ECORESPRODUCTTRANSLATION] DROP ([NAME]);
... " ---> System.Exception: Couldn't complete full-text operation because full-text key for table or indexed view 'ax.ECORESPRODUCTTRANSLATION' is offline. Near statement:
ALTER FULLTEXT INDEX ON [ax].[ECORESPRODUCTTRANSLATION] DROP ([NAME]);
... ---> System.Data.SqlClient.SqlException: Couldn't complete full-text operation because full-text key for table or indexed view 'ax.ECORESPRODUCTTRANSLATION' is offline.

Can you please suggest on this?

Thanks In Advance !!!

Pankaj

I have the same question (0)
  • Ramune Profile Picture
    Ramune Microsoft Employee on at

    Hi Pankaj,

    10.0.26 end of service was on July 15, 2022:

    docs.microsoft.com/.../public-preview-releases

    Not sure how you able to update this version, you should be updating to version 10.0.27 or higher.

  • JeffreyPW Profile Picture
    JeffreyPW 228 on at

    When pushing to a dev environment, if i ever see ax table/view issues during an service update, you can run the script to drop all commerce related tables (DropAllRetaillChannelDbObjects)... then, apply the update and it will recreate all those tables/views/etc for you.

  • SergeyP Profile Picture
    SergeyP 2,928 on at

    You can indeed refresh the Channel DB, sharing some more details below regarding what Jeffrey essentially, has briefly shared already.

    1. The following steps will indicate how to remove the Retail Channel Database components from the AOS database. By following these steps, you acknowledge that you are not using the Retail Channels (Point of Sale or Retail Cloud or Store Scale Units) OR you are using Cloud Scale Units (when using Cloud Scale Units, the Channel Database collocated with the AOS DB [Default Database] is not used anymore) OR you are applying this in your Develop/Demo environment and is able to redeploy your extensions (in this case, please see call out in the end of instructions). After you complete these steps, you will need to retry/resume/start an application deployable package, which will recreate the Retail Channel database components.
    2. Connect to the intended environment.
    3. Find the latest deployable package applied to the environment. It will be under folder <ServiceVolue>:\DeployablePackages\<PackageGUID>
    4. Under the deployable package folder, find the following SQL script <ServiceVolue>:\DeployablePackages\<PackageGUID>\RetailServer\Scripts\DropAllRetialChannelDbObjects.sql
    5. This script, when run against the AOS database (AxDB), will remove all objects related to the Retail Channel Database. Only proceed if you are not using the Retail Channel functionality.
    6. Connect to the AOS database and run the script mentioned on Step 4. This operation will take several minutes.
    7. Resume the package deployment or start the package deployment to have the Retail Channel components recreated correctly.
    8. Note: if you ran these steps on a DEV/DEMO environment and you are using Retail Channel Database; you will need to reapply your extensions (if any) to the Channel Database and then perform a CDX Full Data Sync on the "Default" channel database to restore the data to the database. Any transactions not synchronized to the HQ through P-Jobs would be lost. Reactivating the POS devices is required after these steps.

    At the same time, might make sense to first troubleshoot the original issue, that document has an explanation on why an index might go offline. How does your table's Full Text Search properties look like comparing to the below (right click the table in SQL Server Management Studio and then select Full-Text index->Properties):

    pastedimage1659986970623v1.png

    ?

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 92 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 71 Super User 2026 Season 1

#3
Sagar Suman Profile Picture

Sagar Suman 56 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans