Error authenticating proxy: incorrect or locked-out credentials

Products

• Information Centric Analytics

Issue/Introduction

When running the Information Centric Analytics' (ICA) RiskFabric Processing job, RiskFabric Intraday Processing job, a RiskFabric_IW_DataSourceQueryID_<ID> job, or the Bay Dynamics AD Connector job, a job step fails and returns an error similar to the following:

Unable to start execution of step <step_id> (reason: Error authenticating proxy <domain\account>, system error: The user name or password is incorrect.).  The step failed.

 

Unable to start execution of step <step_id> (reason: Error authenticating proxy <domain\account>, system error: The referenced account is currently locked out and may not be logged on to.).  The step failed.

Environment

Release : 6.x

Component : RiskFabric Processing, RiskFabric Intraday Processing, Bay Dynamics AD Connector Job

Cause

The credentials provided for one of the proxy accounts used by RiskFabric are invalid. These proxies are:

• Operating System (CmdExec) > Bay Dynamics AD Connector Proxy
• Operating System (CmdExec) > RiskFabric Nightly Processing
• Analysis Services Command > RiskFabric Proxy

This error often follows a change or update to the ICA service account password in Active Directory (AD).

Resolution

If the service account is locked-out in AD, work with your AD administrator to unlock it.

If the account password has changed, follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. In Object Explorer, navigate to SQL Server Agent > Proxies
4. Navigate to the subfolder containing the proxy to be updated (refer to the paths provided in the Cause section of this article)
5. Right-click the proxy to be updated and select Properties
   The Proxy Account Properties window opens
6. In the Proxy Account Properties window, note the Credential name specified for the proxy
7. Click the Cancel button to close the Proxy Account Properties window
8. In Object Explorer, navigate to Security > Credentials
9. Right-click the credential identified in step 6 and select Properties
   The Credential Properties window opens
10. In the Credential Properties window, enter the new account password
11. Click the OK button

To update all instances of the service account password following a service account password reset or change, follow the procedures documented in the knowledgebase article Update ICA services credentials and data source credentials.