Reload Failing - but only on second attempt?

[#1]

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.

[Anonymous]

Are you using Publisher and distributing the qvw onto itself ? 

As this would result in the script being removed.

[#3]

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?

[Anonymous]

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

What happens if you run it a third time ?

[martynlloyd]

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

M.

[#6]

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

[#7]

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

[Giuseppe_Novello]

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

[Anonymous]

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.

[#10 · Accepted solution]

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