Problem with QlikView 9 ServerSR2

[galrion82]

Hello

I'm running QlikView Server 9 SR2 64bit on an Windows 2008 SR2 64 bit server. I use the QlikView Distribution Service to reload the files.

The reload process worked fine for 3 months until today. The jobs have started to crash. This i what i get in the log file (TaskLog.txt)

5/28/2010 16:40:20.0061495 Information Executing ClusterID=1, QDSID=1b492786-f266-d359-569b-edb43aeb1fd9QDSMain.ReloadTask
5/28/2010 16:40:20.0217496 Information Starting task "VP_Morarit/Morarit_Cumparari_Curente.qvw" (Attempt 1 of 1)
5/28/2010 16:40:20.0217496 Information Max run time: 06:00:00
5/28/2010 16:40:20.0217496 Information Opening "E:\qlik\VP_Morarit\Morarit_Cumparari_Curente.qvw"
5/28/2010 16:40:20.0217496 Information Allocating QlikView Engine
5/28/2010 16:43:05.2112085 Information Allocating new QlikView Engine. Current usagecount=9 of 20
5/28/2010 16:43:05.2112085 Information An instance of the QlikView Engine is being created
5/28/2010 16:43:05.2112085 Information Starting QlikView Engine
5/28/2010 16:43:36.2086072 Error Failed to create QlikView Engine.. Exception=System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {28CB32FB-415E-11D1-934D-0040333C91CC} failed due to the following error: 80080005.
at QVBWrapper.Document.CreateQVBProcess(ILogBucket i_LogBucket)
5/28/2010 16:43:36.2086072 Information Failed to create QlikView Engine - Cleanup and retry (3 second pause before trying again)
5/28/2010 16:43:36.2086072 Error Close failed.. Exception=System.NullReferenceException: Object reference not set to an instance of an object.
at QVBWrapper.Document.HardCloseThread(ILogBucket i_LogBucket, Int32 i_WaitSecondsBeforeKill)
5/28/2010 16:43:39.2194265 Information An instance of the QlikView Engine is being created (attempt 2/6)
5/28/2010 16:43:39.2194265 Information Starting QlikView Engine
5/28/2010 16:43:40.1242323 Information The QlikView Engine was started successfully. Version=9.00.7320.7, ProcessID=4732
5/28/2010 16:43:40.1242323 Information Allocated QlikView Engine successfully. Current usagecount=9 of 20, Ticket=57
5/28/2010 16:43:40.1242323 Information Loading document "E:\qlik\VP_Morarit\Morarit_Cumparari_Curente.qvw" (6.59 Mb)
5/28/2010 16:43:41.1382388 Information Loading. LoadTime=00:00:01.0140065
5/28/2010 16:43:43.1662518 Information Loading. LoadTime=00:00:03.0420195
5/28/2010 16:43:47.2222778 Information Loading. LoadTime=00:00:07.0980455
5/28/2010 16:43:47.6278804 Information Physical FileSize=6.59 Mb. Memory Allocation Delta for this file=65.60 Mb. Available Physical Memory Before Open=7708.57 Mb. Available Physical Memory After Open=7653.47 Mb. Total Physical Memory=32766.89 Mb.
5/28/2010 16:43:47.6434805 Error The document failed to open.
5/28/2010 16:43:47.6746807 Information Closing the document.
5/28/2010 16:43:47.8150816 Information Closed the QlikView Engine successfully. ProcessID=4732
5/28/2010 16:43:47.9242823 Information Initializing Checkout (0), Loading document (200101), Initializing load (200101), Checking read (200101), Creating QlikView Engine (200101), Checking Size (200148), Load (200148), Load Completed (207090), Tables read (207574), Opened successfully (207621)
5/28/2010 16:43:47.9242823 Error Document could not be opened
5/28/2010 16:43:47.9242823 Information Document could not be opened (0)
5/28/2010 16:43:47.9242823 Information Closed the QlikView Engine successfully. ProcessID=4732
5/28/2010 16:43:47.9242823 Information Initializing (0), Finished (0)
5/28/2010 16:43:47.9242823 Error Reload failed because the document could not be opened successfully. DocumentState=CouldNotOpenDocument
5/28/2010 16:43:47.9242823 Information Initializing (0), Finished (0)
5/28/2010 16:43:47.9242823 Error The task "VP_Morarit/Morarit_Cumparari_Curente.qvw" failed. ErrorCount=5
5/28/2010 16:43:47.9242823 Information Sending Alert Mail to 2 recipients.

What is strange is that not all jobs crash, and not everytime they run. I tried restarting the services (didn't work), restarting the server (dind't work)

Anybody else had a similar problem?

10x in advance

[galrion82 · Accepted solution]

I solved the problem by setting fewer reloads for each job. I made sure that no more then 5 reloads can run simultaneous and since then no jobs have crashed.

[#3]

Hello,

Can you help me with the installation of the QVS 9 on WinServer2008 SR2, please? I don't know what to do... do you have a manual of explanation?

Tks.

[#4]

We are experiencing similar issues, since we are running about up to 10 Jobs in parallel (yes currently, we have to do this).

issues like

Exception=System.Runtime.InteropServices.COMException (0x80080005):

or

Normal 0 21 false false false DE-AT X-NONE X-NONE

Reload failed because the document could not be opened successfully. DocumentState=DocumentNotFound The task "ABCD" failed. Cause=Errorcount=1 The document failed to open.

However, Windows 2003 R2 SP2 on a 16 core CPU (due to Hyperthreading) with 128GB of RAM should be able to handle this. (.NET installations are up to date (most current Service Packs))

We are not even getting close to the RAM limit. I think RAM peaked around 50GB still leaving plenty of RAM left. CPUs do run at 100% for usually not more than 15 seconds frmo tim to time, so even from that point performance it looks fine.

It's just the errors that are confusing and irritateing. Restarting the jobs manually, after they failed, makes them run through without hassle, but next day again randomly "choosen" jobs seem to fail with the mentioned errors.

So, does anyone have any idea other but "just do not run more than 5 jobs simultaneousely"?! BTW, we are running QV 8.5.

[leocvaz]

I have the same problem, and think that this is a problem, a bug of Publisher. If you put 10 or 100 documents to reload, they must respect the priority line, and not crash the server.

The surprise is the next day, users very angry about the server, what can I explain to then? We had a problem in the server. They answer: Again!!! Don't you have upgrated your server.

Imagine Guys!