IBM Support

How to use the 'connection_polling_timeout' FAP mechanism, to reduce the likelihood of Data Marts going to 'Error' when the TM1 cube (TM1 server) is temporarily unavailable (for example TM1 server is rebooting)

Troubleshooting


Problem

Customer is finding that their Data Mart's status is changing to 'Error'. This occurs when the TM1 server has a problem (for example the TM1 cube is being restarted). Example: During a maintenance period, customer reboots all the application servers. The FAP service is small/lightweight and therefore starts quickly. The TM1 server consumes more memory, therefore can take longer to start. This means that the FAP service may start when the TM1 server is unavailable. Is there a way to allow Controller's FAP service to survive a temporary loss of connection to the TM1 cube (TM1 server)?

Symptom

Scenario #1 (main/most-relevant)
This is the most important scenario (which the 'connection_polling_timeout' parameter was mostly designed for).

Initially the TM1 server/cube is not running. Then the customer starts the Windows service 'IBM Cognos FAP Service'. User opens the FAP client, and opens 'Data Mart' and tries to start the initial publish. The status changes to 'error'.

  • Even if the customer starts their TM1 server/cube now, the data mart status will not change from 'error'.


Scenario #2 (less relevant to the 'connection_polling_timeout' feature)
Initially the TM1 server, and FAP service are both running OK. The Data Mart status is set to 'running'. Suddenly the TM1 server/cube is stopped.
  • User opens the FAP client, and opens 'Data Mart'. User sees that the Data Mart status has changed to 'Error'.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.1;10.3;10.2.1;10.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg22012681

Page Feedback