QVD reload Fail on reload failed

[noman212]

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.

[its_anandrjs]

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

[jagan · Accepted solution]

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.

[noman212]

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.

[noman212]

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

pls read error log...help required.

[jagan]

Hi Khan,

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

Regards,

Jagan.