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
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"