Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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?
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.
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
This is happening using the desktop version, not a server.
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.?
Sorry for misunderstanding.
Have you tried to restart your desktop? Windows applications sometimes have weird behavior
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.
Same problem...
That log file that you´ve posted generate the error there?
Here is working fine
Yes, that log file is from the reload from that qvw.