24 Replies Latest reply: Dec 7, 2015 8:04 AM by Olga Feuillet RSS

    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

      ];

        • Re: JOINS cause script failures
          Josh Meyer

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

            • 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.

            • 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.

                • Re: JOINS cause script failures
                  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

                    • Re: JOINS cause script failures

                      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.

                  • Re: JOINS cause script failures
                    Pratul Banerjee

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

                    • Re: JOINS cause script failures
                      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

                      • Re: JOINS cause script failures
                        Clever Anjos

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