EasyQlik Community

App analysis stalls and never completes

We have an app without data and with no more than 100 objects that gets stuck in the analysis phase. When we refresh the page, or even restart the service, the app data appears to have been collected, but when we attempt to load it, it continues to stall at 97% finished.

The error log has this error. (Note: I don’t see a log file being created in C:\Users<user>\AppData\Local\EasyQlik)

2021-09-08 11:33:50.2055 Qsda.QsAppMeta.ParserHelper.ParseElements Error Error parsing expanded expression “num(if(sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Source_Flag={‘SALE’},Weekending=,[Month Year]=,[Period Display]=,_Period={”"}>})=0 OR ISNULL(sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Source_Flag={‘SALE’},Weekending=,[Month Year]=,[Period Display]=,_Period={""}>})) OR 0=1,‘N/A’,
num(sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Source_Flag={‘SALE’}>})-sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Source_Flag={‘SALE’},Weekending=,[Month Year]=,[Period Display]=,_Period={""}>}),’’)
),’’)
/*
pick(match(GetFieldSelections([_MetricType]),‘Dollars’,‘Volume’,‘NewVolume’),
‘N/A’,
num($(vMarketVolumeChange),’$(vFormatNumber)’)
)
" SYNTACTIC Issue: mismatched input ‘"}>})) OR 0=1,‘N/A’,\nnum(sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Source_Flag={‘SALE’}>})-sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Source_Flag={‘SALE’},Weekending=,[Month Year]=,[Period Display]=,_Period={"’ expecting RCURLY From (1, 345) To (1, 345) ; SYNTACTIC Issue: mismatched input ‘}),’ expecting RCURLY From (2, 276) To (2, 276) ; SYNTACTIC Issue: mismatched input ‘)\n),’ expecting RPAREN From (2, 281) To (2, 281) ; SYNTACTIC Issue: extraneous input ‘\npick(match(GetFieldSelections([_MetricType]),’ expecting {LPAREN, SINGLE_QUOTE, DOLLAR, PLUS, MINUS, INTEGER, REAL, AGGR, FIRST_SORTED_VALUE, MAX, MIN, MODE, ONLY, SUM, COUNT, MISSING_COUNT, NULL_COUNT, NUMERIC_COUNT, TEXT_COUNT, AVG, CORREL, FRACTILE, FRACTILE_EXC, KURTOSIS, LINEST_R2, LINEST_DF, LINEST_F, LINEST_M, LINEST_SEB, LINEST_SEM, LINEST_SEY, LINEST_SSREG, LINEST_SSRESID, MEDIAN, SKEW, STDEV, STERR, STEYX, CONCAT, MAX_STRING, MIN_STRING, GEOREDUCEGEOMETRY, IRR, NPV, XIRR, XNPV, ROWNO, ABOVE, BELOW, BOTTOM, TOP, NOOFROWS, AFTER, BEFORE, FIRST, LAST, COLUMNNO, NOOFCOLUMNS, HRANK, RANK, BITNOT, NOT, IDENTIFIER, ‘$(’} From (4, 2) To (4, 2) ; SYNTACTIC Issue: extraneous input ‘Dollars’ expecting {SINGLE_QUOTE, DOLLAR, EQUAL, LESS, GREATER, ‘$(’, TEXT} From (5, 46) To (5, 46) ; SYNTACTIC Issue: mismatched input ‘,’ expecting {RPAREN, COMMA} From (5, 54) To (5, 54) ; SYNTACTIC Issue: mismatched input ‘’’ expecting {RPAREN, COMMA} From (6, 4) To (6, 4) ; SYNTACTIC Issue: Recognition exception: Exception of type ‘Antlr4.Runtime.InputMismatchException’ was thrown. on rule basicFunction From (1, 0) To (1, 0) ; SYNTACTIC Issue: Recognition exception: Exception of type ‘Antlr4.Runtime.InputMismatchException’ was thrown. on rule basicFunction From (1, 4) To (1, 4) ; SYNTACTIC Issue: Recognition exception: Exception of type ‘Antlr4.Runtime.InputMismatchException’ was thrown. on rule setExpressionFunctions From (1, 7) To (1, 7) ; SYNTACTIC Issue: Recognition exception: Exception of type ‘Antlr4.Runtime.InputMismatchException’ was thrown. on rule setExpression From (1, 11) To (1, 11) ; SYNTACTIC Issue: Recognition exception: Exception of type ‘Antlr4.Runtime.InputMismatchException’ was thrown. on rule elementSet From (1, 165) To (1, 165)
2021-09-08 11:33:50.2634 Qsda.QsAppMeta.ParserHelper.ParseElements Error Error parsing expanded expression "num(sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Trend_Flags=p(_Trend_Flags),-,
[Period Display]=,[Brand Name]=[Company Product],_Source_Flag={‘SALE’}>}),’’)

/*
if(GetFieldSelections(Source_Flag)=‘Retail’,NULL(),
if([_MetricType]=‘New Volume’,‘N/A’,
num($(vCompanyVolumeTrend),_Format)
)
)" SYNTACTIC Issue: missing {AGGR, FIRST_SORTED_VALUE, MAX, MIN, MODE, ONLY, SUM, COUNT, MISSING_COUNT, NULL_COUNT, NUMERIC_COUNT, TEXT_COUNT, AVG, CORREL, FRACTILE, FRACTILE_EXC, KURTOSIS, LINEST_R2, LINEST_DF, LINEST_F, LINEST_M, LINEST_SEB, LINEST_SEM, LINEST_SEY, LINEST_SSREG, LINEST_SSRESID, MEDIAN, SKEW, STDEV, STERR, STEYX, CONCAT, MAX_STRING, MIN_STRING, IRR, NPV, XIRR, XNPV, ROWNO, ABOVE, BELOW, BOTTOM, TOP, NOOFROWS, AFTER, BEFORE, FIRST, LAST, COLUMNNO, NOOFCOLUMNS, HRANK, RANK, IDENTIFIER} at ‘-’ From (1, 117) To (1, 117) ; SYNTACTIC Issue: missing EQUAL at ‘,’ From (1, 118) To (1, 118) ; SYNTACTIC Issue: extraneous input ‘)’ expecting {LPAREN, SINGLE_QUOTE, LCURLY, DOLLAR, PLUS, MINUS, INTEGER, REAL, TOTAL, ALL, DISTINCT, AGGR, FIRST_SORTED_VALUE, MAX, MIN, MODE, ONLY, SUM, COUNT, MISSING_COUNT, NULL_COUNT, NUMERIC_COUNT, TEXT_COUNT, AVG, CORREL, FRACTILE, FRACTILE_EXC, KURTOSIS, LINEST_R2, LINEST_DF, LINEST_F, LINEST_M, LINEST_SEB, LINEST_SEM, LINEST_SEY, LINEST_SSREG, LINEST_SSRESID, MEDIAN, SKEW, STDEV, STERR, STEYX, CONCAT, MAX_STRING, MIN_STRING, GEOREDUCEGEOMETRY, IRR, NPV, XIRR, XNPV, ROWNO, ABOVE, BELOW, BOTTOM, TOP, NOOFROWS, AFTER, BEFORE, FIRST, LAST, COLUMNNO, NOOFCOLUMNS, HRANK, RANK, BITNOT, NOT, IDENTIFIER, ‘$(’} From (2, 68) To (2, 68) ; SYNTACTIC Issue: Recognition exception: Exception of type ‘Antlr4.Runtime.NoViableAltException’ was thrown. on rule expression From (2, 68) To (2, 68)
2021-09-08 11:33:50.2856 Qsda.QsAppMeta.ParserHelper.ParseElements Error Error parsing expanded expression "num(sum({<[Source Of Business]=,Period=,YearMonth=,RollingPeriod=,RollingPeriodDisplay=,_Trend_Flags=p(_Trend_Flags),-,
[Period Display]=>}),’’)

/*
if(GetFieldSelections(Source_Flag)=‘Retail’,Null(),
pick(match(GetFieldSelections([_MetricType]),‘Dollars’,‘Volume’,‘NewVolume’),
‘N/A’,
num($(vVolumeVolumeTrend),’#,##0’),
‘N/A’
)
)

" SYNTACTIC Issue: missing {AGGR, FIRST_SORTED_VALUE, MAX, MIN, MODE, ONLY, SUM, COUNT, MISSING_COUNT, NULL_COUNT, NUMERIC_COUNT, TEXT_COUNT, AVG, CORREL, FRACTILE, FRACTILE_EXC, KURTOSIS, LINEST_R2, LINEST_DF, LINEST_F, LINEST_M, LINEST_SEB, LINEST_SEM, LINEST_SEY, LINEST_SSREG, LINEST_SSRESID, MEDIAN, SKEW, STDEV, STERR, STEYX, CONCAT, MAX_STRING, MIN_STRING, IRR, NPV, XIRR, XNPV, ROWNO, ABOVE, BELOW, BOTTOM, TOP, NOOFROWS, AFTER, BEFORE, FIRST, LAST, COLUMNNO, NOOFCOLUMNS, HRANK, RANK, IDENTIFIER} at ‘-’ From (1, 117) To (1, 117) ; SYNTACTIC Issue: missing EQUAL at ‘,’ From (1, 118) To (1, 118) ; SYNTACTIC Issue: extraneous input ‘)’ expecting {LPAREN, SINGLE_QUOTE, LCURLY, DOLLAR, PLUS, MINUS, INTEGER, REAL, TOTAL, ALL, DISTINCT, AGGR, FIRST_SORTED_VALUE, MAX, MIN, MODE, ONLY, SUM, COUNT, MISSING_COUNT, NULL_COUNT, NUMERIC_COUNT, TEXT_COUNT, AVG, CORREL, FRACTILE, FRACTILE_EXC, KURTOSIS, LINEST_R2, LINEST_DF, LINEST_F, LINEST_M, LINEST_SEB, LINEST_SEM, LINEST_SEY, LINEST_SSREG, LINEST_SSRESID, MEDIAN, SKEW, STDEV, STERR, STEYX, CONCAT, MAX_STRING, MIN_STRING, GEOREDUCEGEOMETRY, IRR, NPV, XIRR, XNPV, ROWNO, ABOVE, BELOW, BOTTOM, TOP, NOOFROWS, AFTER, BEFORE, FIRST, LAST, COLUMNNO, NOOFCOLUMNS, HRANK, RANK, BITNOT, NOT, IDENTIFIER, ‘$(’} From (2, 19) To (2, 19) ; SYNTACTIC Issue: Recognition exception: Exception of type ‘Antlr4.Runtime.NoViableAltException’ was thrown. on rule expression From (2, 19) To (2, 19)

Hi Karl,
Can you export the collection – from the Admin → Collection List – and send to me so I can take a look?

-Rob

Thanks Rob. I created a support ticket to send the collection.