locked
[CRM 4.0] SQL Transactional Publication for organization database RRS feed

  • Question

  • hi,

     

    I would like to replicate the organization database from SQL 2005 SP2 SRV01 to SQL SRV02 2005 SP2.

    If I configure juste the publication transactional, i have a crm issue on Event viewer. (the crm work correctly too ), and the issue appear every 30 second.

     

    Host PRODCRM: error while processing organization c5cf5dbe-8019-4622-8a9f-e357ac03321a. Exception: System.Data.SqlClient.SqlException: The target table 'AsyncOperationBase' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.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.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command)
       at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
       at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)

    For more information, see Help and Support Center at

     

    and after,

     

    Host PRODCRM: recovered from error processing organization c5cf5dbe-8019-4622-8a9f-e357ac03321a.

     

     

    Any idea ?

     

    Thanks

    Wednesday, October 29, 2008 8:36 AM