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

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -