Promblem with EXECUTE

[#1]

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.

[fkeuroglian]

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!

[johnca]

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

[#4]

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

[#5]

Hi.

So, here are log files.

[johnca]

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

[#7]

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.

[johnca]

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