7 Replies Latest reply: Mar 29, 2012 9:37 AM by Martin van Niekerk RSS

    Reloads failing - Failed to open document

    Martin van Niekerk

      Reloads failing after upgrade from Qlikview Server SBS V9 to Qlikview Server V10 SR4.Errors: Failed to open document or failed to allocate Reload engine. I have tried to increase the available engines to 8.  Checked all user security issues and cannot seem to resolve the issue.Any help would be appreciated.

        • Reloads failing - Failed to open document
          Bill Britt

          The reload engines count should be the same as the processors. Does this happen all all task?

            • Reloads failing - Failed to open document
              Martin van Niekerk

              Bill. The server has 16 processors, runs Windows 2003 64 Bit OS. I have set the concurrent reloads to 8. The problem is consistent. It always fails. If I run the tasks manually though it works fine.

               

              This is the latest message:

              Document open threw an exception. Exception=The currently executing operation was aborted.
              The document failed to open.
              Task aborted.
              The task "QVD Folder/PnP-Unitrans-QVD/ProdData file Reader.qvw" failed. ErrorCount=3

                • Reloads failing - Failed to open document
                  Ashfaq Mohammed

                  Hi,

                   

                  ErrorCount=3 Generally refers to Syntax Error.

                   

                  I suggest you to enable the detail logging from  docements propeties --> general tab-> click on generate log file button.

                   

                  Hopefully it will show you something.

                   

                  Regards

                  ASHFAQ

                    • Reloads failing - Failed to open document
                      Martin van Niekerk

                      Herewith logfile from manual reload:

                      Manual reload work fine. Server QVB reloads falways fail with Failed to Open document error.

                      Running SBS and using Section access for security on top of NTFS.

                       

                      20/03/2012  9:43:50 AM:      Execution started.
                      20/03/2012  9:43:50 AM:      QlikView Version:10.00.9282.8
                      20/03/2012  9:43:50 AM:      CPU Target                    x64
                      20/03/2012  9:43:50 AM:      Operating System              Microsoft Windows Server 2003 R2 Service Pack 2 (64 bit edition)
                      20/03/2012  9:43:50 AM:      Wow64 mode                    Not using Wow64
                      20/03/2012  9:43:50 AM:      MDAC Version                  2.82.3959.0
                      20/03/2012  9:43:50 AM:      MDAC Full Install Version     2.82.3959.0
                      20/03/2012  9:43:50 AM:      PreferredCompression          2
                      20/03/2012  9:43:50 AM:      EnableParallelReload          1
                      20/03/2012  9:43:50 AM:      ParallelizeQvdLoads           1
                      20/03/2012  9:43:50 AM:      AutoSaveAfterReload           0
                      20/03/2012  9:43:50 AM:      BackupBeforeReload            0
                      20/03/2012  9:43:50 AM:      EnableFlushLog                0
                      20/03/2012  9:43:50 AM:      SaveInfoWhenSavingFile        0
                      20/03/2012  9:43:50 AM:      UserLogfileCharset            0
                      20/03/2012  9:43:50 AM:      OdbcLoginTimeout              -1
                      20/03/2012  9:43:50 AM:      OdbcConnectionTimeout         -1
                      20/03/2012  9:43:50 AM:      ScriptWantsDbWrite            false
                      20/03/2012  9:43:50 AM:      ScriptWantsExe                false
                      20/03/2012  9:43:50 AM:      LogFile CodePage Used:        1252
                      20/03/2012  9:43:50 AM:        1 fields found: DataPath, 1 lines fetched
                      20/03/2012  9:43:50 AM:        1 fields found: DataPath, 2 lines fetched
                      20/03/2012  9:43:50 AM:        14 fields found: ACCESS, USERID, User, Password, Active, NT Domain, NT Name, QV Lic Key, Security Group Code, Position, Phone No., Fax, E-mail Address, Notes, 32 lines fetched
                      20/03/2012  9:43:50 AM:        7 fields found: ACCESS, USERID, PASSWORD, SERIAL, NTNAME, NTDOMAINSID, SECURITYGROUPCODE, 1 lines fetched
                      20/03/2012  9:43:50 AM:        7 fields found: ACCESS, USERID, PASSWORD, SERIAL, NTNAME, NTDOMAINSID, SECURITYGROUPCODE, 33 lines fetched
                      20/03/2012  9:43:50 AM:        2 fields found: SECURITYGROUPCODE, SEC LINK CODE 01, 7 lines fetched
                      20/03/2012  9:43:50 AM:        2 fields found: SECURITYGROUPCODE, SEC LINK CODE 01, 14 lines fetched
                      20/03/2012  9:43:50 AM:        8 fields found: zClient Group, zYear, zCode, zClient, zDoc, zDoc Nr, zSALES, zGP, 12 lines fetched
                      20/03/2012  9:43:50 AM:        4 fields found: Vechile Location, Rigid, Semi, Horse, 3 lines fetched
                      20/03/2012  9:43:50 AM:        12 fields found: Cal Code, Cal Date, Cal Month, Cal Year-Per, Cal Trans Day, Cal Fisc Year, Cal Fisc Per, Cal Year Week, Cal Week, Fisc Year, Fisc Per, Cal WeekDay, 1,257 lines fetched
                      20/03/2012  9:43:50 AM:        17 fields found: Store Code, Store Name, Arrival site, Store, Region, Container, Owner, Store Profile, Area, SAP Type of Delivery, Office No, Cell No 1, Cell No 2, Cell No 3, e-mail 1, e-mail 2, e-mail 3, 395 lines fetched
                      20/03/2012  9:43:50 AM:        3 fields found: Vehicle Size, vehicle cost per km, fuel cost per km, 9 lines fetched
                      20/03/2012  9:43:50 AM:        55 fields found: Row, Branch, SEC LINK CODE 01, FileType, Tripsheet Nr, Department, Fleet, Transporter Details, Hire Order No, Fleet Details, Registration, Vehicle Size, No of Drops, Destination Type, Cross Border Area, Delivery Categroy, Planned Departure Time, Vehicle Utilisation, Shipment Nr, Store Code, Planned HUs Qty, Planned DUs Qty, Planned Departure Time for Store, Planned Arrival Time for Store, PDT_Time, DOT_Time, DOT2, Drop Nr, Actual Depart Time, Actual Return Time, Opening Odometer, Closing Odometer, Km travelled, POD Status, POD Status Reason, Actual Arrival Time at Store, Time Entering Receiving Area, Dock_TAT, Actual Departure Time at Store, Total_TAT, Vehicle_Standing_Time, TAT_Trip, TAT, TAT_OLD, Check Seals, Delay on Drop, Delayed Reason, Actual HU's Qty Delivered, Seal Nr Correct, Driver Name, Debrief Clerk Name, Cal Date, Year, Month, Day, 148,200 lines fetched
                      20/03/2012  9:43:55 AM:        57 fields found: Row, Branch, SEC LINK CODE 01, FileType, Tripsheet Nr, Department, Fleet, Transporter Details, Hire Order No, Fleet Details, Registration, Vehicle Size, No of Drops, Destination Type, Cross Border Area, Delivery Categroy, Planned Departure Time, Vehicle Utilisation, Shipment Nr, Store Code, Planned HUs Qty, Planned DUs Qty, Planned Departure Time for Store, Planned Arrival Time for Store, PDT_Time, DOT_Time, DOT2, Drop Nr, Actual Depart Time, Actual Return Time, Opening Odometer, Closing Odometer, Km travelled, POD Status, POD Status Reason, Actual Arrival Time at Store, Time Entering Receiving Area, Dock_TAT, Actual Departure Time at Store, Total_TAT, Vehicle_Standing_Time, TAT_Trip, TAT, TAT_OLD, Check Seals, Delay on Drop, Delayed Reason, Actual HU's Qty Delivered, Seal Nr Correct, Driver Name, Debrief Clerk Name, Cal Date, Year, Month, Day, DOT, PDT, 148,200 lines fetched
                      20/03/2012  9:43:58 AM:      Execution finished.

                  • Reloads failing - Failed to open document
                    Martin van Niekerk

                    The QVB process always starts up uses 10,600k memeory and then just sits there untill time-out limits are reached.

                    • Reloads failing - Failed to open document
                      Martin van Niekerk

                       

                      The task "PnP-Unitrans/PnP Debrief_Transport.qvw" failed. Part of the log file follows:

                       

                       

                       

                      3/20/2012 11:10:31 AM Error Document open threw an exception. Exception=The currently executing operation was aborted.

                       

                      3/20/2012 11:10:31 AM Error The sourcedocument failed to open.. Exception=System.Runtime.InteropServices.COMException (0x80010108): The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))

                       

                      at QlikView.IUserPreferences.set_SMTPServer(String _SMTPServer)

                       

                      at QVBWrapper.Document.Load(ILogBucket i_LogBucket)

                       

                      3/20/2012 11:10:31 AM Error The document failed to open.

                       

                      3/20/2012 11:10:31 AM Error Task aborted.

                       

                      3/20/2012 11:10:31 AM Error The task "PnP-Unitrans/PnP Debrief_Transport.qvw" failed. ErrorCount=4

                       

                    • Reloads failing - Failed to open document
                      Martin van Niekerk

                      The resolution to this issue was relating to NT Security. The user running the services did not have sufficient access to connect to some of the data sources.