** Troubleshooting ** "QE-DEF-0288 Unable to find the data source 'sqlncli.1:servername:databasename:sqllogin' in the content store" when running Standard Reports

Technote (troubleshooting)


Problem(Abstract)

User runs a standard report (also known as 'system report'). User receives an error.

Symptom

IBM Cognos software

QE-DEF-0288
Unable to find the data source 'sqlncli.1:servername:databasename:sqllogin' in the content store.


Cause

There are several possible causes for this error:

  • Scenario #1 (most likely) - I.T. administrator has created a new 'database connection' but has forgotten to press the 'Repair' button (inside Controller Configuration) to create the required data source
  • Scenario #2 - Database connection settings contain too many characters (string is too long)
    • For more details, see separate IBM Technote #1424236.
  • Scenario #3 - Known limitation (APAR PM80822) of Controller when using DB2 and manually specifying the TCP port.

Resolving the problem

Fix:


Scenario #1
Click the 'Repair' button (inside Controller Configuration) to create the required data source.

    TIP:
    • For Controller 10.1 onwards, you need to click the green "tick" (check) box to make the 'Repair' button appear.
    • For full details, see IBM Technote #1367399 & 1345618.

Scenario #2
Modify the 'Database connection' settings to reduce the number characters (for example shorten the database or server name etc.)
  • For more details, see separate IBM Technote #1424236.

Scenario #3

Manually rename the data source inside Cognos Connection.

  • For more details, see separate IBM Technote #1616157.

Workaround:
Manually create the missing data source inside Cognos Connection.
  • TIP: For more details, see separate IBM Technote #1367399

Related information

1367399 - Error 'QE-DEF-0288 - Unable to find the data
1424236 - Unable to generate standard reports: "QE-DEF-
1616157 - "QE-DEF-0288 - Unable to find the data source

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Controller
Controller

Software version:

8.3, 8.4, 8.5, 8.5.1, 10.1, 10.1.1

Operating system(s):

Windows

Reference #:

1652954

Modified date:

2014-02-25

Translate my page

Machine Translation

Content navigation