Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Uddaraju Rnr
    BI Publisher FTP Issues
    Topic posted December 14, 2018 by Uddaraju RnrGreen Ribbon: 100+ Points, last edited September 11, 2019, tagged Home & Catalog, Reporting 
    490 Views, 1 Comment
    Title:
    BI Publisher FTP Issues
    Summary:
    Not able to FTP a file from BIP server to FTP server. I am not able to add the Server name as well as I have tired using Bursting.
    Content:

    Hi,

     

    I am working on BI Publisher FTP server setup. The FTP Server is a FTPS on DMZ domain. And it seems like Oracle supports only SFTP.

     

    Good news is that, I am able to connect from BIP Server to FTP Server using WinScp via FTP connection type. But, when I am trying to add the same server details in BI Publisher it errors out.

     

    We have a requirement, where we want to send an email to the user community after the BI Publisher Schedule job has successfully done FTP(ing) the output on the FTP server.

     

    As we are not able to add this FTP Server, we tried to see if we can try by bursting technique, which also failed.

     

    if I use DEL_CHANNEL in bursting as SFTP, I get the below error:-

    Document delivery failed

    [INSTANCE_ID=bip.bi_server1] Error sending job to delivery queueoracle.xdo.servlet.scheduler.ProcessingException: Error sending job to delivery queue

    at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.sendToDeliveryQueue(BurstingReportProcessor.java:1153)

    at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.onMessage(BurstingReportProcessor.java:195)

    at oracle.xdo.enterpriseScheduler.util.CheckpointEnabledListener.onMessage(Checkpo

     

    if I use DEL_CHANNEL in bursting as FTP, I get the below error:-

    Document delivery failed

    [INSTANCE_ID=bip.bi_server1] [DELIVERY_ID=-1]Error deliver document to FTP

    Exception happened when calling deliver API

    Error deliver document to FTP

    FILE=[

    Exception happened when calling deliver API

    oracle.xdo.delivery.MissingRequiredPropertyException: Required property missing. Property name :[SFTP_HOST]oracle.xdo.service.delivery.DeliveryException: oracle.xdo.delivery.MissingRequiredPropertyException: Required property missing. Property name :[SFTP_HOST]

    at

     

    Could anyone suggest any solution for this issue?

     

    As I am able to do the above task manually by connecting to WinScp. But looking for automate process, so that users can view the files as soon as they get the email. Is it possible to configure WinScp into OBIEE?

     

    Thank you very much in advance,

    Rama

    Version:
    12.2.1.4.0

    Comment

     

    • Koteswararao Yenikepalli

      You need to open the port 22

       

      once you open the port in the fusion instance then those ftp will be live and the you can able to send the data to the ftp servers