There was on error in accessing ERP Forms though all per-requisites exists on the system.
I've encountered this issue on freshly configured system.
In earlier post I've discussed about this issue:
http://appsdbaworkshop.blogspot.com/2011/02/frm-92101-there-was-failure-in-forms.html
This issue will solved only if yo will Install same version of openmotif as mentioned in Installation document. If you have higher version of rpm then its simply not going to workout.
Required version of openmotif rpm - openmotif21-2.1.30-11.EL5.i386.rpm
Actual version exists on system - openmotif22-2.2.3-18.EL5.i386.rpm
If you do not want to Install the old version of rpm and want to access the forms using the same rpm "openmotif22-2.2.3-18.EL5.i386.rpm" then this is the post/article which you're looking for :
Form error message:
Application Error log:
Its looking for the library file "libXm.so.2" in /usr/lib which does not exists on the server.
The rpm openmotif22-2.2.3-18.EL5.i386.rpm will deliver the higher version of library file then expected:
If we Install rpm openmotif21-2.1.30-11.EL5.i386.rpm then it will generate library libXm.so.2.
Solution:
After modification restart your middle tiers your forms access should work as expected with no more error messages.
Happy troubleshooting :)
thanks,
Zaheer Syed
I've encountered this issue on freshly configured system.
In earlier post I've discussed about this issue:
http://appsdbaworkshop.blogspot.com/2011/02/frm-92101-there-was-failure-in-forms.html
This issue will solved only if yo will Install same version of openmotif as mentioned in Installation document. If you have higher version of rpm then its simply not going to workout.
Required version of openmotif rpm - openmotif21-2.1.30-11.EL5.i386.rpm
Actual version exists on system - openmotif22-2.2.3-18.EL5.i386.rpm
If you do not want to Install the old version of rpm and want to access the forms using the same rpm "openmotif22-2.2.3-18.EL5.i386.rpm" then this is the post/article which you're looking for :
Form error message:
Application Error log:
12/03/24 13:56:12.509 formsweb: Forms session <1> aborted: runtime process failed during startup with errors /u01/applR12/PR
ODERP/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No s
uch file or directory
12/03/24 13:56:12.510 formsweb: Forms session <1> exception stack trace:
oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process
at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletReq
uestDispatcher.java:713)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(S
ervletRequestDispatcher.java:370)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRe
questHandler.java:871)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequ
estHandler.java:453)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.ja
va:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.ja
va:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(Rel
easableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
12/03/24 14:02:56.466 formsweb: 10.1.3.4.0 Stopped
Its looking for the library file "libXm.so.2" in /usr/lib which does not exists on the server.
The rpm openmotif22-2.2.3-18.EL5.i386.rpm will deliver the higher version of library file then expected:
[root@erpappl2 lib]# ls -l libXm.so*
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so -> libXm.so.4.0.1
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so.3 -> libXm.so.3.0.2
-rwxr-xr-x 1 root root 2542828 Jun 6 2007 libXm.so.3.0.2
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so.4 -> libXm.so.4.0.1
-rwxr-xr-x 1 root root 2637260 Nov 3 2010 libXm.so.4.0.1
If we Install rpm openmotif21-2.1.30-11.EL5.i386.rpm then it will generate library libXm.so.2.
Solution:
copy library file
[root@erpappl2 root]#cd /usr/lib
[root@erpappl2 lib]#cp libXm.so.3.0.2 libXm.so.2.0.2
create link
[root@erpappl2 lib]#ln -s libXm.so.2.0.2 libXm.so.2
After modification restart your middle tiers your forms access should work as expected with no more error messages.
Happy troubleshooting :)
thanks,
Zaheer Syed
Comments
I followed the above steps and resolve the error.Thanks for the perfect solution.
special thanks
Thanks for reading my blog.
Its good to know that issue has been solved :)
regards,
Syed Zaheer
[root@host lib]# ls -l libXm.so*
-rwxrwxrwx 1 root root 332785 Sep 21 22:12 libXm.so.2
[root@host lib]# rpm -q openmotif
openmotif-2.3.3-5.el6_3.x86_64