5 Replies Latest reply: Jan 31, 2018 5:23 AM by adli sval RSS

    "Cannot open file" script error during a load operation.

      A Publisher job occasionally fails with this error while reading a QVD file, and occurs with different QVD files and applications.

      I investigated to determine whether there was a 'contention' problem with two applications trying to read from the same QVD simultaneously, although it seems like that should not be a problem. I could not find any other application trying to read the file at the time of the error.

      The application reloads successfully when I restart the Publisher job with no intervening changes to the app or QVD file.

      A sample portion of a log where this occurred is noted below. Has anyone experienced this problem and/or have an idea of what is causing it?

      We are running Qlikview version 8.5, with Publisher running on the Qlikview server. The server is 64-bit with four CPUs and Windows Server 2003 OS and 32 GB of RAM. We are running VMWARE on this box.

      This problem may eventually be eliminated because we are proposing a reconfigured environment. We will be moving Publisher to its own box. The new Production server box will have 64 GB of RAM and eight CPUs but will not have VMWARE loaded on it. However, if approved, it will be a while until this is in place.






      Stockroom:
      LOAD [D06 STOCK ROOM_SURROGATE KEY],
      [D06 STOCK ROOM_SURROGATE KEY] as [STK D06 KEY],
      [STOCK ROOM S21 COMPANY CODE],
      [STOCK ROOM S21 COMPANY NAME],
      [STOCK ROOM CODE] as [WRK STOCKROOM],
      [STOCK ROOM NAME],
      [PRIMARY STOCKROOM CODE],
      [PRIMARY STOCKROOM NAME],
      [STOCK ROOM TYPE CODE],
      [STOCK ROOM TYPE NAME],
      [STOCK ROOM FACILITY TYPE CODE],
      [STOCK ROOM FACILITY TYPE NAME]

      FROM \\Jxn140qlikview00\qve\Production\QVDs\P_BIDW_T-Prd\SCA_STK_RM_DIM_DATA.qvd] (qvd)
      WHERE (([STOCK ROOM TYPE CODE] = 'DST' and [STOCK ROOM S21 COMPANY CODE] = 'D1') OR
      ([STOCK ROOM TYPE CODE] = 'DST' and [STOCK ROOM S21 COMPANY CODE] = 'PR'))
      Error: Cannot open file '\\Jxn140qlikview00\qve\Production\QVDs\P_BIDW_T-Prd\SCA_STK_RM_DIM_DATA.qvd'
      General Script Error
      Execution Failed
      Execution finished.