Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: JOINS cause script failures

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

Not applicable

Re: JOINS cause script failures

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

Re: JOINS cause script failures

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

Re: JOINS cause script failures

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

Not applicable

Re: JOINS cause script failures

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
Not applicable

Re: JOINS cause script failures

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
Not applicable

Re: JOINS cause script failures

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

cuv
Not applicable

Re: JOINS cause script failures

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

Not applicable

Re: JOINS cause script failures

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