Failed to allocate Qlikview Engine

[#1]

Hi

I am facing a problem where in none of the reports are getting refreshed on the server. The error log for every reload is similar to below:

31041128 2011-05-24 10:50:00NormalInformation

Trying to allocate a QlikView Engine. Current usagecount=8 of 8. Waiting max=5/24/2011 10:55:00 AM

31041129 2011-05-24 10:50:00NormalWarning

All QlikView Engines are in use, waiting maximum 300 seconds for one to get free..

31041165 2011-05-24 10:55:00NormalError

Failed to allocate a QlikView Engine.    

I tried increasing the max number of qlikview engine count from 4 to 8 and still it continues giving me the same error.

Any suggestions would be really helpful.

Regards

Kumar

[rwunderlich]

It looks like you are on V8? The timeout is configurable in V9.

For V8, your only choice is to reduce the scheduling overlap or increase the number of engines.

-Rob

[#3]

Hi Rob,

Thanks for your suggestion. I had increased the number of qlikview engines from 4 to 8 and then the usage count was still went up and none of the reports got refreshed.

And every now and then the log files have the following error mentioned

Reload failed Exception=%Exception Exception: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.   at QlikView.Doc.Reload(Int32 _Mode)   at QVBWrapper.Document.Reload(Int32 i_ParentLogID, Object i_Partial)

I am trying to work on why the log files are behaving so wierdly but not able to get the root cause of the problem.

Thank you for the help.

Regards

Kumar

[#4]

Hi...

Some of the log files also display the following error:

"The task Reload Hourly Graphs failed with an exception: System.NullReferenceException: Object reference not set to an instance of an object.
   at QVBWrapper.Document.Close(Int32 i_ParentLogID)
   at QVBWrapper.DocumentPool.Checkin(Int32 i_ParentLogID, Document i_Document)
   at XSMain.ReloadTask.InternalExecute()
   at XSMain.AbstractTask.InternalExecute2()"

I am unable to debug the error. None of files are refreshing on the server. Any help would be great.

Thank you.

Regards

Kumar

[rwunderlich]

I suggest you contact support on this one.

-Rob

[StefanBackstrand]

You are maxing out the available number of simultaneus QVB engines - the error message clearly states it.

How many CPU cores are in the machine?

How many jobs runs at the same time at peak times?

[#7]

Hi Stefan,

Thanks for your input.

At first even I thought that I would be maxing out the available number of simultaneous QVB engines...but the error occurs even when all the engines are free...

The error log is the log for the first job that runs on the day...

31096365 2011-05-31 08:00:00NormalInformation Starting Job "UpdateProdReports" (Attempt 1 of 1)

31096369 2011-05-31 08:00:00NormalInformation Starting task "ProdReports"

31096375 2011-05-31 08:00:00NormalInformation Checking write permissions on "C:\Program Files(x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw"

31096374 2011-05-31 08:00:00NormalInformation Preparing "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw" for reload.

31096373 2011-05-31 08:00:00NormalInformation Starting task "ProdReports" (84a02cf2-8ff5-44d0-a8a1-d2f6c95c589f)

31096376 2011-05-31 08:00:00NormalInformation Opening "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw"

31096379 2011-05-31 08:00:00NormalInformation Preparing to load document "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw".

31096377 2011-05-31 08:00:00NormalInformation Trying to allocate a QlikView Engine. Current usagecount=0 of 13. Waiting max=5/31/2011 8:05:00 AM

31096378 2011-05-31 08:00:00NormalInformation Successfully allocated QlikView Engine. Current usagecount=1 of 13

31096380 2011-05-31 08:00:00NormalInformation An instance of the QlikView Engine is being created.

31096382 2011-05-31 08:00:01NormalInformation Loading document "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw".

31096381 2011-05-31 08:00:01NormalInformation The QlikView Engine was started successfully. Version=8.01.4783.11 ProcessID=7028

31096383 2011-05-31 08:00:01NormalInformation The document "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw" was loaded successfully.

31096386 2011-05-31 08:00:01NormalInformation Starting reload

31096384 2011-05-31 08:00:01NormalInformation All done opening "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw"

31096385 2011-05-31 08:00:01NormalInformation Physical FileSize=0Mb. Memory Usage for this file=0Mb. Available Physical Memory Before Open=4095Mb. Available Physical Memory After Open=4095Mb. Total Physical Memory=4095Mb.

31096605 2011-05-31 08:31:17NormalInformation The document failed to reload. Reason=CrashedWithError

31096607 2011-05-31 08:31:17NormalInformation Reload failed

31096387 2011-05-31 08:00:01NormalInformation Starting Operation: Reload

31096394 2011-05-31 08:00:01NormalInformation Waiting for the document log "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw.log" to become available..

31096395 2011-05-31 08:00:01NormalInformation The Source Document is being reloaded. DocumentPath=C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw

31096401 2011-05-31 08:01:16NormalWarning The QlikView Engine working with document "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw" is not responding.

31096594 2011-05-31 08:31:16NormalWarning The QlikView Engine working with document "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw" hasn't been responding for 1800 seconds. It will be killed.

31096596 2011-05-31 08:31:16NormalInformation Closing QlikView Engine

31096598 2011-05-31 08:31:16NormalInformation Closing the Source Document. DocumentPath=C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw

31096600 2011-05-31 08:31:16NormalInformation Closing the QlikView Engine. ProcessID=7028

31096599 2011-05-31 08:31:16NormalInformation The Source Document was closed successfully DocumentPath=C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw

31096601 2011-05-31 08:31:16NormalError Reload failed Exception=%Exception Exception: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.   at QlikView.Doc.Reload(Int32 _Mode)   at QVBWrapper.Document.Reload(Int32 i_ParentLogID, Object i_Partial).

31096602 2011-05-31 08:31:16NormalError System.Exception: Reload failed ---> System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.   at QlikView.Doc.Reload(Int32 _Mode)   at QVBWrapper.Document.Reload(Int32 i_ParentLogID, Object i_Partial)   --- End of inner exception stack trace ---   at QVBWrapper.Document.Reload(Int32 i_ParentLogID, Object i_Partial)   at QVBWrapper.Document.StartThread2(Int32 i_ParentLogID, Object i_Object)

31096603 2011-05-31 08:31:16NormalInformation Closed the QlikView Engine successfully. ProcessID=7028

31096604 2011-05-31 08:31:17NormalInformation Document log "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\OrdersByHour.qvw.log" was not found / not updated. Skipped.

31096612 2011-05-31 08:31:17NormalError The task ProdReports failed with an exception: System.NullReferenceException: Object reference not set to an instance of an object.   at QVBWrapper.Document.Close(Int32 i_ParentLogID)   at QVBWrapper.DocumentPool.Checkin(Int32 i_ParentLogID, Document i_Document)   at XSMain.ReloadTask.InternalExecute()   at XSMain.AbstractTask.InternalExecute2()

31096606 2011-05-31 08:31:17NormalInformation ReloadASync completed

31096608 2011-05-31 08:31:17NormalInformation Checkin

31096610 2011-05-31 08:31:17NormalInformation Closing QlikView Engine

31096371 2011-05-31 08:00:00NormalInformation  Waiting for "ProdReports" to complete.

31096366 2011-05-31 08:00:00NormalInformation Job started (Attempt 1 of 1)

31096613 2011-05-31 08:31:18NormalInformation 1 task(s) failed - Sending alertmail...

31096614 2011-05-31 08:31:20NormalInformation

31096616 2011-05-31 08:31:20NormalInformation Job "UpdateProdReports" has exited. 

31096615 2011-05-31 08:31:20NormalError Job finished with errors.  

The qlikview engine was allocated and started but the job fails. I am not able to find out why.

Regards

Kumar

[gyan_srivastava]

Hi Kumar,

Please check PF usage ( From Task Manager -->Performance Tab) , if that is maximum , then try restarting QVS service . and load the document again .

If the document gets loaded successful.then It might be a proble of loading muliple documents in RAM .

Please  check QEMC and go to 'QEMC-->System-->Setup-->Qlikview Servers-->QVS@ServerName-->Documents'

and check 'Allow only one copy of document in memory' . this will help to resolve you query .

Regards

Gyan

[#9]

Hi Gyan,

I checked the PF usage and it seems to be within normal limits and no where near to the maximum. I restarted the QVS service as well.

Then as you suggested, I checked the "Allow only one copy of document in memory" and the error still continues. Please have a look at the screenshot below.

I am not able to figure out the problem and thus, finding a solution is even more difficult. Really appreciate your help.

Thanks a lot.

Regards

Kumar

[StefanBackstrand]

I don't think the "Allow only one document [..]" setting will change anything, especially since we have not established any root cause for the is sue. How do you configure something that you don't know will affect it?

First of all; if a task fails, it doesn't necessarily mean that it's Publisher's fault. Have you looked in the qvw script log file? Is there any at all? What is the hardware specs on the machine? How does CPU usage look during the failed reload?