Solved

oracle Forms from 6i to 10g -only blank screen is displaying after deployment

Posted on 2008-10-08
9
1,671 Views
Last Modified: 2013-12-18
I have converted oracle Forms from 6i to 10g (almost 10 forms). In the development environment all 10 forms are working fine without any problems. I have deployed the forms in the server. Now all the forms are working fine except one form. Only blank screen is displaying in this case. What could be the reason? How to resolve this issue? This form is also working fine in the development environment.
Thanks for all your suggestions.
0
Comment
Question by:jyothsna1803
  • 4
  • 3
9 Comments
 
LVL 12

Accepted Solution

by:
jwahl earned 500 total points
ID: 22676059
hard to say what's the reason ... try to put some message codes to have control over the form.
start with the PRE-FORM trigger:

BEGIN
    MESSAGE(1);PAUSE;
    ...
    ... [your code]
    ...
    MESSAGE(2);PAUSE;
END;

then WHEN-NEW-FORM-INSTANCE, then on block level PRE-BLOCK, WHEN-NEW-BLOCK-INSTANCE and so on.

so maybe you are able to locate where the form stops ....
0
 

Author Comment

by:jyothsna1803
ID: 22679886
WHEN-NEW-FORM-INSTANCE is not firing and PRE-FORM trigger is firing. What could be the reson, how to tesrt/resolve this issue,
Thanks!
0
 
LVL 12

Expert Comment

by:jwahl
ID: 22680218
PRE-FORM fires before WHEN-NEW-FORM-INSTANCE ... does PRE-FORM finish completly?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:jyothsna1803
ID: 22680283
Just one small alert i have used in PRE-FORM Trigger. i am using the below line and it is displaying the message.
message( 'pre form Trigger');
Even i have written the same alery in the WHEN-NEW-FORM-INSTANCE trigger. but i am not seeing this messge. I thought after firing PRE-FORM trigger the process is stopped, but in the development it is working fine and i am seeing messages successfully.
0
 

Author Comment

by:jyothsna1803
ID: 22681725
I have written alert messages in the following triggers to verify above problem
pre form
pre block
pre record
pre text item
when new form instance

I got alert messages for pre form,pre block and pre record triggers. But not to pre text item. So is it the real issue with pre text item, anyway i am not getting any kind response to when new form instance trigger. Any suggestions please
0
 
LVL 12

Expert Comment

by:jwahl
ID: 22684792
i'm not sure if Forms 10g supports this, in 6i you can debug the form by turning on Debug Mode: Tools --> Preferences --> Runtime --> Debug Messages
at runtime you will get a message for every trigger that is fired.
maybe this will help you to locate the problem ...?
0
 

Author Comment

by:jyothsna1803
ID: 22687580
Still no luck Jwahl. Thanks for all your help. I am developing a new form.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question