Oracle Forms 12c and FRM-93652
Posted by Dirk Nachbar on Thursday, August 24, 2017
I am currently working on a huge migration project for Oracle Forms 11g to Oracle Forms 12c (12.2.1.2.0) and we experience some nice FRM-93652 errors in several Forms.
We had several Forms masks on which we executed a query over the menu, data is displayed in the Forms mask afterwards we clicked a button to exit the Forms and the complete Forms session crashed with FRM-93652 :-)
In the underlying formsapp-diagnostic.log in $DOMAIN_HOME/servers/<servername>/logs directory, I only could see following 3 lines:
The important parts are:
After some investigations in My Oracle Support (MOS), I only found a MOS Note for Oracle Forms 11g "Forms Crash With Error FRM-93652 After 11g Upgrade (Doc ID 1096125.1)". This MOS Note is providing a solution who to avoid the above mentioned FRM-93652 error by setting the menu property "Share Library with Form"= Yes or apply a Patch 9965029. But this MOS Note is exclusively for Oracle Forms 11g (11.1.1.2.0 to 11.1.2.2.0) and the referenced Patch is a One-Off-Patch Oracle Database 11g (11.1.0.70 to 11.2.0.3.7).
Every Oracle Forms & Reports Software Home is also containing Oracle Database Required Support Files, so I simply cross checked my ORACLE_HOME which Version are the Database Components in my Oracle Forms and Reports 12.2.1.2.0 Release:
I downloaded the Patch 9965029 for Linux and Oracle Release 11.2.0.3.0, stopped all processes from the Oracle Forms & Reports environment (Managed Servers, OHS, AdminServer and Node Manager) and applied the Patch 9965029 to my Oracle Forms & Reports Software Home with the opatch utility under $ORACLE_HOME/OPatch, started my complete Oracle Forms & Reports Environment and tested once again if the FRM-93652 error comes up again . . . and the problem was solved :-)
I hope that Oracle Support or Oracle Product Management for Forms & Reports will update the My Oracle Support Note 1096125.1, that the provided Patch can also be used for Oracle Forms & Reports 12c.
Update 25th August 2017: I received a confirmation from My Oracle Support, that the above mentioned patch can be used for Oracle Forms & Reports Release 12.2.1.2.0
We had several Forms masks on which we executed a query over the menu, data is displayed in the Forms mask afterwards we clicked a button to exit the Forms and the complete Forms session crashed with FRM-93652 :-)
In the underlying formsapp-diagnostic.log in $DOMAIN_HOME/servers/<servername>/logs directory, I only could see following 3 lines:
[2017-08-24T11:16:50.300+02:00] [MS_FORMS] [ERROR] [FRM-93546] [oracle.forms.servlet] [tid: 21] [userId: <anonymous>] [ecid: b629152b-5758-4998-8aac-f6d306179e0f-000000f0,0] [APP: formsapp] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FORMS_SESSION_ID: MS_FORMS.formsapp.6] [SRC_CLASS: oracle.forms.servlet.RunformProcess] [SRC_METHOD: fromFrmwebToODL] external message from runtime process: In-flux value for a pin at 0x29d0290 [2017-08-24T11:16:50.300+02:00] [MS_FORMS] [ERROR] [FRM-93546] [oracle.forms.servlet] [tid: 21] [userId: <anonymous>] [ecid: b629152b-5758-4998-8aac-f6d306179e0f-000000f0,0] [APP: formsapp] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FORMS_SESSION_ID: MS_FORMS.formsapp.6] [SRC_CLASS: oracle.forms.servlet.RunformProcess] [SRC_METHOD: fromFrmwebToODL] external message from runtime process: kgepop: no error frame to pop to for error 600 [2017-08-24T11:16:50.306+02:00] [MS_FORMS] [ERROR] [FRM-93652] [oracle.forms.servlet] [tid: 21] [userId: <anonymous>] [ecid: b629152b-5758-4998-8aac-f6d306179e0f-000000f0,0] [APP: formsapp] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FORMS_SESSION_ID: MS_FORMS.formsapp.6] [SRC_CLASS: oracle.forms.servlet.BaseServlet] [SRC_METHOD: logConnectionException] The runtime process has terminated abnormally.
The important parts are:
. . . [FRM-93546] . . . external message from runtime process: In-flux value for a pin at 0x29d0290 . . . [FRM-93546] . . . external message from runtime process: kgepop: no error frame to pop to for error 600 . . . [FRM-93652] . . . logConnectionException] The runtime process has terminated abnormally.
After some investigations in My Oracle Support (MOS), I only found a MOS Note for Oracle Forms 11g "Forms Crash With Error FRM-93652 After 11g Upgrade (Doc ID 1096125.1)". This MOS Note is providing a solution who to avoid the above mentioned FRM-93652 error by setting the menu property "Share Library with Form"= Yes or apply a Patch 9965029. But this MOS Note is exclusively for Oracle Forms 11g (11.1.1.2.0 to 11.1.2.2.0) and the referenced Patch is a One-Off-Patch Oracle Database 11g (11.1.0.70 to 11.2.0.3.7).
Every Oracle Forms & Reports Software Home is also containing Oracle Database Required Support Files, so I simply cross checked my ORACLE_HOME which Version are the Database Components in my Oracle Forms and Reports 12.2.1.2.0 Release:
$ORACLE_HOME/oui/bin/viewInventory.sh | grep "FeatureSet: db_clientFR"
FeatureSet: db_clientFR 11.2.0.3.0
I downloaded the Patch 9965029 for Linux and Oracle Release 11.2.0.3.0, stopped all processes from the Oracle Forms & Reports environment (Managed Servers, OHS, AdminServer and Node Manager) and applied the Patch 9965029 to my Oracle Forms & Reports Software Home with the opatch utility under $ORACLE_HOME/OPatch, started my complete Oracle Forms & Reports Environment and tested once again if the FRM-93652 error comes up again . . . and the problem was solved :-)
I hope that Oracle Support or Oracle Product Management for Forms & Reports will update the My Oracle Support Note 1096125.1, that the provided Patch can also be used for Oracle Forms & Reports 12c.
Update 25th August 2017: I received a confirmation from My Oracle Support, that the above mentioned patch can be used for Oracle Forms & Reports Release 12.2.1.2.0
Categories: Oracle, Oracle Forms 12c
