The Workbench Service Account “mciworkb” must be configured with a ulimit for the number of open files set to at least 10240. This setting is normally configured when you install Information Server.
On AIX, check the /etc/security/limits file which should contain the following lines:-
| Code Block |
|---|
mciworkb:
nofiles = 10240
nofiles_hard = 10240 |
If the values are not there or set to smaller values, use the following commands:-
| Code Block |
|---|
chuser "nofiles=10240" mciworkb
chuser "nofiles_hard=10240" mciworkb |
On other flavours of Linux, check the file /etc/security/limits.conf file which should contain the following lines:-
| Code Block |
|---|
* soft nofile 10240
* hard nofile 10240 |
If these values are not there or set to smaller values, edit the limits.conf file.If the Workbench server is constrained for resources, there is a possibility that Workbench will show errors in mci.log soon after startup
A JAVA_OPTS environment variable can now be set which allows the resource usage of Java to be tweaked.
The error above was mitigated by halving the Stack Size from 2MB to 1MB.
The technical setting is $JAVA_OPTS=-Xss1024K