Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.
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.
When i manually reload this script it succeded butr when i reload continously on server its failed.....
pls read error log...help required.
Hi Khan,
I think the problem is with the ODBC driver, did you created the ODBC driver in the server?
Regards,
Jagan.