OBIEE Publisher FTP Question — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Publisher FTP Question

Received Response
31
Views
7
Comments
dilek
dilek Rank 6 - Analytics Lead
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

Hello everybody,

In our company, we send an email (including daily report) in daily routines to all company staff. However, sending an email brings a huge network traffic, what we don't want :S So, we want to send this report via FTP, and only an send path information via email. How can I do this? I do not know where to start?

Thank you for your attention.

Regards,

Dilek

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    BIP bursting
    Adding Bursting Definitions

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi,

    I tried the steps written on the guide. However, I face the following error;

    [INSTANCE_ID=prd-intrarapor-n128.1508356316425] [OUTPUT_ID=3324]

    [INSTANCE_ID=prd-intrarapor-n128.1508356316425] [DELIVERY_ID=3302]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.DeliveryException: oracle.xdo.delivery.ssh2.SshException: File cannot be opened for writing.oracle.xdo.service.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException: oracle.xdo.delivery.ssh2.SshException: File can

    Why this is the case? I can connect FTP server via WİNSCP and when I test the connection, publisher successfully connect my ftp server. Do I make something wrong?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Are you sure it's the same accounts actually opening the connections and trying to access? Because if you use your account and then the service account tries to connect then you're cmparing apples and oranges.

  • dilek
    dilek Rank 6 - Analytics Lead

    I do not understand what you mean by 'the same accounts' :S When I try to telnet from OBIEE machine to FTP server, it successfully connects. However, document is not sent to FTP server.

    Error details are;


    [INSTANCE_ID=prd-intrarapor-n128.1508356316425] [OUTPUT_ID=3328]
    [INSTANCE_ID=prd-intrarapor-n128.1508356316425] [DELIVERY_ID=3306]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.DeliveryException: oracle.xdo.delivery.ssh2.SshException: Exception in authenticatingoracle.xdo.service.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException: oracle.xdo.delivery.ssh2.SshException: Exception in au

  • Rajesh Dhanapal
    Rajesh Dhanapal Rank 4 - Community Specialist

    Hi,

    Hope your configuration in BIP Publihser, Manage BI Publisher, Delivery, FTP is successful. Did you check the option Use Passive Mode to true? If not please chek this option and try to see whether you are able to generate the files in the FTP location.

    Best regards,

    Rajesh Dhanapal.

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi, I solved this problem by using same USERNAME & PASSWORD for FTP setting and Report job setting. Then, it worked!

    Thank you again.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    As I said...accounts :-P