topic Re: batch run using QVDistributionService.exe in QlikView

batch run using QVDistributionService.exe

Mon, 08 Apr 2013 09:10:50 GMT

Hi,

I'm creating a qvw, do launch a series of qvw loading using QVDistributionService.exe.

If i load it manually in QV desktop, it works.

but if i schedule it publisher, it simply open the doc, and no reload was done. and it treat it as successful.

Does anyone face the same issue before?

Thanks.

Re: batch run using QVDistributionService.exe

Mon, 08 Apr 2013 18:56:34 GMT

here is the error message when scheduled by publisher.

4/8/2013 8:52:52 PM Error Exception=System.IO.DirectoryNotFoundException: Could not find a part of the path 'E:\TEMP\15fnbk13.tmp'.

at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)

at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)

at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)

at System.CodeDom.Compiler.TempFileCollection.EnsureTempNameCreated()

at System.CodeDom.Compiler.TempFileCollection.AddExtension(String fileExtension, Boolean keepFile)

at System.CodeDom.Compiler.CodeCompiler.FromSourceBatch(CompilerParameters options, String[] sources)

at System.CodeDom.Compiler.CodeCompiler.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)

at SolutionGlobal.Compilers.JScriptCompiler.Compile(String i_Source, Action`1 i_ErrorDelegate)

at QDSMain.LoadBalancer.Config_ConfigChangedEvent()

at QDSMain.LoadBalancer..ctor()

at QDSMain.ObjectPool.InitObjects(ILogBucket i_LogBucket, eRunLevel i_RunLevel, Func`1 clusterIDListGetFunc)

at QDSMain.MainClass.BatchRun(eBatchReloadMode i_BatchReloadMode, String i_BatchReloadDocumentPath, String i_VariableName, String i_VariableValue)

4/8/2013 8:52:52 PM Information Setting exit code to the number of errors. ErrorCount=1

Re: batch run using QVDistributionService.exe

stevedark — Tue, 09 Apr 2013 07:30:06 GMT

Hi Nick,

Is this issue affecting just one document or any document that you attempt to schedule to run?

Are you running the Desktop reload on the same server as Publisher?

Are you logged on to the box as the same user account as Publisher is running under?

Do you have 'Generate Logfile' ticked in the Document Properties?

If it is working on the Desktop but not Publisher it is possible that it is an environmental or user related difference that causes this.

If a LogFile is generated then this should give you a better idea of the execution flow of the reload, and whether it is actually getting to the end of the load successfully.

Hope that helps point you in the right direction.

Steve

http://www.quickintelligence.co.uk/

Re: batch run using QVDistributionService.exe

Tue, 09 Apr 2013 14:39:58 GMT

Nick,

Are you using "Set ErrorMode" anywhere in your script? It's possible that if you are, publisher is just "ignoring" the error that comes up.

-Ralph

Re: batch run using QVDistributionService.exe

Fri, 12 Apr 2013 13:43:35 GMT

Hi there,

Thanks for the advice. but apparently, this is a system error, and i confirm not a problem of QV.

What happen? Classic error.

We migrated our server, and the new data center guy change our E:\TEMP, to F:\TEMP for whatever reason it was, but they forgot to update the path in system variable.

After changing the system variable path to F:\TEMP, it is working again.

Thanks gentlemen for your helpful advice.

Have a nice weekend.