Does Modeler support reading Cognos packages in Dynamic Query Mode?

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

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.

Could not get metadata from selected package.


Cause

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).


Environment

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

Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Modeler
Modeler

Software version:

15.0, 16.0

Operating system(s):

Windows

Reference #:

1645793

Modified date:

2014-08-27

Translate my page

Machine Translation

Content navigation