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