Skip to main content

Posts

Showing posts from July, 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/

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" fa

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 a