Maybe I have multiple issues, but the same pattern of error keeps repeating itself, giving no information on some cases and some on others.
This is part of the log when I run the task on the QMC.
Note that there were other tasks failing similarly, but they were "fixed", by one of two ways (how exactly or why I have no idea, I'm just going by an action-reaction reasoning):
-Reset QDS service.
-Ran all failing scripts manually on QV, then through the QMC, where some of the failing scripts ran like nothing ever happened.
Relevant may be the fact that the QDS reset was supposed to be happening everyday (via Windows Task) but the task itself started failing probably due to a user password change. This user password change had made all triggered tasks to fail. Once the credentials were updated, most tasks ran without problem.
Could this password change be at the root of the problem?
TaskLog.txt 5.8 K
Can you post the document log? Normally when you see a QVW that will load in the desktop but not through the Distribution service there are a could things to look for.
1. Does the service account has access to all the data.
2. Are the ODBC connections setup as system DSN and not Users DSN
You can also try changing the service account to the same as the LOGIN used to run it in desktop to see if it will run correctly
EDIT: attached correct document log.
Attached is the Document Log.
1.Yes, we have access to all the data.
2.Yes, ODBC connections are system connections.
DocumentLog.txt 97.7 K
Who's hosting your Qlikview server as the windows config can have an effect on the performance
We tried on running Qlikview Server on Google Compute Engine and had similar errors, basically we had a CSV config file that our application would loop over, this all worked fine locally but when we ran it on a brand new GCE box it would hang when the application tried to import the CSV.
This was strange behaviour and when you go to add the CSV in the script editor you can see the fields and data, so we created an EC2 windows box and installed everything on there exactly as we did on the GCE box, when we reloaded the QVW it worked no problem, since then Qlik Support have looked at the GCE box and installed an earlier version of the server software and it works fine, and they said that Windows had config issues.
I'm trying every avenue and yet nothing seems to pop out. I'm guessing it won't "pop" at any moment.
I'm looking to find a history of performed tasks through time. Maybe this will show me an unhealthy (for the server) number of tasks running concurrently. All I have to try and visualize that for the moment is the Governance Dashboard (which honestly has me a little confused as for the CPU utilization it displays either a 0 or a 1.
Does anyone have any clue as to this approach?