KB19372: 'A connection to the application server would exceed the installation-defined limit' error occurs on reports running on MicroStrategy Intelligence Server Universal 9.x/10.x using IBM DB2/UDB driver

Symptom

When running a report in Strategy Developer against a Strategy Intelligence Server, the following error is seen:

Error: SQL Generation Complete
QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect.
Optional feature not implemented.
Connection to application server DMRTPRD would exceed the installation-defined limit.
Driver`s SQLSetConnectAttr failed.
Error in Process method of Component: QueryEngineServer, Project DRL Prod, Job 390, Error Code= -2147212544.

 

Cause

The error is not a Strategy error but is coming from the database side.
The DB2 database has a setting that restricts the number of applications that can connect to it. The above error message indicates that this setting is being exceeded.
 

Action

To resolve this issue, check the maxappls configuration setting for this database. The maxappls setting specifies the maximum number of concurrent applications that can be connected (both local and remote) to the database.
 
For additional information on this setting, refer to the following article:
http://publib.boulder.ibm.com/tividd/td/ITPME/SC23-1284-00/en_US/HTML/p12plmst94.htm#setmaxappls