Hi, I really need help with this one.
I deinstalled Developer Suite 10g and wipe out my registry of anything that has a value of c:\Orant10g(ORACLE_HOME). I then reintalled the Oracle 10g Developer Suite. Now I have trouble running my reports using the URL: http://finnt43.llnl.gov:8889/reports/rwservlet?[server=rep_finnt43]+report=ofc1000r.rdf+userid=[userid/password@db]+destype=cache+desformat=htmlcss+PARAMFORM=yes
I get an error REP-56105 in the Start OC4J instance command prompt. This is my trace file.
<beginning of trace file>
[2004/6/22 3:26:11:771] Debug 50103 (RWClient:initCORBA): Visibroker connection pool size is =500
[2004/6/22 3:26:11:771] Debug 50103 (RWClient:RWClientInit): Get ORACLE_HOME from environment variable, oracle home: C:\Orant10g
[2004/6/22 3:26:12:21] Warning 50103 (RWClient.RWClientInit): Failed to connect to OiD server
[2004/6/22 3:26:12:121] Debug 50103 (KeyMapParser:readKeyMapFile): file: C:\Orant10g\reports\conf\cgicmd.dat
[2004/6/22 3:26:12:422] (RWClient:doGet) enter...
[2004/6/22 3:26:12:442] Debug 50103 (RWClient:doGet): QueryString: server=repfinnt43+report=ofc1000r.rdf+userid=[username/password@db+destype=cache+desformat=htmlcss+PARAMFORM=yes
[2004/6/22 3:26:12:622] Debug 50103 (RWClientUtility:appendPFTags): hiddenString server=repfinnt43&report=ofc1000r.rdf&userid=[username/password@db&destype=cache&desformat=htmlcss&PARAMFORM=yes
[2004/6/22 3:26:49:946] Info 50103 (RWClientUtility:findServer): Cannot find server: repfinnt43
[2004/6/22 3:26:50:437] Warning 50103 (RWClient:startInProcessServer): start inprocess server repfinnt43
[2004/6/22 3:28:38:131] Exception 52266 (): The in-process Reports Server repfinnt43 failed to start.exception oracle.reports.RWException {
oracle.reports.RWError[] errorChain={struct oracle.reports.RWError {
int errorCode=52266,
java.lang.String errorString="The in-process Reports Server repfinnt43 failed to start.",
java.lang.String moduleName="REP"
}}
}
exception oracle.reports.RWException {
oracle.reports.RWError[] errorChain={struct oracle.reports.RWError {
int errorCode=52266,
java.lang.String errorString="The in-process Reports Server repfinnt43 failed to start.exception oracle.reports.RWException {
oracle.reports.RWError[] errorChain={struct oracle.reports.RWError {
int errorCode=52266,
java.lang.String errorString="The in-process Reports Server repfinnt43 failed to start.",
java.lang.String moduleName="REP"
}}
}",
java.lang.String moduleName="REP"
}}
}
at oracle.reports.utility.Utility.newRWException(Utility.java:604)
at oracle.reports.rwclient.RWClient.startInProcessServer(RWClient.java:767)
at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1422)
at oracle.reports.rwclient.RWClient.doGet(RWClient.java:349)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
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:604)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
at java.lang.Thread.run(Thread.java:534)
[2004/6/22 3:28:38:131] Debug 50103 (RWClientUtility:isFromPortal): portal: null
[2004/6/22 3:28:38:131] Debug 50103 (RWClientUtility:isFromPortal): webdbversion: null
[2004/6/22 3:28:38:292] Debug 50103 (RWClientUtility:isStatusFormat): statusformat: null
[2004/6/22 3:28:38:292] Debug 50103 (RWClientUtility:isStatusFormat): statusformat: null
[2004/6/22 3:28:38:312] (RWClient:doGet) ...exit
<end of trace file>
When I run the URL below to check if my report server is running, I get this error - REP-52266.
http://finnt43.llnl.gov:8889/reports/rwservlet/showjobs?server=repfinnt43
REP-52266: The in-process Reports Server repfinnt43 failed to start.exception oracle.reports.RWException {
oracle.reports.RWError[] errorChain={struct oracle.reports.RWError {
int errorCode=52266,
java.lang.String errorString="The in-process Reports Server repfinnt43 failed to start.",
java.lang.String moduleName="REP"
}}
}
Here is my rwservlet.properties file setting.
SERVER_IN_PROCESS=YES
RELOAD_KEYMAP=NO
DIAGNOSTIC=YES
TRACEOPTS=TRACE_ALL
TRACEFILE=rwservlet.trc
TRACEMODE=TRACE_REPLACE
SERVER=repfinnt43
#IMAGEURL=http://<web_server_name>:<port_num>/reports/rwservlet
#KEYMAPFILE=CGICMD.DAT
#DBAUTH=RWDBAUTH.HTM
#SYSAUTH=RWSYSAUTH.HTM
#ERRORTEMPLATE=RWERROR.HTM
#COOKIEEXPIRE=30
#ENCRYPTIONKEY=reports9i
#DIAGBODYTAGS=<reports_servlet_help_file_title>
#DIAGHEADTAGS=<reports_servlet_help_file_body_tag>
#HELPURL=<url_of_customized_help_file_for_reports_servlet>
SINGLESIGNON=NO
OID_ENTITY=%REPORTS_OID_ENTITY%
#CONNECTION_POOLSIZE=500
#ALLOWHTMLTAGS=NO
I also set the report_path to the directory where I had my reports.
Please help. What is going on? Does reinstalling the 10giDS messed things up? How can I resolve this report server issue?
Jennifer