This discussion is archived
4 Replies Latest reply: Dec 12, 2013 6:46 AM by amith.madisetty RSS

FDM bulk load error

ezlee Newbie
Currently Being Moderated

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

  • 1. Re: FDM bulk load error
    amith.madisetty Journeyer
    Currently Being Moderated

    Hi,

     

    The Service Account is not of SQL its the service accounts which was used while configuring FDM. Its basically because it stores all its data under inbox,outbox,reports etc folders structures and to have complete access as a administrator its suggested to have service account , make sure service account with which you login has full complete access on Shared Path. Also FDM1 is server if am not wrong try pinging the server from FDM app server if its not FDM1 from where you are trying to import.

     

    Also make sure password for that Service account is set as never expired.

     

    Thanks

    Amith

  • 2. Re: FDM bulk load error
    ezlee Newbie
    Currently Being Moderated

    Thank you for your reply, Amith!

    But I know it is trying to use the SQL service account to access the share folder by looking at the Security Event log on the FDM1 server.

    There is an "Audit Failure" and access attempt was from the SQL server with the local SQL Service account - Logon failure: unknown user name or bad password, exactly as the FDM bulk load error:

    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.)


    I would like to use the service account which configured FDM and other EPM components as you mentioned, that account is a domain account that has the access to the share folder.

    But don't know how can I change it that way...


    thanks, ezlee

  • 3. Re: FDM bulk load error
    JeffJon Guru
    Currently Being Moderated


    The account that is going to be used to attempt to open the .tmp and .fmt files that are generated with the bulk insert command is the windows account that is configured to run the MSSQL Windows Service on the Database Server.  You can view this account within the SQL Server Configuration Manager and view the properties of the SQL Server Service and view the Identity Tab.     This account must have the ability to read/write to the FDMDATA folder and all sub-folders.    

  • 4. Re: FDM bulk load error
    amith.madisetty Journeyer
    Currently Being Moderated

    Hi,

     

    Is the issue resolved now, what was the resolution step which helped you.

     

    Thanks

    Amith

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points