Monday, December 24, 2012

NAV 2013, NAV 2009 R2, NAV 2009 SP1 & NAV 2009 on Same Machine with Same Ports


Hi all,

As discussed in my most of the Earlier post when we install NAV 2013, it is the best practice to Uninstall all
previous version that are installed.

Reason - When we install multiple versions of Navision after 2009 and try to run the object from the object designer it gives us an error message.

Today we will be discussing the extended part of the Posts -
1) NAV 2009 SP1 and R2 on Same Machine
2) NAV 2009 SP1 & R2 on same machine with Issue Resolution

As new version of NAV, i.e NAV 2013 have been released so we need to change some of the setting.

Monday, December 17, 2012

Port Sharing in NAV 2013

Hi all,

After installing NAV 2013, the Port 7046 is blocked for NAV 2013 Management services.

Earlier till NAV 2009 R2 we can create services for NAV 2009 and NAV 2009 SP1 on the same port by enabling TCP Port Sharing service.

But when we try same after installing NAV 2013 it gives an error.

The Breakpoint Already Exist...


Hi all,

Just a quick post.

Most of time we get a error message "The BreakPoint Already Exist" Error Message in Navision.

The Error message is due to - "During testing the process by Technical Consultant we put breakpoints to test the value at that particular instance.

One of my user reported this error which he was getting during execution of Job in Event Viewer.

So now how can i remove all the breakpoints that i have applied, as i might have applied into multiple objects into multiple places.

Wednesday, December 12, 2012

Sunday, December 9, 2012

NAV 2013 Credential Type - How to Use?



Hi all,

Please do these activities when you have time, its a long activity and i would suggest do all activities in one go. So be clam and lets start.

For NAV 2013 R2 Refer Here.

For NAV 2016 Steps have been Reduced Please Refer Here.

I have installed NAV 2013 and its work great with my windows credentials.



I was checking the service console (Microsoft Dynamics NAV Administration) in NAV 2013 and found out that Credentials Type have multiple Options.

Saturday, December 8, 2012

NAV 2013 Upgrade Part IV - SQL Migration.


Hi all,

While Release of NAV 2013, we had some new things but some old things became obsolete and cannot be used with this version of Navision.

One of them that effect most of the customer is Support to NATIVE Database. So today we will discuss about Native to SQL Migration which is one of the steps during upgrade to NAV 2013.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all,

As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes.

Let's start the process.

Remember - 
1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only.
2) The Synchronization of users with SQL Server is no more required.

Friday, December 7, 2012

You are not authorized to sign in. Verify that you are using valid credentials and that you have been setup as a user in Microsoft Dynamics NAV.

Hi all,

while creating a database in NAV 2013 or during upgrade we sometime forget to add our own windows login into the database.

Result of same is that we are unable to access the database anymore.

Till NAV 2009 R2 we used to add the login from the Native Client but with NAV 2013 user creation have also being moved to RTC Client.

So it was a tedious task to repeat activities again :(.

Below listed steps will delete all the existing users from the database but if you don't want to do that and just want to add your login in the database please follow the related post.

If you are using NAV 2013 R2 or Higher Please refer this article.

Thursday, December 6, 2012

NAV 2013 Report Header Doesn't get Printed.

Hi all,

During working on NAV 2013 Report, i faced an issue. The issue was weird so i thought sharing same with all of you.

I created a report with all the same techniques that we used to use till NAV 2009 R2. Everything was fine and was previewing fine.

Just for your information while creating Report Header and Footer i used GetData and SetData as we used till now.

Saturday, December 1, 2012

Monday, November 26, 2012

The date format is incorrect in an Excel worksheet when you export in excel via RTC Client

Hi all,

Today i created a processing only report in navision classic client which used to pull some data into excel.

The format contain the date fields too.

Now while running that report from classic client it works great but while running report from RTC client the date format was incorrect.

If the report would have the field then i would have changed the date format in the RTC Report layout but that was not the case.

Unhandled thread exception caught. Exception while trying to create an instance of the Dynamics NAV integration pages

Hi all,

After installing Connector for Microsoft Dynamics NAV with CRM and during configuration we get below error message.


Unhandled thread exception caught. Exception while trying to create an instance of the Dynamics NAV integration pages

Tuesday, November 13, 2012

NAV 2013 Upgrade Part II - Upgrading the Standard Objects.

Hi all,

As discussed in previous post about upgrading the customized objects, let's move ahead and see how to upgrade the standard objects.

As the old standard process of Upgrade suggested by Microsoft, we need to compare and merge the changes in target. Lets see the steps for the same.

The steps listed below may not be followed by all during upgrade but for me i find these steps the best way to upgrade which do leave any issues.

Monday, November 12, 2012

NAV 2013 Upgrade Part I - TextFormatUpgrade2013 Tool

Hi all,

HAPPY DIWALI TO ALL THE READERS.

Let's Talk about upgrading process to NAV 2013. 

As we all know the pre-requisite version to upgrade is NAV 2009 SP1 / R2 and we all know how to upgrade from any older version to NAV 2009 SP1 / R2.

I will break down upgrade process to NAV 2013 to multiple Post -


Let me know if anyone require other information other then above listed points, will include them too.

Wednesday, November 7, 2012

Action Image in Navision 2013

Hi all,

While Developing Pages for Role Tailored Client we face issues when we create an action an set its prompted to true, and want an image for the action. Below is the screenshot of the page property where we set the image for an action in NAV 2013.


Now for the image till NAV 2009 R2 Microsoft doesn't provide a list or look up we need to type in name of the image we want to use. so how can we find the name of image that we want to use.

Action Image in Navision 2009, 2009 SP1 & 2009 R2


Hi all,

While Developing Pages for Role Tailored Client we face issues when we create an action an set its prompted to true, and want an image for the action. Below is the screenshot of the page property where we set the image for an action.


Friday, November 2, 2012

Navision 2013 Sharepoint Client Installation & Configuration Errors

Hi all,

While installing Sharepoint 2010 For Running Microsoft Dynamics 2013 Sharepoint client. During installation  Microsoft Sharepoint 2012 we get many errors.

I will be keep this post updated will all those errors and resolution for those errors. Currently i got below listed error so for now below is the error and resolution.

Friday, October 19, 2012

Conditional Colouring in NAV 2013 Pages


Hi all,

As we were facing problem in Role Tailored client till NAV 2009 R2 about the colors.

Customer wanted conditional coloring of rows based on some condition but was not possible in Role Tailored Client.

With NAV 2013 Microsoft have come up with a level of Conditional coloring  yeah still have some limitations. The number of colors that are supported are fixed.

Let's see how is it there -

I was just checking pages in NAV 2013 and seen this.

If you remember a property of Field in Page i.e StyleExpr which used to have value True or False is now have been changed and can take variables as value.

Just have a look in Page Customer Ledger Entries, Field - "Document No.". Below is the property for the field.



So the property have value StyleTxt which sets onAftergetrecord() and get value from function setstyle as shown below.



Then i navigate to Table 21 Cust. Ledger Entry for the function definition and below is the code written in the function.


so i guess its one of the cool feature that every customer of every partner wanted. So lets use it with customer database.

Here is how the customer ledger entry page look like.


You can see lines in Red Color based on condition.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Wednesday, October 17, 2012

Error 47-1 During Export Objects as Text

Hi all,

Sometime we face an error message while exporting objects as Text file, but when we try to export as .fob it works fine.

Today i require to compare some object so i needed them in text file, when i tried to export as text i get below listed error.

There are errors in the text conversation (text no. 165-205 does not exist in the .stx file).

Internal error: 47-1

Reason of Error -
The reason of the error is due to objects version conflict. The objects which i was trying to export as text file are of higher version and were in the older version of database. In my case the objects were from NAV 2009 SP1 and were in NAV 5 SP1.

Resolution of Error -

1) Export the objects into .fob format.
2) Create a new temporary database in new version.
3) Import the exported objects into new created database.
4) export objects into text file.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Run XMLPORT in Navision Before NAV 2013

Hi all,

For Running a XML PORT in Navision Before NAV 2013, we can do that via a codeunit.

Below is the sample of execution of Xml Port via a codeunit.

Variables in Codeunit


Name                                 DataType
_Filev                                 File
_DatafileOutstream                 OutStream
Selection                                 Integer
_DatafileInstream                 InStream


Wednesday, October 10, 2012

Hyper Link to a Page from a Report.


Hi all,

As we see in last post how to expand-collapse in Navision RTC report.

In the same report we will now try to add Hyperlink to the item Number. So that on clicking on the item number in the report, the item card will get open in edit mode.

Let's see how to do it.

Taking Report 1001 (Inventory Valuation) Report for Demo.

1) Open Microsoft Dynamics NAV Developer Environment.
2) Design Report 1001.
3) In C/AL Global add a new variable.
     a) Name - ItemRecRef, Datatype - RecordRef.

4) Now i will add code in the data item to get item.
5) Goto Pre-data of Item and write following line of code.
     a) ItemRecRef.OPEN(27);

6) Goto OnAfterGetRecord of Value Entry add following line of code.
     a) ItemRecRef.SETPOSITION(Item.GETPOSITION);

7) Add a column in Report Desing for Item Table.
     a) DataSource - FORMAT(ItemRecRef.RECORDID,0,10), Name - Item_Rec_Ref_Val


8) Now open the Report Layout in Visual Studio.

9) Goto TextBox Properties of =Fields!Value_Entry__Item_No__.Value.
10) Select the Action and select Go to URL.

11)Open the expression and change the existing code to this.
 ="DynamicsNAV:////runpage?page=30&mode=edit&bookmark="+FORMAT(Fields!Item_Rec_Ref_Val.Value)
12) The windows should look like this.



Execute the report.

once you click the item number it will open item card in edit mode (as command in hyperlink).


All this is possible will all version of NAVISION Role Tailored Client Reports.

Regards,
Saurav Dhyani

Tuesday, October 9, 2012

NAV 2013 Query


Hi all,

Let's try to create a new query (new object released with NAV 2013) and use that query in a chart.

For example suppose i want to display the Top 10 item by sales in a period say last 10 days.

I will open the developer environment of NAV 2013 and start creating a query.

As i require Top 10 items my data items will be Value Entry and Item.

From these tables i will require Item Sales Amount (Actual) and Item Description to display on the chart.

Below is the screen shot of how my query look like.



As i require Total of Sales Amount Actual i added the method type as Totals and Method as SUM and i grouped the Query by Item No.

For Filtering based on date i used posting date from Value entry table.

Let's try to run the query and see the output.


As you can see in the output of the query above that it returns the First 1000 Rows which is not required in my case.

So let's go back to query and go to query properties  Here as shown below i will set the property TopNumberofRows to 10.




Then the query will show the Top 10 Records from the database as shown below.


So we are done with query. Now lets go to role tailored client and start creating chart using this query object.

As you can see that the chart accept only two data source table & query.

I started creating a chart. Below are the field values that i set -

1) ID - Test.
2) Name - Item By Sales - Last 10 Days
3) Source Type - Query.
4) Source ID - 50001.
6) Filters - Posting Date = w-10D..w (as i want to show the top sales in last 10 days)
7) Required Measure - Sum_Sales_Amount_Actual (SUM (aggregation), Graph type (Column) and Caption sales Amount).
8)Y axis Caption - sales amount.
9)X Axis Item No or Item Description.

Here is the image of how the chart in chart builder look like.


Now i will add this chart to role center page and lets see what we get in output.

Here is the output...


The whole process is also available in below video.



Regards,
Saurav Dhyani

Zetadocs Express For NAV 2013

Hi all,

Zetadocs Express has been updated for use with the Microsoft Dynamics NAV 2013 Windows client.

Zetadocs Express for Microsoft Dynamics NAV is available for the following NAV Databases: AU-NZ, NA, DK, FR, DE, IN, IE, IT, NL, ES, GB, W1, AT*, BE*, FI, NO*, PT*, SE, CH*

Zetadocs for NAV 2013 include following Features -

Document Drag & Drop - This action automatically uploads the document to Microsoft SharePoint Online and links it to the Microsoft Dynamics NAV Record.

Choice of Client - Users can store, view and access documents from the Microsoft Dynamics NAV RoleTailored Client or from Microsoft SharePoint Online.

Basic Document Approval - Allows the approval status of documents to be seen within Microsoft Dynamics NAV. Approving managers are prompted by email, as with any Microsoft SharePoint workflow*

Save & Send PDF - Enables users to email a report as a PDF attachment, filing a copy of the report automatically in Microsoft SharePoint Online.



Download Zetadocs For NAV 2013 From Partner Source.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Monday, October 8, 2012

Expand - Collapse Feature in NAV RTC Reports

Hi all,

This feature is there from NAV 2009, sorry i am late but still most of us don't know about this feature.

Below is the demonstration of how to do it in NAV 2013.

I have taken a standard report "Inventory Valuation" for the Demo Purpose.

Below is the standard report output -


Now i went to Microsoft Dynamics NAV 2013 Development Environment, and designed the report.

Opened the layout of the report. Now i selected the body part of the report and went to group properties.

I just changed some properties in the Visibility tab of the group, as shown below.


And here is the output of the report after i saved and executed it again.


So it was nice and easy to do expand and collapse in RTC Report.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Wednesday, October 3, 2012

NAV 2013 First Error with License

Hi all,

After installing NAV 2013 RTC client doesn't get connected and throws the below error message.

Your program license does not permit you to run this version of the Microsoft Dynamics NAV Development Environment. 
Contact your system administrator to upgrade your license. 



Reason For Error

I got this error because i have my old developer license (Developer License For NAV 2009 R2) uploaded on SQL Server.

The license does not support NAV 2013.

Resolution

There are two ways to resolve the error -

1) For temporary solution import demo License file on the SQL Server that as shipped with NAV 2013 DVD.

2) For Permanent Soultion download the latest license file from Microsoft VOICE and upload that on SQL Server.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Wednesday, September 26, 2012

NAV 2013 Released For Group I

Hi all,

Finally the wait is over.

Yesterday Microsoft has released NAV 2013 from Group A Countries. Below is the list of Group A Countries.

  • AU-Australia
  • CA-Canada
  • DK-Denmark
  • FR-France
  • DE-Germany
  • IN-India
  • IT-Italy
  • MX-Mexico
  • NL-Netherlands
  • NZ-New Zealand
  • ES-Spain
  • SE-Sweden
  • UK-United Kingdom
  • US-United States
  • W1 
 NAV 2013 can be downloaded from the link. It would require a Partner source login.

But there is some issues in downloading the same.I got an error message while trying to Download.


MBS File Exchange Access Denied.
If you feel you received this message in error please contact VOICE@microsoft.com.

Hope we will be able to download soon.

Enjoy...

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Friday, September 21, 2012

Replacement of JET Reports

Hi all,

While reading today in Microsoft Website about new features of Microsoft and guess what i found.

Power Pivot an replacement for Jet Reports.

It connects to SQL Database in the same way but i don't know about the License but it don't have those issues which we have for JET Report License Issue.

Power Pivot can be downloaded From here.

NAV 2013 Latest Updates

Hi all,

This post is only for those who have a valid partner source Login.

Microsoft Partner Source have a page which have a list of all the features that have been released till date for NAV 2013.

This Page also contain a Excel File Named as Mega Map which contain Links for Videos for NAV 2013.

Tuesday, September 11, 2012

Either the caller does not have the required permission or the specified path is read-only.

Hi all,

Sometime while trying to connect to Role tailored client we face an error message which says this -
"Either the caller does not have the required permission or the specified path is read-only."
and it looks like -



 This can happen with NAV 2009 & later.

Reason -
The reason for error is that the user have not sufficient rights on the service tier or i can say on the service folder in Server.

Resolution -

1) Go to service folder in the server.
2) Right click and select properties.
3) Navigate to security Tab.
4) Click Edit.
5) see user by which you are trying to connect is there, if not add it.
6) If exist check for the permissions in below box.
7) In both the cases assign permission to user.
8) Apply and ok.
9) Restart the service.
10) Connect to RTC Client.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/


Wednesday, September 5, 2012

The Object File cannot be used with this version of the program.

Hi all,

While exporting the objects in FOB format we sometime get the below error that says -

"The Object File cannot be used with this version of the program."


 I got this error while trying objects from NAV 2009 installed and trying to export the objects in FOB Format whereas the Text format export was working fine.

After searching i found out that it was due to some exported objects of NAV 2013 lying at the same path.

Once i removed those higher version FOB files from the location i was able to take backup on that location.


Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Monday, August 27, 2012

Debugging in NAV 2013 Client


Hi all,

As most of us know that due to changes in version there has been changes in Debugging Process of Navision Process.

Here are some screenshot of the debugger in NAV 2013 Client -

For Activating Debugger we need to Start it from Classic or Developer Environment Client Option.



Sunday, August 26, 2012

Debugging in NAV 2009,2009SP1 & NAV2009R2 RTC Client

Hi all,

With the new client version of Navision the debugging process have also been changed.

This post contain details of NAV 2009, NAV 2009 SP1 and NAV 2009 R2 RTC Client.

First step is to Stop the Microsoft Dynamics NAV Server Service.

Then we  need to don EnableDebugging in CustomSettings.config found here: C:\Program Files\Microsoft Dynamics NAV\60\Service.

Now start the Microsoft Dynamics NAV Server Service.
Now we have debugging enabled. Now start the RoleTailored client. This will take a bit longer to start up, because C# files are generated for each of the objects. (Pages, Codeunits, Reports etc.) - .cs files will be created.
In this example I will make a codeunit with a simple message and add this to an action on the Customer list.
Create a Codeunit. Ex. 50000
OnRun trigger place the following code: MESSAGE ('Debug test')

Save and compile Codeunit 50000.
Now let us add this codeunit to a action. Design page 22 and navigate to the Actions on page 22.


Insert a new action below the the Customer Action group


Hit F9 and enter this code on the Debug test -  OnAction trigger: CODEUNIT.RUN(50000);
Save and compile page 22


we now have all code completed so now let us set a breakpoint in Visual Studio.
Navigate to “C:\ProgramData\Microsoft\Microsoft Dynamics NAV\60\Server\MicrosoftDynamicsNavServer\source\Codeunit” IN WINDOWS 7
Assuming that you have Visual Studio installed, (In my case I’m using Visual Studio 2008 with SP1) open Codeunit50000.cs
If you have UAC turned you will need to open Visual Studio with “Run as administrator”.
Now we need to attach the NAV service. Select “Debug / Attach to process…”
Attach Microsoft.Dynamics.Nav.Server.exe
Your screen should now look like this:
Now add a break point on the message “Debug test”
With this done now let us go to RoleTailored client.
Navigate to Customer List and see that you have a new action called “Debug test” under “Related Information”
Now select “Debug test”
Visual Studio will come back in focus with the breakpoint selected.


Now try to hit F5 and debugging will continue and RoleTailored client will come back in focus and show the message “Debug test”:
"In Next post i will discuss the Debugging Process in NAV 2013 which is an enhanced version of Debugging. i Personally feel that its a better version than debugger in classic client and RTC Client till NAV 2009 R2."
Regards,
Saurav  Dhyani



Debugging in Nav 2009 R2 and Earlier Version of Classic Client.


Hi all,

As most of us know that due to changes in version there has been changes in Debugging Process of Navision Processes.
Let's start with the Orignal Debugging version of Navision i.e Debugging in classic client.

In classic client the debugger was present in the classic client window itself under Tools Sections.

Here are some screenshot of the debugger in classic client -



Functional New Functional Features in NAV 2013

Hi all,

For keeping a log of the post for NAV 2013 below are some new features in NAV 2013.

By Clicking on the link below you can redirect to the actual post in Microsoft Dynamics NAV Team Blog -

VAT Rate Change Tool in Microsoft Dynamics NAV 2013.

Cost Accounting in Microsoft Dynamics NAV 2013.


Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Microsoft Dynamics NAV 2013 Beta VM

Hi all,

The most awaited Virtual Machine for Navision Consultants is now available on Microsoft Partner Source.

For Downloading Microsoft Dynamics NAV 2013 Virtual Machine, follow the link.

Additional guidance and documentation around the Virtual Machine will be released shortly.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Monday, August 6, 2012

Microsoft Dynamics NAV 7 / 2013 Web Client


Hi all,

Please make sure that u have installed Web client from the DVD web Client folder but it will not work by installing that way.

Let’s see the steps how to install web client.

      1) Please make sure that these components have been installed in your windows OS.

For same go to Control Panel, Program and Features. Click from the left hand side Turn Windows features on or off.

Sunday, August 5, 2012

NAV 2013 Sharepoint Client on Windows 7.

Hi all,

Lets see how can we install Share point client on windows 7.

We would require Share Point Foundation 2010 before installing navision Sharepoint Client. You can download Share Point Foundation from here.

Run the setup after downloading the setup.

If you are trying to install it in windows 7 as i am doing it, you might find error as shown below -


Thursday, July 26, 2012

Microsoft Dynamics NAV 2013 Release

Hi all,

Microsoft have shared the release date of NAV 2013 for Partners.

We don't need to wait so long it will be available on 23 September 2012.

Here are the complete details of event Click Here.

So get ready to using NAV 2013 complete Version.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Thursday, July 19, 2012

SQL Error System.Data.SqlClient.SqlError: The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation'

Hi all,

While Restoring a SQL Backup from SQL Server Management Studio sometime we get an error as shown below -


System.Data.SqlClient.SqlError: The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\SQL\Databases\\TestDB_2012_10.mdf'. (Microsoft.SqlServer.Smo)




Cause of Error
we typed the name incorrectly during the file name creation in Restore Operation.

Resolution -


Check out the file name in Option tab of Restore Database window.
You would have put two \\ instead of one while specifying the path where file should get created.

Below is the image of what i did -



Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Friday, July 6, 2012

Error: 5133 SQL Server while attaching the Database

Hi all,

One of my friend reported an error while trying to attached a database received from client to SQL SERVER 2008 R2.

The database received have only two files one is .mdf & second one is .ndf.

while attaching database to the server he was getting below error -


TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'XXX-XX--XX'.  (Microsoft.SqlServer.Smo)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Directory lookup for the file "G:\SQLLOG\NAV_D_CQPA_370B_Log.ldf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)
------------------------------


Resolution -


1) Check for the file path during attach.
In my case as i don't have the Log File (.ldf)  it was taking a random path which does not exist in the system.

2) Delete the selected file (in my case the log file) and click attach.

The system creates the missing file automatically.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Thursday, July 5, 2012

Microsoft Dynamics NAV Client has stopped working..


Hi all,

some time we face issues when RTC Client Crashes. There can be multiple issues for the same. below is the screen shot for same.



The Event Viewer Details for the Error is -.NET Runtime 2.0 Error Reporting.
EventType clr20r3, P1 microsoft.dynamics.nav.client, P2 6.0.0.0, P3 4d030e65, P4 microsoft.dynamics.nav.client.ui, P5 6.0.0.0, P6 4d030e5c, P7 74e, P8 69, P9 k0r55xemoobpb22dbjzdn4p0sfjo3u25, P10 NIL.

Below is the error message for same.


Generally these issues comes due to issues in Role Center Pages in Navision 2009 and later. You can filter objects by using filter @*Role* in Pages. Below is the List of Pages in NAV 2009 SP1 IN Database.



Case 1 - When the values in cues is negative. Then due to having a negative value in integer field crashes the client. These tables can be found by filtering tables in NAV 2009 & later by @*cue*. Below is the List of Tables in NAV 2009 SP1 IN Database.



Most of the fields in these tables are flowfield, if by anycase the value comes to be Negative the RTC Client Crashes.

Case 2 - A wired cases i found out that Notes(a system part in RTC Pages) have not been supported in NAV 2009 R2 FI version. Every Role Center Page have generally this part.


THERE CAN BE OTHER CASES WHICH YOU MIGHT ENCOUNTER DURING USING RTC.

How to find the cause of the crashing?

Start the Role Tailored Client and start debugger, by selecting the Debug the Program.

For Case 1 - When you start Debugging, it will break at a point where you will find an error as shown in screen below.



The error message says that Argument must be non-negative so it means that the cue of role center page that is loading have a negative value. You can go the tables list provided above, run them and check where its getting a negative value.


For Case 2 - When you start Debugging, it will break at a point where you will find an error as shown in screen below.



The error message says that Form My Notification Must Close so it means that the system is unable to load the Notes part of the page. You can design the page and delete the Notes Part from Role center pages.

The point where debugger stops shows the exact error.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

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
http://saurav-nav.blogspot.com/

Wednesday, June 6, 2012

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
http://saurav-nav.blogspot.in/

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.

Reason-

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.

Resoultion-

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);
OR
ExcelBuffer.AddColumn((''''+ "No."),False,False,False,False,'');

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/