IBM Support

PDS-RM-0009 error when opening Remote Cube reports with PowerPlay Client

Troubleshooting


Problem

Powerclient shows the following error when editing reports of a remote cube:
PDS-RM-0009 The cube is not available, or the cube has been disabled. Package = <PACKAGE NAME>. Saving the report(s) or reconnecting to the cube may result in losing your last few actions
image 2362
Error is not displayed when editing the reports from a local cube.

Cause

Problem with the network connection.

Environment

Cognos Analytics 11

Resolving The Problem

Increase the idle time out value in the powerplayservice.xml file to a value large enough for the report to complete running. 
<child-proc-cmd>idleTimeLimitSec=3600</child-proc-cmd>
Important note: Please ensure you take a backup copy of the XML file before making this modification.
Navigate to : IBM Cognos Administration -> Status -> System -> All Servers (dropdown) -> Services(dropdown) -> PowerPlay -> PowerPlayService(dropdown) -> Set Properties -> Settings Tab -> Advanced settings(edit)
and add the following parameter with values:
SRV.Options.MaxRestrictClientConnections (Value=IN,50)
SRV.Options.RestrictClientTimeout (Value=IN,60)
The SRV.Options.MaxRestrictClientConnections and SRV.Options.RestrictClientTimeout settings only come into play when a Port value is specified in the PPDSRemote section of the ppds_cfg.xml file (from the PowerPlay Client install).
 
Important note: This setup can be used in Firewall situations and the specified ports must be opened bi-directionally.
Steps to specify a port value:

1. Output to a file, netstat -a on the PowerPlay Client remote machine.

2. From <Powerplay Client install>\configuration\ppds_cfg.xml, edit the Port value (to an available port that is not being used in step 1).

i.e. 9600 in this example:

    <Section value="PPDSRemote">

      <Port value="9600"/>

      <NATTimeout value="-1"/>

    </Section>

Note: This restricts communication to the port specified, rather than use an OS-assigned port. This can be done only on a PowerPlay Client install. Do not change this port value on the server's ppds_cfg.xml as it would cause problems. On the server-side, it used for its local processes only, not inter-communication with the client.

3. If no concern of Firewall, you may skip to step 4.

On the PowerPlay server side, set PowerPlay Service advanced setting (configured via Cognos Administration on the portal) restricts the PowerPlay Dispatcher on the server (i.e. 9662).

SRV.PPDSRM.ServerPort  IN,9662

Note: Must be set to an available port on the server. Use a different value than port chosen from step 2 in the Client-side for clarity.

4. Launch PowerPlay Client and test to see if the issue occurs.

Note: Restricting the port on the Client means that there can only be one instance of PowerPlay Client running at a time on the client workstation.

5. If problem still occurs, from <Powerplay Client install>\configuration\ppds_cfg.xml, try Network Address Translation (NAT) feature by setting:

<NATTimeout value="0"/>

6. Re-start PowerPlay Client and re-test.

 

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 February 2020

UID

ibm13121857

Page Feedback