&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:
what?
Thanks, this info was very usefull !
Much better than the Oracle
"8.4 Viewing Forms Trace Output" info.
Anton,
This is great. I was facing issue just due to CLASSPATH setting.
Thanks a lot.
Thanks for the comment. It's always nice to find out it helped someone.
Anton
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.
I am only aware of the xml and html output. Sorry I'm not able to help any more than that.
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
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
These commands look pretty interesting and useful, I would like to get some tutorials about these kind of commands. generic viagra kamagra
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.
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.
hey buddy,this is one of the best posts that I�ve ever seen; you may include some more ideas in the same theme. I�m still waiting for some interesting thoughts from your side in your next post.
Thank you for the info.
Post a Comment