CMS Snapshot Analysis - Run Analyzer - Fatal Error - Failed to connect on local database - connection profile may be badly configured

Description

While executing Run analysis, the process fails with the below fatal error at “Run Analysis on the current analysis unit’s group”

2022-02-24 09:53:12.608226 Fatal Error MODULMSG ; Job execution Failed to connect on local database - connection profile may be badly configured anaman\amexecute.cpp

Observed in CAST AIP

Release	Yes/No
8.3.x	✅

Observed on RDBMS

RDBMS	Yes/No
CSS3	✅
CSS4	✅

Step by Step Scenario

Package and deliver the source code
Accept the delivery, set as the current version, and launch the analysis
While executing Run analysis, the process fails with the below fatal error at “Run Analysis on the current analysis unit’s group”
2022-02-24 09:53:12.436354 Information MODULMSG ; Job execution Connection Profiles read from ‘C:\ProgramData\CAST\CAST\8.3\CWProfileConnection.INI’.
2022-02-24 09:53:12.608226 Information MODULMSG ; Job execution Connection profile “hostname:port on CastStorageService.schema_name_local” not found
2022-02-24 09:53:12.608226 FatalError MODULMSG ; Job execution Failed to connect on local database - connection profile may be badly configured anaman\amexecute.cpp

Action Plan

Open the log for the step “Run Analysis on the current analysis unit’s group” where the Run analysis fails: e.g AUTO-UA-SQL_44895-20220224-095248.castlog
Search for the error message:
Failed to connect on local database - connection profile may be badly configured
Check whether the following lines appear in the log file :

2022-02-24 09:53:12.436354 Information MODULMSG ; Job execution Connection Profiles read from ‘C:\ProgramData\CAST\CAST\8.3\CWProfileConnection.INI’. 2022-02-24 09:53:12.608226 Information MODULMSG ; Job execution Connection profile “hostname:port on CastStorageService.schema_name_local” not found 2022-02-24 09:53:12.608226 FatalError MODULMSG ; Job execution Failed to connect on local database - connection profile may be badly configured anaman\amexecute.cpp

4. If you are running an AIP console, then:

   1. Stop AIP Console
   2. Stop AIP  node
   3. Make sure all CAST processes are no longer running
   4. Edit file   <Cast AIP installation folder>\8.3\CWProfileConnection.INI
   5. The issue occurs here due to the corruption of this file or if we have duplicated (and incomplete)entries in  <Cast AIP installation folder>\8.3\CWProfileConnection.INI,
   6. Remove the duplicate entries and incomplete lines.
5. Retry  from CAST-MS and see if the AU analysis now works.
6. If so, restart the node and console and see if it works now in the console fine
7. If the above points do not help you to resolve the issue, contact [CAST Technical Support](https://help.castsoftware.com/hc/en-us/articles/204189137-How-to-contact-CAST-Technical-Support) with [relevant input](/export-v2/tg/technical-guides/technical-guides-by-cast-aip-component/cms-snapshot-analysis-component/cms-snapshot-analysis-run-analyzer/cms-snapshot-analysis-run-analyzer-fatal-error/)

**Impact on Analysis Results and Dashboard**

Impact of issue: While executing Run analysis, the process fails with a below fatal error at "Run Analysis on the current analysis unit's group"

2022-02-24 09:53:12.436354  Information  MODULMSG ; Job execution Connection Profiles read from 'C:\ProgramData\CAST\CAST\8.3\CWProfileConnection.INI'.  
2022-02-24 09:53:12.608226 Information MODULMSG ; Job execution Connection profile "hostname:port on CastStorageService.schema\_name\_local" not found

2022-02-24 09:53:12.608226  FatalError MODULMSG ; Job execution  Failed to connect on local database - connection profile may be badly configured    anaman\amexecute.cpp

Impact after applying solution: Analysis runs fine.

**Notes/comments**

Ticket # 34650

**Related Pages**