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.