Error : while validating RDL content: Value cannot be null

Once you upgrade databse to  NAV2015,we need to create a service for the databse otherwise some times we may get the below error

Microsoft Dyanamics NAV
----------------------------

Error while validating RDL content:
Value cannot be null.

Parameter name: path1
----------------------------

To resolve this issue,we need to create a service name and check the service name effected to our database through file --> database information-> service name

Error: To upgrade reports, you must have Microsoft SQL Server 2014 Report Builder 3.0 installed.

Some times we may get the below error when we upgrade fron NAV2013 to NAV2015

---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
To upgrade reports, you must have Microsoft SQL Server 2014 Report Builder 3.0 installed.
Binary fields can't be upgraded.
---------------------------

Microsoft SQL Server 2014 Report Builder 3.0 will automatically install when you install NAV2015.
Some times  it may un install  by some one then we need to install the Microsoft SQL Server 2014 Report Builder 3.0 .

The history of Dynamics NAV / Navision

Read full story

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

Virtual Tables in to NAV 2015

Virtual Tables in  to NAV 2015

Table No.	Table Name
2000000001	Object
2000000007	Date
2000000009	Session
2000000020	Drive
2000000022	File
2000000024	Monitor
2000000026	Integer
2000000028	Table Information
2000000029	System Object
2000000038	AIIObj
2000000039	Printer
2000000040	License Information
2000000041	Field
2000000042	OLE Control
2000000043	License Permission
2000000044	Permission Range
2000000045	Windows Language
2000000046	Automation Servers
2000000047	Server
2000000048	Database
2000000049	Code Coverage
2000000055	SID - Account ID
2000000058	AllObjWithCaption
2000000063	Key
2000000070	Error List
2000000101	Debugger Call Stack
2000000102	Debugger Variable
2000000103	Debugger Watch Value
2000000135	Table Synch. Setup

How to Find Currently Running Queries in SQL Server

Some time Navision will take more time when execute an activity like data up gradation etc. We are not sure the particular activity is going on or not,in this case the following script find out which are the queries running currently on your server and the status of our activity.

SELECT sqltext.TEXT,req.session_id,req.status,req.command,req.cpu_time,req.total_elapsed_timeFROM sys.dm_exec_requests reqCROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

  

 the output will shown like below

NAV 2015 - Cumulative update 4 Released

Microsoft Dynamics NAV 2015 Cumulative Update 4 has been released .Please find the link below


Build No. - 39663
Release Date - February, 2015
Local Version are AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.

Download

Thanks

NAV2009 Reporting Error

Sometimes the following error may occur while designing RDLC Report

     “The provided metadata is not valid”

This error can happen when the following conditions are true:

You are using Windows Vista and User Access Control (UAC) is turned on.

• The executable file that runs the Visual Studio development environment (devenv.exe) is set to run as an administrator.
• The executable file that runs the Classic client with Microsoft SQL Server (finsql.exe) is not set to run as an administrator.
• To resolve this issue, either turn off UAC or set both finsql.exe and devenv.exe to run as an administrator.

To turn off UAC

• In Control Panel, select User Accounts.
• In User Accounts, click Turn User Account Control On or Off.
• Clear the Use User Account Control (UAC) to help protect your computer check box.
• To set a program to run as an administrator
• Right-click the .exe file, and then select Properties.

In the Properties window, on the Compatibility tab, in the Privilege Level section, selectRun this program as an administrator.