Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

timeout filtering contacts in a marketing list

Posted on by 95

Hi,

when filtering contacts in a marketing list we get an execution timeout.
Does anyone have a solution.

Version: MS DYnaimcs 365 Version1612 (9.028.1) LOCAL

OrganizationServiceFault System.Data.DataException: Das Ausführungstimeout ist abgelaufen. Der Timeoutzeitraum wurde überschritten, bevor der Vorgang beendet wurde, oder der Server antwortet nicht.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: Das Ausführungstimeout ist abgelaufen. Der Timeoutzeitraum wurde überschritten, bevor der Vorgang beendet wurde, oder der Server antwortet nicht.
The statement has been terminated. ---> System.ComponentModel.Win32Exception: Der Wartevorgang wurde abgebrochen
--- Ende der internen Ausnahmestapelüberwachung ---
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
bei Microsoft.Crm.CrmDbConnection.<>c__DisplayClass107_0.b__0()
bei Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func)
bei Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)
bei Microsoft.Crm.ObjectModel.CommandExecution.StoredProcedureExecutionService.ExecuteNonQuery(CommandInfo storedProcInfo)
--- Ende der internen Ausnahmestapelüberwachung ---
bei Microsoft.Crm.ObjectModel.CommandExecution.StoredProcedureExecutionService.ExecuteNonQuery(CommandInfo storedProcInfo)
bei Microsoft.Dynamics.Marketing.Plugins.ListFetchService.ExecAddMembersProcV2(Guid listId, String memberLogicalName, IEnumerable`1 listMemberIds, IMarketingPluginContext`1 context)
bei Microsoft.Dynamics.Marketing.Plugins.ListFetchService.ExecAddMembersProc(Guid listId, String memberLogicalName, IEnumerable`1 listMemberIds, IMarketingPluginContext`1 context)
bei Microsoft.Dynamics.Marketing.Plugins.ListFetchService.AddListMembersUsingSproc(Guid listId, String memberLogicalName, List`1 listMemberIds, IMarketingPluginContext`1 context)
bei Microsoft.Dynamics.Marketing.Plugins.ListFetchService.AddListMembers(Guid listId, Guid[] memberIds, IMarketingPluginContext`1 context)
bei Microsoft.Dynamics.Marketing.Plugins.ListFetchService.InternalAddMembersByFetchXml(MarketingList list, String fetchXml, IMarketingPluginContext`1 context)
bei Microsoft.Dynamics.Marketing.Plugins.ListFetchService.AddMembersByFetchXml(MarketingList listEntity, String fetchXml, IMarketingPluginContext`1 context)
bei Microsoft.Dynamics.Marketing.Plugins.AddMembersByFetchXml.ExecuteCrmPlugin(IMarketingPluginContext`1 localContext)
bei Microsoft.Dynamics.Marketing.Plugins.MarketingPluginBase.Execute(IServiceProvider serviceProvider)

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
    RE: timeout filtering contacts in a marketing list

    Hello,

    According to the stack of the error, you posted here it's related to OOB plugins. I would recommend getting in touch with Microsoft and open a support ticket.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans