Thursday, 16 April 2015

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.


Monday, 13 April 2015

NAV TechDays 2015


Mark your calendar: NAV TechDays 2015   - 19 & 20 November - Antwerp (Belgium)

Pre-conference day: 18 November





The day before the NAV TechDays conference, on Wednesday 18 November, you have the opportunity to attend some workshops. 

Workshop #1: Power BI for Dynamics NAV (Steven Renders)
In this workshop Steven will introduce you to the world of Power BI for Dynamics NAV. Learn how you can create stunning dashboards in Excel 2013 or the Power BI Designer, so you can find answers to your most important questions using natural language and make decisions based on the right data anytime, anywhere, on any device.

Workshop #2: Working with Powershell and Microsoft Dynamics NAV (Eric Wauters)
During this workshop, I will make you familiar with PowerShell, and what NAV has to offer within PowerShell. We’ll use the existing commandlets, enhance them, look into the existing PowerShell scripts, learn from them and also enhance them. All with practical and useful examples which we will create during the workshop.

Workshop #3: Document Reporting in NAV 2015 (Claus Lundstrøm)
Join this class to master the teachings behind how to easily create Document reports in RDLC in NAV 2015. After this class you will also have a clear understanding how Grouping is done RDLC reports. We will also have a look at how End Customers can do Document Reports in Word.

Workshop #4: Troubleshooting Essentials for SQL Server and Dynamics NAV (Jörg Stryk)
The first part of the workshop will focus on resolving so called “Expensive Queries”. You will learn about the importance of “Keys” and “Indexes”, how to detect problems related to them and how to implement appropriate solutions. According to this, you will get an introduction of several useful tools, like “SQL Profiler”, “SQL Trace”, TSQL/DMV etc. and some pretty cool 3rd party tools.
The second part of the workshop will explain the concept of locking mechanisms in SQL Server and how to deal with it in NAV. You’ll learn how to detect blocks and deadlocks, using on-board features and 3rd party tools. Finally you’ll get some inspirations about how to resolve and prevent blocking problems.


These workshops will take place in the selected conference hotel, and will be charged separately (lunch & coffee breaks included).

Friday, 10 April 2015

Cumulative Update 6 for Microsoft Dynamics NAV 2015 has been released


Cumulative Update 6 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:
  •   AU - Australia
  •   AT - Austria
  •   BE - Belgium
  •   CH – Switzerland
  •   CZ – Czech Republic
  •   DE - Germany
  •   DK - Denmark
  •   ES - Spain
  •   FI  - Finland
  •   FR - France
  •   IS - Iceland
  •   IT - Italy
  •   NA - North America
  •   NL - Netherlands
  •   NO - Norway
  •   NZ - New Zealand
  •   RU – Russia
  •   SE - Sweden
  •   UK - United Kingdom
Note: You must convert the database if you are upgrading to Cumulative Update 6 from a cumulative update earlier than Cumulative Update 4 (build 39663). For more information, see Converting a Database in Help for Microsoft Dynamics NAV. 

Where to find Cumulative Update 6
You can download the cumulative update from KB 3052226  – Cumulative Update 6 for Microsoft Dynamics NAV 2015 (Build 40459). 

Additional Information
For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update. 

For information about how to work around a recent process change, see How to Get Back the 'Hotfix Directories' from NAV 2015 Cumulative Update 1.


For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.  

Announcing Dynamics C5 for tablets


Dynamics C5 for tablets is now available for download from the App Store, Google play, or Windows Store.
Note: Microsoft Dynamics NAV 2015 CU1 must be installed if you are using Microsoft Azure Active Directory as the authentication mechanism.

Get the app today    





Google Play is a trademark of Google Inc. Apple and the Apple logo are trademarks of Apple Inc., registered in the U.S. and other countries. App Store is a service mark of Apple Inc.

Tuesday, 17 March 2015

Webclient Issue - Error Message: Value cannot be null

We installed NAV2015 CU3 on our database – and facing issue with the web client.

Web client opens ok and runs some pages but then stops with error "A server error has occurred, and the content cannot be displayed. Refresh the page or open a new browser window"

Error message: Value cannot be null.




Event Viewer says:
Error accessing Website Microsoft Dynamics NAV 2015 Web Client URL: http://XXXXXXXXX:8080/NAV80_Live/WebClient/Services/CallbackService.svc/InvokeHandler Type: System.ArgumentNullException Message: Value cannot be null. Parameter name: form StackTrace: at Microsoft.Dynamics.Framework.UI.EventBlock..ctor(LogicalForm form) at Microsoft.Dynamics.Nav.Client.UIPatterns.ExpressionPattern.Evaluate(LogicalControl fieldTarget) at Microsoft.Dynamics.Nav.Client.UIPatterns.VisibleFormHostControlExpressionPattern.Evaluate(LogicalControl fieldTarget) at System.EventHandler`1.Invoke(Object sender, TEventArgs e) at Microsoft.Dynamics.Nav.Client.DataBinder.NstDataAccess.OpenForm(LogicalForm mainForm, Collection`1 subForms) at Microsoft.Dynamics.Nav.Client.UIPatterns.OnFormOpeningPattern.OpenForm(LogicalForm form) at System.EventHandler.Invoke(Object sender, EventArgs e) at Microsoft.Dynamics.Framework.UI.UX2006.EmbeddedListView.OnFormBuilt(EventArgs e) at Microsoft.Dynamics.Nav.Client.Builder.NavSessionHelper.BuildForm(LogicalForm form) at Microsoft.Dynamics.Nav.Client.FormBuilder.PageBuilder.Build(MasterPage definition, BindingManager bindingManager, UIBuilderContext context) at Microsoft.Dynamics.Nav.Client.FormBuilder.UIBuildManager.BuildPage(MasterPage pageDef, UIBuilderContext context) at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.CreateLogicalForm(MasterPage metadata, FormState formState) at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.CreateLogicalForm(Int32 formId, FormState formState, Int32 retryCounter) at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.CreateLogicalForm(String name) at Microsoft.Dynamics.Framework.UI.UISession.CreateLogicalForm(String name, Boolean reuseActiveForm) at Microsoft.Dynamics.Framework.UI.UX2006.NavigationService.OpenEmbeddedForm(String formName) at Microsoft.Dynamics.Framework.UI.UX2006.NavigateToFormAction.InvokeCore(LogicalControl logicalControl, Object state, UISession uiSession) at Microsoft.Dynamics.Nav.Client.Actions.NavNavigateToFormAction.InvokeCore(LogicalControl logicalControl, Object state, UISession uiSession) at Microsoft.Dynamics.Framework.UI.LogicalAction.InvokeCoreWithErrorHandling(LogicalControl logicalControl, Object state, UISession uiSession) at Microsoft.Dynamics.Framework.UI.LogicalAction.DoInvoke(LogicalControl logicalControl, UISession uiSession) at Microsoft.Dynamics.Framework.UI.UX2006.NavigationService.NavigateToNode(LogicalControl logicalControl, NavigationNode node) at Microsoft.Dynamics.Framework.UI.UX2006.NavigateInteraction.InvokeCore(NavigateInteractionInput logicalInteractionInput) at Microsoft.Dynamics.Framework.UI.InteractionInvoker.Invoke[T](String interactionName, Action`1 invokeMethod, T input) at Microsoft.Dynamics.Framework.UI.LogicalInteraction`1.Invoke(T logicalInteractionInput) at Microsoft.Dynamics.Framework.UI.InteractionManager.<>c__DisplayClass8.<InvokeInteractions>b__4() Source: Microsoft.Dynamics.Framework.UI


Finally, the new feature called “Social Listening” is causing the issue.
This new feature is introduced after NAV2015 RTM and uses a Dll and some pages use the fact boxes related to “Social Listening” and Dll which is required is missing in Database.

Solution:
1.      Open Control Add-In’s page from RTC or Webclient
2.      Add below line using New action (You can check Codeunit 2 Company-Initialize function InsertClientAddIns to copy instead of typing)




3.      Click Import and choose the path where Social Listening Dll is located.


Now Webclient is working fine J

Wednesday, 14 January 2015

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.


Monday, 12 January 2015

C/AL Coding Guidelines

Finally Microsoft has Published C/AL Coding Guidelines that they use at Microsoft Development Center Copenhagen

Please find them in below link.

https://community.dynamics.com/nav/w/designpatterns/156.cal-coding-guidelines.aspx