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 : 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.

Error: Form Transformation

While transforming form to pages from NAV2009 or NAV2009R2 we may get the below error

Error: Schema: \ApplicationObjects.xsd

Error: Form -2: The validation for file:///C:/Users/xxx/Desktop/NAV2009/TransformationTool/ApplicationObjects.xsd.tmp.xml failed. Detailed Information: LineNumber=69, LinePosition=14

Error: Form -2: The element 'Properties' in namespace 'urn:schemas-microsoft-com:dynamics:NAV:ApplicationObjects' has invalid child element 'Style' in namespace 'urn:schemas-microsoft-com:dynamics:NAV:ApplicationObjects'. List of possible elements expected: 'IndentationColumnName, Editable, ShowAsTree, InstructionalTextML, Visible, Enabled, GroupType, IndentationControls, Description, Name' in namespace 'urn:schemas-microsoft-com:dynamics:NAV:ApplicationObjects'.

Error: Some input file can’t be validated by schema. Please, correct it and rerun tool again

Solution:Transformation tool won't support form control properties like FontBold,FontItalic. so we need to remove before form transformation.

Test and fix dimensions before upgrading to NAV 2013

Please go through this link  from Gunnar's Blog

How to Debug RTC Pages in NAV2009

Debugging RTC Pages in NAV2009

   1.      Go to C:->Program Data-> Microsoft->Dynamics Nav->60->Server->Microsoft  Dynamics Nav Server->Source -> Codeunit. Here you can find the source of the pages DLL files written in C#, if the    pages are generated successfully.

   2.      Go to C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service. Give full control to                      CustomSettings.config file.

   3.      Opne CustomSettings.config file. Make the enable debugging key to true by editing the following            settings for making the RTC page debugging possible :

 <add key="EnableDebugging" value="True"></add>

   4.      Run Visual Studio as Administrator.

    5.      Open the RTC page DLL file.

    6.      Go to Tools->Attach Process. Place check mark in Show Process from All Users check box.

    7.      Select the Nav Server process .

    8.      In the Page, put breakpoints wherever required.

    9.      Run RTC page in Nav. Then in Visual studio the code execution will be stopped at the break point.

               This way, you can make the RTC pages debugging possible.

                                                       ***Thank you very much***