locked
Upgrade to MSCRM 2011 RRS feed

  • Question

  • Hi, i have a CRM4.0 organization database (12 GB) and i need to imported to a CRM 2011 environment. While importing the orgnization , i  get the following error: "Deletion service failed to clean up remaining  soft deletion records" and the below log file:

    Deletion Service received exception System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'SubjectId', table 'dbname_MSCRM.dbo.DocumentIndex'; column does not allow nulls. UPDATE fails.

    The statement has been terminated.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

       at Microsoft.Crm.V4.SqlHelper.ExecuteNonQuery(String sqlCommand, CrmDbConnection connection, Boolean splitBatchSqlIntoPieces, Boolean swallowSQLException547)

       at Microsoft.Crm.V4.ReferencingEntity.RemoveLink(CrmDbConnection connection, String extensionTableName, Boolean isCustomAttribute, String referencingEntity, String referencingAttribute)

       at Microsoft.Crm.V4.ReferencingEntity.DeleteAll(CrmDbConnection connection, String referencingEntity, String referencingAttribute)

       at Microsoft.Crm.V4.ReferencingEntity.DeleteAll(CrmDbConnection connection)

       at Microsoft.Crm.V4.TableEntity.DeleteAll(CrmDbConnection connection)

       at Microsoft.Crm.V4.DeletionService.DeleteAll(CrmDbConnection connection, List`1 tables)

       at Microsoft.Crm.V4.DeletionService.Run()

       at Microsoft.Crm.DataUpgrade.RemoveDscReferencesDriver.RunV4DeletionService()

    ClientConnectionId:e2f0f6d6-532a-471f-9976-8b28a07a80e2.

    Any help can be appreciated. Thanks in advance.

    Thursday, September 26, 2013 10:04 AM

All replies

  • Hi,

    Have you Run any query's on Your Database........???

    Restore the data base again and run the following query on your database.

    http://support.microsoft.com/kb/968520 To delete asynchronous records from DataBase

    And check weather their is any SQL Triggers and work flows are running.  

    Thank's


    Vinay Kumar.


    Thursday, September 26, 2013 2:53 PM