Qe-def-0288 Error In Cognos
Contents |
'sqlncli.1:servername:databasename:sqllogin' in the content store" when running Standard Reports Technote (troubleshooting) Problem(Abstract) User qe-def-0288 cognos 10 runs a standard report (also known as 'system report'). User
Unable To Find The Data Source 'url_xml' In The Content Store.
receives an error. Symptom IBM Cognos software QE-DEF-0288 Unable to find the data source 'sqlncli.1:servername:databasename:sqllogin' in qe def 0286 unable to find the connection in the content store 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 Document information More support for: Cognos Controller Controller Software version:
the content store QE-DEF-0314 An error occurred while calling the content store for the databases: '< databasename> ' information CCL-RCI-0005 Content Manager is looking for a trusted request CM-REQ-4011 You do not have permission to access the object " /Directory/Cognos/< databasename> /< databasename> " . RSV-DR-0002 Unable to execute this request. Technote (troubleshooting) Problem(Abstract) One or more users that are not part of the system administrators group receive http://www-01.ibm.com/support/docview.wss?uid=swg21652954 an error when trying to run reports or queries. QE-DEF-0288 Unable to find the database Data Source Name in the content store. Resolving the problem Add the data source in Cognos Connection if it does not exist. Ensure that the user has the proper permissions: Execute and Traverse on the data source itself http://www-01.ibm.com/support/docview.wss?uid=swg21339843 Execute and Traverse on the Cognos namespace Steps:1. Open Cognos Connection. 2. Under Tools, click Directory. 3. Click the Data Sources tab. 4. If your data source is not listed, you will have to create it. Otherwise: 5. Click Set Properties beside the data source, then click the Permissions tab. 7. Ensure that the affected users have Execute and Traverse permissions, and click OK. 8. Click the Users, Groups, and Roles tab at the top of the Directory page. 9. Click the Set Properties icon for the Cognos namespace, and then click the Permissions tab. 10. Ensure that the affected users have Execute and Traverse permissions, and click OK. Cross Reference information Segment Product Component Platform Version Edition Business Analytics Cognos 8 Business Intelligence Analysis Studio Business Analytics Cognos 8 Business Intelligence Cognos Connection Business Analytics Cognos 8 Business Intelligence Framework Manager Business Analytics Cognos 8 Business Intelligence Install and Config Business Analytics Cognos 8 Business Inte
(troubleshooting) Problem(Abstract) Reports http://www.ibm.com/support/docview.wss?uid=swg21644617 with Data Source prompts run correctly, but fail http://www-01.ibm.com/support/docview.wss?uid=swg21341402 with the below error when validating. QE-DEF-0288 Unable to find the data source 'testValue' in the content store, when validating a report. Cause There is a macro prompt in the data source defined in unable to the Framework Manager model that does not have a default value. Resolving the problem In the Framework Manager model: 1.) Open the "Data Sources" entry 2.) Find the data source(s) that uses a macro prompt to dynamically select the data source at run-time unable to find 3.) Add a default value for the "Content Manager Data Source" field. The default value must be a configured data source name. This will need to be added for each data source with a macro prompt in this field #prompt('DATABASE','token')# would need to be changed so something like: #prompt('DATABASE','token','Audit')# It may be necessary to have different names for the first value in the macro prompts if multiple data sources use these prompts. Document information More support for: Cognos Business Intelligence Software version: 10.1.1, 10.2, 10.2.1 Operating system(s): AIX, HP-UX, Linux, Solaris, Windows Reference #: 1644617 Modified date: 12 September 2014 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
in the content store. Technote (troubleshooting) Problem(Abstract) Unable to verify a model in Framework Manager Symptom Reference Object ID: [].[dataSources].[data source name] [Error] - BMT-MD-2036 The following error occurred while testing the integrity of the object: QE-DEF-0288 Unable to find the data source 'data source name' in the content store. There is no repair action available. Cause The data source is disabled in Cognos Connection. Resolving the problem Enable the data source that is being tested in Framework Manager model. Steps:1. Go to data sources tab in Cognos Connection under Tools, Directory. 2. There will be an icon beside the data source name indicating that is disabled. 3. Select the properties of the data source and uncheck the check box labelled "Disable this entry" under the "General" tab . 4. Click on Okay to save the changes. 5. Retest in Framework Manager. Related information Historical Number 1029020 Document information More support for: Cognos 8 Business Intelligence Framework Manager Software version: 8.1 Operating system(s): Windows Reference #: 1341402 Modified date: 15 April 2008 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility