Directory Link Changes in Windows 2019 Breaks FDMEE/FDM Integration

FDMEE
Written By Brad Spelman

In previous version of Oracle EPM HFM and FDMEE, it is possible to place HFM and FDMEE in separate instances on the same server. The use of the Windows command ‘mklink /d’ allows the FDMEE application to drop data into the HFM instance folder in this configuration. After 11.2.5 it is recommended to place both HFM and FDMEE, if on the same server, into a single instance.  For those installations of 11.2.4 and earlier, and using Windows 2019, it is important to note that the behavior of directory links has changed – the operating system no longer consistently reads the link as a directory! The issue can be seen when running a data load – FDMEE looks for the presence of the FileTransferData folder and if it does not find it, creates the folder and drops its payload in a subdirectory there in the FDMEE instance. The MKLINK command in Windows 2019 has to be changed to use /j – creating a junction instead of a directory link. Below is an example of the new process:

  • Navigate to E:\Oracle\Middleware\user_projects\FDMEE1\products\FinancialManagement

  • Delete the folder FileTransferData

  • Open a command prompt and navigate to E:\Oracle\Middleware\user_projects\FDMEE1\products\FinancialManagement

  • Execute the following command:

    • Mklink /j FileTransferData E:\Oracle\Middleware\user_projects\FM1\products\FinancialManagement\FileTransferData

Brad Spelman
Previous

EPM version 11.2 support for Essbase – you’re covered
Next

Oracle publishes January 2022 Critical Patch update – What you need to know for EPM