Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

martinvn2
New Contributor III

Reloads failing - Failed to open document

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.

1 Solution

Accepted Solutions
martinvn2
New Contributor III

Reloads failing - Failed to open document

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.

7 Replies
Employee
Employee

Reloads failing - Failed to open document

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

martinvn2
New Contributor III

Reloads failing - Failed to open document

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

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

martinvn2
New Contributor III

Reloads failing - Failed to open document

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.

martinvn2
New Contributor III

Reloads failing - Failed to open document

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

martinvn2
New Contributor III

Reloads failing - Failed to open document

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

martinvn2
New Contributor III

Reloads failing - Failed to open document

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.

Community Browser