7 Replies Latest reply: Feb 20, 2013 8:51 AM by Syed Khaled Shahbaaz RSS

    Reload Runs in Desktop But Fails in Server...!!

      Hi,

       

      I'm trying to reload a document using Management Console and the reload fails. The document runs fine when reloaded using QlikView Desktop with OLEDB connectivity.

       

      The Log file reads as follows:

       

       

      2/20/2013 1:47:00 PM:      Execution started.

      2/20/2013 1:47:00 PM:      QlikView Version:11.0.11440.0

      2/20/2013 1:47:00 PM:      CPU Target                    x64

      2/20/2013 1:47:00 PM:      Operating System              Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

      2/20/2013 1:47:00 PM:      Wow64 mode                    Not using Wow64

      2/20/2013 1:47:00 PM:      MDAC Version                  6.1.7601.17514

      2/20/2013 1:47:00 PM:      MDAC Full Install Version     6.1.7601.17514

      2/20/2013 1:47:00 PM:      PreferredCompression          2

      2/20/2013 1:47:00 PM:      EnableParallelReload          1

      2/20/2013 1:47:00 PM:      ParallelizeQvdLoads           1

      2/20/2013 1:47:00 PM:      AutoSaveAfterReload           0

      2/20/2013 1:47:00 PM:      BackupBeforeReload            0

      2/20/2013 1:47:00 PM:      EnableFlushLog                0

      2/20/2013 1:47:00 PM:      SaveInfoWhenSavingFile        0

      2/20/2013 1:47:00 PM:      UserLogfileCharset            0

      2/20/2013 1:47:00 PM:      OdbcLoginTimeout              -1

      2/20/2013 1:47:00 PM:      OdbcConnectionTimeout         -1

      2/20/2013 1:47:00 PM:      ScriptWantsDbWrite            false

      2/20/2013 1:47:00 PM:      ScriptWantsExe                false

      2/20/2013 1:47:00 PM:      LogFile CodePage Used:        1252

      2/20/2013 1:47:00 PM: 0002  SET ThousandSep=','

      2/20/2013 1:47:00 PM: 0003  SET DecimalSep='.'

      2/20/2013 1:47:00 PM: 0004  SET MoneyThousandSep=','

      2/20/2013 1:47:00 PM: 0005  SET MoneyDecimalSep='.'

      2/20/2013 1:47:00 PM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

      2/20/2013 1:47:00 PM: 0007  SET TimeFormat='h:mm:ss TT'

      2/20/2013 1:47:00 PM: 0008  SET DateFormat='M/D/YYYY'

      2/20/2013 1:47:00 PM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

      2/20/2013 1:47:00 PM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

      2/20/2013 1:47:00 PM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

      2/20/2013 1:47:00 PM: 0013  set source="C:\NIC Project\QVDFiles\"

      2/20/2013 1:47:00 PM: 0016  set vHol = '38722,38723'

      2/20/2013 1:47:00 PM: 0019  OLEDB CONNECT32*Provider*

      2/20/2013 1:47:01 PM:      Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed for user 'sa'.

      2/20/2013 1:47:01 PM:       General Script Error

      2/20/2013 1:47:01 PM:       Execution Failed

      2/20/2013 1:47:01 PM:      Execution finished.

       

       

      If I use ODBC connectivity, the error log has the following message:

       

      Data source name not found and no default driver specified

       

      Can somebody tell me what could be the problem?

       

      Thanks,

       

      -Khaled