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