Skip to main content

Upgrade Error - The database collation cannot be changed if a schema-bound object depends on it.

Hi all,

Found a issue while upgrading from Navision 5 SP1 to NAV 2013 related to database collation.

Posted the issue on mibuso and got the hint to resolve same.

I thought I should share it with you all, so here it is.

Issue -

1. Completed Step 1 Successfully.

2. Tried to Open the database in NAV 2013, and get below listed error during database conversion.


CAUSE OF ERROR -

1. This error occurs when we try to upgrade a database which does not have local language pack of Microsoft Dynamics NAV.

RESOLUTION -

1. Take Navision backup of database on old version (in my case NAV 5 SP1).

2. Create new database with collation that is requested by error message in old version.

3. Perform upgrade steps as suggested by standard Microsoft Upgrade manual.

I hope this will help some of the readers.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All, While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV. Let's see the History of Code Names Given to Previous Version  - NAV 2013 - Code Name 'Sicily' NAV 2015 - Code Name 'CRETE' NAV 2016 - Code Name 'CORFU' And as we all know that all these are the Islands.