nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE Publisher FTP Question

dilek

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

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

BIP bursting
Adding Bursting Definitions

dilek

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]

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

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

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

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]

As I said...accounts :-P