{"id":3642,"date":"2013-02-20T09:42:10","date_gmt":"2013-02-20T14:42:10","guid":{"rendered":"https:\/\/pitss.org\/us\/2013\/02\/20\/forms-application-freezes-on-alert-functions-even-with-patch-12433970-applied\/"},"modified":"2017-06-28T13:47:28","modified_gmt":"2017-06-28T17:47:28","slug":"forms-freezes-on-alerts-with-patch-12433970","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2013\/02\/20\/forms-freezes-on-alerts-with-patch-12433970\/","title":{"rendered":"Forms application freezes on ALERT functions even with Patch 12433970 applied"},"content":{"rendered":"<p>There have been reports in many Forms installations where the Forms application hangs when an ALERT (SHOW_ALERT for example) is supposed to appear. A patch, 12433970, is available to fix this problem (see <a href=\"https:\/\/pitss.org\/us\/2012\/07\/10\/oracle-forms-alert-freeze\/\">https:\/\/pitss.org\/us\/2012\/07\/10\/oracle-forms-alert-freeze\/<\/a> for more information). However, there are cases where Oracle Forms freezes when an alert is supposed to appear even if the patch is applied. Also, in Forms versions 11.1.1.6 and 11.1.2.1, this patch is included in these patchsets.<\/p>\n<p>This has resulted in the 12433970 patch not fixing the problem. Another fix exists which has been known to fix the problem. This only requires a few changes in a couple of configuration files, and the environment does NOT need to be shut down. To apply this fix, you will need to do the following:<\/p>\n<ol>\n<li>Go to %ORACLE_INSTANCE%\\config\\FormsComponent\\forms\\server<\/li>\n<li>Make a backup of webutiljpi.htm<\/li>\n<li>Open up webutiljpi.htm in a text editor<\/li>\n<li>Look for all of the PARAM tags after &lt;SCRIPT LANGUAGE=\u201dJavaScript\u201d \u2026 tag. Before the PARAM NAME=\u201dARCHIVE\u201d tag, add the following line into the document:\n<ul>\n<li>&lt;PARAM NAME=&#8221;cache_archive_ex&#8221; VALUE=&#8221;%cache_archive_ex%&#8221;&gt;<\/li>\n<li><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2013\/02\/image3.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border-width: 0px\" src=\"https:\/\/pitss.org\/files\/2013\/02\/image_thumb3.png\" alt=\"image\" width=\"495\" height=\"387\" border=\"0\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>Save and close the file.<\/li>\n<li>Go to %DOMAIN_HOME%\\config\\fmwconfig\\servers\\WLS_FORMS\\applications\\formsapp_11.1.#\\config<\/li>\n<li>Make a backup of formsweb.cfg<\/li>\n<li>Open up formsweb.cfg in a text editor<\/li>\n<li>Add the following parameter to each configuration section in formsweb.cfg such as default, webutil, or any application-related sections:\n<ul>\n<li>cache_archive_ex=jacob.jar;preload<\/li>\n<li>Example if you have a custom jar file containing your icons and you are using WebUtil:<\/li>\n<li>cache_archive_ex=jacob.jar;preload,pitss.jar;preload<\/li>\n<li>NOTE: As you can see above, while each jar file is still separated by a comma, the \u201c;preload\u201d must be added at the end of the jar file before the comma. These jar files excluding the ones which start with \u201cfrm\u201d should only be deployed here.<\/li>\n<li><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2013\/02\/image4.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border-width: 0px\" src=\"https:\/\/pitss.org\/files\/2013\/02\/image_thumb4.png\" alt=\"image\" width=\"577\" height=\"465\" border=\"0\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>If you have any jar files excluding the jar files which start with \u201cfrm\u201d in the archive parameter, please remove them from the parameter.<\/li>\n<li>Repeat for all other sections in formsweb.cfg that you are using.<\/li>\n<li>Remove jacob.jar from all WebUtilArchive parameters in the file. Each WebUtilArchive should now look like this:\n<ul>\n<li>WebUtilArchive=frmwebutil.jar<\/li>\n<li><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2013\/02\/image5.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border-width: 0px\" src=\"https:\/\/pitss.org\/files\/2013\/02\/image_thumb5.png\" alt=\"image\" width=\"576\" height=\"207\" border=\"0\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>Save and close the file.<\/li>\n<\/ol>\n<p>After applying the changes above, start a new browser session (close all open browser windows first). You will notice that the application no longer hangs when an alert or dialog box appears. NOTE: If you notice that the problem is still occurring, try clearing your browser cache as well as your Java cache.<\/p>\n<p><strong>Source: Oracle Support note 1328039.1<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There have been reports in many Forms installations where the Forms application hangs when an ALERT (SHOW_ALERT for example) is supposed to appear. A patch, 12433970, is available to fix this problem (see https:\/\/pitss.org\/us\/2012\/07\/10\/oracle-forms-alert-freeze\/ for more information). However, there are cases where Oracle Forms freezes when an alert is supposed to appear even if the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[22,14],"tags":[11,16,25,23,40],"class_list":["post-3642","post","type-post","status-publish","format-standard","hentry","category-forms","category-resolve-issues","tag-11g","tag-11gr2","tag-customer-support-request","tag-forms","tag-weblogic"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=3642"}],"version-history":[{"count":6,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3642\/revisions"}],"predecessor-version":[{"id":9478,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3642\/revisions\/9478"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=3642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=3642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=3642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}