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

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  Fatal Error MODULMSG ; Job execution  Failed to connect on local database - connection profile may be badly configured    anaman\amexecute.cpp

1. Package and deliver the source code
2. Accept the delivery, set as the current version, and launch the analysis

3. 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

1. 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
2. Search for the error message: 

   Failed to connect on local database - connection profile may be badly configured 

3. 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 with relevant input

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.

Ticket # 34650