Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

samp_123
New Contributor III

Scheduled Reload not worling in publisher

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.
1 Solution

Accepted Solutions
samp_123
New Contributor III

Re: Scheduled Reload not worling in publisher

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

Thanks

3 Replies
samp_123
New Contributor III

Re: Scheduled Reload not worling in publisher

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

Thanks

Not applicable

Re: Scheduled Reload not worling in publisher

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

samp_123
New Contributor III

Re: Scheduled Reload not worling in publisher

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

Community Browser