Issue:
The 'Connection Dead' error sporadically occurs when MicroStrategy Intelligence Server uses the MicroStrategy ODBC driver for Oracle Wire Protocol to connect to metadata.
This error, indicative of a disconnection from the database, specifically arises on UNIX machines hosting an Oracle database. The low value of the maxuproc setting (maximum processes per user) on UNIX is identified as a potential cause.
Root Cause:
The 'Connection Dead' error signals disconnection from the database, often linked to a low maxuproc setting on the Oracle UNIX machine. This setting restricts the maximum number of processes per user. Competition for resources, especially when other processes (e.g., a Web Server) are contending, can quickly exhaust this limit.
Fix:
Check the maxuproc setting value using lsattr -El sys0
. The default is usually 128.
Increase the maxuproc value to a higher number (e.g., 4096) using
chdev -l sys0 -a maxuproc=4096
.
Note: The 'Connection Dead' error is generic, and this technical note addresses one potential cause. Another possibility is covered in KB17194.
Published: Apr 2, 2017 Last Updated: Jul 20, 2023 Related Versions: 10.7, 10.6, 10.5, 10.4, 10.3, 10.2, 10.1, 10.0, 9.5.1, 9.4.1
No comments:
Post a Comment