Tuesday, 29 July 2014

The Microsoft Dynamics NAV server is currently not ready to serve requests. Try again later or contact your system administrator.

Error Message:

The Microsoft Dynamics NAV server is currently not ready to serve requests. Try again later or contact your system administrator.

Problem Statement:

System returns above error message when you try to Connect to NAV Database and Stops the Running service.

Solution: 

Open SQL Management

Go to Security -> Logins -> find the login used by the NAV Server (e.g. Network Service) -> Properties -> User Mapping -> find the database and select db_owner in the "Database role membership".

Tuesday, 8 July 2014

NAV TechDays 2014

what?

NAV TechDays is the name of a conference, organized by mibuso.com. This conference offers 2 days full of – technical only and highly relevant – sessions, related to Microsoft Dynamics™ NAV.
NAV TechDays is the place where some of the best developers and leading business owners cross paths, exchange ideas, find partners and conceive projects. It is where community ties are strengthened and where boundaries will be broken. It is where you want to be to make things happen. If you are passionate about Microsoft Dynamics NAV, then you need to be at NAV TechDays!

When?

20 & 21 November 2014
Antwerp, Belgium

For Who?

The conference is targeted towards:
  • ALL Microsoft Dynamics NAV developers (working for Microsoft partners or customers, freelancers, trainers, ...)
  • Technical decision makers, Project managers, IT managers
Although this event takes place in Europe, we welcome all attendees from other continents and regions.

Pre-conference?

This year, we added a pre-conference day packed with 10 full-day workshops. Each workshop is limited to max. 15 participants.
Take your laptop with you and dive into:
  • Microsoft .NET Interoperability
  • RDLC Reporting
  • Installing, configuring and troubleshooting SQL Server
  • Powershell
  • NAV ALM using Team Foundation Server
  • ...

Any Questions?



What are you waiting for?
Go and talk to your boss or management and convince them.




Thursday, 10 April 2014

Webclient Issue - Error Message: Value cannot be null


We installed our NAV2013R2 NLD Trade+ database – build 35915 and facing issue with the web client.

Error message: Value cannot be null.

Event Viewer says:
Error accessing Website Microsoft Dynamics NAV 2013 R2 Web Client
URL: http://localhost:8080/DynamicsNAV71/WebClient/default.aspx
The ClientExceptionState indicated that the session should be abandoned but the exception handler had no UISession assigned.

Error accessing Website Microsoft Dynamics NAV 2013 R2 Web Client
URL: http://localhost:8080/DynamicsNAV71/WebClient/default.aspx
Type: System.ArgumentNullException
Message: Value cannot be null.
Parameter name: bindingManager

Generally the issue occurs if we have the Links system part added to the Role Center. Links system part is not supported by Web Client. 
If any or one of Role Center’s has the links part added then we can get this error on Web Client.

We deleted the Link part and it started working fine.

Friday, 21 March 2014

Reset Autoincrement field in NAV

In SQL Server we have command called DBCC CHECKIDENT 

Checks the current identity value for the specified table and, if needed, corrects the identity value.
You can also use DBCC CHECKIDENT to manually set a new current identity value for the identity column.

The syntax of the DBCC CHECKIDENT command is as follows:

DBCC CHECKIDENT ( <table_name> [ , { NORESEED | { RESEED [, <new_reseed_value> ] } } ] )
[ WITH NO_INFOMSGS ]

The <table_name> parameter is the name of the table for which to check the current identity value and it must contain an identity column.  The NORESEED clause specifies that the current identity value should not be changed.  The RESEED clause specifies that the current identity value should be changed.  The <new_reseed_value> is the new value to be used as the current value of the identity column.  Lastly, the WITH NO_INFOMSGS clause suppresses all informational messages.


If the table has no rows and execute below statement

Use [Demo Database NAV (7-1)]
GO
DBCC CHECKIDENT ([CRONUS Nederland BV$Test Increment], NORESEED);
GO

Result:
Checking identity information: current identity value 'Null', current column value 'Null'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

If it has one row then result of above statement is:

Checking identity information: current identity value '1', current column value '1'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


To set the IDENTITY column of a table to start from 1, the following statement can be issued:
The following example forces the current identity value in the table to a value of 0. The next row inserted will use 1 as the value, that is, the new current increment value defined for the column value plus 1.

Use [Demo Database NAV (7-1)]
GO
DBCC CHECKIDENT ([CRONUS Nederland BV$Test Increment], RESEED,0);
GO

Permissions:
Caller must own the table, or be a member of the sysadmin fixed server role, the db_owner fixed database role, or the db_ddladmin fixed database role.

Friday, 7 February 2014

NAV Web Client - Communication with the Server Failed Error

ERROR Message:

I have installed NAV2013R2 version and RTC working perfectly but when I run the web client, I am getting standard Cronus message and when I click OK, I am getting below error message
---------------------------
Message from webpage
---------------------------
Communicatie met de server is mislukt. De inhoud kan niet worden weergegeven. Vernieuw de pagina of open een nieuw browservenster.
---------------------------
OK  
---------------------------

Sorry, it’s in Dutch.

If I translate it using http://translate.google.com/

---------------------------
Message from webpage
---------------------------
Communication with the server failed. The content can not be displayed. Refresh the page or open a new browser window.
---------------------------
OK
---------------------------

More details from Event Viewer are:

Error      7-2-2014 06:14:50            System.ServiceModel 4.0.0.0       3             WebHost             "WebHost failed to process a request.
Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/20974680
 Exception: System.ServiceModel.ServiceActivationException: The service '/DynamicsNAV71/WebClient/Services/CallbackService.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (631484416 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.. ---> System.InsufficientMemoryException: Memory gates checking failed because the free memory (631484416 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.
   at System.ServiceModel.Activation.ServiceMemoryGates.Check(Int32 minFreeMemoryPercentage, Boolean throwOnLowMemory, UInt64& availableMemoryBytes)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CheckMemoryCloseIdleServices(EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   --- End of inner exception stack trace ---
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)
 Process Name: w3wp
 Process ID: 11720"

Cause:
Insufficient memory for application/Web client. An application or a process takes up a large chunk of the memory.

Opened Task manager and noticed that Memory used is 94% L.

Resolution:
Stopped some services and applications (Now the memory used is 88%)
Run web client again.


It started working without any error J


Monday, 30 December 2013

Happy New Year 2014

May god bless you with all the success and happiness you deserve.



May Every Day of the New Year Glow with Good Cheer and Happiness for you and your Family.


Happy New Year 2014 

Wednesday, 27 November 2013

Microsoft Dynamics NAV 2013 administration tool does not work in a side-by-side installation with Microsoft Dynamics NAV 2013 R2.

Platform hotfix for Microsoft Dynamics NAV 2013 (Build 35591) is released.

This hotfix resolves the following problems:

ID
 Title
353997 
Microsoft Dynamics NAV 2013 administration tool does not work  in a side-by-side installation with Microsoft Dynamics NAV 2013  R2.
353766
When you use RapidStart services to import lots of records from an Excel workbook, it takes longer than expected.
353279
When you export an account schedule to an Excel workbook and select the Update Workbook option, calculated cells are not updated in the Excel workbook.

You can request the hotfix here (Partnersource login required)