Error
The gateway timeout has expired. IWR reside on one server and is not a distributed environment.
The event log displays the following:
IWR:IWReqMan
Text: Socket Error connecting during open failed. Unknown error.
Desc: Socket Error connecting during open failed. Unknown error.
A report contains a picklist prompt. Shortly after attempting to view it within the browser, the error message occurs. This does not occur with IWR 5.0. The report is personal. The error is generated before the prompt screen displays.
Here are the steps to resolve this issue:
1. Stop the IWR services in the services dialog box.
2. On the server, start a cmd window or dos window.
3. Change to the following directory;
X:\program files\cognos\cer1\bin\
4. Enter the following line:
X:\program files\cognos\cer1\bin\iwrconfig -attr prompttimeout=300000
5. This should change the time out to 5mins or 300000 ms.
6.
Attempt to run the report again after you have restarted the services.
7. If you time out again, adjust the prompt timeout.
8. In addition to increasing IWR server prompt timeout via iwrconfig, increase IWR gateway timeout.
In the file \cgi-bin\imrap.ini, edit the following line (time is in milliseconds):
IWRRequestTimeOut=60000
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu Web Reports","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"}],"Version":"Impromptu 7.1;Impromptu Web Reports 6.0;Impromptu Web Reports 6.1;Impromptu Web Reports 7.0;Impromptu Web Reports 7.1;Impromptu Web Reports 7.3;PowerPrompt 7.1;Upfront 7.1;Upfront 7.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu Web Reports","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"PowerPrompt","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Upfront","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]