Re: REP-51018 + REP-50004 Errors
Date: Wed, 01 Dec 2004 22:40:00 GMT
Message-ID: <bf3abc3c18c64b34993b4f3d144bd348_at_OracleMonster.com>
Hello,
As I mentionned, when running my WebReports from WebForms through Parameter Forms, I get a login screen asking me to type the username/password/database information. With the login screen is included a error message:
REP-51018: user authentication required
If I press the submit button, I then get an error:
REP-500004: No report specified on the command line
Looking on MEtalink, for those errors it said to increase the SESSIONS parameter in the database init file, which I did. I set LOGIN_MAX_SESSIONS and SESSIONS to maximum values.
This did not solve the issue. I tried to change the order of the parameters passed from WebForms to WebReports and got the error:
REP-51017: userid is incomplete
This seems to point to a problem in the passing of parameters from Forms to Reports. On the iDS, even with REP-51018 and REP-50004, pressing the 'Reset' button I can generate WebReports. On iAS, I do not see the Paper Parameter Form Fields located on the right hand side of my Parameter Forms. The Paper Parameter Form Fields appear normally on iDS however. (???) I have no idea why this is happening ???
Digging deeper, into these errors, some metalink articles indicated that I should disable the SINGLESIGNON parameter and set its value to NO in the rwservlet.properties file.
Here is a copy of my rwservlet.properties file under iDS:
SERVER_IN_PROCESS=YES
RELOAD_KEYMAP=YES
DIAGNOSTIC=YES
TRACEOPTS=TRACE_ALL
TRACEFILE=rwservlet.trc
#TRACEMODE=TRACE_REPLACE
SERVER=RepSRV
#IMAGEURL=http://<web_server_name>:<port_num>/reports/rwservlet
#KEYMAPFILE=CGICMD.DAT
#DBAUTH=RWDBAUTH.HTM
#SYSAUTH=RWSYSAUTH.HTM
#ERRORTEMPLATE=RWERROR.HTM
#DIAGNOSTIC=NO
#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
I also made modifications to my <report server name>.conf file. I removed the <security> and <destination> tags + specified my Reports Source directory. Here is that file:
<?xml version = '1.0' encoding = 'ISO-8859-1'?> <!DOCTYPE server PUBLIC "-//Oracle Corp.//DTD Reports Server Configuration //EN" "file:/C:/Oracle9i_iDS/reports/dtd/rwserverconf.dtd"> <server>
<!--compatible version="6i"/-->
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="50"/> <!--property name="cacheDir" value="your cache directory"/--> <!--property name="maxCacheFileNumber" value="max number of cache files"/--> <!--property name="ignoreParameters" value="parameter names to be ignored in constructing cache key, separated by comma ','"/--> </cache> <!--Please do not change the id for reports engine.--><!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.--> <engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000">
<!--property name="sourceDir" value="H:/TEMP"/--> <!--property name="tempDir" value="your reports temp directory"/--> </engine> <engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000"/> <job jobType="report" engineId="rwEng"/><job jobType="rwurl" engineId="rwURLEng"/> <notification id="mailNotify" class="oracle.reports.server.MailNotify">
<property name="succnotefile" value="succnote.txt"/> <property name="failnotefile" value="failnote.txt"/> </notification>
<log option="noJob"/>
<!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
<property name="repositoryConn" value="repo_db_username/repo_db_password_at_repo_db_tnsname" confidential="yes" encrypted="no"/>
</jobStatusRepository--> <!--trace traceOpts="trace_all"/--> <connection maxConnect="20" idleTimeOut="15"> <orbClient id="RWClient" publicKeyFile="clientpub.key"/> <cluster publicKeyFile="serverpub.key" privateKeyFile="serverpri.key"/> </connection> <queue maxQueueSize="1000"/> <!--identifier confidential="yes" encrypted="no">scott/tiger</identifier--> <pluginParam name="mailServer"/> <!--pluginParam name="proxy" type="file">proxyinfo.xml</pluginParam--> <pluginParam name="xmlpds" type="file">xmlpds.conf</pluginParam><pluginParam name="jdbcpds" type="file">jdbcpds.conf</pluginParam> <pluginParam name="textpds" type="file">textpds.conf</pluginParam> </server>
Your feedback is appreciated with regards to these error messages.
Regards,
PT
-- Message posted via http://www.oraclemonster.comReceived on Wed Dec 01 2004 - 23:40:00 CET