4 Replies Latest reply on Mar 23, 2011 8:51 PM by beyerch2

    FDM. Data acces error

    838683
      Hello,

      Would need someone to help me with error that I get to import a file through FDM. Below I am attaching the error log.

      ** Begin FDM Runtime Error Log Entry [2011-03-22-10:13:56] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Cannot bulk load because the file "\\ringbearer.sco.grupocatalanaoccidente.com\APP\FDMGCO\Inbox\tWadmin550827407062.tmp" could not be opened. Operating system error code 5(Access is denied.).
      BULK INSERT CONSOGCO..tWadmin550827407062 FROM N'\\ringbearer.sco.grupocatalanaoccidente.com\APP\FDMGCO\Inbox\tWadmin550827407062.tmp' WITH (FORMATFILE = N'\\ringbearer.sco.grupocatalanaoccidente.com\APP\FDMGCO\Inbox\tWadmin550827407062.fmt',DATAFILETYPE = N'widechar',ROWS_PER_BATCH=4,TABLOCK)
      Procedure........................................ clsDataManipulation.fExecuteDML
      Component........................................ upsWDataWindowDM
      Version.......................................... 1111
      Thread........................................... 2740

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... RINGBEARER
      App Name......................................... FDMGCO
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... ringare.sco.grupocatalanaoccidente.com
      Database Name.................................... CONSOGCO
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... AT00
      Location ID...................................... 759
      Location Seg..................................... 11
      Category......................................... REAL
      Category ID...................................... 12
      Period........................................... dic - 2010
      Period ID........................................ 12/31/2010
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2011-03-22-10:13:56] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Data access error.
      Procedure........................................ clsImpDataPump.fImportTextFile
      Component........................................ upsWObjectsDM
      Version.......................................... 1111
      Thread........................................... 2740

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... RINGBEARER
      App Name......................................... FDMGCO
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... ringare.sco.grupocatalanaoccidente.com
      Database Name.................................... CONSOGCO
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... AT00
      Location ID...................................... 759
      Location Seg..................................... 11
      Category......................................... REAL
      Category ID...................................... 12
      Period........................................... dic - 2010
      Period ID........................................ 12/31/2010
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2011-03-22-10:13:56] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Data access error.
      Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
      Component........................................ upsWObjectsDM
      Version.......................................... 1111
      Thread........................................... 2740

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... RINGBEARER
      App Name......................................... FDMGCO
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... ringare.sco.grupocatalanaoccidente.com
      Database Name.................................... CONSOGCO
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... AT00
      Location ID...................................... 759
      Location Seg..................................... 11
      Category......................................... REAL
      Category ID...................................... 12
      Period........................................... dic - 2010
      Period ID........................................ 12/31/2010
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      Thanks and regards.
        • 1. Re: FDM. Data acces error
          848933
          Check if the folder "FDMGCO" on the server is shared and has been granted access.

          go to the properties of the folder and sharing, enable the sharing and also provide full access to the username used while creating this application.

          i would also suggest to add the username "everyone" in the security and provide full access to this folder including its sub folders.
          • 2. Re: FDM. Data acces error
            848933
            also try to open this document in oracle site "Import Error: "Cannot Bulk Load Because the File "D:\Application Path\*.tmp" Could Not be Opened. Operating System Error Code 3 (The System Cannot Find the Path Specified.)" [ID 761066.1]"

            may be of some help
            • 3. Re: FDM. Data acces error
              JeffJon
              The windows account that is running the MSSQL Service on the SQL Server does not have read permission to the FDM application folder share. In order to perform the bulk insert process, the account must be able to read from the inbox directory to read the .tmp file generated during the import process. The error code 5 shows that it is unable to read the .tmp file in the inbox directory to complete the process.
              • 4. Re: FDM. Data acces error
                beyerch2
                Second the comment about making sure the SQL Server account has access to that folder/files.