load xlsx from ftp get a failure on a scheduled task

[bvmike2001]

Hello guys,

please help me with a problem:

i have a load scrip in an qwv app. witch load data from a xlsx file from a ftp. When i run the app. from the local client an the client from the server also it's working but when i run a scheduled load i get a failure.

the error from the log file is:

Error: Bad Zip File

General Script Error

Execution Failed

Execution finished.

the log from the schedule task is:

(2013-08-22 15:20:17) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\DEV\MONITORIZARE\ITSM.qvw.

(2013-08-22 15:20:17) Information: Closing the document.

(2013-08-22 15:20:18) Information: Closed the QlikView Engine successfully. ProcessID=2124

(2013-08-22 15:20:18) Error: The task "Monitorizare/ITSM.qvw" failed. Exception:

(2013-08-22 15:20:18) 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=D:\DEV\MONITORIZARE\ITSM.qvw.

(2013-08-22 15:20:18) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2013-08-22 15:20:18) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-08-22 15:20:18) Error: --- End of inner exception stack trace ---

(2013-08-22 15:20:18) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-08-22 15:20:18) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-08-22 15:20:18) Error: --- End of inner exception stack trace ---

(2013-08-22 15:20:18) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-08-22 15:20:18) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2013-08-22 15:20:18) Information: Task Execute Duration=00:00:01.6406460

(2013-08-22 15:20:18) Information: TaskResult.status=Finished

(2013-08-22 15:20:18) Information: Notifying all triggers of new state:FinishedWithErrors

(2013-08-22 15:20:18) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2013-08-22 15:20:18) Information: Saving Task Result

Please help because i don't find any answer.

Tanks!

[marcus_sommer]

Most often runs the server with an another user who has here probably not the proper access rights.

- Marcus

[bvmike2001]

Thanks Marcus,

it was my guess also.

There can be anything else?

[marcus_sommer]

Another possibility could be any macros/executes in the loadscript which failed. An alternatively could be to copy the xlsx per triggered batch in another place in your network.

- Marcus

[bvmike2001]

the load script is very simple. it contains only the load statement from the xlsx.

but related with your first response it is true: the servers services are running under an account without permission on the specific ftp site.

even if in the load script for the xlsx is specified an unsr and a pass for the fpt site, the account under witch the server is running must also have permission on the ftp site? because i don't understand why when i run the app with the client on the server it' fine but from the QMC i get a failure.

[marcus_sommer]

The client runs always with your user and leased only a licence from server. Perhaps there are another security restrictions in the server settings or with firewall/ports/group policies.

- Marcus