Tuesday, May 08, 2007

How to Enable Tracing in Oracle Forms 10g

Enable Tracing from the url by adding the following to your forms url:
&record=forms&tracegroup=0-98,100-199 (note: item 99 causes some issues, so we are skipping it here. See the Oracle documenation for a description of what is being traced for each item.)

for example
http://machine:port/forms/frmservlet?config=myConfig&record=forms&tracegroup=0-98,100-199

You will get a trace file in the following location:

%ORACLE_HOME%\forms\trace\forms_xxx.trc where xxx is the forms session ID.

Open dos window and do the following:

set ORACLE_HOME=

set PATH=%ORACLE_HOME%\jdk\bin;%PATH%

set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%ORACLE_HOME%\forms\java\frmxlate.jar

java oracle.forms.diagnostics.Xlate datafile=%ORACLE_HOME%\forms\trace\forms_xxx.trc outputfile=%ORACLE_HOME%\forms\trace\html_xxx.html outputclass=WriteOutHTML


you will get a file html_xxx.html in your %ORACLE_HOME%\forms\trace directory.

13 comments:

Anonymous said...

what?

PDOS.ICT said...

Thanks, this info was very usefull !
Much better than the Oracle
"8.4 Viewing Forms Trace Output" info.

Anonymous said...

Anton,
This is great. I was facing issue just due to CLASSPATH setting.

Thanks a lot.

Anton Nielsen said...

Thanks for the comment. It's always nice to find out it helped someone.

Anton

Anonymous said...

Hello, at I ahve just set up Forms tracing with 10g, and it is working, I find that it no longer appears to support loading the parse data into the Oracle database. Do you know if there is a workaround for this? It appears that in 10g, only WriteOutput (XML file) and WriteOutputHTML (HTML) is supported, hwoever in 9.0.2 and lower, uploading to a databaase was available.
Thanks in advance for any assistance.

Anton Nielsen said...

I am only aware of the xml and html output. Sorry I'm not able to help any more than that.

Alexander said...

Thanks for sharing this info its very helpful!

Do you have any experience with forms 11g tracing

We have an issue with some clients. The runtime process is crashing with error

Runtime process 7712 is terminating due to exception c0000005 (ACCESS_VIOLATION).

Thanks
Alex Reichman
syncreon.com

Anton Nielsen said...

Alex,

I do have experience with 11g tracing, but this error is usually do to the O/S (probably Windows, right?) throwing up its hands. I'm not familiar with the ACCESS_VIOLATION specifically, but you should find a stack trace for that process (7712) in your forms dump directory. The trace file will probably have 7712 in the name. Those traces can be a lot to wade through. If this is intermittent you might have to contact Oracle support. With some work, though, that trace file might give you enough clues.

I'm not sure if this was very helpful. If you see something specific in that trace, post back.

Anton

Generic Viagra said...

These commands look pretty interesting and useful, I would like to get some tutorials about these kind of commands. generic viagra kamagra

surea said...

I tried the same command. But when converting to html, i got
C:\Documents and Settings\sleelara>java oracle.forms.diagnostics.Xlate datafile=
%ORACLE_HOME%\forms\trace\a.trc outputfile=%ORACLE_HOME%\forms\trace\a.html outp
utclass=WriteOutHTML
Exception in thread "main" java.lang.IndexOutOfBoundsException
at java.io.FileInputStream.readBytes(Native Method)
at java.io.FileInputStream.read(FileInputStream.java:194)
at java.io.DataInputStream.read(DataInputStream.java:224)
at oracle.forms.diagnostics.ReadDataFile.readStrAttribute(Unknown Source
)
at oracle.forms.diagnostics.ReadDataFile.preRead(Unknown Source)
at oracle.forms.diagnostics.ReadDataFile.preReadEvent(Unknown Source)
at oracle.forms.diagnostics.Xlate.process(Unknown Source)
at oracle.forms.diagnostics.Xlate.main(Unknown Source)


Any idea or help? The file size is only 1 kb, but still cannot conver.

Anton Nielsen said...

Make sure you have set the ORACLE_HOME. In the dos window, prior to running the command, type
set ORACLE_HOME=c:\oracle\...
(that is
set ORACLE_HOME=[your oracle home] )

You could also try using actual paths. In my instructions, where is says
set ORACLE_HOME=
it means to set it to the correct thing.

Anonymous said...

Thank you for the info.

Anonymous said...

Hi, i follow the step and encounter below message

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/forms/diagno
ics/Xlate

regards