CAUSE

This error occurs when the total number of users accessing the Microsoft Dynamics NAV database at the same time has exceeded the total number of user sessions that a license gives access for. If you are licensed for 5 users and you are the 6th user trying to log into the Microsoft Dynamics NAV database, you will receive this error.

The error can occur even though the actual number of active users that are logged into the Microsoft Dynamics NAV database are less than the number of user sessions your license gives access for. The situations this may occur in are listed here:

1. If you are using N/ODBC or C/Front, each instance of these programs that you have running will use a user session.
2. There may be idle sessions still connected to the Microsoft Dynamics NAV database. This can happen if a user did not close Microsoft Dynamics NAV properly when exiting, or after power failures.
3. Microsoft Dynamics NAV Database Server only
   The maximum number of sessions that are allowed to log on to the Microsoft Dynamics NAV Database server simultaneously can be specified when you start the Microsoft Dynamics NAV Database service. If the maximum number of sessions was set when the Microsoft Dynamics NAV Database service was started, no more users than this maximum can log into the NAV Database server at the same time no matter how many sessions is on the license.

RESOLUTION

1. How to determine how may users are logged into the Microsoft Dynamics NAV database

You can see how many users are logged into the Microsoft Dynamics NAV database at any given time from the Database Sessions window. To access the Database Sessions window in Microsoft Dynamics NAV follow these steps:

1. Go to File, Database, Information, Sessions tab
2. Drill down into the Current Sessions field
   The Database Sessions window will show a list of all sessions connected to the Microsoft Dynamics NAV database, including users, N/ODBC sessions etc.

You can filter by the Microsoft Dynamics NAV database in the Database Name field to limit the records to only show sessions connected to this database.

2. Inactive/Idle Sessions

You can delete idle user sessions from the Database Sessions window by selecting the record for the session you want to delete, right-click and select Delete, or press the Delete key.

Note: Inactive/idle sessions will automatically expire after a certain amount of time, normally 2 hours.

3. Microsoft Dynamics NAV Database Server only

When the Microsoft Dynamics NAV Database Server is installed, the Sessions parameter is automatically set equal to the number of user sessions on the license that is installed on the server. However, this setting can be changed manually so that maximum sessions are set to less than the number of user sessions on the license installed on the server

You can check Maximum Sessions by going to a command prompt; go to the directory where the Microsoft Dynamics NAV Database server is installed and type SERVER, or go to the directory where the database server is installed from Windows Explorer and double click the Server.exe file.

If Maximum Sessions are set to less than the number of user sessions on your license, the Maximum Sessions parameter can be changed in the Microsoft Database Server Manager Snap-in for Microsoft Management Console or you can change the maximum sessions parameter from the command line when you start the server by entering sessions=XX, where XX is the number of sessions.

You can find this on Partner or Customer source also.

With NAV 2009 onwards you can set Vertical & Horizontal Gridlayout for fields in your pages,request pages.

Below is the Horizontal Gridlayout setting,

The very first type should be a container.

2nd Type Group & Subtype as group ,without layout property set to row or column.

3rd Type Group & Subtype GridLayout ,with layout property set as row, and indented.

4th Type Group & Subtype as group,without layout property set to row or column and indented.

After wards select the field you want to show.

You can also search in the help file of NAV or see the Item card->Reorder-Point Parameters fast tab.

Below is a screen shot…

Now you have a new tool called Microsoft Dynamics NAV Administration in your Control Panel ->Administration Tools.

The Microsoft Dynamics NAV Server Administration tool shows settings for the currently selected Microsoft Dynamics NAV Server instance. Settings are grouped into the following tabs, according to service category.

General :- Settings apply to all kinds of services.

Client Services:- Settings apply to RoleTailored clients.

OData Web Services:- Settings apply to OData web services.

SOAP Web Services:- Settings apply to SOAP web services.

NAS Services:- Settings apply to NAV Application Server (NAS) services.

Management Services:- Settings apply to the Microsoft Dynamics NAV Server Administration tool.