Technote (troubleshooting)
Problem(Abstract)
User runs standard report. User receives error message.
Symptom
QE-DEF-0288
Unable to find the data source 'IBMDADB2.DB2COPY1:servername:TCPport:DATABASECONNECTION:username' in the content store
Cause
Known limitation (APAR PM80822) of Controller when using DB2 and manually specifying the TCP port.
Environment
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.
Steps:
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:
-
IBMDADB2.DB2COPY1:VBRACONTDB2
:50000:RCTST04A:fastnet
Related information
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.