getting error DPR-ERR-2056 when dragging to rows

[dxwallace]

Whenever I drag over a second dimension to the rows or columns of a crosstab after dragging a first dimension, the messge after that second dimension drag gives me the message DPR-ERR-2056 - Report server is not responding.  The regular dimensions reside on one server and they are connected to a measures dimension on another server.  Both servers are NetezzaSQL servers.

tried changing which one I dragged second and not matter which one, I got this message I did my homework and got the message from Cognos KB below. Ther errors don't apply to me because there are no cube or SAP joins. They are all relational to relational. Can anyone help?



Description:

There are limitations when attempting to join queries from different data sources.

For example, open Report Studio, using either a Cube data source from the Cognos sample Great Outdoors Company (or Microsoft Analysis Services).

When joining two queries with two simple query items for each, an error page is generated.

Error Message:

DPR-ERR-2056 The Report Server is not responding.
Details   
Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler [the_dispatcher]
com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer]
com.cognos.pogo.handlers.logic.ChainHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [reportservicechain]
com.cognos.pogo.handlers.logic.ChainHandler [warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_warp]

Solution:

When joining queries between different data sources, Cognos 8 BI supports:

RDBMS to RDBMS joins
set operations of any two queries
Master-detail relationships of any two queries
Drill from any query to any other query
As of Cognos 8.2, the following joins are not supported:

Cube-to-cube (homogeneous) joins
Cube-to-cube (heterogeneous) joins
Cube-to-RDBMS joins
Cube-to-SAP BW joins
SAP-BW-to-RDBMS joins
Related Documents:

[Darek]

Try forcing local processing. It will be slower, but might help. When queries are processed locally, a data extract occurs from both databases and results are joined locally, record by record.