Error: "You have exceeded the maximum [%s] connections for this session." [ID 749386.1]

 

Applies to:

Hyperion Planning - Version: 9.3.1.0.00 and later   [Release: 9.3 and later ]
Information in this document applies to any platform.

Symptoms

Error message while using Excel Add in: You have exceeded the maximum [%s] connections for this session.

Cause

The error message appears because Essbase has a limitation of 250 sessions - this is an Essbase limitation of 250 connection limit.

Solution

1. The maximum number of connections that are allowed per Port is 250. There is a 250 connection limit per port. Please use a different user ID and desktop as the workaround, so this way a different port can be used.

2. If using a different user ID and desktop is not feasible, increase the value of the maxlogins parameter as indicated below:

Increase the maxlogins in the Essbase.cfg file to 5000, and restart Essbase.

Note: Make sure that there are no sessions active within the EAS console before restarting the Essbase services.