Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\OrganizationName_MSCRM.mdf'. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    I am trying to import CRM 4.0 organization on another  CRM 4.0 Sever, it giving error in log file :

     

     

    Info| Update Organization...
    21:02:35|  Error| Import Organization (Name=OrganizationName, Id=b7ced50f-7e19-e111-b006-080027dfc2fd) failed with Exception:
    System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xf918e383; actual: 0x7948e383). It occurred during a read of page (1:65670) in database ID 9 at offset 0x0000002010c000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\OrganizationName_MSCRM.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.Tools.Admin.DBImportHelper.UpdateOrganizationReferences(IDbCommand command, Guid newOrganizationId, String newFriendlyName)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName, String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)
    21:02:35|Warning| Attempting to cancel a long running process: ProgressWizard. This might leave the data in an invalid state and the application might not function correctly.

     

     

    Plz any body can help me.

    Thanks In Advance

    Mohammad Sharique

    Monday, November 28, 2011 6:24 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    It looks like the SQL database file is corrupt, or it may have come from a newer version of SQL Server. How did copy the MSCRM database that you're trying to import ?

    The first thing I'd do is to try recopying the database and trying again. Otherwise, this is more a SQL Server issue than a CRM one. In this case the first thing I'd do in SQL is run the DBCC CHECKDB command against the database, and see what it reports

     

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Monday, November 28, 2011 12:18 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi David,

     

    Thnx for reply,

     

    Regard

    Mohammad Sharique

    Tuesday, November 29, 2011 6:52 AM