Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Failed to allocate Qlikview Engine

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

17 Replies
Not applicable
Author

Hi Stefan,

I checked the qvw script log file as well. It just says general script error.

6/1/2011 9:25:00 AM:      Execution started.

6/1/2011 9:25:00 AM:      QlikView Version:8.01.4783.11

6/1/2011 9:25:00 AM: 0002  SET ThousandSep=','

6/1/2011 9:25:00 AM: 0003  SET DecimalSep='.'

6/1/2011 9:25:00 AM: 0004  SET MoneyThousandSep=','

6/1/2011 9:25:00 AM: 0005  SET MoneyDecimalSep='.'

6/1/2011 9:25:00 AM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

6/1/2011 9:25:00 AM: 0007  SET TimeFormat='h:mm:ss TT'

6/1/2011 9:25:00 AM: 0008  SET DateFormat='M/D/YYYY'

6/1/2011 9:25:00 AM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

6/1/2011 9:25:00 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

6/1/2011 9:25:00 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

6/1/2011 9:25:00 AM: 0014  ODBC CONNECT TO wfprd (XUserId is JeXPbYBOSbbIWCC, XPassword is WEfbOSFMCDbKXSNOSJEB)

6/1/2011 9:25:00 AM: 0020  SELECT count(psr.OID) TODAY_ORDERS,

6/1/2011 9:25:00 AM: 0021         to_char(psr.req_date, 'HH24') HOUROFDAY,

6/1/2011 9:25:00 AM: 0022         trunc(psr.req_date) PLACEDATE,

6/1/2011 9:25:00 AM: 0023         scp.prov_name PROVIDER,

6/1/2011 9:25:00 AM: 0024         'QC' || scp.oid PROVIDER_NUMBER,

6/1/2011 9:25:00 AM: 0025         rsc.FLASH_SVC_CATEGORY CATEGORY,

6/1/2011 9:25:00 AM: 0026         rsc.oid CATKEY,

6/1/2011 9:25:00 AM: 0027         q.bp_name PARTNER,

6/1/2011 9:25:00 AM: 0028         q.ENTITY_NAME      

6/1/2011 9:25:00 AM: 0029    FROM system_request psr, category_provider scp, REF_SCP_SRVC_CAT_TYPE rsc,qc_cp_master q

6/1/2011 9:25:00 AM: 0030   WHERE psr.oid_provider=scp.oid

6/1/2011 9:25:00 AM: 0031   and psr.oid_cm = q.entity_oid

6/1/2011 9:25:00 AM: 0032     and trunc(psr.req_date) = trunc(sysdate)

6/1/2011 9:25:00 AM: 0033     and psr.req_type=1

6/1/2011 9:25:00 AM: 0034     and psr.req_state>=1

6/1/2011 9:25:00 AM: 0035     and scp.OID_SERV_CAT_TYPE=rsc.oid

6/1/2011 9:25:00 AM: 0036   GROUP BY trunc(psr.req_date),to_char(psr.req_date, 'HH24'),scp.prov_name,'QC' || scp.oid, rsc.FLASH_SVC_CATEGORY,rsc.oid,q.bp_name,q.ENTITY_NAME

6/1/2011 9:25:00 AM: 0037   ORDER BY trunc(psr.req_date),to_char(psr.req_date, 'HH24')

6/1/2011 9:56:16 AM:       General Script Error

6/1/2011 9:56:16 AM:      Execution finished.

CPU Usage is normal during the reload failure. The hardware does not seem to be a problem cos now I am refreshing the files using windows batch files on the server machine. The users cannot wait for me to resolve the issue and hence, I had to come up with the back up plan of executing from command line to automate the reloads.

Thanks a lot guys for helping me.

Regards

Kumar

StefanBackstrand
Partner - Specialist
Partner - Specialist

What is the version of qv.exe on the server that you are running the tasks in now (that works)?

And what is the version of the qvb.exe on the server (that does not work)?

I mean, exakt version - look in the properties on the files.

Not applicable
Author

Hi Stefan,

The qv.exe version is QlikView 9.00 SR7.

The QVS.exe version is QlikView 8.01

The QVB.exe version is QlikView 8.01 

Can you suggest me what do I need to test here?

Regards

Kumar

StefanBackstrand
Partner - Specialist
Partner - Specialist

Upgrade the server. No support is issued on 8.0x and no changes or fixes will be done in this version. And no extended logging is available in 8 to my knowledge. Maybe debugging the qvb process to get some clues, but other then that.. difficult.

StefanBackstrand
Partner - Specialist
Partner - Specialist

Or try and exclude parts of or change the script statement, to see what part breaks it.

Not applicable
Author

Hi Stefan,

I dont think the problem is with the script cos when I run it through the command line using the script

"C:\Program Files (x86)\QlikView\Qv.exe" /r "C:\Program Files (x86)\QlikView\Examples\QvsDocuments\PlacedOrderAnalysis.qvw"

It works perfectly fine. Its just that while using the Qlikview Publisher to automate reloading on server that it creates a problem.

Can you tell me how to debug the qvb process?

Thanks a lot for all the help.

Regards

Kumar

StefanBackstrand
Partner - Specialist
Partner - Specialist

Oh, on the contrary, it is definitely the script that makes all the difference. Or at least how the different versions of the qlikview engine will interpret and execute it. You see, the QVS and qvb (where the latter is responsible for the publisher reloads) are version 8.01. The Qv developer you're running are 9 sr7, a much more stable and refined version than 8. That is most probably why 8 will work different, in this case not work at all. If you we to run this script on a 9 sr7 server, it would probably work just as fine as it does in the developer today.

Not applicable
Author

Hi Stefan,

To check if the problem was the qlikview developer version,  I tried to reload the files on the qliview professional for windows 8.01 version. I am able to reload the files but I am not able to set up any new database connections. The database part is disabled.

Attaching the image for your reference. Would this be a case of concern? Qliview 8.01.bmp