We are needing to change some reports from an Oracle data source to SQL Server. There are no problems in Oracle, but when the report is run in SQL Server, ReportNet returns the error:
DPR-ERR-2056 - The Report Server is not responding
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] com.cognos.pogo.handlers.logic.ChainHandler
[warpmta] com.cognos.pogo.reportservice.ReportServerHandler
We have had no problems with this in Oracle, but SQL Server randomly gives this error to very simple or very complex reports without any consistency. We are using crn 1.1 MR2 now and it gave the error before and after the upgrade. Any thoughts? We are thinking it could be our ODBC driver, but to upgrade the driver is over 25K! All queries in the report will return the tabular data, it just won't run the entire report.
Any help is appreciated...
DPR-ERR-2056 - The Report Server is not responding
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] com.cognos.pogo.handlers.logic.ChainHandler
[warpmta] com.cognos.pogo.reportservice.ReportServerHandler
We have had no problems with this in Oracle, but SQL Server randomly gives this error to very simple or very complex reports without any consistency. We are using crn 1.1 MR2 now and it gave the error before and after the upgrade. Any thoughts? We are thinking it could be our ODBC driver, but to upgrade the driver is over 25K! All queries in the report will return the tabular data, it just won't run the entire report.
Any help is appreciated...