1 Reply Latest reply on May 14, 2012 12:40 PM by sfr.farhan

    how to setup in-process report server 11g on linux for destype=mail

    sfr.farhan
      Currently, getting Error when send report as an email attachment destype=mail. Is there any thing missed out during Mail server configuration?

      REP-50159: The report generated successfully but distribution to destinations failed.
      REP-50152: Destination ID ProfitLoss failed with error An error occurred while sending mail: null..

      Call report via Oracle form with destype=mail, desformat=PDF and desname=sfarhan@saudiorix.com.sa

      Log file: rwserver_diagnostic.log

      [2012-05-13T17:04:39.273+03:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-50152] [oracle.reports.server] [tid: 16] [userId: <anonymous>] [ecid: 0000JT6ULwsATOG6yz6iMG1Ffvn4000000,1:18567] [APP: reports#11.1.2] REP-50152 : An error occurred while sending mail: null. [[
      oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
           at oracle.reports.utility.Utility.newRWException(Utility.java:1053)
           at oracle.reports.server.MailService.send(MailService.java:588)
           at oracle.reports.server.DesMail.sendFile(DesMail.java:186)
           at oracle.reports.server.Destination.send(Destination.java:578)
           at oracle.reports.server.JobObject.distribute(JobObject.java:2041)
           at oracle.reports.server.JobManager.updateJobStatus(JobManager.java:2763)
           at oracle.reports.server.EngineCommImpl.updateEngineJobStatus(EngineCommImpl.java:154)
           at oracle.reports.server.EngineCommPOA._invoke(EngineCommPOA.java:94)
           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
      ]]

      Able to print report via Oracle form with destype=CACHE, desformat=PDF.

      Mail Server Parameters are defined.

      EM > Reports Application Basic Configuration > Mail Server Parameters

      Mail Server, Mail Server Port, Mail Server Username, Mail Server Password Key.

      Environment:

      Server Side:
      Oracle Linux 5
      Oracle Weblogic Server 10.3.6
      Oracle FMW Forms and Report 11.1.2
      Configure: In-Process Report Server

      Client Side:
      Window 7