Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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?

7 Replies
MVP
MVP

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

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

Not applicable

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

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

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

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

-Rob

Not applicable

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

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.

Not applicable

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

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
Contributor

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

I have exact the same problem. Any suggestion?

Not applicable

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

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.

Community Browser