Hallo zusammen,
nachfolgend "sinngemaß" der Text eines Servicerequests, den ich bei Oracle aufgemacht haben (daher in Englisch), aber leider bisher noch keine Antwort bekommen habe.:
FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508
Forms Migration from 11g (Weblogic 10.3.6.0) to 12c (Weblogic 12.2.1.3)
We have a extensive application with more than 200 different Forms modules, some using webutil, others not. Currently, we are migrating from Forms 11g (Weblogic 10.3.6.0) to Forms 12c (Weblogic 12.2.1.3) and facing the following problem with our application.
From Forms 6i, Forms 10g to Forms 11g (Weblogic 10.3.6.0) everything worked fine with this application, but with Forms 12c (Weblogic 12.2.1.3) we are receiving errors having worked with the application for a couple of minutes.
Initially, everything seems to be ok, but after a couple of minutes (1 to 5min) and changing between different Forms modules the error occurs, when trying to invoke another modul. Having occurred once, the error occures every time you invoke another module. After closing and reconnecting to the database you can invoke the modules that have crashed, and work without error for a couple of minutes, but suddenly the error appears again.
webutil-Demo and another "Standalone"-Form module with webutil work fine without this error, so it seems the problem has something to do with the change between Forms modules (after a couple of minutes).
ERROR_TEXT:
WHEN-CUSTOM-ITEM-EVENT Trigger trifft auf unbehandelte Exception ORA-06508.
FRM-40735:WHEN-CUSTOM-ITEM-EVENT Trigger trifft auf unbehandelte Exception ORA-06508
ORA-01403: No Data Found
Thus we first thought, that this had to be be a webutil-problem, but in some modules without webutil a similar error occures:
ERROR_TEXT:
PRE-FORM Trigger trifft auf unbehandelte Exception ORA-06508
FRM-40735: PRE-FORM Trigger trifft auf unbehandelte Exception ORA-06508
In the formsapp-diagnostic.log the following error occures and we first thought, this had a connection to our problem, but in the end this entry regulary occures in the formsapp-diagnostic.log and seems to have nothing to do with our problem
formsapp-diagnostic.log:
[2019-01-31T07:37:20.137+01:00] [FORMS21] [ERROR] [FRM-93546] [oracle.forms.servlet] [tid: 137] [userId: <anonymous>] [ecid: 6b148315-9903-4bb5-9bc9-e3481396927c-00002c5c,0] [APP: formsapp] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FORMS_SESSION_ID: FORMS21.formsapp.71] [SRC_CLASS: oracle.forms.servlet.RunformProcess] [SRC_METHOD: fromFrmwebToODL] external message from runtime process: ERROR: KGL Pin timeout. Handle=0x2d63ec0 Time=298213444
There's nothing special in our application as it has been working since Forms 6i and following versions. We open modules, call modules, close modules and share library data.
Now we are at a loss, because we really don't know, where to locate the problem. Is it a webutil problem or not; does the problem occur, when a form is opened, called or when another is closed?
What we have tried so far:
- Recreation of the webutil repository with create_webutil_db.sql and compiling webutil.pll and the whole application (*.fmb, *.mmb, 'pll) again.
All modules, menus and libraries compiled without error and there are no invalid objects in the database.
- We did a kernel update on the weblogic server: Doc ID 2288127.1
- We patched the weblogic server to the actual version
Yet, the problem still exists and advice or any idea is appreciated
Jetzt in "deutsch" weiter und Kommentare natürlich bitte gerne in "deutsch" :-)
Wir haben so ziemlich alles, was wir zu dem obigen Fehler im Internet gefunden haben ausprobiert, kommen aber einfach nicht weiter, weil wir das Problem nicht wirklich einkreisen können.
Fall jemand also eine Idee oder Anregungen hätte, wären wir wirklich sehr dankbar.
Gruß
Udo