000017228 - Jobs are not running. Unable to save Instance database information. - RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000017228
Applies ToRSA Archer
IssueJobs are not working. Unable to save Instance database information.
JobFramework log file errors:
There was an unexpected problem while connecting to the queue.
Exception has been thrown by the target of an invocation.
Keyword not supported.

<ApplicationData>
  <TraceData>
    <DataItem>
      <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
        <TraceIdentifier>ArcherTech.JobFramework</TraceIdentifier>
        <Description>Abort Error</Description>
        <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain>
        <Exception>
          <ExceptionType>System.Configuration.Provider.ProviderException, System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</ExceptionType>
          <Message>There was an unexpected problem while connecting to the queue.</Message>
          <Source>ArcherTech.JobFramework.SqlServerPlugins</Source>
          <StackTrace>   at ArcherTech.JobFramework.SqlServerPlugins.SqlServerJobQueueHelper.DeadlockRetry(Delegate target, Object[] parameters, DeadlockRetryWaitIntervalType waitIntervalType)
    at ArcherTech.JobFramework.Job.JobRunner.OnWorkflowAborted(Object sender, WorkflowEventArgs e)</StackTrace>
          <InnerException>
            <ExceptionType>System.Reflection.TargetInvocationException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
            <Message>Exception has been thrown by the target of an invocation.</Message>
            <Source>mscorlib</Source>
            <StackTrace>   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
    at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at ArcherTech.JobFramework.SqlServerPlugins.SqlServerJobQueueHelper.DeadlockRetry(Delegate target, Object[] parameters, DeadlockRetryWaitIntervalType waitIntervalType)</StackTrace>
            <InnerException>
              <ExceptionType>System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
              <Message>Keyword not supported: 'fggbh6wc+5uftid+ymt9ik2/be5ovyjxgqxxmmk/yv2bb27tk5grm9mmh1ok17opnanjmisigthlnbghebamjcadpl/1xoaef245lhj4joa6tnvjbwjegmefx6arkny2mcos8omsjriz/g8wxehlpg=;application name'.</Message>
              <Source>System.Data</Source>
              <StackTrace>   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
    at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
    at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions&amp; userConnectionOptions)
    at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
    at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
    at Microsoft.Practices.EnterpriseLibrary.Data.Database.CreateConnection()
    at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
    at Microsoft.Practices.EnterpriseLibrary.Data.TransactionScopeConnections.GetConnection(Database db)
    at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection(Boolean disposeInnerConnection)
    at Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command)
    at Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database)
    at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues)
    at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(String storedProcedureName, Object[] parameterValues)
    at ArcherTech.JobFramework.SqlServerPlugins.DistributedSqlServerRunningJobs.CompleteRunningJobInternal(JobDescription job)</StackTrace>
            </InnerException>
          </InnerException>
        </Exception>
      </TraceRecord>
    </DataItem>
  </TraceData>
</ApplicationData>
 
CauseThe connection string information for the Instance database is corrupt in the Configuration database.
 
Resolution

To resolve this issue:


1.  Close the Archer Control Panel (ACP) on all servers.
2.  Perform a SQL Backup of the Configuration database in case a restore is needed.
3.  Run the following SQL commands to clear the connection string from the Configuration database.
            delete tblXPropertyTag where property_id in(select property_id from tblproperty where property_key='ConnectionString')
            delete tblProperty where property_key='ConnectionString'
4.  Reopen the ACP and open the Instance settings.
5.  Re-enter the Instance database information on the Database tab.
6.  Save changes.
7.  Restart the Archer services.
8.  Confirm the Job Engine Manager is processing jobs.

Legacy Article IDa64729

Attachments

    Outcomes