Hi Team,
Please advise if any one has faced issue using BI report bursting for SFTP and share the solution/idea please.
We are trying to send file to SFTP location using report bursting by scheduling report but it is failing with below error message.
*********ERROR MESSAGE*************
Document delivery failed
[INSTANCE_ID=bip.bi_server1] [DELIVERY_ID=-1]
Delivery is completed
[INSTANCE_ID=bip.bi_server1] [FTPProcessor]Delivery to SFTP completed with failure Server [sftp.myonex.com] does not exist or user does not have permission to access the server.
=> Working Scenario:
If we schedule the report and open from "REport Job History" and use the Option "Send" then select Destination Type as "FTP" the file is sent successfully to SFTP server.
********Sample Bursting Script which we used*********
select distinct
receipt_num as "KEY"
,'PRODUCT LABEL REPRINT' TEMPLATE
,'en-US' LOCALE
,'XML' OUTPUT_FORMAT
,receipt_num OUTPUT_NAME
,'FTP' DEL_CHANNEL
,'sftp.***.com' PARAMETER1 -- Server Name
,'dummy' PARAMETER2 -- Username
,'dummy' PARAMETER3 -- Password
,'/Reprint/' PARAMETER4 --Remote Directory
,receipt_num||'_reprint.xml' PARAMETER5 -- Remote Filename
,'true' PARAMETER6 --Secure (set this value to 'true' to enable Secure FTP)
from rcv_shipment_headers where receipt_num = :ReceiptNumber
Appreciate your suggestions.
Thanks,
Jhansi
