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

Your sample code works fine. This is crashing for you if you put it into a brand new .qvw with nothing else?

Not applicable
Author

Correct.  It crashes with nothing else.  I've been trying this for the past 2 days with no success, using all types of examples of JOIN.

I can LOAD two tables, LOAD two tables with an Except() function, etc, but as soon as I add a JOIN my script fails on reload.  I've rebooted, upgraded, created new .qvw's .  Nothing seems to work.

Not applicable
Author

Log file produced:

10/2/2015 3:36:31 PM:      Execution started.

10/2/2015 3:36:31 PM:      QlikView Version:11.20.12904.0

10/2/2015 3:36:31 PM:      CPU Target                    x64

10/2/2015 3:36:31 PM:      Operating System              Windows 7 Enterprise Service Pack 1 (64 bit edition)

10/2/2015 3:36:31 PM:      Wow64 mode                    Not using Wow64

10/2/2015 3:36:31 PM:      MDAC Version                  6.1.7601.17514

10/2/2015 3:36:31 PM:      MDAC Full Install Version     6.1.7601.17514

10/2/2015 3:36:31 PM:      PreferredCompression          2

10/2/2015 3:36:31 PM:      EnableParallelReload          1

10/2/2015 3:36:31 PM:      ParallelizeQvdLoads           1

10/2/2015 3:36:31 PM:      AutoSaveAfterReload           0

10/2/2015 3:36:31 PM:      BackupBeforeReload            0

10/2/2015 3:36:31 PM:      EnableFlushLog                0

10/2/2015 3:36:31 PM:      SaveInfoWhenSavingFile        0

10/2/2015 3:36:31 PM:      UserLogfileCharset            1200

10/2/2015 3:36:31 PM:      OdbcLoginTimeout              -1

10/2/2015 3:36:31 PM:      OdbcConnectionTimeout         -1

10/2/2015 3:36:31 PM:      ScriptWantsDbWrite            false

10/2/2015 3:36:31 PM:      ScriptWantsExe                false

10/2/2015 3:36:31 PM:      LogFile CodePage Used:        1200

10/2/2015 3:36:31 PM:       Reload Executed By xxxxxx

10/2/2015 3:36:31 PM:       Process Executing: QlikView Desktop

10/2/2015 3:36:31 PM:       Process ID: 8956

10/2/2015 3:36:31 PM: 0003  SET DateFormat='M/D/YYYY'

10/2/2015 3:36:31 PM: 0232  TABLE1:

10/2/2015 3:36:31 PM: 0233  LOAD * INLINE [

10/2/2015 3:36:31 PM: 0234  A

10/2/2015 3:36:31 PM: 0235  1

10/2/2015 3:36:31 PM: 0236  3

10/2/2015 3:36:31 PM: 0237  ]

10/2/2015 3:36:31 PM:       1 fields found: A, 2 lines fetched

10/2/2015 3:36:31 PM: 0239  LEFT JOIN (TABLE1)

10/2/2015 3:36:31 PM: 0240  LOAD * INLINE [

10/2/2015 3:36:31 PM: 0241  A, B

10/2/2015 3:36:31 PM: 0242  1,2

10/2/2015 3:36:31 PM: 0243  1,3

10/2/2015 3:36:31 PM: 0244  2,2

10/2/2015 3:36:31 PM: 0245  ]

10/2/2015 3:36:31 PM:       2 fields found: A, B, 3 lines fetched

10/2/2015 3:36:31 PM:       Joining/Keeping

10/2/2015 3:36:31 PM:       General Script Error

10/2/2015 3:36:31 PM:       Execution Failed

10/2/2015 3:36:31 PM:      Execution finished.

Not applicable
Author

You sample code is correct, are you trying to store this table anywhere?

Not applicable
Author

No, I am not trying to store this table.  FYI, This is just a simple example of code that does not work in my QlikView editor. 

evan_kurowski
Specialist
Specialist

Hello Larry,

Looks like a large  gap in your log file row numbering.  What is happening between line 3 and 232?

Larry Witham wrote:

Log file produced:

10/2/2015 3:36:31 PM:       Process ID: 8956

10/2/2015 3:36:31 PM: 0003  SET DateFormat='M/D/YYYY'

10/2/2015 3:36:31 PM: 0232  TABLE1:

10/2/2015 3:36:31 PM: 0233  LOAD * INLINE [

10/2/2015 3:36:31 PM: 0234  A

10/2/2015 3:36:31 PM: 0235  1

Digvijay_Singh

Someone else also faced similar problem in the past but got rid of it by mere restart, strange  though

Re: Seemingly simple left join returns general script error

Clever_Anjos
Employee
Employee

I´m guessing you´re not having problems with JOIN, but saving your file, please check your file permissions

Not applicable
Author

Yeah, I saw that, and obviously tried it to no avail.