IBM Support

Retrieving data in Notebook fails with QF-888

Troubleshooting


Problem

Retrieving data in Jupyter Notebooks in Cognos Analytics fails with
Exception: Error details:
---------------------------------------------
{"errors":[{"code":"QF-888","message":"-0008 Query contains unresolved parameter(s).","parameters":[{"name":"p_name","value":{"dataType":"xsdString","modelFilterItem":"[Namespace].[Query Subject].[Query item]","modelPath":null,"modulePath":null,"caption":"","parameterName":"p_name","promptType":"","capabilities":{"optional":false,"discreteValue":true,"multivalued":false,"unboundedRange":false,"boundRange":false}}}]}]}

Symptom

Exception: Error details:
{
	"errors": [
		{
			"code": "QF-888",
			"message": "-0008 Query contains unresolved parameter(s).",
			"parameters": [
				{
					"name": "p_name",
					"value": {
						"dataType": "xsdString",
						"modelFilterItem": "[Namespace].[Query Subject].[Query item]",
						"modelPath": null,
						"modulePath": null,
						"caption": "",
						"parameterName": "p_name",
						"promptType": "",
						"capabilities": {
							"optional": false,
							"discreteValue": true,
							"multivalued": false,
							"unboundedRange": false,
							"boundRange": false
						}
					}
				}
			]
		}
	]
}

 

Cause

Data source requires user input, which is not supported in Jupyter Notebooks.

Environment

IBM Cognos Analytics 11.1.x

Resolving The Problem

  1. Confirm the data source requires user input, by using the source in Authoring. User input can be any prompt or filter, that might be required to retrieve the data
  2. Locate the query subject in the data source, i.e. in Framework Manager and remove the parameterized filter.
  3. An alternative is to create a data set on top of the data source, which will handle the prompting.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 November 2021

UID

ibm15690589

Page Feedback