Re: REP-51018 + REP-50004 Errors

From: Paolo Treves via OracleMonster.com <forum_at_OracleMonster.com>
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.com
Received on Wed Dec 01 2004 - 23:40:00 CET

Original text of this message