Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cheburashka
Creator III
Creator III

Load Inline does not work.

Hello,

I have a very basic script but it keeps on crashing (QlikView hangs) on the load inline.

No idea why. I assume some of my technical settings are wrong?

The script looks like:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€#.##0,00;-€#.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=0;

SET FirstMonthOfYear=0;

SET CollationLocale='';

Test:

LOAD * INLINE [

    F1, F2

    df, sdf

    sdf, asdf

];

Exit script

,Thanks for your advice

1 Solution

Accepted Solutions
gino_scheppers
Contributor III
Contributor III

Hi Koen,

Please check the answer at the end op thread:

https://community.qlik.com/message/1134171#1134171

Regards

Gino Scheppers

View solution in original post

20 Replies
cheburashka
Creator III
Creator III
Author

=========================   Document Info   ==========================

Document                           C:\Users\JD72306\OneDrive for Business\Projects\QlikViewModules\Asset Management with QVModules v3.1.qvw

Connection                         Local

DecimalSep                         Doc=","(2C)       Sys=","(2C)

ThousandSep                        Doc="."(2E)       Sys="."(2E)

ListSep                            Doc=","(2C)       Sys=";"(3B)

MoneyDecimalSep                    Doc=","(2C)       Sys=","(2C)

MoneyThousandSep                   Doc="."(2E)       Sys="."(2E)

MoneyFmt                           Doc="€#.##0,00;-€#.##0,00" Sys="€ #.##0,00;€ -#.##0,00"

TimeFmt                            Doc="hh:mm:ss"    Sys="h:mm:ss"

DateFmt                            Doc="DD/MM/YYYY"  Sys="D/MM/YYYY"

TimestampFmt                       Doc="DD/MM/YYYY hh:mm:ss[.fff]" Sys="D/MM/YYYY h:mm:ss[.fff]"

Document File Format               6000 (6000)

Saved in Version                   12.0.20200.0

Client NT Name                    

Access                             ADMIN

License                            -

Document License Status            ALLOWED

=======================   Object Cache Info   ========================

Object Cache Limit (MB)            1628.91

=========================   QlikView Info   ==========================

Client Version                     12.0.20200.0

Server Version                     -

QlikTech Product                   QlikView 64-bit Edition (x64)

License Key                        [Leased license]

PE Recoveries Remaining            4

CPU Target                         x64

===========================   INI Values   ===========================

AlwaysShowAdvancedDesignMenuItems  1

AutoSaveTimer                      30

BackupBeforeReload                 1

BookmarkDocument                   1

CalculationProgressInformation     2

CanDynamicUpdate                   1

CurSelFirstColWidth                83

CurSelSecondColWidth               49

DebugDlgHeight                     1045

DebugDlgWidth                      2003

DefaultObjectCaptionStyle          0

ExpOvwColWidths                    60,303,222,335,452,100,180,1915

ExpOvwFiltersMask                  -2147483635

FirstUserExperience                0

InstalledLIBID110                  {15B258E8-415E-11D1-934D-0040333C91CC}

InterfaceLanguage                  English

LeasedLicenseCheck                 d92838d8e384fcb82307234902db05fca2770cf4ba994c0884002b97af848054

LeasedLicenseExpiry                2017-01-22 17:00:19, 2016-12-23 17:00:19

MarginTop                          20

OverrideFileSecurity               1

OverrideLaunchSecurity             1

OverrideModuleSecurity             1

OverrideScriptSecurity             1

PreferredCompression               1

PreferredSearchStyle               1

PreferredSelCol                    2

PrintAndXLIconsForNewTables        0

QvScriptNormalText                 2000000,2FFFFFF,1,0,0

SavedCustomColors                  FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF

ScriptLogFolder                    C:\ProgramData\QlikTech\QlikView

SearchIconForNewListboxes          0

ShowSystemFields                   1

ShowSystemVariables                1

UseRelativePaths                   1

UserPrefGenerateLogfile            1

Utf8FileDlgPathSaveDoc             C:\Users\JD72306\OneDrive for Business\Projects\QlikViewModules

=======================   Local System Info   ========================

Operating System                   Windows 7 Enterprise Service Pack 1 (64 bit edition)

Operating System Version           6.1.7601

Wow64 mode                         Not using Wow64

IE Version                         9.11.9600.18524

MDAC Version                       6.1.7601.17514

MDAC Full Install Version          6.1.7601.17514

ComCtl32 version                   6.16.7601

Current Theme                      C:\Windows\resources\themes\Aero\Aero.msstyles

Graphics 1                         3440*1440 pixels. 2 Monitors.

Graphics 2                         32 Bit Color Depth. 120 XDpi. 120 YDpi.

Local Time                         2016-12-23 18:00

GMT Time                           2016-12-23 17:00

Country                            32 Belgium Belgium

Language                           0813 Dutch (Belgium) Dutch

Physical RAM(MB)                   16289

VMCommitted(MB)                    152

VMAllocated(MB)                    473

VMFree(MB)                         11162

VMLargestFreeBlock(MB)             11162

Number of CPUs                     8

CPU 0                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

CPU 1                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

CPU 2                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

CPU 3                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

CPU 4                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

CPU 5                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

CPU 6                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

CPU 7                              Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2693MHz

joseduque
Partner - Contributor III
Partner - Contributor III

Hi,

I paste yoru script and run a test is working fine. I attached image:

Did you use exit script at then end because you dont have to.

vishsaggi
Champion III
Champion III

I dont find any issue with your script? What is that happening? I mean hanging in the sense is the script exec progress window freezing up?

sunny_talwar

What is the exact error message you see?

vishsaggi
Champion III
Champion III

What happens when you run this in debug mode ? Can send us a screen shot of your progress window ?

sunny_talwar

One thing I would say is that make sure you have space between the word inline and [. In the script you have provided does have it, but may be for some reason it might not be in your actual load.

LOAD * INLINE[ -> will give error

LOAD * INLINE [ -> will work

cheburashka
Creator III
Creator III
Author

I just use the standard insert. so it created "INLINE ["

cheburashka
Creator III
Creator III
Author

It just stops doing anything and I have to close down qlikview using windows task manager.

sunny_talwar

Do you create logfile? Can you share the details within the logfile?