4 Replies Latest reply on Dec 12, 2013 2:46 PM by amith.madisetty

    FDM bulk load error

    ezlee

      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

          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

            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


              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

                Hi,

                 

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

                 

                Thanks

                Amith