Troubleshooting
Problem
Customer receives an error when running a Standard Report, indicating that the data source has not been created. Customer attempts to solve this problem by using 'Controller Configuration - Report Server'. Unfortunately this 'automatic' method fails (with an error). How can the customer create the missing data sources, without using the 'Controller Configuration' method?
Symptom
Customer gets error inside Controller Configuration, when trying to use the 'Test' or 'Repair' button..
- For example, see separate IBM Technote #1655518
Resolving The Problem
The instructions will vary slightly depending on the environment (version of Controller, and if using SQL/Oracle/DB2).
- Therefore, the following instructions may need to be changed slightly for your environment.
1. Launch Cognos Connection (URL: //servername/ibmcognos)
2. Navigate to "Administer IBM Cognos content" - "Configuration"
3. Click on "Data Source Connections":
- Notice how you may have some existing database connections listed in there, for example:
4. Near the top-right, click "New Data Source":
5. Inside the "Name" section type in a value similar to the following:
SQLNCLI.1:mysqlservername:my_database_name:fastnet
NOTE:
- If using Oracle, replace 'SQLNCLI.1' with: OraOLEDB.Oracle.1
6. Click "Next"
7. Choose the appropriate type (for example "Microsoft SQL Server (SQL 2008 Native Client)")
8. Untick the box "Configure JDBC connection" and click "Next"
9. Configure the relevant details, for example:
10. Click "Test the connection" and ensure that it works OK
11. Click "Finish".
Related Information
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3;10.2.1;10.2.0;10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21997625