Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Unanswered

Error Upgrade NAV 2013 R2

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,

Categories:

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans