Hi
We 've got an error when we import the data via the FDM web client:(See attached error message)
It looks like the bulk load process cannot access the share folder "\\fdm1\FDMData\FDM\Inbox\", but we do have "everyone" granted with r/w at both the share and NTFS security levels. Sine it showed as the O/S error code 1326, and I googled and found someone saying that the SQL service account needs to have access to the share folder. I checked and found that we are NOT using a domain account for the "SQL Server" service. Also checked the Security Log, there is an Audit Failure of the local SQL service account trying to access the FDM server.
Before we can change the SQL Service account to a domain account (because I am afraid there is any impact to the EPM applications that all use the same SQL instance), is there any other way that I can specify another domain account for the FDM bulk load process to access the file share (inbox folder)?
thanks a lot! Any advice is welcome!
** Begin FDM Runtime Error Log Entry [2013-12-09 15:22:49] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... Cannot bulk load because the file "\\fdm1\FDMData\FDM\Inbox\tWxxx165246169991.tmp" could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad password.).
BULK INSERT FDM..tWxxx165246169991 FROM N'\\fdm1\FDMData\FDM\Inbox\tWxxx165246169991.tmp' WITH (FORMATFILE = N'\\fdm1\FDMData\FDM\Inbox\tWxxx165246169991.fmt',DATAFILETYPE = N'widechar',ROWS_PER_BATCH=76839,TABLOCK)
Procedure........................................ clsDataManipulation.fExecuteDML
Component........................................ upsWDataWindowDM
Version.......................................... 1112
Thread........................................... 4616
IDENTIFICATION:
User............................................. xxx
Computer Name.................................... FDM1
App Name......................................... FDM
Client App....................................... WebClient
CONNECTION:
Provider......................................... SQLOLEDB
Data Server...................................... sql1\epmprd
Database Name.................................... FDM
Trusted Connect.................................. False
Connect Status.. Connection Open
GLOBALS:
Location......................................... LOC1
Location ID...................................... 750
Location Seg..................................... 4
Category......................................... Actual
Category ID...................................... 13
Period........................................... Oct - 2012
Period ID........................................ 10/31/2012
POV Local........................................ True
Language......................................... 1033
User Level....................................... 1
All Partitions................................... True
Is Auditor....................................... False
** Begin FDM Runtime Error Log Entry [2013-12-09 15:22:49] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... Data access error.
Procedure........................................ clsImpDataPump.fImportTextFile
Component........................................ upsWObjectsDM
Version.......................................... 1112
Thread........................................... 4616
IDENTIFICATION:
User............................................. xxx
Computer Name.................................... FDM1
App Name......................................... FDM
Client App....................................... WebClient
CONNECTION:
Provider......................................... SQLOLEDB
Data Server...................................... sql1\epmprd
Database Name.................................... FDM
Trusted Connect.................................. False
Connect Status.. Connection Open
GLOBALS:
Location......................................... LOC1
Location ID...................................... 750
Location Seg..................................... 4
Category......................................... Actual
Category ID...................................... 13
Period........................................... Oct - 2012
Period ID........................................ 10/31/2012
POV Local........................................ True
Language......................................... 1033
User Level....................................... 1
All Partitions................................... True
Is Auditor....................................... False
** Begin FDM Runtime Error Log Entry [2013-12-09 15:22:50] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... Data access error.
Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
Component........................................ upsWObjectsDM
Version.......................................... 1112
Thread........................................... 4616