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/