This content has been marked as final. Show 6 replies
Oracle or SQL Server DB?1 person found this helpful
If Oracle, the SQLLDR component needs to be on the server
If SQL, the service account running the SQL Server service needs read write access to the FDM Share.
Thanks for the reply.
I have Oracle Database and the version is 126.96.36.199; So even for this version do I need to have SQLLDR.exe on the server where FDM is installed.
Edited by: user10720012 on May 16, 2011 11:42 AM
I have SQLLDR application available on the server in the bin directory.
Do I need to install it?
Yes, SQL Loader is required. it needs to be installed on each FDM application server in the environment. You should be able to open a command prompt on the server and type sqlldr and hit the enter key and receive information back and not a File not found error.1 person found this helpful
Yes SQLLDR is there on the FDM server, Still I am gettting the below error:
An error occurred importing the file.
Detail: File does not exist or access denied.
Edited by: user10720012 on May 16, 2011 3:19 PM
Are you importing a simple flat file or a trail balance template of some sort? What is the full contents of the user error log if you choose Tools > Clear Error Log and then re-run the import to reproduce the error and choose Tools > View Error Log?