Metrics Reports Fail to Complete when using Cognos with IBM Connections
How to resolve an issue when Cognos metrics reports for IBM Connections start, but fail to complete successfully in Communities
When using IBM Connections Community Metrics, the Cognos server may start to create folders, but can not complete. The Community Metrics starts to increase the percentage but never completes, or when adding a second Community, metrics are requested and get added to the queue but do not finish.
Go to the Cognos server and click on the IBMConnectionsMetrics, StaticReports and drill down 3 levels deep. You will see some folders get created, but not all 110 as expected.
The error that is shown in the systemout.log and systemerr.log is:
SystemErr R java.net.SocketTimeoutException: Read timed out
SystemErr R at java.net.SocketInputStream.socketRead0(Native Method)
This issue is caused by not having enough time to run the report before a time-out is reached.
Increase the cognos.secsPerRequest in the metrics-config.xml file from the default value of 1200 seconds to 3600 or more.
Information on this setting is also available in the Wiki:
This issue can occur in both 4.x and 5.x IBM Connections using Cognos Metrics.
Resolving the problem
The issue comes from the configuration of cognos.secsPerRequest in the metrics-config.xml file. The default value is 1200 seconds, since the http client socket time-out is set to 1200/5=240 seconds increasing the secsPerRequest to 3600 seconds may help to resolve the issue.
Checkout the metrics-config.xml file:
Then change the following: