I have a problem when using the auto reload [Qlikv... - Qlik Community

Report Inappropriate Content · ‎2011-12-30

Hi,

1] scheduled auto reload via the management console

I have a qwv file that should connect to an oracle database and gather some data.

If I run the file manually then there is no issue. If I configure this in the management console to run automatically at a certain time then the reload fails and in the logfile I see the following info.

Good to know: I'm running Qlikview Server 11 - 64 bit on a Window 2008 R2.

My connectionstring in the qvw is based on the 'Microoft ole db provider for Oracle'[Force 32 bit].

*********************************************************************************************************************************************************************************

The task "Reloaddata.qvw" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Reloaddata.qvw.

at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

--- End of inner exception stack trace ---

at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

--- End of inner exception stack trace ---

at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

********************************************************************************************************************************************************************************

2] I thought, let's try something else

I removed the 32 bit oracle client and installed the 64 bit oracle client. Problem there is that 'Microsoft oledb provider for oracle' is not available.

Only available option is 'Oracle provider for Ole DB'. Now the reload works in both cases [Manually \ Auto reload].

As soon as the reload is done, I opened a financial report and refreshed the data based on the previous reload.

Result: All the number values are changed and it looks like about 10 extra zero's were added after the comma.

Does anyone have a solution for the first issue or at least the second?

swuehl · ‎2011-12-30

If you say you manually loaded successfully, do yo load in a desktop client or from the server QMC?

Regarding your second problem, I remember some similar issues reported here, please search the forum, e.g.

http://community.qlik.com/message/134940

http://community.qlik.com/thread/27844

Report Inappropriate Content · ‎2011-12-30

Desktop client is installed on the server and,

With manual reload i mean loading the file from the desktop client.

As soon as i schedule it in the QMC, I get 'reload Failed' and the error as I mentioned above is the only info I can get out of the logfile

rwunderlich · ‎2011-12-30

Do you have a document logfile turned on for the document? What is in the document logfile?

-Rob

Report Inappropriate Content · ‎2011-12-31

Nothing much.

30/12/2011 18:09:12: Execution started.

30/12/2011 18:09:12: QlikView Version:11.00.11149.0

30/12/2011 18:09:12: CPU Target x64

30/12/2011 18:09:12: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

30/12/2011 18:09:12: Wow64 mode Not using Wow64

30/12/2011 18:09:12: MDAC Version 6.1.7601.17514

30/12/2011 18:09:12: MDAC Full Install Version 6.1.7601.17514

30/12/2011 18:09:12: PreferredCompression 2

30/12/2011 18:09:12: EnableParallelReload 1

30/12/2011 18:09:12: ParallelizeQvdLoads 1

30/12/2011 18:09:12: AutoSaveAfterReload 0

30/12/2011 18:09:12: BackupBeforeReload 0

30/12/2011 18:09:12: EnableFlushLog 0

30/12/2011 18:09:12: SaveInfoWhenSavingFile 0

30/12/2011 18:09:12: UserLogfileCharset 0

30/12/2011 18:09:12: OdbcLoginTimeout -1

30/12/2011 18:09:12: OdbcConnectionTimeout -1

30/12/2011 18:09:12: ScriptWantsDbWrite false

30/12/2011 18:09:12: ScriptWantsExe false

30/12/2011 18:09:12: LogFile CodePage Used: 1252

30/12/2011 18:09:12: 0002 SET ThousandSep='.'

30/12/2011 18:09:12: 0003 SET DecimalSep=','

30/12/2011 18:09:12: 0004 SET MoneyThousandSep='.'

30/12/2011 18:09:12: 0005 SET MoneyDecimalSep=','

30/12/2011 18:09:12: 0006 SET MoneyFormat='€ #.##0,00;€ -#.##0,00'

30/12/2011 18:09:12: 0007 SET TimeFormat='h:mm:ss'

30/12/2011 18:09:12: 0008 SET DateFormat='D/MM/YYYY'

30/12/2011 18:09:12: 0009 SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff]'

30/12/2011 18:09:12: 0010 SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec'

30/12/2011 18:09:12: 0011 SET DayNames='ma;di;wo;do;vr;za;zo'

30/12/2011 18:09:12: 0013 OLEDB CONNECT32*Provider*XPassword*

30/12/2011 18:09:12: Error: ErrorSource: (null), ErrorMsg: (null)

30/12/2011 18:09:12: General Script Error

30/12/2011 18:09:12: Execution Failed

30/12/2011 18:09:12: Execution finished.

Report Inappropriate Content · ‎2012-01-05

hey guys,

i ve the same error as adminfred has mentioned in his first post.

BUT: my qvw only loads data from QVD-Files, not from a DB-Source.

When i run the qvw in QVDesktop 11 it works perfect. when i run it as a task in QV Server 11 (SBE) it fails. any ideas?

but it worked when i had run it in QV Server 10..

eleni_theodorid · ‎2012-11-08

I have exact the same problem. Any suggestion?

Report Inappropriate Content · ‎2012-11-08

I solved the issue by using the function num() in my load script, same goes for date values if you have issues with that as well.

I have a problem when using the auto reload [Qlikview Server 11]