topic Re: Reload Failing - but only on second attempt? in QlikView

Reload Failing - but only on second attempt?

Thu, 04 Sep 2014 14:22:52 GMT

Hello,

I'm having a bit of a bizzare issue, and I wonder if anyone else has encoutered it.

I have a QV dashboard and when I reload it the first time (either via the management console in publisher or using personal addition) it works fine.

However when I reload it for a second time no data is loaded. I dont get any error messages, it just doesnt appear that any of the script is executed. When I switch logging on I get a full log file detailing the script the first time I run it, but when I run it a second time I just get log details at the end of this post.

I run the second load immediatly after the first, so nothing has changed in any of my source files. When I delete the version on the server and move a new version on from my laptop it reloads again, however only once.

Does anybody have any ideas on what might be going on?

Any help would greatly appreciated!

Cheers,

Alistair

Logging from an unsucesful load:

04/09/2014 11:46:35: Execution started.

04/09/2014 11:46:35: QlikView Version:11.20.12347.0

04/09/2014 11:46:35: CPU Target x64

04/09/2014 11:46:35: Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)

04/09/2014 11:46:35: Wow64 mode Not using Wow64

04/09/2014 11:46:35: MDAC Version xxxxx

04/09/2014 11:46:35: MDAC Full Install Version xxxxx

04/09/2014 11:46:35: PreferredCompression 2

04/09/2014 11:46:35: EnableParallelReload 1

04/09/2014 11:46:35: ParallelizeQvdLoads 1

04/09/2014 11:46:35: AutoSaveAfterReload 0

04/09/2014 11:46:35: BackupBeforeReload 0

04/09/2014 11:46:35: EnableFlushLog 0

04/09/2014 11:46:35: SaveInfoWhenSavingFile 0

04/09/2014 11:46:35: UserLogfileCharset 1200

04/09/2014 11:46:35: OdbcLoginTimeout -1

04/09/2014 11:46:35: OdbcConnectionTimeout -1

04/09/2014 11:46:35: ScriptWantsDbWrite false

04/09/2014 11:46:35: ScriptWantsExe false

04/09/2014 11:46:35: LogFile CodePage Used: 1200

04/09/2014 11:46:35: Reload Executed By xxxxx

04/09/2014 11:46:35: Process Executing: QlikView Desktop

04/09/2014 11:46:35: Process ID: 2920

04/09/2014 11:46:36: Execution finished.

Re: Reload Failing - but only on second attempt?

Anonymous — Thu, 04 Sep 2014 14:26:16 GMT

Are you using Publisher and distributing the qvw onto itself ?

As this would result in the script being removed.

Re: Reload Failing - but only on second attempt?

Thu, 04 Sep 2014 15:06:22 GMT

Hi Bill,

Thanks for getting back to me.

I get the same issue when I run in QV personal addition, which I do my development in, so dont think it's a distribution issue in publisher?

Re: Reload Failing - but only on second attempt?

Anonymous — Thu, 04 Sep 2014 15:10:16 GMT

Could you run it twice using your QV Desktop and share the 2 log files ?

What happens if you run it a third time ?

Re: Reload Failing - but only on second attempt?

martynlloyd — Thu, 04 Sep 2014 15:12:35 GMT

Are you locking the file in some way? Like not ticking "Close when finished" in the script execution window?

Re: Reload Failing - but only on second attempt?

Thu, 04 Sep 2014 15:30:10 GMT

I get the same error when it a third/ fourth time.

Log files below( I havent put all of the script in their and edited out some of the details etc.)

When it works(1st time)

04/09/2014 11:43:25: Execution started.

04/09/2014 11:43:25: QlikView Version:11.20.12347.0

04/09/2014 11:43:25: CPU Target x64

04/09/2014 11:43:25: Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)

04/09/2014 11:43:25: Wow64 mode Not using Wow64

04/09/2014 11:43:25: MDAC Version xxxxx

04/09/2014 11:43:25: MDAC Full Install Version xxxxx

04/09/2014 11:43:25: PreferredCompression 2

04/09/2014 11:43:25: EnableParallelReload 1

04/09/2014 11:43:25: ParallelizeQvdLoads 1

04/09/2014 11:43:25: AutoSaveAfterReload 0

04/09/2014 11:43:25: BackupBeforeReload 0

04/09/2014 11:43:25: EnableFlushLog 0

04/09/2014 11:43:25: SaveInfoWhenSavingFile 0

04/09/2014 11:43:25: UserLogfileCharset 1200

04/09/2014 11:43:25: OdbcLoginTimeout -1

04/09/2014 11:43:25: OdbcConnectionTimeout -1

04/09/2014 11:43:25: ScriptWantsDbWrite false

04/09/2014 11:43:25: ScriptWantsExe false

04/09/2014 11:43:25: LogFile CodePage Used: 1200

04/09/2014 11:43:25: Reload Executed By xxxxx

04/09/2014 11:43:25: Process Executing: QlikView Desktop

04/09/2014 11:43:25: Process ID: 2920

04/09/2014 11:43:25: 0002 SET ThousandSep=','

04/09/2014 11:43:25: 0003 SET DecimalSep='.'

04/09/2014 11:43:25: 0004 SET MoneyThousandSep=','

04/09/2014 11:43:25: 0005 SET MoneyDecimalSep='.'

04/09/2014 11:43:25: 0006 SET MoneyFormat='£#,##0.00;-£#,##0.00'

04/09/2014 11:43:25: 0007 SET TimeFormat='hh:mm:ss'

04/09/2014 11:43:25: 0008 SET DateFormat='DD/MM/YYYY'

04/09/2014 11:43:25: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

04/09/2014 11:43:25: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

04/09/2014 11:43:25: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

04/09/2014 11:43:25: 0014 ImageData:

04/09/2014 11:43:25: 0015

04/09/2014 11:43:25: 0016 LOAD * INLINE [

04/09/2014 11:43:25: 0017 ID, Cnt

04/09/2014 11:43:25: 0018 LogoLarger, 1

04/09/2014 11:43:25: 0019 LogoSmaller, 2

04/09/2014 11:43:25: 0020 Hexagon, 3

04/09/2014 11:43:25: 0021 Logo, 4

etc. etc. for the whole script.

See first post for results when it doesnt work.

Cheers,

Alistair

Re: Reload Failing - but only on second attempt?

Thu, 04 Sep 2014 15:31:32 GMT

Not sure if I am locking the file somehow, the "close when finished" box is checked but not sure if that would make a difference?

Cheers,

Alistair

Re: Reload Failing - but only on second attempt?

Giuseppe_Novello — Thu, 04 Sep 2014 15:39:01 GMT

Alistair,

Are you using ODBC or OLE BD? Have you try in another program besides Qlikview, like Excel?

If you are using ODBC, make sure that you have the latest driver installed.

Gio

Re: Reload Failing - but only on second attempt?

Anonymous — Thu, 04 Sep 2014 15:46:05 GMT

Alistair

After an unsuccessful reload, can you check that the script is still there ?

The unsuccessful log you shared is exactly as one would get if there was no script.

Re: Reload Failing - but only on second attempt?

Mon, 08 Sep 2014 15:36:52 GMT

Hi,

Thanks for everyones help. I managed to sort it out after a bit of thinking.

These were dashboards developed by a supplier, and there was a hidden script that was causing some issues. I manage to remove the script by exporting the dashbaords and deleting the .BAK file. Then I reloaded everything into a blank document and it worked!

Bit of an odd one, but thanks for you input.

Cheers,

Alistair