Getting error while bursting BIP report output to sFTP server
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-