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

  • Question

  • 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

  • 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
  • Hi David,


    Thnx for reply,



    Mohammad Sharique

    Tuesday, November 29, 2011 6:52 AM