Dynamics CRM 2013 throws SQL Timeout adding a user to a team -
i have simple tough problem.
i trying add user team through user interface, i'm getting sql time out users.
i got no plugins firing on association request. did not find familiarity between ones getting error.
i have turned trace log on did not give me more details.
following error log generated tracing tool.
web service plug-in failed in sdkmessageprocessingstepid: {d3de2f15-53fa-4a12-a286-346cc4bfd310}; entityname: none; stage: 30; messagename: associate; assemblyname: microsoft.crm.extensibility.internaloperationplugin, microsoft.crm.objectmodel, version=6.0.0.0, culture=neutral, publickeytoken=31bf3856ad364e35; classname: microsoft.crm.extensibility.internaloperationplugin; exception: unhandled exception: system.reflection.targetinvocationexception: exception has been thrown target of invocation. @ system.runtimemethodhandle.invokemethod(object target, object[] arguments, signature sig, boolean constructor) @ system.reflection.runtimemethodinfo.unsafeinvokeinternal(object obj, object[] parameters, object[] arguments) @ system.reflection.runtimemethodinfo.invoke(object obj, bindingflags invokeattr, binder binder, object[] parameters, cultureinfo culture) @ system.web.services.protocols.logicalmethodinfo.invoke(object target, object[] values) @ microsoft.crm.extensibility.internaloperationplugin.execute(iserviceprovider serviceprovider) @ microsoft.crm.extensibility.v5pluginproxystep.executeinternal(pipelineexecutioncontext context) @ microsoft.crm.extensibility.versionedpluginproxystepbase.execute(pipelineexecutioncontext context) inner exception: microsoft.crm.crmexception: sql timeout expired. @ microsoft.crm.extensibility.versionedpluginproxystepbase.execute(pipelineexecutioncontext context) @ microsoft.crm.extensibility.pipeline.execute(pipelineexecutioncontext context) @ microsoft.crm.extensibility.messageprocessor.execute(pipelineexecutioncontext context) @ microsoft.crm.extensibility.internalmessagedispatcher.execute(pipelineexecutioncontext context) @ microsoft.crm.extensibility.manytomanyforwardentityassociationcommand.associateentities(entityreference entity1, entityreference entity2, string relationshipname, boolean associate, executioncontext context) @ microsoft.crm.extensibility.manytomanyforwardentityassociationcommand.execute(relationshipprocessor processor, entitymetadata entitymetadata, guid entityid, entityreferencecollection relatedentities, boolean associate, executioncontext context) @ microsoft.crm.extensibility.relationshipprocessor.processassociation(entitymetadata entitymetadata, guid entityid, relationship relationship, entityreferencecollection relatedentities, boolean associate, executioncontext context) @ microsoft.crm.extensibility.relationshipprocessor.associate(entityreference entityreference, relationship relationship, entityreferencecollection relatedentities, executioncontext context) inner exception: microsoft.crm.crmexception: sql timeout expired. inner exception: system.data.sqlclient.sqlexception: timeout expired. timeout period elapsed prior completion of operation or server not responding. @ system.data.sqlclient.sqlconnection.onerror(sqlexception exception, boolean breakconnection, action`1 wrapcloseinaction) @ system.data.sqlclient.tdsparser.throwexceptionandwarning(tdsparserstateobject stateobj, boolean callerhasconnectionlock, boolean asyncclose) @ system.data.sqlclient.tdsparser.tryrun(runbehavior runbehavior, sqlcommand cmdhandler, sqldatareader datastream, bulkcopysimpleresultset bulkcopyhandler, tdsparserstateobject stateobj, boolean& dataready) @ system.data.sqlclient.sqlcommand.finishexecutereader(sqldatareader ds, runbehavior runbehavior, string resetoptionsstring) @ system.data.sqlclient.sqlcommand.runexecutereadertds(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, boolean async, int32 timeout, task& task, boolean asyncwrite, sqldatareader ds) @ system.data.sqlclient.sqlcommand.runexecutereader(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, string method, taskcompletionsource`1 completion, int32 timeout, task& task, boolean asyncwrite) @ system.data.sqlclient.sqlcommand.internalexecutenonquery(taskcompletionsource`1 completion, string methodname, boolean sendtopipe, int32 timeout, boolean asyncwrite) @ system.data.sqlclient.sqlcommand.executenonquery() @ microsoft.crm.objectmodel.businessmanagementutility.locksystemuserentriesforteammembershipchange(guid userid, executioncontext context) @ microsoft.crm.objectmodel.teammembershipserviceinternal`1.associate(businessentitymoniker entityonemoniker, businessentitymoniker entitytwomoniker, string associationrelationshipname, executioncontext context) @ microsoft.crm.businessentities.businessprocessobject.handleassociationoperation(businessentitymoniker entityonemoniker, businessentitymoniker entitytwomoniker, string associationrelationshipname, boolean createassociation, executioncontext context) @ microsoft.crm.businessentities.businessprocessobject.associateentities(businessentitymoniker entityonemoniker, businessentitymoniker entitytwomoniker, string associationrelationshipname, executioncontext context) inner exception: system.componentmodel.win32exception: wait operation timed out
Comments
Post a Comment