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:
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
Could not get metadata from selected package.
Or sometimes you will see this error:
<Param>XQE-V5-0001 V5 syntax error(s) found:
Encountered "*" at line 1, column 10.
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