IBM Support

"QE-DEF-0288 - Unable to find the data source 'IBMDADB2.DB2COPY1:servername:TCPport:..." when running standard reports, if TCP port is specified

Technote (troubleshooting)


User runs standard report. User receives error message.



Unable to find the data source 'IBMDADB2.DB2COPY1:servername:TCPport:DATABASECONNECTION:username' in the content store


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"

4. Locate the relevant data source, and click "Properties" button:

5. Inside the "Name" section, rename the item slightly so that it includes the TCP port, for example:

6. Test.

TIP: For more information on creating Data Sources, see separate IBM Technote #1997625.

Related information

APAR PM80822
1652954 - ** Troubleshooting ** "QE-DEF-0288 Unable to
1997625 - How to manually create a Cognos 'Data Source'

Document information

More support for: Cognos Controller

Software version: 10.1, 10.1.1

Operating system(s): Windows

Reference #: 1616157

Modified date: 23 January 2017

Translate this page: