IBM Support

Does Modeler support reading Cognos Packages which are Dynamic Query Mode?

Technote (troubleshooting)


Cannot connect using the Cognos source node in Modeler to Cognos TM1 package to import data. Connecting to a package of type 'Compatible Query Mode' is successful.


When attempting to connect to Cognos TM1 pkg to import data, get's the following error:

Modeler 15.
error received: DPR-ERR-2014 Unable to load balance the request
because no nodes in the cluster are available, or no nodes are
configured for the service

Modeler 16 and higher:

Could not get metadata from selected package.

Or sometimes you will see this error:

<Error id="kCOGNOS_GetMetadata_Failed">

<Param>XQE-V5-0001 V5 syntax error(s) found:

Encountered "*" at line 1, column 10.

Was expecting:




The Cognos BI source node can only connect to the Cognos server using Compatible Query Mode(CQM). It cannot pull from a TM1 package that is set to Dynamic Query Mode(DQM).


Windows 2008 R2

Diagnosing the problem

The Cognos admin can gather the 'Set Properties' of the package involved. Towards the bottom of this window will exist a heading 'Query Mode'. If the value for that is 'Dynamic'(DQM), the symptoms above will be presented. If Query Mode is Controlled,(CQM) then it will work.

Resolving the problem

Modeler doesn't support the reading of Cognos packages in Dynamic Query Mode (DQM).
There is an Enhancement Request already open for this: ECM00191215.

Note: Exporting in DQM mode is not supported either.

Related information

Need more help? Our Modeler forum is Live!

Document information

More support for: SPSS Modeler

Software version: 15.0, 16.0, 17.0, 17.1, 18.0

Operating system(s): Windows

Reference #: 1645793

Modified date: 29 April 2015

Translate this page: