How to resolve MDX Statement error. Error occurred when starting the parser.Error when opening an RFC connection (Function).
It is possible that the RFC failes due to the OS reching the limit on maximum number of processes.
First need to check the ulimit values on the OS system: For this you can refer KBA “2048826”.
To do so in the command prompt type “ulimit -a” as shown below values must be appear in your system.
ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user) unlimited
Note:- For windows server the above check can resolve the issue. But for AIX system you need to follow the below steps to resolve.
On AIX there is a second limit for processes, which is set to 128 on your server:
[3]lsattr El
sys0 a
maxuproc
maxuproc 128 Maximum number of PROCESSES allowed per user True.
This maxuproc should be increased to atleasst 1024. See note 1972803 SAP on AIX:
Recommendations Section 3 for detailes:
“o Maximum number of processes for each user in the system:
This value (maxuproc) can be checked using the command ‘lsattr El
sys0 a
maxuproc’ and is often set too low at 128. You should use the
command ‘chdev l
sys0 a
maxuproc=1024′ to set the value to at least
1024.”
Please increase the maxuproc to resolve this issue.
Regards,
Aravind