"QE-DEF-0288 - Unable to find the data source 'IBMDADB2.DB2COPY1:servername:TCPport:..." when running standard reports, if TCP port is specified
User runs standard report. User receives error message.
There are many potential causes for this error.
- TIP: For more scenarios, see separate IBM Technote #1652954.
This IBM Technote specifically relates to the scenario where the cause is a known limitation (APAR PM80822) of Controller when using DB2 and manually specifying the TCP port.
Inside "Controller Configuration" the "Database Connection" contains the TCP port (e.g. 50000) inside the section "Location":
Resolving the problem
Upgrade to Controller 10.2 or later.
Manually rename the data source inside Cognos Connection.
1. Launch Cognos Connection (http://servername/ibmcognos)
2. Navigate to "Administer IBM Cognos content" - "Configuration"
3. Click on "Data Source Connections"