topic Re: Promblem with EXECUTE in QlikView

Promblem with EXECUTE

Sun, 09 Feb 2014 15:32:00 GMT

Hi!

I load data from Google Analytics, using GoogleAnalyticsClient.

In my script there is a line

EXECUTE -jar GoogleAnalyticsClient-20100127.jar -u $(gUserName) -p $(gPassword) -f $(gProfileId1) -d $(gDimensions) -m $(gMetrics) -s $(date) -e $(date) --max-results=10000 --o visits.csv;

So, if I launch reloading in desktop, it works correctly.

But if I launch it from the QVServer, it fails with error

Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Дизкон\GA_Dizkon\GA.qvw.

Error: в QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

Error: в QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

Error: в QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

Error: --- Конец трассировки внутреннего стека исключений ---

Error: в QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

Error: в QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

Could you help me to resolve this problem.

Thanks.

Re: Promblem with EXECUTE

fkeuroglian — Sun, 09 Feb 2014 19:45:53 GMT

Hi, if in the desktop run ok and not in qmc, please check that the user that is runing service have the correct permission to do it in the console.

it sounds like a problem of credentials and permissions.

good luck!

Re: Promblem with EXECUTE

johnca — Sun, 09 Feb 2014 20:33:03 GMT

Another thing that may help would be the log file. Make sure Generate Logfile is enabled (in the document properties). If it is indeed the server not having access it should me detailed here, and probably in the last few lines of the log. I never have luck determining why a doc doesn't reload using the reload failure message.

--john

Re: Promblem with EXECUTE

Mon, 10 Feb 2014 08:03:38 GMT

QMC service is running by the same user as I work in desktop.

Re: Re: Promblem with EXECUTE

Mon, 10 Feb 2014 08:08:25 GMT

Hi.

So, here are log files.

Re: Re: Promblem with EXECUTE

johnca — Mon, 10 Feb 2014 13:16:51 GMT

Log files are created in the same folder as the QVW.

Re: Re: Promblem with EXECUTE

Mon, 10 Feb 2014 13:39:21 GMT

Yes.

It seems like a problem with executing unsafe macro by QMC.

Settings Allow unsafe macro execution on server and Allow macro execution on server are enabled.

Re: Re: Promblem with EXECUTE

johnca — Mon, 10 Feb 2014 16:10:59 GMT

Sorry, I couldn't see the attachments (for some reason).

Your deduction sounds right...a server macro execution thing.

Anyway, that's about as far as I can help. Other than viewing the script execution in debug mode and stepping or animated modes I can't help further. Hopefully, some other Google mapper or Publisher admin expert can chime in.

--john