Re: Oracle Forms 10g not running in OC4J

From: <rob_at_oraclewizard.com>
Date: Mon, 28 Mar 2016 18:48:43 +0000
Message-ID: <W9025611905230841459190923_at_atl4webmail08>


  1. Memory usage is about 1/2g.
  2. the pre-form / block / item message does not render on the screen.
  3. so I set a breakpoint on the pre-form /block / item trigger. the debugger does not get control.
  4. I also checked in sql developer for sessions to see if anything is touching the database. The only sessions are frmbld.exe and sql developer. So, it appears the instance is not getting started up.

What makes this so strainge is the form works fine in OAS and all my other forms will start up in oc4j. it's just this one. It's a head scratcher.


Robert P. LockardOracle ACEWinner of the 2015 Oracle Developers Choice Award for Database DesignPresident Oraclewizard.com, Inc. "When given the choice between two evils, I always take the one I have not tried." Mae West
(cell) 571.276.4790
(office) 410.766.6960
(fax) 410.766.0332

twitter _at_navonpilot
youtube https://www.youtube.com/user/n4281k blog: http://www.oraclewizard.com
-----Original Message-----
From: raza siddiqui [mailto:raza.siddiqui_at_oracle.com] Sent: Monday, March 28, 2016 02:29 PM
To: rob_at_oraclewizard.com
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle Forms 10g not running in OC4J

OK.

 The PRE-* series of trigger fire BEFORE any WHEN-* triggers which in turn fire before and POST-*triggers..which is why I asked about the PRE-FORM. If there are no PRE-FORM, are there any PRE-BLOCK, or FIELD triggers ? Check those.

 The PRE-FORM then BLOCK,then FIELD triggers (if they exist) are executed before the WHEN-NEW-[FORM / BLOCK / FIELD]-INSTANCE triggers in terms of navigational-focus. Think of the PRE-* trigger as a "probe" ahead of the user-focus (initializing variables etc), the WHEN* - when focus has arrived and the POST-* when user-focus has left.

 If there is no PRE-FORM, create one and add a diagnostic MESSAGE('Firing at PRE-FORM'); Similarly, add one at the FIRST navigational BLOCK and first navigational field in that block..this should indicate if the form has actually instantiated.

 As for VM memory, seems adequate, but how much is the VM using itself ?

On 3/28/2016 11:11 AM, rob_at_oraclewizard.com wrote:

  1. there are no pre-form triggers.
  2. the VM has 2G allacated to it.
  3. I put a break point on the first line of the WHEN-NEW-FORM-INSTANCE trigger to see if it was getting that far. The debugger never comes back.
  4. Checking task manager, iexplorer just seems to stall with 0 cpu usage.

 Robert P. Lockard Oracle ACEWinner of the 2015 Oracle Developers Choice Award for Database Design President Oraclewizard.com, Inc.  "When given the choice between two evils, I always take the one I have not tried." Mae West

 (cell) 571.276.4790 
 (office) 410.766.6960 
 (fax) 410.766.0332 

 twitter _at_navonpilot
 youtube https://www.youtube.com/user/n4281k  blog: http://www.oraclewizard.com/
-----Original Message-----
From: raza siddiqui [mailto:raza.siddiqui_at_oracle.com] Sent: Monday, March 28, 2016 02:03 PM
To:rob_at_oraclewizard.com
Cc:oracle-l_at_freelists.org
Subject: Re: Oracle Forms 10g not running in OC4J

Inspect any PRE-FORM / PRE-BLOCK triggers for developer-inserted diagnostics, such as BREAK commands (leftover from a prior debugging session perhaps ?)

 Is memory allocation to your VM adequate for this particular form ?  Is this particular form the first to be instantiated or do you navigate to it from another via GO_FORM, OPEN_FORM etc (so they maybe occupying available memory)

On 3/28/2016 10:49 AM, rob_at_oraclewizard.com wrote:

-- 


-- 





--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 28 2016 - 20:48:43 CEST

Original text of this message