When running the Find & Reserve Data Model, the find fails with a 500 error: WCM-SIT-3 - Connection is not available, request timed out after 10000ms. However, testing the Connection Profile from the configuration page works fine.
Since there is no way to remove a connection profile from an Environment in Portal, we created a new Project and Environment to test only the necessary Connection Profile (WCM - SIT-3), we were able to create the Find & Reserve model and retrieve data.
The problem is due to the "WEALTH_WOT" connection profile, which is not needed for this particular environment that has been defined in Portal.
TDM Portal 126.96.36.199
The user account name: wot_tdm_lead
Project name: Wealth_Client_Master [WCM - SIT 3].
The Connection Profiles configuration page for Portal shows only 3 Connection Profiles defined for this user/project:
DB2 SI0T (DBMS DB2)
WCM - DEV (DBMS Oracle)
WCM - SIT-3 (DBMS Oracle)
The WCM-SIT environment has two Data Sources:
Engineering reviewed the case and they determined that the best way to resolve the issue is to delete the Environment from Portal and recreate it. They said it is too risky to try hacking the database to delete the problematic connection profile.