Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Cannot get bat file triggered from FDM (web or workbench)

I have created a bat file that simply 7zip to unzip an HFM extended analytics extract which will be loaded to Hyperion Planning. This bat file works perfectly when manually run while on the FDM server (same credentials used for FDM application logon). The bat file contents are below and it is currently placed in the FDM inbox next to the file it is intended to unzip.
________________________BAT FILE CONTENTS_________________
for /R "D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\fdmdata\FDMPRD\Inbox\EAEXTRACT" %%I in ("*.gz") do (
"%ProgramFiles%\7-Zip\7z.exe" x -y -o"%%~dpI" "%%~fI"
)
_____________________________________________________________
Then, in a Custom (general) FDM script I have tried to trigger the bat file several 3 different ways but none of them work.
_____________________FDM SCRIPT CONTENTS___________________
Sub EAExtract
Dim BatPath
BatPath = "D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\fdmdata\FDMPRD\Inbox\EAEXTRACT\unzip.bat"
API.DataWindow.Utilities.mShellAndWait BatPath,60 'Attempt 1 to trigger bat file
DW.Utilities.mShellAndWait BatPath,-1 'Attempt 2 to trigger bat file
Set WshShell = CreateObject("WScript.Shell") 'Attempt 3 to trigger bat file
WshShell.Run BatPath, 3, Run
End Sub
_____________________________________________________________
Based on what I have read all three of these attempts above should worked. Can someone please give me a little assist on this? The same behavior occurs on the FDM workbench and the web client. FDM says the script runs successfully but nothing happens.
Thank you
Best Answer
-
I was able to resolve this issue by putting the full path to 7-zip in the bat file as opposed to using %program files% variable
Answers
-
Have you tried?
Set fdmShell = CreateObject("wscript.shell")
fdmShell .Run(strcommand)
Set fdmShell = Nothing
-
I was able to resolve this issue by putting the full path to 7-zip in the bat file as opposed to using %program files% variable