locked
MSCRM workflow throwing an error. RRS feed

  • Question

  • Hello All,

    i am getting the error in workflow.

    workflow is temporarily suspended.

    Workflow suspended temporarily due to error: Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail: 
    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
      <ErrorCode>-2147204784</ErrorCode>
      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>Generic SQL error.</Message>
      <Timestamp>2017-02-08T10:30:50.9149963Z</Timestamp>
      <InnerFault>
        <ErrorCode>-2147204784</ErrorCode>
        <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
        <Message>Generic SQL error.</Message>
        <Timestamp>2017-02-08T10:30:50.9149963Z</Timestamp>
        <InnerFault>
          <ErrorCode>-2147204784</ErrorCode>
          <ErrorDetails xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
          <Message>Generic SQL error.</Message>
          <Timestamp>2017-02-08T10:30:50.9149963Z</Timestamp>
          <InnerFault>
            <ErrorCode>-2147220970</ErrorCode>
            <ErrorDetails xmlns:d5p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
            <Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #72D8AF37</Message>
            <Timestamp>2017-02-08T10:30:50.915994Z</Timestamp>
            <InnerFault i:nil="true" />
            <TraceText>
    [Cardtronics.Opus.NCA: Cardtronics.Opus.NCA.NCACheck]
    [e05c4af8-3214-e611-818c-005056974dc5: Cardtronics.Opus.NCA.NCACheck: Update of any entity]
    Tracing Service Configured.
    Configuring base plugin, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Configured Plugin Name: NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Intialized registeredEvents collection, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Successfully configured base plugin for NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Entering Execute for plugin NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    New Tuple configured for Update of card_Contactdetails and card_document., Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Pre-Register Event, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Post-Register Event, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Done Registering updateATMContactEvent and updateDocumentcontactEvent., Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Plugin Event is firing for Entity: card_contactdetails, Message: Update 20, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    NCACheck is firing for Entity: card_contactdetails, Message: Update, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Pre-Check for InputParameter Target, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting InputParameter Target, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    atmContact atmContact iscard_contactdetails, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    atmcontact iscard_contactdetails, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting ssn, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting Field card_socialsecuritynumber, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Value from Target: , Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Checking for PreImage, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting card_socialsecuritynumber from PreImage, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Value from PreImage: XXX-XX-9990, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    card_socialsecuritynumber Value: XXX-XX-9990, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Value from Target: XXX-XX-9990, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Base Plugin Exiting firePluginRegisteredEvents for NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    </TraceText>
          </InnerFault>
          <TraceText i:nil="true" />
        </InnerFault>
        <TraceText i:nil="true" />
      </InnerFault>
      <TraceText>[Microsoft.Xrm.Sdk.Workflow: Microsoft.Xrm.Sdk.Workflow.Activities.UpdateEntity]
    [UpdateStep1]


    [Cardtronics.Opus.NCA: Cardtronics.Opus.NCA.NCACheck]
    [e05c4af8-3214-e611-818c-005056974dc5: Cardtronics.Opus.NCA.NCACheck: Update of any entity]
    Tracing Service Configured.
    Configuring base plugin, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Configured Plugin Name: NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Intialized registeredEvents collection, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Successfully configured base plugin for NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Entering Execute for plugin NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    New Tuple configured for Update of card_Contactdetails and card_document., Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Pre-Register Event, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Post-Register Event, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Done Registering updateATMContactEvent and updateDocumentcontactEvent., Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Plugin Event is firing for Entity: card_contactdetails, Message: Update 20, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    NCACheck is firing for Entity: card_contactdetails, Message: Update, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Pre-Check for InputParameter Target, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting InputParameter Target, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    atmContact atmContact iscard_contactdetails, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    atmcontact iscard_contactdetails, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting ssn, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting Field card_socialsecuritynumber, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Value from Target: , Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Checking for PreImage, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Getting card_socialsecuritynumber from PreImage, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Value from PreImage: XXX-XX-9990, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    card_socialsecuritynumber Value: XXX-XX-9990, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Value from Target: XXX-XX-9990, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    Base Plugin Exiting firePluginRegisteredEvents for NCACheck, Correlation Id: 2c231e81-aa86-4124-aebc-5f35bf048481, Initiating User: 5d2da0ca-5e7e-e211-98fa-0050568e7d89
    </TraceText>
    </OrganizationServiceFault>
       at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Update(Entity entity, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode)
       at Microsoft.Crm.Extensibility.InprocessServiceProxy.UpdateCore(Entity entity)
       at Microsoft.Crm.Workflow.Services.UpdateActivityService.<>c__DisplayClass1.<UpdateInternal>b__0(IOrganizationService sdkService)
       at Microsoft.Crm.Workflow.Services.ActivityServiceBase.ExecuteInTransactedContext(ActivityDelegate activityDelegate)
       at Microsoft.Crm.Workflow.Services.UpdateActivityService.UpdateInternal(Entity entity, String stepId)
       at Microsoft.Crm.Workflow.Services.UpdateActivityService.ExecuteInternal(ActivityContext executionContext, UpdateEntity updateEntity)
       at Microsoft.Crm.Workflow.Services.UpdateActivityService.Execute(ActivityContext executionContext, UpdateEntity updateEntity)
       at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
       at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

    what could be the reason behind this.

    Wednesday, February 8, 2017 10:42 AM

All replies

  • Also in the stacktrace getting below error.

    # CRM Tracing Version 2.0
    # LocalTime: 2016-11-14 01:55:08.725
    # Categories: *:Error
    # CallStackOn: No
    # CRMVersion: 6.1.0000.0581
    # DeploymentType: OnPremise
    # ScaleGroup: 
    # ServerRole: AppServer, AsyncService, DiscoveryService, ApiServer, HelpServer, DeploymentService, SandboxServer, DeploymentManagementTools, VssWriter, EmailConnector

    [2016-11-14 01:55:08.595] Process:CrmAsyncService |Organization:41fac041-85f6-4816-8c45-76c58421175b |Thread:   15 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId:  | DataAccessSharedBase.ExecuteSqlCommand  ilOffset = 0x7
    >ITXCQCCRM01.MSCRMAsyncService.302857ab-fcbb-45bc-aec6-8fb720f427ca: Exception while trying to open the database connection Workstation ID=ITXCQCCRM01.CrmAsyncService;Data Source=ITXCQCCRM01;Initial Catalog=Cardtronics_MSCRM_2011_PROD;Integrated Security=True;Min Pool Size=2;Connect Timeout=150;Application Name=MSCRMAsyncService : System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Cardtronics_MSCRM_2011_PROD" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
       at Microsoft.Crm.CrmDbConnection.Open()
       at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
    ClientConnectionId:ddae1a22-6990-486d-ba61-b8ad1f7ccf27
    [2016-11-14 01:55:08.725] Process:CrmAsyncService |Organization:41fac041-85f6-4816-8c45-76c58421175b |Thread:   38 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId:  | DataAccessSharedBase.ExecuteSqlCommand  ilOffset = 0x7
    >ITXCQCCRM01.MSCRMAsyncService.302857ab-fcbb-45bc-aec6-8fb720f427ca: Exception while trying to open the database connection Workstation ID=ITXCQCCRM01.CrmAsyncService;Data Source=ITXCQCCRM01;Initial Catalog=Cardtronics_MSCRM_2011_PROD;Integrated Security=True;Min Pool Size=2;Connect Timeout=150;Application Name=MSCRMAsyncService : System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Cardtronics_MSCRM_2011_PROD" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
       at Microsoft.Crm.CrmDbConnection.Open()
       at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
    ClientConnectionId:ddae1a22-6990-486d-ba61-b8ad1f7ccf27
    [2016-11-14 01:55:09.019] Process:CrmAsyncService |Organization:41fac041-85f6-4816-8c45-76c58421175b |Thread:   38 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId:  | DataAccessBase.ExecuteSqlCommandAndProcessRecords  ilOffset = 0x1F
    >ITXCQCCRM01.MSCRMAsyncService.302857ab-fcbb-45bc-aec6-8fb720f427ca: Exception while trying to open the database connection Workstation ID=ITXCQCCRM01.CrmAsyncService;Data Source=ITXCQCCRM01;Initial Catalog=Cardtronics_MSCRM_2011_PROD;Integrated Security=True;Min Pool Size=2;Connect Timeout=150;Application Name=MSCRMAsyncService : System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Cardtronics_MSCRM_2011_PROD" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
       at Microsoft.Crm.CrmDbConnection.Open()
       at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor, Guid inputOrganizationId)
    ClientConnectionId:ddae1a22-6990-486d-ba61-b8ad1f7ccf27
    [2016-11-14 01:55:09.687] Process:CrmAsyncService |Organization:41fac041-85f6-4816-8c45-76c58421175b |Thread:   30 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId:  | DataAccessSharedBase.ExecuteSqlCommand  ilOffset = 0x7
    >ITXCQCCRM01.MSCRMAsyncService.302857ab-fcbb-45bc-aec6-8fb720f427ca: Exception while trying to open the database connection Workstation ID=ITXCQCCRM01.CrmAsyncService;Data Source=ITXCQCCRM01;Initial Catalog=Cardtronics_MSCRM_2011_PROD;Integrated Security=True;Min Pool Size=2;Connect Timeout=150;Application Name=MSCRMAsyncService : System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Cardtronics_MSCRM_2011_PROD" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
       at Microsoft.Crm.CrmDbConnection.Open()
       at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
    ClientConnectionId:ddae1a22-6990-486d-ba61-b8ad1f7ccf27
    [2016-11-14 01:55:19.688] Process:CrmAsyncService |Organization:41fac041-85f6-4816-8c45-76c58421175b |Thread:   34 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId:  | DataAccessSharedBase.ExecuteSqlCommand  ilOffset = 0x7
    >ITXCQCCRM01.MSCRMAsyncService.302857ab-fcbb-45bc-aec6-8fb720f427ca: Exception while trying to open the database connection Workstation ID=ITXCQCCRM01.CrmAsyncService;Data Source=ITXCQCCRM01;Initial Catalog=Cardtronics_MSCRM_2011_PROD;Integrated Security=True;Min Pool Size=2;Connect Timeout=150;Application Name=MSCRMAsyncService : System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Cardtronics_MSCRM_2011_PROD" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
       at Microsoft.Crm.CrmDbConnection.Open()
       at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
    ClientConnectionId:ddae1a22-6990-486d-ba61-b8ad1f7ccf27

    Wednesday, February 8, 2017 10:54 AM
  • Is error coming only from Workflow or it is appearing even for CRM pages. From error message Cannot open database "Cardtronics_MSCRM_2011_PROD" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE' it looks like Server where Async services are installed are not able to make SQL Connection to SQL Server database.

    MaKeer

    Wednesday, February 8, 2017 7:01 PM