Home » Developer & Programmer » Forms » Secure WEB.SHOW_DOCUMENT & running reports JSP using Key in URL (merged)
Secure WEB.SHOW_DOCUMENT & running reports JSP using Key in URL (merged) [message #429536] Wed, 04 November 2009 08:01 Go to next message
Chirag.Bhatt
Messages: 3
Registered: November 2009
Junior Member
Dear Sir,
I am trying to run a jsp report through secure web.show_document and had gone through all the steps mentioned in "Oracle Forms Services Secure Web.Show_Document() calls to Oracle Reports" whitepaper, and have followed all the steps.
now when i try to run that report following error is generated

javax.servlet.jsp.JspException: REP-52005: The specified key USERID does not exist in key map file.
javax.servlet.jsp.JspException: REP-52005: The specified key USERID does not exist in key map file.
at oracle.reports.jsp.ReportTag.doStartTag(ReportTag.java:464)
at _gl4416r._jspService(_gl4416r.java:51)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:350)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
at java.lang.Thread.run(Thread.java:534)

please help
running reports JSP using Key in URL [message #429840 is a reply to message #429536] Thu, 05 November 2009 23:39 Go to previous messageGo to next message
Chirag.Bhatt
Messages: 3
Registered: November 2009
Junior Member
I am trying to cal a report jsp by passing a key in url instead of userid/password@connect_string.
i had uncommented KEYMAPFILE=CGICMD.DAT and changed RELOAD_KEYMAP to 'YES' in rwservelet file and in cgicmd.dat i had added key as:
CHI_KEY1: userid=rmenu/rmenu@devtest, under jsp section.

Now when i use this key in my url and call report i get following error.
WEB.SHOW_DOCUMENT ('htp://localhost:8889/reports/gl4416r.jsp?&cmdkey=CHI_KEY1&param='||:IBP_REPORT_PARAMETER.F_REP_SEQ, '_blank');

ERROR:
--------
Fri Nov 06 11:05:48 GMT+05:30 2009
javax.servlet.jsp.JspException: REP-55008: Failed to create report. The command line is: expiredays=0 jobname="/reports/gl4416r.jsp" report="/reports/gl4416r.jsp" ="" userid=rmenu@devtest jsprun=yes authid=RWUser
javax.servlet.jsp.JspException: REP-55008: Failed to create report. The command line is: expiredays=0 jobname="/reports/gl4416r.jsp" report="/reports/gl4416r.jsp" ="" userid=rmenu@devtest jsprun=yes authid=RWUser
at oracle.reports.jsp.ReportTag.doStartTag(ReportTag.java:464)
at _gl4416r._jspService(_gl4416r.java:51)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:350)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)

pls help!!!!


Re: Secure WEB.SHOW_DOCUMENT [message #432369 is a reply to message #429536] Mon, 23 November 2009 18:39 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: how to set and get system idle time in oracle form to reactivate default login screen
Next Topic: error in runtime
Goto Forum:
  


Current Time: Fri Sep 20 06:33:30 CDT 2024