Tip : How to import only objects from Navision backup (FBK) files

We can import objects directly  from NAV backup FBK file without restore  

If you have a Navision backup (the FBK file) with the application objects included, then you can import these objects directly without restoring the whole backup.

In the Object designer choose import and select the .FBK file instead of the suggested .FOB or .TXT.

 Navision will then import only the objects.

NAV UPGRADE Error : Invalid object name 'XXXX.dbo.company$xxxxx' The table for which the above error is occurring does not exists in NAV database or could not be found in SQL

We get the below error while converting the  database from NAV2009 to NAV2013.

 
 Invalid object name 'XXXX.dbo.company$xxxxx' The table for which the above error is occurring does not exists in NAV database or could not be found in SQL


Solution :

Object Metadata must have Table Reference in NAV2009  which table object does not exists in the current  database.


We have to remove the record and start upgrade again from the beginning.

NAV Upgrade Error : Login failed error while upgrading from NAV2009 to NAV2015

The following error occur when we 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.

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

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 'xxxxx'.

4060,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "xxxxxx-xxxx" requested by the login. The login failed.

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

OK  

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

Solution:

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

The value of Decimal parameter is outside of the permitted range. The current value is: 1,944,000,000,000,000. The permitted range is: from -999,999,999,999,999.99

We will get the below error while run the step2 process for upgrade from NAV2009 R2  to NAV2015

The value of Decimal parameter  is outside of the permitted range. The current value is: 1,944,000,000,000,000. The permitted range is: from -999,999,999,999,999.99.

The above error will occur due to UpdateProdOrderRoutingLine function in the codeunit 104051. this function is Updating Expected Capacity Need in the Prod. Order Routing Line with Expected Capacity Need with the Time factor of the unit of Measure code which returns the value outside of the decimal range.