This content has been marked as final. Show 5 replies
In Apex Listener 2.0 EA, I have pre/post process procedure set in default.xml fileYou mean apex-config.xml , right?
Did you edit this file manually or using SQL Developer or listenerAdmin?
In the defined procedure, when I try to get a CGI environment variable, using owa_util.get_cgi_env('remote_user' ), I get a "500 - Internal Server Error".This should work with APEX Listener. Could you post the corresponding output of APEX Listener's log?
I used SQL Developer 3.2 to define the procedure.preProcess and procedure.postProcess at the Database Setting level not at the Global Setting level. I then saved the settings and moved the zip file over to the sever manually. When pre/post procedure did not work, I manually edited the default.xml and then tried again. That is when I got the "500 - Internal Server Error" error. I don't have an apex-config.xml file. The files I have are:
The glassfilsh log show this when pre/post procedure is called
defaults.xml url-mapping.xml conf/dvlpdms.xml conf/dvlpdms_al.xml conf/dvlpdms_rt.xml
By commenting out the lines where I retrieve environment variables from oas_util.before_proc , then things work.
[#|2012-11-19T11:40:38.221-0600|SEVERE|glassfish3.1.2|null|_ThreadID=18;_ThreadName=Thread-2;|Executing procedure failed for oas_util.before_proc |#]
You are right. I forgot that the apex-config.xml in my instance came from the previous APEX Listener 1.1 release. It moved to defaults.xml with APEX Listener 2 EA2. I'm sorry I've send you into the wrong direction.
So, you could add
to this file in order to get a more comprehensive error message in your log.
I used SQL Developer 3.2Which exact version?
When pre/post procedure did not work, I manually edited the default.xml and then tried again.What exactly did you edit and how?
Thanks for taking my question. I manually edited the default.xml file with these values:
SQL Developer 3.2.20.09
<entry key="log.procedure">true</entry> <entry key="debug.debugger">true</entry> <entry key="debug.printDebugToScreen">true</entry> <entry key="procedure.preProcess">oas_util.before_proc</entry> <entry key="procedure.postProcess">oas_util.after_proc</entry>
APEX Listener 18.104.22.1688.17.04
When the "500 - Internal Server Error" error message is raised, that is all there is on the screen. So, how do I get it to display detailed debugging information.
Edited by: Sanjeev Chauhan on Nov 20, 2012 10:20 AM
I'd really expect to see more information on that error in the application/server log on your GlassFish.
I'll try to reproduce your scenario as soon as I have access to my testing environment again if you can't find anything there...