TDM Portal 4.7.0.14
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:
- WCM-SIT-3 (Connection Profile: WCM - SIT-3) Oracle DB
- WCM_ACC (Connection Profile: WEALTH_WOT) SQL SERVER DB
The TDMFindReserve.log only shows entries for the WEALTH_WOT connection profile, where the TDMConnectionProfileManager.log shows Connection Profile "WCM - SIT-3" is loading the oracle.jdbc.OracleDriver, and the "WEALTH_WOT" profile shows it is using the jdbc.SQLServer, and this is throwing an exception:
2019-04-29 09:37:42.294 UTC [ERROR] [find-reserve-sync ] --- [U:][M:][P:] c.c.t.f.d.s.SyncTask: Sync task for DataViewInstance{id=1ccfa510-e159-4f2d-9676-fc3884636b02, profileName='WEALTH_WOT', dataView=AbstractDataView{id=bf4cce29-2c40-43f5-a0d4-ad112a18f60e, profileName='WEALTH_WOT', projectId=2570, versionId=2571, sourceTable='SIT_WOT_Final', schema='null'}, createdAt=2018-10-04T20:04:40.333Z, updatedAt=2018-10-04T20:04:40.488Z, dataTableName='dvid_0b761ec7eea444028b97a8423', pendingDelete=false, schema='null'} failed
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'CLIENT_NUMBER'.
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.