Monday, April 28, 2014

NAV 2013 R2 - Howto enable Windows Search Service in Windows Server 2012.

Hi all,

While installing NAV 2013 R2 on Windows Server 2012 the Installer gives an error message of missing component of Windows Search.

ERROR - "The following external program are prerequisites to one of more of the selected product components. They must be present on your computer before the configuration can be installed. For more information, see the system requirement's for Microsoft Dynamics NAV.

Sunday, April 27, 2014

NAV 2013 R2 Synchronization Paradigm Continued..

Hi All,

Let's continue from the point we left in earlier Post. If you haven't read earlier post read it here

Microsoft Dynamics NAV 2013 R2

SCENARIO 2 (DEPRECATED): 
Single-tenancy / Legacy mode
“Prevent data loss from table changes” = No (Manually opted, not persistent)

IMPORTANT NOTICE: 

Setting the “Prevent data loss from table changes” C/SIDE switch to “No” has been intended to be used as last resource in a pure multitenancy scenario and in Test or Staging environments when partners does not have any business data database mounted against the application database.

Never change for any reason this parameter to “No” when developing against a single-tenant / Legacy mode database.


Thursday, April 24, 2014

NAV 2013 R2 Synchronization Paradigm.

Dear All,

Below are some extracts of the article published in Microsoft Team Blog about

"The New Table Synchronization Paradigm in Microsoft Dynamics NAV 2013 R2".

It start's explaining the History, how it used to happen in NAV 2009 /  NAV 2013-

Microsoft Dynamics NAV 2009 / Microsoft Dynamics NAV 2013 


When we import/compile an object in C/SIDE, system checks the object Metadata Version and Compare with Current Version. If the Current Version is New it updates the Object Metadata in Navision and Schema changes are directly applied to SQL Server.

So before NAV 2013 R2, everything used to get updated directly from Classic Client and at the time when we used to process.

At most the only issue we used to have was “The Object Metadata does not exist. Identification and values … “ when running the Microsoft Dynamics NAV Windows client.

Which used to be resolved just by recompiling the Objects specified in error or all the objects or deleting the metadata of that object and re-creating it.

Tuesday, April 22, 2014

How - To enable Windows Search Service in Windows Server 2008.

Hi all,

While installing NAV 2013 R2 on Windows Server 2008 the Installer gives an error message of missing component of Windows Serach.

ERROR - "The following external program are prerequisites to one of more of the selected product components. They must be present on your computer before the configuration can be installed. For more information, see the system requirements for Microsoft Dynamics NAV.
WINDOWS SEARCH.



Thursday, April 17, 2014

NAV 2013 R2 - How to Login in a Database Which have NO Companies?

Hi all,

This post can also be used for NAV 2013 R2 - Creating New Companies in Database From Cmdlets.

With Release of NAV 2013 R2, we can create database from the Developer Environment but there is no option of creating company from Developer Environment.

Due to this we have so many issues as Role Tailored Client will not open until there is a company in the database. One of the issues is discussed below with resolution.


Wednesday, April 16, 2014

NAV 2013 R2 - Update Rollup (cumulative update) 6 Released.

Hi all,

Please find below the details of Update Rollup Cumulative Update 6 released for Microsoft Dynamics NAV 2013 R2.

NOTE: The term “update rollup”, which has been used until now for hotfix releases, has been replaced with the term “cumulative update”. The meaning of the term is unchanged.

Title - Update Rollup Cumulative Update 6 for Microsoft Dynamics NAV 2013 R2
Build No. - 36366
Release Date - April, 2014
Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

Download Link

Monday, April 14, 2014

NAV 2013 and NAV 2013 R2 - Add Image in Report.

Hi all,

Let's see a simple thing today i.e How to add images in Reports in NAV 2013 and Later.

* Below screen shot are from NAV 2013 R2, the steps remain same for NAV 2013 too.

So let's do it in a standard Report, say Report 405 which doesn't contain Company Logo. We will add the Company Image from Company Information Card / Table.


Sunday, April 13, 2014

NAV 2013 - Update Rollup (cumulative update) 13 Released.

Hi all,

Please find below the details of Update Rollup Cumulative Update 13 released for Microsoft Dynamics NAV 2013.

NOTE: The term “update rollup”, which has been used until now for hotfix releases, has been replaced with the term “cumulative update”. The meaning of the term is unchanged.

Title - Update Rollup 13 for Microsoft Dynamics NAV 2013
Build No. - 36347
Release Date - April, 2014
Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

Download Link


Wednesday, April 9, 2014

How to Apply Rollup of NAV 2013 and Later.

Hi all,

In Previous post we had seen how to download the Rollup of NAV 2013 and Later.

Let's see how to apply Rollup of Microsoft Dynamics Rollup for NAV 2013 & NAV 2013 R2.

Remember - Before applying the rollup there should be no user accessing client. All NAV Services, NAV Clients (windows & developer Environment) should be stopped & closed.

Thank you +nishant srivastava  for suggesting correction in the article.

File Already Downloaded in previous post, Extract the file in a folder and open the extracted Folder.



Tuesday, April 8, 2014

How to Download the Rollup for NAV 2013 and NAV 2013 R2.

Hi all,

It has been asked so many time so here it is

"How to Download the Rollup for NAV 2013 and NAV 2013 R2".

Follow the Link to the KB Article as per the Rollup you want to Download. You can find details of all Rollup released for NAV 2013 and NAV 2013 R2 here.

You can find details of all updates roll ups for NAV 2013 and NAV 2013 Here.

Friday, April 4, 2014

NAV 2013 NAV 2013 R2 Upgrade Error - Data Source name not found and no default drivers specified.

Hi all,

I am in process of upgrading a database from NAV 2009 SP1 to NAV 2013 R2 in one step. Earlier the One Step was not working for me but i hope this time i will be able to complete it. Keeping my finger crossed.

During upgrade step 1 i faced a issue that i would like to share with you all. After Step 1 of Data Migration when i tried to open the database in NAV 2013.

NAV 2013 gave me below error -

Error: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified. State ID: IM002

Wednesday, April 2, 2014

NAV 2013 R2 - The Object table contains a Microsoft Dynamics NAV Development Environment field data type that is not compatible with the SQL Server data type.

Hi all,

Let's discuss a issue resolution which most of us are facing after applying Rollup 5 for NAV 2013 R2 with Build  36281.

The Error Message that i faced is -

The Object table contains a Microsoft Dynamics NAV Development Environment field data type that is not compatible with the SQL Server data type.
Field : Version List
Type: Text 248
SQL type : VARCHAR(80)


Tuesday, April 1, 2014

NAV 2013 & Later - An item with the same key has already been added.

Dear All,

During a upgrade process to NAV 2013 R2 from NAV 2009 SP1, i faced an issue which took a lot of time to resolve.

So i thought sharing the same with you all.

When i tired to run a page it crash the NAV 2013 Windows Client exe, I thought that page might have issues but when i run table from developer environment everything same.

The ERROR that i was getting - "An item with the same key has already been added"

Below is the Some part of Error in event viewer -

System.ArgumentException was unhandled
  HResult=-2147024809
  Message=An item with the same key has already been added.
  Source=mscorlib