IBM Support

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

Troubleshooting


Problem

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 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:

<MA_IDENTIFIER>...</Param>

</Error>


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.

Note: Exporting in DQM mode is not supported either.

[{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Modeler","Platform":[{"code":"PF033","label":"Windows"}],"Version":"17.0;16.0;15.0;17.1;18.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21645793