Getting error while bursting BIP report output to sFTP server

Feb 3, 2025 12:58PM

Summary:

Getting below error while bursting BIP report output to sFTP server-

Below is my SFTP bursting query-

*with hash_q as query*

select
distinct HASH "KEY",
'MicroStrategy_Inventory_Rpt_Template.rtf' template,
'en-US' locale,
'text' output_format, --Output type
'FTP' del_channel, --WCC for the content server
'XXSW_MICROSTRATEGY_INVENTORY_' || :p_region || '.csv' output_name, --Primary File (or File Name)
'EMEAB2BDMZSFTP' parameter1, --Server name
NULL parameter2, --USERNAME
NULL parameter3, --password
'/outgoing/OracleCloud/COA' parameter4, --remote directory
'XXSW_MICROSTRATEGY_INVENTORY_' || :p_region || '.csv' parameter5, --Title
'True' parameter6 --secure
from hash_q

I have enabled bursting in report properties as well-

Getting error while bursting BIP report output to sFTP server

Howdy, Stranger!