RELOAD IN QMC FAILING

[#1]

I am using QV VER 11. I have a ORACLE Database which I am connecting to using  ODBC Driver. If I am in QV and Reloads the task it connects and Reloads fine. I have Scheduled the Task in QMC and it fails Everyday. Even If I try to reload Manually in QMC it fails but Like I said If I try to Reload in QV it works fine.

Any Clues?

[iktrayanov]

The account that QlikView services are running under should have access to your Oracle server.

[#3]

Thnx for the response

HOw can I find out if it has Access or whats the Account info? where I can find it

[iktrayanov]

On your QlikView server open the Services and check the properties on the QlikView services you should be able to see which account they are using. This account should have access to your Oracle server.

[#5]

Sorry I am new to this ,  Where exactly shall I go to look for the  Account Info

[iktrayanov]

Go to Server Manager on your QlikView Server

then go to Services

on the right find

right click on one of these and choose Properties

You should see the service account

[#7]

The Service Account is Same for both the DEV and PROD server. Its working fine on DEV

[Clever_Anjos]

Could you post your app log? We need to check the error message

[#9]

2/3/2014 1:00:36 AM:      Execution started.

2/3/2014 1:00:36 AM:      QlikView Version:11.20.12018.0

2/3/2014 1:00:36 AM:      CPU Target                    x64

2/3/2014 1:00:36 AM:      Operating System              Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

2/3/2014 1:00:36 AM:      Wow64 mode                    Not using Wow64

2/3/2014 1:00:36 AM:      MDAC Version                  6.1.7601.17514

2/3/2014 1:00:36 AM:      MDAC Full Install Version     6.1.7601.17514

2/3/2014 1:00:36 AM:      PreferredCompression          2

2/3/2014 1:00:36 AM:      EnableParallelReload          1

2/3/2014 1:00:36 AM:      ParallelizeQvdLoads           1

2/3/2014 1:00:36 AM:      AutoSaveAfterReload           0

2/3/2014 1:00:36 AM:      BackupBeforeReload            0

2/3/2014 1:00:36 AM:      EnableFlushLog                0

2/3/2014 1:00:36 AM:      SaveInfoWhenSavingFile        0

2/3/2014 1:00:36 AM:      UserLogfileCharset            1200

2/3/2014 1:00:36 AM:      OdbcLoginTimeout              -1

2/3/2014 1:00:36 AM:      OdbcConnectionTimeout         -1

2/3/2014 1:00:36 AM:      ScriptWantsDbWrite            false

2/3/2014 1:00:36 AM:      ScriptWantsExe                false

2/3/2014 1:00:36 AM:      LogFile CodePage Used:        1200

2/3/2014 1:00:36 AM:       Reload Executed By MAGNT\qlikview

2/3/2014 1:00:36 AM:       Process Executing: QVB

2/3/2014 1:00:36 AM:       Process ID: 6820

2/3/2014 1:00:36 AM: 0002  SET ThousandSep=','

2/3/2014 1:00:36 AM: 0003  SET DecimalSep='.'

2/3/2014 1:00:36 AM: 0004  SET MoneyThousandSep=','

2/3/2014 1:00:36 AM: 0005  SET MoneyDecimalSep='.'

2/3/2014 1:00:36 AM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

2/3/2014 1:00:36 AM: 0007  SET TimeFormat='h:mm:ss TT'

2/3/2014 1:00:36 AM: 0008  SET DateFormat='M/D/YYYY'

2/3/2014 1:00:36 AM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

2/3/2014 1:00:36 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

2/3/2014 1:00:36 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

2/3/2014 1:00:36 AM: 0018  ODBC CONNECT*XUserId*XPassword*

2/3/2014 1:00:36 AM:       Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

2/3/2014 1:00:36 AM:       General Script Error

2/3/2014 1:00:36 AM:       Execution Failed

2/3/2014 1:00:36 AM:      Execution finished.

[Clever_Anjos]

Probably your ODBC was created as "USER DSN".

It should be System DSN