'Error in report results
Your request could not be processed. Please try again. If the problem persists, contact the Administrator.
(QueryEngine encountered error: MFileSystem::File::OpenStream: ::fopen failed for '/opt/MicroStrategy/MSIReg.reg_lock'. System Error (EMFILE): Too many open files Error in Process method of Component: QueryEngineServer, Project <Project_Name>, Job 4350, Error Code = -2147212544. )'
Note: This error may also be observed when running the reports via a 3-Tier connection in Strategy Desktop 9.x.
CAUSE:A file descriptor is an abstraction that a process uses to uniquely identify files opened for input or output. It is possible to limit at a user or system level, the number of file descriptors that a process may open concurrently.
This error may be observed when the Intelligence Server process exceeds its environment limit on the maximum number of file descriptors that can be opened concurrently. This error message is specific to the Strategy Intelligence Server 9.x Universal on a UNIX/Linux operating system. The maximum number of open files for the Intelligence Server process may vary depending on the specific environment (number of projects, network connections, database threads, cache files being accessed concurrently etc.).
ACTION:Users should contact their system administrators for assistance in changing the file descriptor limit for the account under which the Intelligence Server process runs. It is suggested to set the limit initially to at least 1024 descriptors, and then increase this limit if necessary. Once these changes have been made to allow sufficient file descriptors to be opened concurrently, the user will be able to run reports and no error will be thrown either via Strategy Web 9.x or via Strategy Desktop 9.x.
For versions 10.x and newer, the minimum initial limit should be set to 8192 to meet the minimum recommended requirements.
For more details on the number of file descriptor settings for Strategy Intelligence Server Universal 9.x, refer to the following technical documents:
KB34488 - How to reduce file descriptor usage of Strategy Intelligence Server Universal 8.1.x - 9.0.1 on Linux
