FDM Import Error Bulk Insert Method

(Doc ID 2410716.1)

Last updated on JUNE 13, 2018

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.3.500 and later
Information in this document applies to any platform.

Symptoms

Executing a dataload process using Bulk Insert method, customer is receiving error message stating during the Import process.

  "Cannot bulk load because the file "\\Oracle\FDMData\<Application Name>\Inbox\xxxxxxxxxxxxxxxxxxx.tmp" could not be opened."

Reviewing the FDM User Error Log File;

ERROR:
Code............................................. -2147217900
Description...................................... Cannot bulk load because the file "\\Oracle\FDMData\<Application Name>\Inbox\xxxxxxxxxxxxxxxxxxx.tmp" could not be opened. Operating system error code 3(The system cannot find the path specified.).
BULK INSERT FDM_NEWAPP..tWadmin887650203123 FROM N'\\Oracle\FDMData\<Application Name>\Inbox\xxxxxxxxxxxxxxxxxxx.tmp' WITH (FORMATFILE = N'\\Oracle\FDMData\<Application Name>\Inbox\xxxxxxxxxxxxxxxxxxx.fmt',DATAFILETYPE = N'widechar',ROWS_PER_BATCH=28695,TABLOCK)
Procedure........................................ clsDataManipulation.fExecuteDML
Component........................................ upsWDataWindowDM

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms