Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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.
Or try and exclude parts of or change the script statement, to see what part breaks it.
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
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.
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?