This discussion is archived
2 Replies Latest reply: Feb 19, 2013 8:50 PM by 645106 RSS

FRM- 41213 after <destination> tag added on reserver.conf for pluggable D.S

645106 Newbie
Currently Being Moderated
I have added destination tag entry to rwserver.conf as instructed in the Oracle Documentation for Pluggable Datasource "SecurePdfDestination".

After adding below entry to rwserver.conf,

<destination destype="SecurePDF" class="oracle.reports.plugin.destination.securepdf.SecurePdfDestination"/>

the reports server does not seem to start up correctly, the Oracle Form application from which I use to run the reports will throw an error: FRM- 41213: Unable to connect to the report server error

However when I remove above <destination>entry and restart the server, the reports server resumes good and well,

As a result, I am not able to use the Pluggable Data Source from our Oracle Forms Application,

I cannot find any comprehensive logs on my server regarding this issue, the below are some details:

---------------------------------------------------------------------------------------------------------------------------------------------------------

[2013-02-18T23:15:51.307+07:00] [reports] [INCIDENT_ERROR] [REP-50002] [oracle.reports.server] [tid: 14] [ecid: 0000JnhpDZ56aMH6yvmZMG1H8^B6000000,0:1:100000001] REP-50002 : The server is shutting down. [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
     at oracle.reports.utility.Utility.newRWException(Utility.java:1046)
     at oracle.reports.server.RWServer.stateCheck(RWServer.java:1545)
     at oracle.reports.server.ConnectionImpl.callCheck(ConnectionImpl.java:2979)
     at oracle.reports.server.ConnectionImpl.disconnect(ConnectionImpl.java:757)
     at oracle.reports.server.ConnectionPOA._invoke(ConnectionPOA.java:309)
     at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
     at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1682)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1540)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:922)
     at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:694)
     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:451)
     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1213)
     at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:471)
     at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:500)

]]
[2013-02-18T23:15:51.307+07:00] [reports] [INCIDENT_ERROR] [REP-50002] [oracle.reports.server] [tid: 14] [ecid: 0000JnhpDZ56aMH6yvmZMG1H8^B6000000,0:1:100000001] REP-50002 : The server is shutting down. [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
     at oracle.reports.utility.Utility.newRWException(Utility.java:1046)
     at oracle.reports.server.RWServer.stateCheck(RWServer.java:1545)
     at oracle.reports.server.ConnectionImpl.callCheck(ConnectionImpl.java:2979)
     at oracle.reports.server.ConnectionImpl.disconnect(ConnectionImpl.java:757)
     at oracle.reports.server.ConnectionPOA._invoke(ConnectionPOA.java:309)
     at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
     at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1682)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1540)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:922)
     at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:694)
     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:451)
     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1213)
     at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:471)
     at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:500)

]]
[2013-02-18T23:15:59.713+07:00] [reports] [NOTIFICATION] [] [oracle.reports.server] [tid: 10] [ecid: 0000Jni5mJX6aMH6yvmZMG1H8_Ez000001,0] ServerConfig:logConf Reading server config file D:\Oracle\Middleware\asinst_1\config\ReportsServerComponent\ReportsServer_BPK-SPMApp_asinst_1\rwserver.conf
[2013-02-18T23:15:59.713+07:00] [reports] [NOTIFICATION] [] [oracle.reports.server] [tid: 10] [ecid: 0000Jni5mJX6aMH6yvmZMG1H8_Ez000001,0] ServerConfig:logConf <server version="11.1.1.2.0" xmlns="http://xmlns.oracle.com/reports/server">[[
<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"/-->
</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" maxEngine="10" minEngine="1" engLife="1" classPath="D:\Oracle\Middleware\as_1\reports\jlib\itextpdf-5.3.5.jar">
<property name="sourceDir" value="D:\SPM2011\rep;D:\SPM2011\TNS\rep"/>
<!--property name="tempDir" value="your reports temp directory"/-->
<!--property name="keepConnection" value="yes"/-->
</engine>
<engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" maxEngine="10" minEngine="0" engLife="1" classPath="D:\Oracle\Middleware\as_1\reports\jlib\itextpdf-5.3.5.jar"/>
<security id="rwJaznSec" class="oracle.reports.server.RWJAZNSecurity"/>
<!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">
<property name="dbuser" value="$$PORTAL_DB_USERNAME$$"/>
<property name="dbpassword" value="csf:$$CSF_ALIAS$$:$$PORTAL_DB_PASSWORD_KEYE$$"/>
<property name="dbconn" value="$$PORTAL_DB_TNSNAME$$"/>
</destination-->
<destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP"/>
<destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV"/>
<destination destype="SecurePDF" class="oracle.reports.plugin.destination.securepdf.SecurePdfDestination"/>
<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>
<!--notification id="wfNotify" class="oracle.reports.server.WorkflowNotify">
<property name="connStr" value="%WF_DB_USERNAME%/%WF_DB_PASSWORD%@%WF_DB_TNSNAME%" encrypted="no"/>
</notification-->
<!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
<property name="dbuser" value="$$REPO_DB_USERNAME$$"/>
<property name="dbpassword" value="csf:$$CSF_ALIAS$$:$$REPO_DB_PASSWORD_KEYE$$"/>
<property name="dbconn" value="$$REPO_DB_TNSNAME$$"/>
</jobStatusRepository-->
<connection maxConnect="50" idleTimeOut="15"/>
<queue maxQueueSize="1000"/>
<!--jobRecovery auxDatFiles="yes"/-->
<proxyInfo>
<proxyServers>
<proxyServer name="proxy.XXXX.XX.XX" port="9999" protocol="all"/>
</proxyServers>
<bypassProxy/>
</proxyInfo>
<pluginParam name="mailServer" value="%MAILSERVER_NAME%">
<!--property name="enableSSL" value="yes"/-->
<!--UserName and Password that can be used to connect to the mail server-->
<!--property name="mailUserName" value="%MAIL_USERID%" /-->
<!--property name="mailPassword" value="%MAIL_PASSWORD%"/-->
</pluginParam>
</server>

-------------------------------------------------------------------------------------------------------------------------------------------

Edited by: user642103 on Feb 18, 2013 8:15 PM
  • 1. Re: FRM- 41213 after <destination> tag added on reserver.conf for pluggable D.S
    Kishore Rout Journeyer
    Currently Being Moderated
    Hi,
    Can you please check the class "oracle.reports.plugin.destination.securepdf.SecurePdfDestination" and make sure that it is correct. Make sure the class name is in correct word case (class name is case sensitive) and should be in one line.

    Try with below entry and check error is coming or not.
    <destination destype="SecurePDF" class="oracle.reports.plugin.destination.securepdf.SecurePDFDestination"/>

    Mark If this helps you.

    Regards,
    Kishore
  • 2. Re: FRM- 41213 after <destination> tag added on reserver.conf for pluggable D.S
    645106 Newbie
    Currently Being Moderated
    Thanks, I had copied my original line of <destination> tag from Oracle Documentation so I am pretty confident that I have done it right,

    Also, in order to confirm that I had correctly specified REPORTS_CLASSPATH to reference to SecurePdfDestination.jar,

    I would like to attach the line from "dms.log" in application server,

    As you can see from the log, the "classPath" value point to correct jar files:
    -------------------------------------------------------------------------------------------------------------------------------------------------
    classPath.value:     D:\Oracle\Middleware\as_1\reports\jlib\rwbuilder.jar;D:\Oracle\Middleware\as_1\reports\jlib\rwrun.jar;D:\Oracle\Middleware\as_1\jlib\zrclient.jar;D:\Oracle\Middleware\as_1\reports\jlib\itextpdf-5.3.5.jar;D:\Oracle\Middleware\as_1\reports\jlib\plop.jar;D:\Oracle\Middleware\as_1\reports\jlib\SecurePdfDestination.jar;
    -------------------------------------------------------------------------------------------------------------------------------------------------

    Never the less, I will re-try with the entry line suggested in above thread and revert to you with the result,

    Edited by: junny on Feb 19, 2013 8:49 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points