topic Re: Stored Procedures Not Working For Scheduled Task! in QlikView

Stored Procedures Not Working For Scheduled Task!

Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Stored Procedures Not Working For Scheduled Task!

Sat, 23 Feb 2013 14:37:47 GMT

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?

Re: Stored Procedures Not Working For Scheduled Task!

Wed, 27 Feb 2013 13:01:40 GMT

Hi Donald,

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

version : QV 10 SR1

Re: Stored Procedures Not Working For Scheduled Task!

Wed, 27 Feb 2013 13:04:46 GMT

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

Re: Stored Procedures Not Working For Scheduled Task!

Thu, 28 Feb 2013 17:22:12 GMT

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

Re: Stored Procedures Not Working For Scheduled Task!

Thu, 28 Feb 2013 19:14:57 GMT

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.