topic Re: QVD reload Fail on reload failed in QlikView

QVD reload Fail on reload failed

noman212 — Fri, 31 Oct 2014 07:17:07 GMT

i made a qvd (incremental load) when i set reload continously on server its failed to reload but when i manually reload it succeded . how can i set it on sever continously so that reload not failed.

Re: QVD reload Fail on reload failed

its_anandrjs — Fri, 31 Oct 2014 07:23:53 GMT

I believe you can fetch data from the SQL server some time this problem occurs due to table use, otherwise you can write the script for error mode to ignore the error on the above of the scripts.

set ErrorMode=0;

Load

From Location;

Regards

Anand

Re: QVD reload Fail on reload failed

jagan — Fri, 31 Oct 2014 07:28:35 GMT

Hi,

What is the error you are getting? Did you check the error message in log file? If log file is not generated then configure to generate the Log file like below

Document Properties -> General -> Select Generate Log File -> select Timestamp in Log file name

Hope this helps you.

Regards,

Jagan.

Re: QVD reload Fail on reload failed

noman212 — Sat, 01 Nov 2014 06:02:19 GMT

11/1/2014 11:05:33 AM: Execution started.

11/1/2014 11:05:33 AM: QlikView Version:11.20.12018.0

11/1/2014 11:05:33 AM: CPU Target x64

11/1/2014 11:05:33 AM: Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)

11/1/2014 11:05:33 AM: Wow64 mode Not using Wow64

11/1/2014 11:05:33 AM: MDAC Version 6.1.7601.17514

11/1/2014 11:05:33 AM: MDAC Full Install Version 6.1.7601.17514

11/1/2014 11:05:33 AM: PreferredCompression 2

11/1/2014 11:05:33 AM: EnableParallelReload 1

11/1/2014 11:05:33 AM: ParallelizeQvdLoads 1

11/1/2014 11:05:33 AM: AutoSaveAfterReload 0

11/1/2014 11:05:33 AM: BackupBeforeReload 0

11/1/2014 11:05:33 AM: EnableFlushLog 0

11/1/2014 11:05:33 AM: SaveInfoWhenSavingFile 0

11/1/2014 11:05:33 AM: UserLogfileCharset 1200

11/1/2014 11:05:33 AM: OdbcLoginTimeout -1

11/1/2014 11:05:33 AM: OdbcConnectionTimeout -1

11/1/2014 11:05:33 AM: ScriptWantsDbWrite false

11/1/2014 11:05:33 AM: ScriptWantsExe false

11/1/2014 11:05:33 AM: LogFile CodePage Used: 1200

11/1/2014 11:05:33 AM: Reload Executed By WINT8G2B7FSRAF\Qvadmin

11/1/2014 11:05:33 AM: Process Executing: QVB

11/1/2014 11:05:33 AM: Process ID: 2772

11/1/2014 11:05:33 AM: 0003 SET ThousandSep=','

11/1/2014 11:05:33 AM: 0004 SET DecimalSep='.'

11/1/2014 11:05:33 AM: 0005 SET MoneyThousandSep=','

11/1/2014 11:05:33 AM: 0006 SET MoneyDecimalSep='.'

11/1/2014 11:05:33 AM: 0007 SET MoneyFormat='$#,##0.00;($#,##0.00)'

11/1/2014 11:05:33 AM: 0008 SET TimeFormat='h:mm:ss TT'

11/1/2014 11:05:33 AM: 0009 SET DateFormat='M/D/YYYY'

11/1/2014 11:05:33 AM: 0010 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

11/1/2014 11:05:33 AM: 0011 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

11/1/2014 11:05:33 AM: 0012 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

11/1/2014 11:05:33 AM: 0264 OLEDB CONNECT32*Provider*XPassword*

11/1/2014 11:05:33 AM: Error: ErrorSource: Microsoft OLE DB Provider for ODBC Drivers, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

11/1/2014 11:05:33 AM: General Script Error

11/1/2014 11:05:33 AM: Execution Failed

11/1/2014 11:05:33 AM: Execution finished.

Re: QVD reload Fail on reload failed

noman212 — Sat, 01 Nov 2014 06:03:39 GMT

When i manually reload this script it succeded butr when i reload continously on server its failed.....

pls read error log...help required.

Re: QVD reload Fail on reload failed

jagan — Mon, 03 Nov 2014 01:29:41 GMT

Hi Khan,

I think the problem is with the ODBC driver, did you created the ODBC driver in the server?

Regards,

Jagan.