JOINS cause script failures

[#1]

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

];

[#2]

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

[#3]

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.

[#4]

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.

[#5]

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

[#6]

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]

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]

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

[#10]

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