If you are unable to create a new account, please email support@bspsoftware.com

 

DPR-ERR-2056 The Report Server is not responding; for one report only

Started by tpaddack, 21 May 2007 07:02:11 PM

Previous topic - Next topic

tpaddack

Greetings,

I am new to Cognos Administration and need some help with figuring out the problem with this one report and how it interacts with our production server.  Of course, it is a new report that the Sales people LOVE and it is causing some problems.

Here is the error message:
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 [rxBalancedRequest]
com.cognos.pogo.handlers.logic.ChainHandler [service_lookup]
com.cognos.pogo.handlers.engine.ServiceLookupHandler [batchreportservicechain]
com.cognos.pogo.handlers.logic.ChainHandler [warptask_with_authenticate]
com.cognos.pogo.handlers.logic.ChainHandler [do_batch_warp]
com.cognos.pogo.handlers.logic.ChainHandler [warptaskmtaChain]
com.cognos.pogo.handlers.logic.ChainHandler [warptaskmta]
com.cognos.pogo.reportservice.BatchReportServerHandler

Here are the symptoms:
* we can run the report immediately, but cannot schedule the report to a later time nor save the report. If we do, we get the above error and the server makes a massive dump file in the c:\Program Files\cognos\c8mr2\bin directory
* we can run, schedule and save any OTHER report but this new Sales report
* this behavior only happen in our PROD instance, not in TEST or DEV - in test and dev, everything runs fine
* there is a minor URI location difference in the configuration between TEST and PROD; we are going to fix this tonight and then bounce the PROD server

goose

This is unfortunately very difficult to debug via a forum... but there is a cognos KB article for this on the cognos support site (you will need a support account to view this), its not for the exact same thing as yours is for a batch report but it may shed some light.

http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=123931

They say the root cause is an invalid layout reference(s) in ther report due to copy/paste of calculations.  To rectify this adjust the references in the copied calculation to point to the query that the list is based on resolves the error.

Hope this helps