18 Replies Latest reply: Oct 24, 2014 10:19 AM by Morgan Patou RSS

    Reload Task does work locally, but not via QMC

    Till Bentz

      Hello,

       

      I have a problem with my reload tasks. There seems to be a problem using any database connections and I can't figure out why it does not work.

       

      I have several QVWs using data from several oracle databases. When I execute a reload locally from within the Qlikview Desktop everything works fine:

       

      10.09.14 12:17:59: Execution started.

      10.09.14 12:17:59: QlikView Version:11.20.12451.0

      10.09.14 12:17:59: CPU Target                    x64

      10.09.14 12:17:59: Operating System              Windows Server 2012 R2 Standard  (64 bit edition)

      10.09.14 12:17:59: Wow64 mode                    Not using Wow64

      10.09.14 12:17:59: MDAC Version                  6.3.9600.16384

      10.09.14 12:17:59: MDAC Full Install Version     6.3.9600.16384

      10.09.14 12:17:59: PreferredCompression          2

      10.09.14 12:17:59: EnableParallelReload          1

      10.09.14 12:17:59: ParallelizeQvdLoads           1

      10.09.14 12:17:59: AutoSaveAfterReload           0

      10.09.14 12:17:59: BackupBeforeReload            0

      10.09.14 12:17:59: EnableFlushLog                0

      10.09.14 12:17:59: SaveInfoWhenSavingFile        0

      10.09.14 12:17:59: UserLogfileCharset            1200

      10.09.14 12:17:59: OdbcLoginTimeout              -1

      10.09.14 12:17:59: OdbcConnectionTimeout         -1

      10.09.14 12:17:59: ScriptWantsDbWrite            false

      10.09.14 12:17:59: ScriptWantsExe                false

      10.09.14 12:17:59: LogFile CodePage Used:        1200

      10.09.14 12:17:59:  Reload Executed By AD\svc_qlikview_test

      10.09.14 12:17:59:  Process Executing: QlikView Desktop

      10.09.14 12:17:59:  Process ID: 70740

      [...]             

      10.09.14 12:17:59:  OLEDB CONNECT*Provider*XPassword*

      10.09.14 12:17:59:  [...]

      10.09.14 12:17:59:  SQL SELECT *

      10.09.14 12:17:59:  FROM [...]

      10.09.14 12:18:00:      10 fields found: [...], 12.804 lines fetched

      10.09.14 12:18:00:  [...]

      10.09.14 12:18:00:  OLEDB CONNECT*Provider*XPassword*

      10.09.14 12:18:00:  [...]

      10.09.14 12:18:00:  SQL SELECT *

      10.09.14 12:18:00:  FROM [...]

      10.09.14 12:18:01:      53 fields found: [...], 29.507 lines fetched

      10.09.14 12:18:04:  [...]

      10.09.14 12:18:04:  EXIT Script

      10.09.14 12:18:04: Execution finished.


      When I try to execute the same reload task from within the publisher using the QMC the reload just stops right at the database connection:


      10.09.14 12:20:15: Execution started.

      10.09.14 12:20:15: QlikView Version:11.20.12451.0

      10.09.14 12:20:15: CPU Target                    x64

      10.09.14 12:20:15: Operating System              Windows Server 2012 R2 Standard  (64 bit edition)

      10.09.14 12:20:15: Wow64 mode                    Not using Wow64

      10.09.14 12:20:15: MDAC Version                  6.3.9600.16384

      10.09.14 12:20:15: MDAC Full Install Version     6.3.9600.16384

      10.09.14 12:20:15: PreferredCompression          2

      10.09.14 12:20:15: EnableParallelReload          1

      10.09.14 12:20:15: ParallelizeQvdLoads           1

      10.09.14 12:20:15: AutoSaveAfterReload           0

      10.09.14 12:20:15: BackupBeforeReload            0

      10.09.14 12:20:15: EnableFlushLog                0

      10.09.14 12:20:15: SaveInfoWhenSavingFile        0

      10.09.14 12:20:15: UserLogfileCharset            1200

      10.09.14 12:20:15: OdbcLoginTimeout              -1

      10.09.14 12:20:15: OdbcConnectionTimeout         -1

      10.09.14 12:20:15: ScriptWantsDbWrite            false

      10.09.14 12:20:15: ScriptWantsExe                false

      10.09.14 12:20:15: LogFile CodePage Used:        1200

      10.09.14 12:20:15:  Reload Executed By AD\svc_qlikview_test

      10.09.14 12:20:15:  Process Executing: QVB

      10.09.14 12:20:15:  Process ID: 22612

      [...]

      10.09.14 12:20:15:  let vLastReload = Timestamp(ReloadTime(),'YYYYMMddHHmmss')


      The task then hangs until I abort it. AS you can see, I am using the same account. The manual reload is also done on the same server.

       

      Any hints or tipps would be very much appreciated!

       

      Thank you very much!

       

      Regards, Till