File Import Error

Problem: When attempting to perform an import of a GL file into FDM, the following error message (or similar) is returned: Error: An error occurred importing the file!Detail: File [C:\DOCUME~1\! <serviceaccount>\LOCALS~1\Temp\tWhypadm10936117046556-SL.log] does not exist!

Cause: When you use the Oracle SQL Loader to import data into the FDM schema within the Oracle Instance, a temp file is generated within the user profiles (C:\documents and settings\\applicationdata). When the SQL Loader is attempting to write the log to this directory it encounters an issue and the import fails.

  To verify the cause, perform the following tests:

  1. Open the FDM application.

  2. Select Metadata, and then Locations.

  3. Find the location set in the POV.

  4. Change Insert Type from Bulk Insert to SQL Insert.

  5. Click Save.

  6. Rerun the import process and verify that the import completes successfully.

    When using the SQL Insert option, the SQL Loader is not used during the import operation.

Solution: Reinstall the SQL Loader Database Utility on the FDM server by performing the following procedure:

  1. Open the FDM application.

  2. Working from the Oracle Hyperion Financial Data Quality Management, Fusion Edition server, launch the Oracle Client Installer.

  3. Choose Custom Install and click Next.

  4. Expand Database Utilities, and select the SQL Loader option or choose to install all database utilities and click Next.

  5. Choose the current Oracle home directory to install the components and click Next.

  6. When the installation is complete, click Finish.

  7. Reset the insert type that you changed in the test procedure back to Bulk Insert.