How to resolve an issue when Cognos metrics reports for Connections start, but fail to complete successfully in Communities
When using Community Metrics and the Cognos server 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 does not finish.
Go to Cognos server and click on the IBMConnectionsMetrics, StaticReports and drill down 3 levels deep, some folders get created but not all 110.
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.
Information on this setting is also available in the Wiki:
This issue can occur in both 4.0 and 4.5 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 for is 1200 seconds, since the http client socket time-out is set to 1200/5=240 seconds increasing the secsPerRequest to 3600 seconds in order to resolve the issue.
Checkout the metrics-config.xml file:
Then change the following: