The below are the environment details:
Operating System: RHEL 5.5 64bit
IBM tools: ITNM 3.9, DB2 9.7, ITM agent for ITNM
Oracle 11g is used for TDW.
My issue is when I am trying to configure NCPOLLDATA datasource for Cognos, I am unable to make connection. I am getting below error code.
QE-DEF-0285 The logon failed
I have installed and configured ITM agent for ITNM as it is required for Performance Reports. KNP_POLL_DATA_COLLECTION table is created in TDW and I am able to view data in it. When I am trying to configure NCPOLLDATA datasource to TDW which is on Oracle, I am getting this error. However I successfully configured NCPOLLDATA datasource for ITNM BIRT based reports using below command.
trcmd.sh -modify -dataSources -reports -reportName "/content/package[@name='Network Manager']/folder[@name='Performance Reports']/report[@name='Device Availability Summarization']" -username tipadmin -password tipadmin -dataSource name=NCPOLLDATA -setDatasource odaURL= "jdbc:oracle:thin:@tivolibocodb01:1532:TIVOPROD" odaDriverClass= "oracle.jdbc.driver.OracleDriver" odaUser=xxxx odaPassword=xxxx
Kindly find the attachment along with this post for detailed information.
Any help in this regard is really appreciated.