You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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-

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!