Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Error Upgrade NAV 2013 R2

(0) ShareShare
ReportReport
Posted on by 15

Hi, 

I am getting below error while performing step 2 "Upgrade New Version" in nav 2013 R2. i have probablly checked all possible actions to perform, sync-navtenant is done successfully and no compilation issue in object. one thing to notice here is, i have around 400 companies in database and database size is 30 gb. yes it took long time(12 hours) in Sync-NAVTenant but there was no error. 

i tried all possible reasons described in this link https://cloudblogs.microsoft.com/dynamics365/no-audience/2014/03/27/the-new-table-synchronization-paradigm-in-microsoft-dynamics-nav-2013-r2/?source=nav

The following SQL error was unexpected.
The nvarchar data type cannot be selected as DISTINCT because it is not comparable.
Statement(s) could not be prepared.

Thanks,

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans