1 Reply Latest reply on Aug 29, 2011 1:51 PM by JeffJon

    FDM Import error: Data access error.

    user13362532
      Dear experts,
      Since today I cannot load any files to FDM anymore. The error message is:
      "Error: An error occurred importing the file.
      Detail: Data access error."

      Watch the error log below to see the details; it looks like FDM can't create a temp-file anymore.

      ** Begin FDM Runtime Error Log Entry [2011-08-29-09:27:41] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Cannot bulk load because the file "\\cgpbi03.comet.ch\fdm\FDMprod\Inbox\tWhaasfa24424231564536.tmp" could not be opened. Operating system error code 5(error not found).
      BULK INSERT FDM113_prod..tWhaasfa24424231564536 FROM N'\\cgpbi03.comet.ch\fdm\FDMprod\Inbox\tWhaasfa24424231564536.tmp' WITH (FORMATFILE = N'\\cgpbi03.comet.ch\fdm\FDMprod\Inbox\tWhaasfa24424231564536.fmt',DATAFILETYPE = N'widechar',ROWS_PER_BATCH=1137,TABLOCK)
      Procedure........................................ clsDataManipulation.fExecuteDML
      Component........................................ upsWDataWindowDM
      Version.......................................... 1111
      Thread........................................... 23156

      IDENTIFICATION:
      User............................................. haasfa
      Computer Name.................................... CGPBI03
      App Name......................................... FDMprod
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... cchdb03.comet.ch
      Database Name.................................... FDM113_prod
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... FLA_SAP_BS
      Location ID...................................... 751
      Location Seg..................................... 4
      Category......................................... Act
      Category ID...................................... 12
      Period........................................... Aug - 2011
      Period ID........................................ 8/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2011-08-29-09:27:42] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Data access error.
      Procedure........................................ clsImpDataPump.fImportTextFile
      Component........................................ upsWObjectsDM
      Version.......................................... 1111
      Thread........................................... 23156

      IDENTIFICATION:
      User............................................. haasfa
      Computer Name.................................... CGPBI03
      App Name......................................... FDMprod
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... cchdb03.comet.ch
      Database Name.................................... FDM113_prod
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... FLA_SAP_BS
      Location ID...................................... 751
      Location Seg..................................... 4
      Category......................................... Act
      Category ID...................................... 12
      Period........................................... Aug - 2011
      Period ID........................................ 8/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False


      ** Begin FDM Runtime Error Log Entry [2011-08-29-09:27:43] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Data access error.
      Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
      Component........................................ upsWObjectsDM
      Version.......................................... 1111
      Thread........................................... 23156

      IDENTIFICATION:
      User............................................. haasfa
      Computer Name.................................... CGPBI03
      App Name......................................... FDMprod
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... cchdb03.comet.ch
      Database Name.................................... FDM113_prod
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... FLA_SAP_BS
      Location ID...................................... 751
      Location Seg..................................... 4
      Category......................................... Act
      Category ID...................................... 12
      Period........................................... Aug - 2011
      Period ID........................................ 8/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      Thanks in advance for your help!!

      BR,
      Fabian Haas
        • 1. Re: FDM Import error: Data access error.
          JeffJon
          The windows account that is configured to run the MSSQL Service on the Database Server does not have read access to the FDM application folder and it's inbox directory in order to read the .tmp and .fmt files that are generated to perform the bulk insert operation.

          You need to make sure that this account has the ability to read from this directory.