IBM Support

"QE-DEF-0288 Unable to find the data source 'SQLNCLI11.1:servername:databasename:sqllogin' in the content store" running standard report, caused by permissions on the data source

Troubleshooting


Problem

User runs a standard report. An error appears.

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 message.
  • TIP: See separate IBM Technote #1652954 for more examples.
 

This Technote specifically relates to the scenario where the cause is that the Cognos Analytics (Cognos BI) permissions are too restrictive on the data source, so that the user cannot utilise it.

More Information:

By default, the permissions for the data source have the group 'Everyone' has Read/Execute/Traverse permissions:


 

Example #1:

In one real-life customer example, the relevant Controller user group ("Controller Users") only had 'Traverse' permissions:


 

Example #2:

In a different real-life customer example, the user group that they were using to control access with ("Everyone") did not have 'Execute' permissions:

image-20200224082211-1

Resolving The Problem

Ensure that all Controller users have the following permissions for the relevant Data Source:
  • Read
  • Execute
  • Traverse

 

Steps:

There are many different methods to achieve the above. Below are two examples.

 

Example #1

Give the relevant Controller user group (by default this is called "Controller Users") Read, Execute and Traverse permissions.

1. Launch the 'Cognos Connection' website, then open 'Cognos Administration'

 

2. Click tab 'Configuration'

3. Ensure that 'Data Source Connections' is highlighted

4. To the right of your 'bad' data source connection (the one that is named inside the error message) click the 'Set properties' button

5. Click 'Permissions' tab

6. Tick the box 'Override access permissions for this entry'

7. Tick the box next to your user group (for example 'Controller Users')

8. Tick the 'Grant' boxes next to 'Read', 'Execute' and 'Traverse':



9. Click OK
10. Test.
 

Example #2

Give the relevant user group (in this case the group 'Everyone') Read, Execute and Traverse permissions, by performing steps similar to those described above, so (afterwards) the entry looks similar to:

image-20200224082602-2

[{"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.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 February 2020

UID

swg22014987

Page Feedback