Interne fout 3 opgetreden in module 9 (ENU=Internal error 3 in Module 9)

While Converting the Microsoft Dynamics NAV 2009 R2 or SP1 database to a Microsoft Dynamics NAV 2013 database we are getting the below mentioned error message

Description:

Interne fout 3 opgetreden in module 9(ENU=Internal error 3 in Module 9)

Problem signature:

Problem Event Name: NavisionInternalError

Problem Signature 01: Dynamics NAV Development Environment

Problem Signature 02: 7.0.44969.0

Problem Signature 03: 3

Problem Signature 04: 9

OS Version: 6.1.7601.2.1.0.272.7

Locale ID: 1043

Reason: 

It is related to the binary format saved in the field type RecordID

some binary values in the field type ‘RecordID’ are causing a buffer overflow while reading them, most probably while storing these values in the older version the validation did not run properly, and we got some wrong values in that field.

Solution:

Export the data 

Fix the wrong data 

Import the data

Run the conversion again.

The Temp Windows Login already exists error while upgrading

Error: The following error may occur while running Form 104001 (Upgrade - Old version) in the process of upgrading from NAV2009 to NAV2013/2015.

The Temp Windows Login already exists.

Problem Statement:  If users from other domain exist in windows login table with SID and not on Active directory then the above error will raise.

Generally it happens when we copy customer database to local environment (not in customer domain) and try to upgrade.

Solution: Delete all those out of domain users with SID.

Invalid object name '$ndo$usrproperty'

Error: The following error may come while deleting company or table

---------------------------

Microsoft Dynamics NAV Classic

---------------------------

The following SQL Server error or errors occurred:

208,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '$ndo$usrproperty'.

16945,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.

SQL:

SELECT [sid] FROM [$ndo$usrproperty]---------------------------

OK   

---------------------------

Problem Statement: $ndo$usrproperty table is not available in database.

Solution: Open SQL Server Management Studio

Run below query

CREATE TABLE [dbo].[$ndo$usrproperty](

   [sid] [varbinary](85) NOT NULL,

   [artoken] [varchar](128) NOT NULL,

PRIMARY KEY CLUSTERED

(

   [sid] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

Login failed error while upgrading from NAV2009 to NAV2015

Error Message:

---------------------------

Microsoft Dynamics NAV Development Environment

---------------------------

The following SQL Server error or errors occurred:

18456,"28000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'GAC\MPA'.

4060,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "GAC-COPY-PRODUCTION-Test" requested by the login. The login failed.

---------------------------

OK  

---------------------------

Problem Statement:

System returns this error message when you try to open the NAV2009 database with NAV2013 client in upgrade process and you can’t open the database in NAV2009 anymore, can’t fix the error and can’t continue further with upgrade process.

Solution:

Restore the NAV2009 backup again and remove all tables which have property “LinkedObject“ Yes before converting the database to NAV2013.

Mainstream Support for Microsoft Dynamics NAV 2009 Ended January 13, 2015

Mainstream support for Microsoft Dynamics NAV 2009, including 2009 SP1 and 2009 R2, ended yesterday i.e., January 13, 2015 per the Microsoft Support Lifecycle Policy.

It means:
Microsoft is not be doing any work on NAV2009 version.

Customers who are current on a service plan can continue to access the following benefits through CustomerSource:

• Previously released Upgrades, Updates, Service Packs, Fixes and Regulatory/Tax Updates

• Self-Help Support through Knowledge Base articles and online content

• Unlimited Online Training
  
  Paid support (including Premier, Essential, Pay-Per incident, and Microsoft Dynamics Advantage and Advantage Plus plans or any other paid support plan) will be available through the length of extended support. 

• Extended support for Microsoft Dynamics NAV 2009 ends January 2020.

This is the last NAV version with the classic client.