TechNote (Archived)

ColdFusion 5: Using cfgraph in a cluster

Issue

When using cfgraph in a clustered environment where sticky sessions are not enabled, the output of the resulting graph may display as follows:

 Sorry, the data for this graph has Expired

When a graph is created with the cfgraph tag, the information for the graph is stored in a memory table on the specific machine where the cfgraph code is being executed. For this reason, in order for cfgraph to work reliably in a clustered environment, sticky sessions must be enabled to ensure each user remains on the same server once the code begins execution.

Solution

Enable sticky sessions on the load balancing hardware/software, which will ensure each session is limited to a single server. Refer to vendor-specific instructions on how to do so.