topic Re: RELOAD IN QMC FAILING in QlikView

RELOAD IN QMC FAILING

Mon, 03 Feb 2014 03:30:51 GMT

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?

Re: RELOAD IN QMC FAILING

iktrayanov — Mon, 03 Feb 2014 03:33:05 GMT

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

Re: RELOAD IN QMC FAILING

Mon, 03 Feb 2014 03:35:38 GMT

Thnx for the response

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

Re: RELOAD IN QMC FAILING

iktrayanov — Mon, 03 Feb 2014 03:40:11 GMT

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.

Re: RELOAD IN QMC FAILING

Mon, 03 Feb 2014 03:44:37 GMT

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

Re: RELOAD IN QMC FAILING

iktrayanov — Mon, 03 Feb 2014 04:05:39 GMT

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

Re: RELOAD IN QMC FAILING

Mon, 03 Feb 2014 13:36:00 GMT

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

Re: RELOAD IN QMC FAILING

Clever_Anjos — Mon, 03 Feb 2014 13:37:43 GMT

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

Re: RELOAD IN QMC FAILING

Mon, 03 Feb 2014 13:56:38 GMT

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.

Re: RELOAD IN QMC FAILING

Clever_Anjos — Mon, 03 Feb 2014 14:14:31 GMT

Probably your ODBC was created as "USER DSN".

It should be System DSN

Re: RELOAD IN QMC FAILING

Tue, 04 Feb 2014 02:59:46 GMT

Already Tried the above, still same issue

Re: RELOAD IN QMC FAILING

Tue, 04 Feb 2014 06:12:00 GMT

First u install the oracle OLEDB Driver in your server, Then u can connect through OLEDB.

Re: RELOAD IN QMC FAILING

Peter_Cammaert — Tue, 04 Feb 2014 08:06:47 GMT

You said a manual reload from the QV desktop works fine. Did you test this on the server using account MAGNT\qlikview?

Peter