Stored Procedures Not Working For Scheduled Task!

[#1]

Hi,

I am using a few Stored Procedures inside my QlikView script.

The reload works fine when performed manually, but automatic reload (configured via QlikView Server) fails.

Looking for assistence.

Thanks,

Irfan Ghori.

[#2]

Have you verified that the account you are using on the server (that authenticates your QlikView services) for the task has appropriate permissions on your database to execute the SP and the data?

[#3]

Hi Donald,

Yes I dont, the user have permit to access SP.

version : QV 10 SR1

[#4]

When the job fails from the server, what is recorded in your Publisher log for the task that failed?

[#5]

Found Error at Qlikview Server task->log

(2013-02-27 11:12:47)  Warning: Could not get QlikView Document Log Name. Log reading skipped!

(2013-02-27 11:12:47) Error: The sourcedocument failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

(2013-02-27 11:12:47) Error:    at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)

(2013-02-27 11:12:47) Error:    at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)

(2013-02-27 11:12:47) Information: Initializing Reload (0), Finished (611704)

(2013-02-27 11:12:47) Error: Reload failed.

(2013-02-27 11:12:47) Information: Initializing (0), Finished (0)(2013-02-27 11:12:47) Error: Reload failed. Distribution skipped.

(2013-02-27 11:12:47) Error: The task "Reload of BODB.qvw" failed. ErrorCount=3

[#6]

I just realized you posted above you are using v10SR1... may not hurt to patch that to at least the most current SR for v10, just in case.  Then make sure your QVW option to 'Generate Logfile' is enabled (in your document, Document Settings, General tab) so that you can inspect that log as well.