IBM Support

Drillthrough from PowerPlay to Dynamic Query report fails intermittently with QFS-ERR-0141

Troubleshooting


Problem

The user has a PowerPlay cube which drills through to a DQM report. There are two dispatchers, one is 32-bit, the other is 64-bi

Cause

Advanced routing rules have no been configured correctly on the server. This causes an intermittent problem when routed round robin the dispatcher has a 50/50 chance of choosing the correct dispatcher for the report.

PowerPlay only supports 32bit mode, DQM supports 32bit and 64bit to allow improved performance.

Resolving The Problem

Routing rules can be configured using the following documentation:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_specifyadvanceddispatcherrouting.html

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0.9;11.0.8;11.0.7;11.0.6","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22014369