3 Replies Latest reply: Apr 10, 2014 1:53 AM by sampad dey RSS

    Scheduled Reload not worling in publisher

    sampad dey

      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.