Scheduled Reload not worling in publisher

[Anonymous]

Hi

my qlikview services are running under user sysadmin ,but in my qlikview file the database is accessed using different username  hence the reload is not working. if i give the sysadmin access to database i think it will work but how do i get it working without giving the user sysadmin access to database.

can you please give a solution the above problem.

Thanks in advance.

here is the log file.

12/16/2013 2:18:38 AM:	Execution started.
12/16/2013 2:18:38 AM:	QlikView Version:11.20.11922.0
12/16/2013 2:18:38 AM:	CPU Target	x64
12/16/2013 2:18:38 AM:	Operating System	Windows Server 2008 R2 Datacenter Service Pack 1 (64 bit edition)
12/16/2013 2:18:38 AM:	Wow64 mode	Not using Wow64
12/16/2013 2:18:38 AM:	MDAC Version	6.1.7601.17514
12/16/2013 2:18:38 AM:	MDAC Full Install Version	6.1.7601.17514
12/16/2013 2:18:38 AM:	PreferredCompression	2
12/16/2013 2:18:38 AM:	EnableParallelReload	1
12/16/2013 2:18:38 AM:	ParallelizeQvdLoads	1
12/16/2013 2:18:38 AM:	AutoSaveAfterReload	0
12/16/2013 2:18:38 AM:	BackupBeforeReload	0
12/16/2013 2:18:38 AM:	EnableFlushLog	0
12/16/2013 2:18:38 AM:	SaveInfoWhenSavingFile	0
12/16/2013 2:18:38 AM:	UserLogfileCharset	1200
12/16/2013 2:18:38 AM:	OdbcLoginTimeout	-1
12/16/2013 2:18:38 AM:	OdbcConnectionTimeout	-1
12/16/2013 2:18:38 AM:	ScriptWantsDbWrite	false
12/16/2013 2:18:38 AM:	ScriptWantsExe	false
12/16/2013 2:18:38 AM:	LogFile CodePage Used:	1200
12/16/2013 2:18:38 AM:	Reload Executed By ENTERPRISE\sysadmin
12/16/2013 2:18:38 AM:	Process Executing: QVB
12/16/2013 2:18:38 AM:	Process ID: 6892

12/16/2013 2:18:38 AM: 0002  SET ThousandSep=','

12/16/2013 2:18:38 AM: 0003  SET DecimalSep='.'

12/16/2013 2:18:38 AM: 0004  SET MoneyThousandSep=','

12/16/2013 2:18:38 AM: 0005  SET MoneyDecimalSep='.'

12/16/2013 2:18:38 AM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

12/16/2013 2:18:38 AM: 0007  SET TimeFormat='h:mm:ss TT'

12/16/2013 2:18:38 AM: 0008  SET DateFormat='M/D/YYYY'

12/16/2013 2:18:38 AM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

12/16/2013 2:18:38 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

12/16/2013 2:18:38 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

12/16/2013 2:18:38 AM: 0016  OLEDB CONNECT*Provider*

12/16/2013 2:18:39 AM:	Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed for user 'ENTERPRISE\sysadmin'.
12/16/2013 2:18:39 AM:	General Script Error
12/16/2013 2:18:39 AM:	Execution Failed
12/16/2013 2:18:39 AM:	Execution finished.

[Anonymous · Accepted solution]

got the solution , you can override the user under which the process is running, in the section access of reload tab.

Thanks

[#3]

Hi,

I am trying to do the same thing. But I am unable to till now. Can you give me a step by step solution how you can do this?

Thanks,

Tutan

[Anonymous]

Actually tutan the process that i have described earlier will only allow to run the job(created using publisher, before overriding even the job was failing), but the data in the dashboards does not get refreshed.

BTW for overriding the user you can open QMC. in that when you create a job in publisher the dialog appears. in that dialog there is a reload tab in that you will see a "section access" field where you can set the username and password