BI Publisher SFTP Bursting is failing with oracle.xdo.delivery.MissingRequiredPropertyException: Required property missing (Doc ID 1989968.1)

Last updated on SEPTEMBER 12, 2021

Applies to:

Symptoms

POD:hufu : BI publisher SFTP bursting is not working

Description:
--------------
BI Publisher report SFTP bursting is failing with the following errors

Error Message:
-----------------
Delivery failed.
[INSTANCE_ID=chfar02150m04.usdc2.oraclecloud.com.1421514728675] [SUBJOB_ID=5167]
Document delivery failed
[INSTANCE_ID=chfar02150m04.usdc2.oraclecloud.com.1421514728675] [DELIVERY_ID=3928]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 mis
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Schedule a report to run as a BI Publisher Job and deliver the output to ftp server

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.