Warehouse database is not populating

Symptom

Found the below error in Tivoli Enterprise Portal Server RAS1 log

(559D3A4C.0062-32:ctsqlhelper.cpp,626,"CTSQLHelper::fetchDatabaseProperties") dsnType = 'DB2', dsn = 'TDW1'.
(559D3A4C.0063-32:ctsqlhelperlocal.cpp,316,"CTSQLHelper::RequestLocator::doRequest") initialFetchSize = 2147483647.
(559D3A4C.0064-32:ctpropertysequence.cpp,738,"CTPropertySequence::Dump")---> name = queryType
(559D3A4C.0065-32:ctpropertysequence.cpp,738,"CTPropertySequence::Dump")-----> -1021 = "DB2"
(559D3A4C.0066-32:ctpropertysequence.cpp,738,"CTPropertySequence::Dump")-----> QUERY_TYPE = "CTSQL::Query"
(559D3A4C.0067-32:ctsqlaccessodbc.cpp,732,"CTSQLEvalODBC::AccessElement::AccessElement") Constructing AccessElement at 2B1B3024E030
(559D3A4C.0068-32:ctsqlaccessodbc.cpp,756,"CTSQLEvalODBC::AccessElement: :init") Initializing AccessElement at 2B1B3024E030
(559D3A4C.0069-32:ctsqlconnectionodbc.cpp,458,"CTSQLEvalODBC::Connection::Connection") Create 2B1B2E459010
(559D3A4C.006A-32:ctsqlconnectionodbc.cpp,476,"CTSQLEvalODBC::Connection::~Connection") Destroy 2B1B2E459010
(559D3A4C.006B-32:ctsqlaccessodbc.cpp,1035,"CTSQLEvalODBC::AccessElement::pullSequenceWithTimeout") accessElement = 2B1B3024E030, pos = 0, count = 2147483647, timeout = -1
(559D3A4C.006C-30:ctsqlconnectionodbc.cpp,297,"CTSQLEvalODBC::Connection::sqlErrorCheck") SQLAllocHandle ENV rc=0: SQL_SUCCESS
(559D3A4C.006D-30:ctsqlconnectionodbc.cpp,297,"CTSQLEvalODBC::Connection::sqlErrorCheck") SQLSetEnvAttr rc=0: SQL_SUCCESS
(559D3A4C.006E-30:ctsqlconnectionodbc.cpp,297,"CTSQLEvalODBC::Connection::sqlErrorCheck") SQLAllocHandle DBC rc=0: SQL_SUCCESS
(559D3A4C.006F-30:ctsqlconnectionodbc.cpp,148,"CTSQLEvalODBC::Connection::sqlErrorCheckMsg") [IBM][CLI Driver] CLI0150E  Driver not capable. SQLSTATE=HYC00, GENERIC SQLSTATE: HYC00, ERR: -99999 +559D3A4C.006F SQLSetConnectAttr - SQL_ATTR_CONNECTION_TIMEOUT rc=-1:SQL_ERROR
(559D3A4C.0070-30:ctsqlconnectionodbc.cpp,2006,"CTSQLEvalODBC::Connection::removeConnLimit") CONNECTION_LIMIT parm not found, connection string remaints the same.
(559D3A4C.0071-30:ctsqlconnectionodbc.cpp,635,"CTSQLEvalODBC::Connection::_init") Using SQLDriverConnect with 'TDW1'.
(559D3A4C.0072-30:ctsqlconnectionodbc.cpp,148,"CTSQLEvalODBC::Connection::sqlErrorCheckMsg") [IBM][CLI Driver] SQL30082N  Security processing failed with reason "3"("PASSWORD MISSING").  SQLSTATE=08001, GENERIC SQLSTATE: 08001, ERR:-30082 +559D3A4C.0072 SQLDriverConnect rc=-1: SQL_ERROR
(559D3A4C.0073-30:ctsqlconnectionodbc.cpp,178,"CTSQLEvalODBC::Connection::sqlErrorCheck") Taking down connection (1E37C290)
(559D3A4C.0074-30:ctpropertysequence.cpp,738,"CTPropertySequence::Dump") ---> name = SQL Exception: dsn = TDW1
(559D3A4C.0075-30:ctpropertysequence.cpp,738,"CTPropertySequence::Dump") -----> -2101a = -1 L
(559D3A4C.0076-30:ctpropertysequence.cpp,738,"CTPropertySequence::Dump") -----> -2102 = "[IBM][CLI Driver] SQL30082N  Security processing failed with reason "3" ("PASSWORD MISSING").  SQLSTATE=08001, GENERIC SQLSTATE: 08001, ERR: -30082 559D3A4C.0076 SQLDriverConnect rc=-1: SQL_ERROR"
(559D3A4C.0077-30:ctsqlconnectionodbc.cpp,1089,"CTSQLEvalODBC::Connection::describeDataSource") ERROR: unable to establish database connection to 'TDW1'