4 Replies Latest reply: Jan 25, 2017 6:20 PM by navaneeth narayanan 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.

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

          jmgarwood,

          I am experiencing the EXACT same thing, and it's nice to see that someone else has seen it to verify that I'm not losing my mind! It sounds like we have similar environments as well. I'm running version 8.5 Publisher on a 64 bit, 128Gb, 12 CPU dedicated box, so I can tell you with pretty good certainty that upgrading your hardware is not going to solve this. I've looked at other processes running at the same time but haven't found any possible contention issues. And, if I just click the green arrow on Publisher when the error occurs, it magically runs successfully. I have not been able to recreate it on demand, but I do have two jobs that both fail regularly. One of them is a weekly job, and it fails every time it runs via the scheduler. The other is a daily job that fails on Monday mornings. The weekly job runs on Monday morning as well. I have lots of other jobs that perform similar update tasks that run daily and weekly with no issues ever. If I find anything, I'll certainly post it here. I'd appreciate it if you would do the same.

           

          Thanks,

          Bret