Thursday, June 7, 2012

How to Disable ESC Key in Navision Classic

Hi all,

Sometime User want to force the user to click on the Cancel button instead of pushing the Esc key.

This can be done From in Navision from Tools Menu in Navision Menu and select Options.

There is an option Close Forms On Esc which is by default set to YES, set it to No.

Refer to screen below.

This option will set the ESC Disabled for all objects.

If we want to customize this for a specific form follow steps below -

1. In the form declare a Boolean variable i.e. OverwriteEsc.
2. Set the Cancel property of the Cancelbutton to No
3. In the OnPush trigger of the Cancel button and Ok button: OverwriteEsc := TRUE;
4. In the OnQueryClose Trigger of the form: EXIT(OverwriteEsc);

Thanks & Regards,
Saurav Dhyani

Wednesday, June 6, 2012

Restore a Database In SQL Server Managment Studio.

Hi all,

Most of us are aware with Navision Backup but at the same time unaware of SQL Server Backup. So lets discuss how to restore a SQL Database backup.

Let see the steps how to restore a SQL Server Database Backup.

Error 3154 - The backup set holds a backup of a database other than the existing database.

Hi all,

While Restoring Database on SQL Server Management Studio, some of us encounter an error i.e
Error 3154- "The backup set holds a backup of a database other than the existing database".

Resolution for the error

After selecting the database backup, goto option Tab from the Left Hand Side Menu and click on First Restore Option i.e Overwrite the existing database(WITH REPLACE) as shown in screen below.

* Make sure that there is no database file exist at the path mentioned in RESTORE the database file as section with same file name otherwise it will replace those files.

For Reading How to Restore a database from scratch in SQL Server Managment Studio, read article here.
Thanks & Regards,
Saurav Dhyani

Table xxx is Locked by User XXX.

Hi all,

Sometime client face issues while posting transaction that Table is Locked by a particular User.

Yes, i know that if a user is Performing a huge transaction then it happens and we can identify that from
File - Database - Information - Session Tab. Here we can get the User Name in Blocking User ID Field.

But what if the Blocking user id is BLANK. What can be the reason of the Locking message that client users are getting?

Monday, June 4, 2012

Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.

Hi all,
During Installation of NAV 2009 & Later, sometime we come across an error which says -

Could not connect to the SQL database.  (-2147467259   master      ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.

This error can be occured due to multile Reasons, so there are mutiple resoultion for the same.

Resolutions -

1) Did u Run installer as Administrator (If Operating system is Windows 7)?
    If not then try intalling using Run as Administrator.

2) Go to services.msc from RUN and check that SQL Server service is running or not. If not start the service and try intalling again.

3) Your Windows does not have sufficient priviledges on the SQL Server. Set up your account with the sysadm server role. Note, that you cannot rely on indirect permissions through Windows group memberships when Vista User Access Control (UAC) is turned on. Try seraching UAC in Control Panel.

4) A previous installation has left the database files (mdf+ldf) sitting in the \Program Files\Microsoft Dynamics NAV\60\Database\ folder and the SQL Server has been reinstalled. This will result in the installer trying to attach an orphaned database. If this is the case, then you should just delete the files or Rename the Database, run the installation once where you select to remove the database components, and run the installation once again where you select to install the demo database.

These are the comman resolutions in this case i was able to find it. I hope someone might be helpfull and it resolve someones issues.

Thanks & Regards,
Saurav Dhyani

NAV Report Export to Excel Number as Text

Hi all,

While adding export to excel functionality into Reports sometime we face issues while sending numbers with Leading Zeros to excel.

In My case customer wanted to export a Report to Excel. Report have first field as Item Number which have Leading Zeros. I created the report and below is the diffrence between excel and Navision Data.

The issue at this point is that Leading Zero in Item No. have been skipped.


Excel formatted the cell as integer, while formatting as intger excel removes leading zeros. Beacuse a number starts with zero dosen't make any sense.


After seraching through blogs and articles i figurred out a soultion so that excel formats the cell as text not as integer.

The solution is simple just to add four single quotes ('''') for the field which you want excel to format as text not as intger.

Sample -
EnterCell(Row, Column, '''' + "No.", FALSE, FALSE, FALSE);
ExcelBuffer.AddColumn((''''+ "No."),False,False,False,False,'');

Thanks & Regards,
Saurav Dhyani

Friday, June 1, 2012

Microsoft Dynamics NAV RTC The type 'Option' is unsupported for the min/max validation rule.

Hi all,

After an upgrade to NAV 2009 RTC from classic client, a client locked an wiered issue.

While accessing a page from Role center client he was getting the error message

"The type 'Option' is unsupported for the min/max validation rule". 

I checked the page, complied the page but no luck.

I checked the tables too that there might be an option field as the message says something about option
but no luck.I was not getting the resolution, so i started deleting the fields from page and i identified the field
which was giving error. To my surprise it was a Option type of field.

I went to properties and identified that the min value for the field have been set to Ship.

I don't know why but when i cleared these two values from field properties, the page started working.

Resolution -

1) Check the properties of Option Type Field In Table.
2) Check the fields in source table and remove the min & Max value for fields.
3) Remove the values for these properties and issue resolved as shown in image below.

Thanks & Regards,
Saurav Dhyani

Popular Posts