Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

JOINS cause script failures

I can't figure out what I am doing incorrectly.  Anytime I add a "JOIN" to my script, when I reload the data, the data loads into the tables, however, at the end of the script I get a "Execution of script error".  I have put logging on and I do not see any descriptive info in the log that points me in a direction to fix the problem.  Any ideas?

Sample code:

TABLE1:

LOAD * INLINE [

A

1

3

];

LEFT JOIN (TABLE1)

LOAD * INLINE [

A, B

1,2

1,3

2,2

];

24 Replies
Not applicable
Author

I save my qvw file before I run the reload and have no problem in doing that.  What file permissions should I be looking at?  What would Qlikview be running up against regarding file permissions during a reload of data?

Not applicable
Author

Appologize, that log was from prior attempts with a different qvw (but with the same problem).  Here is the log for the simpler qvw:

10/5/2015 8:16:07 AM:      Execution started.

10/5/2015 8:16:07 AM:      QlikView Version:11.20.12904.0

10/5/2015 8:16:07 AM:      CPU Target                    x64

10/5/2015 8:16:07 AM:      Operating System              Windows 7 Enterprise Service Pack 1 (64 bit edition)

10/5/2015 8:16:07 AM:      Wow64 mode                    Not using Wow64

10/5/2015 8:16:07 AM:      MDAC Version                  6.1.7601.17514

10/5/2015 8:16:07 AM:      MDAC Full Install Version     6.1.7601.17514

10/5/2015 8:16:07 AM:      PreferredCompression          2

10/5/2015 8:16:07 AM:      EnableParallelReload          1

10/5/2015 8:16:07 AM:      ParallelizeQvdLoads           1

10/5/2015 8:16:07 AM:      AutoSaveAfterReload           0

10/5/2015 8:16:07 AM:      BackupBeforeReload            0

10/5/2015 8:16:07 AM:      EnableFlushLog                0

10/5/2015 8:16:07 AM:      SaveInfoWhenSavingFile        0

10/5/2015 8:16:07 AM:      UserLogfileCharset            1200

10/5/2015 8:16:07 AM:      OdbcLoginTimeout              -1

10/5/2015 8:16:07 AM:      OdbcConnectionTimeout         -1

10/5/2015 8:16:07 AM:      ScriptWantsDbWrite            false

10/5/2015 8:16:07 AM:      ScriptWantsExe                false

10/5/2015 8:16:07 AM:      LogFile CodePage Used:        1200

10/5/2015 8:16:07 AM:       Reload Executed By xxxxxxxxxxx

10/5/2015 8:16:07 AM:       Process Executing: QlikView Desktop

10/5/2015 8:16:07 AM:       Process ID: 10196

10/5/2015 8:16:07 AM: 0002  SET ThousandSep=','

10/5/2015 8:16:07 AM: 0003  SET DecimalSep='.'

10/5/2015 8:16:07 AM: 0004  SET MoneyThousandSep=','

10/5/2015 8:16:07 AM: 0005  SET MoneyDecimalSep='.'

10/5/2015 8:16:07 AM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

10/5/2015 8:16:07 AM: 0007  SET TimeFormat='h:mm:ss TT'

10/5/2015 8:16:07 AM: 0008  SET DateFormat='M/D/YYYY'

10/5/2015 8:16:07 AM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

10/5/2015 8:16:07 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

10/5/2015 8:16:07 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

10/5/2015 8:16:07 AM: 0013  TABLE1:

10/5/2015 8:16:07 AM: 0014  LOAD * INLINE [

10/5/2015 8:16:07 AM: 0015  A

10/5/2015 8:16:07 AM: 0016  1

10/5/2015 8:16:07 AM: 0017  3

10/5/2015 8:16:07 AM: 0018  ]

10/5/2015 8:16:07 AM:       1 fields found: A, 2 lines fetched

10/5/2015 8:16:07 AM: 0020  LEFT JOIN (TABLE1)

10/5/2015 8:16:07 AM: 0021  LOAD * INLINE [

10/5/2015 8:16:07 AM: 0022  A, B

10/5/2015 8:16:07 AM: 0023  1,2

10/5/2015 8:16:07 AM: 0024  1,3

10/5/2015 8:16:07 AM: 0025  2,2

10/5/2015 8:16:07 AM: 0026  ]

10/5/2015 8:16:07 AM:       2 fields found: A, B, 3 lines fetched

10/5/2015 8:16:07 AM:       Joining/Keeping

10/5/2015 8:16:07 AM:       General Script Error

10/5/2015 8:16:07 AM:       Execution Failed

10/5/2015 8:16:07 AM:      Execution finished.

Clever_Anjos
Employee
Employee

When you script finishes the execution, Qlikview Distribution Service saves the file.

Steps that could solve your problem

1) Restart your QlikView services

2) Restart your server

Not applicable
Author

This is happening using the desktop version, not a server.

Anonymous
Not applicable
Author

Larry

Seems ok for me on my QV Desktop.

Can you try reloading the attached qvw on your environment and see how it fares for you.?

Clever_Anjos
Employee
Employee

Sorry for misunderstanding.

Have you tried to restart your desktop? Windows applications sometimes have weird behavior

Not applicable
Author

Yes, I have tried rebooting also. 

FYI, I do not have any problems loading data until I add a "JOIN" .  I have other, more involved qvw's where I am loading from spreadsheets and xml files into multiple tables, even using the "Except" function, and do not have problems.

Not applicable
Author

Same problem...

Clever_Anjos
Employee
Employee

That log file that you´ve posted generate the error there?

Here is working fine

Not applicable
Author

Yes, that log file is from the reload from that qvw.