topic Re: JOINS cause script failures in QlikView

JOINS cause script failures

Fri, 02 Oct 2015 19:42:01 GMT

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 [

];

LEFT JOIN (TABLE1)

LOAD * INLINE [

A, B

1,2

1,3

2,2

];

Re: JOINS cause script failures

Fri, 02 Oct 2015 19:51:56 GMT

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

Fri, 02 Oct 2015 20:17:46 GMT

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

Fri, 02 Oct 2015 20:20:30 GMT

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

Fri, 02 Oct 2015 20:59:31 GMT

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

Re: JOINS cause script failures

Fri, 02 Oct 2015 21:21:09 GMT

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.

Re: JOINS cause script failures

evan_kurowski — Sat, 03 Oct 2015 03:33:02 GMT

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

Digvijay_Singh — Sat, 03 Oct 2015 09:10:29 GMT

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 — Sat, 03 Oct 2015 13:42:50 GMT

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

Re: JOINS cause script failures

Mon, 05 Oct 2015 12:05:09 GMT

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

Re: JOINS cause script failures

Mon, 05 Oct 2015 12:11:42 GMT

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?

Re: JOINS cause script failures

Mon, 05 Oct 2015 12:19:02 GMT

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

Clever_Anjos — Mon, 05 Oct 2015 12:39:41 GMT

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

Re: JOINS cause script failures

Mon, 05 Oct 2015 12:43:58 GMT

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

Re: JOINS cause script failures

Anonymous — Mon, 05 Oct 2015 12:51:36 GMT

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

Re: JOINS cause script failures

Clever_Anjos — Mon, 05 Oct 2015 12:59:57 GMT

Sorry for misunderstanding.

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

Re: JOINS cause script failures

Mon, 05 Oct 2015 13:12:11 GMT

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.

Re: JOINS cause script failures

Mon, 05 Oct 2015 13:14:09 GMT

Same problem...

Re: JOINS cause script failures

Clever_Anjos — Mon, 05 Oct 2015 13:24:43 GMT

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

Here is working fine

Re: JOINS cause script failures

Mon, 05 Oct 2015 13:30:19 GMT

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