Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Promblem with EXECUTE

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.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.

7 Replies
fkeuroglian
Honored Contributor

Re: Promblem with EXECUTE

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!

johncaqc
Valued Contributor

Re: Promblem with EXECUTE

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

Not applicable

Re: Promblem with EXECUTE

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

Not applicable

Re: Re: Promblem with EXECUTE

Hi.

So, here are log files.

johncaqc
Valued Contributor

Re: Re: Promblem with EXECUTE

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

Not applicable

Re: Re: Promblem with EXECUTE

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.

johncaqc
Valued Contributor

Re: Re: Promblem with EXECUTE

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

Community Browser