After Sense update 3.1 CALL qvc.CalendarFromField ('%Date') not working

[BImotive]

Hello Rob,

After updating today a client's server to sense 3.1 the reload of apps crash on the following:

Below part of script, see last lines " No qualified path for file: "\CalendarExtFields.qvs"

Any suggestions?

Kind regards Arjen

2016-09-21 15:10:31 0472 CALL qvc.CalendarFromField ('%Date') 2016-09-21 15:10:31 0473 2016-09-21 15:10:31 0483 UNQUALIFY "qvctemp." 2016-09-21 15:10:31 0485 CALL Qvc.GetFieldValues('_vStats', '%Date') 2016-09-21 15:10:31 2289 UNQUALIFY "qvctemp." 2016-09-21 15:10:31 2291 IF len('')=0 THEN 2016-09-21 15:10:31 2292 2016-09-21 15:10:31 2292 SET _vSource = ";LOAD FieldValue('%Date', recno()) as [%Date] AUTOGENERATE FieldValueCount('%Date')" 2016-09-21 15:10:31 2293 ELSEIF index('', '.') = 0 THEN 2016-09-21 15:10:31 2294 2016-09-21 15:10:31 2301 _qvctemp.temptab: 2016-09-21 15:10:31 2302 LOAD 2016-09-21 15:10:31 2303
2016-09-21 15:10:31 2304 max([%Date])+0 as _qvctemp.maxval, 2016-09-21 15:10:31 2305 min([%Date])+0 as _qvctemp.minval
2016-09-21 15:10:31 2306 2016-09-21 15:10:31 2304 LOAD FieldValue('%Date', recno()) as [%Date] AUTOGENERATE FieldValueCount('%Date') 2016-09-21 15:10:31 2 fields found: _qvctemp.maxval, _qvctemp.minval, 2016-09-21 15:10:31 1 lines fetched 2016-09-21 15:10:31 2308 LET _vStats.Max = replace(peek('_qvctemp.maxval'), ',', '.') 2016-09-21 15:10:31 2309 LET _vStats.Min = replace(peek('_qvctemp.minval'), ',', '.') 2016-09-21 15:10:31 2310 DROP table _qvctemp.temptab 2016-09-21 15:10:31 2312 SET _vSource= 2016-09-21 15:10:31 2313 END SUB 2016-09-21 15:10:31 2314 2016-09-21 15:10:31 0489 SET _Qvc.Calendar.v.Field.Date.Override='%Date' 2016-09-21 15:10:31 0491 CALL Qvc.Calendar(_vStats.Min, _vStats.Max, '', '', '') 2016-09-21 15:10:31 0178 UNQUALIFY "qvctemp." 2016-09-21 15:10:31 0181 LET _tableName = if(len('')=0, 'MasterCalendar','') 2016-09-21 15:10:31 0183 LET _firstMonth = if(len('')=0, 1,'') 2016-09-21 15:10:31 0184 LET monthOffset = -(1-1) 2016-09-21 15:10:31 0186 ** * * * * * * * **** 2016-09-21 15:10:31 0187 IF len('%Date') > 0 THEN
2016-09-21 15:10:31 0188 2016-09-21 15:10:31 0188 SET _fDate='[%Date]' 2016-09-21 15:10:31 0189 ELSE 2016-09-21 15:10:31 0190 2016-09-21 15:10:31 0192 SET _fDay='[Day]' 2016-09-21 15:10:31 0193 SET _fWeekday='[Weekday]' 2016-09-21 15:10:31 0194 SET _fYear='[Year]' 2016-09-21 15:10:31 0195 SET _fMonth='[Month]' 2016-09-21 15:10:31 0196 SET _fYearMonth='[Year-Month]' 2016-09-21 15:10:31 0197 SET _fQuarter='[Quarter]' 2016-09-21 15:10:31 0198 SET _f_MonthSerial='[_MonthSerial]' 2016-09-21 15:10:31 0199 SET _f_QuarterSerial='[_QuarterSerial]' 2016-09-21 15:10:31 0200 SET _f_WeekSerial='[_WeekSerial]' 2016-09-21 15:10:31 0201 SET _f_DateSerial='[_DateSerial]' 2016-09-21 15:10:31 0203 IF 'VIEW' = 'VIEW' OR len('')> 0 THEN 2016-09-21 15:10:31 0204 2016-09-21 15:10:31 0204 LET _qvctemp.v.IncludeExtension = replace( 2016-09-21 15:10:31 0205 '@(Include=@(Qvc.Global.Extension.Directory)\@(Qvc.Calendar.v.ExtFields))' 2016-09-21 15:10:31 0206 ,'@','$') 2016-09-21 15:10:31 0207 ELSE 2016-09-21 15:10:31 0208 2016-09-21 15:10:31 0211 LET concatenate = if(len(NoOfRows('MasterCalendar'))>0, 'CONCATENATE ([MasterCalendar])', '') 2016-09-21 15:10:31 0213 [MasterCalendar]: 2016-09-21 15:10:31 0214
2016-09-21 15:10:31 0215 LOAD 2016-09-21 15:10:31 0216 , 2016-09-21 15:10:31 0217 dual([Year] & '-' & [Month],Date(MonthStart([%Date],-0))) as [Year-Month] 2016-09-21 15:10:31 0218 2016-09-21 15:10:31 *_No qualified path for file: "\CalendarExtFields.qvs"** 2016-09-21 15:10:31 Execution Failed 2016-09-21 15:10:31 Execution finished.

[philippfrenzel]

Have you tried to rename %Date to varDate? Seems like a issue with the FieldName ...

[BImotive]

After your proposal I tried and changed the %Date field to Date. But things did not change. So problem persists.

Thx for your trouble

Arjen

Van: Philipp Frenzel [mailto:notifications@github.com] Verzonden: donderdag 22 september 2016 08:08 Aan: RobWunderlich/Qlikview-Components Qlikview-Components@noreply.github.com CC: Arjen Tervoort atervoort@bimotive.nl; Author author@noreply.github.com Onderwerp: Re: [RobWunderlich/Qlikview-Components] After Sense update 3.1 CALL qvc.CalendarFromField ('%Date') not working (#51)

Have you tried to rename %Date to varDate? Seems like a issue with the FieldName ...

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/RobWunderlich/Qlikview-Components/issues/51#issuecomment-248820287, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ATRF_DYyhv2qo5roKpL5sHgBhiQAEkqaks5qshtOgaJpZM4KC0yU.

[philippfrenzel]

how do you include the qvc lib? must_include or include?

[BImotive]

Must_Include. When running debugger it just works until the Mastercalender call. It is caused due to 3.0 -> 3.1 update. Same script runs without error on 3.0 server.

Arjen

Van: Philipp Frenzel [mailto:notifications@github.com] Verzonden: donderdag 22 september 2016 09:01 Aan: RobWunderlich/Qlikview-Components Qlikview-Components@noreply.github.com CC: Arjen Tervoort atervoort@bimotive.nl; Author author@noreply.github.com Onderwerp: Re: [RobWunderlich/Qlikview-Components] After Sense update 3.1 CALL qvc.CalendarFromField ('%Date') not working (#51)

how do you include the qvc lib? must_include or include?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/RobWunderlich/Qlikview-Components/issues/51#issuecomment-248827675, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ATRF_FLgTQuDd9iPCGnV0XXMR2NvRpGCks5qsifCgaJpZM4KC0yU.

[philippfrenzel]

do you already have a table named "Mastercalendar"? As the script will build a default Table with the name "MasterCalendar" -> attention on Upper/Lowercase!

[BImotive]

No. Today I installed sense server 3.0 again. All is working well again. Hope somebody helpd out voor 3.1 version

Arjen

Van: Philipp Frenzel notifications@github.com Beantwoorden - Aan: RobWunderlich/Qlikview-Components reply@reply.github.com Datum: donderdag 22 september 2016 10:25 Aan: RobWunderlich/Qlikview-Components Qlikview-Components@noreply.github.com CC: Arjen Tervoort atervoort@bimotive.nl, Author author@noreply.github.com Onderwerp: Re: [RobWunderlich/Qlikview-Components] After Sense update 3.1 CALL qvc.CalendarFromField ('%Date') not working (#51)

do you already have a table named "Mastercalendar"? As the script will build a default Table with the name "MasterCalendar" -> attention on Upper/Lowercase!

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/RobWunderlich/Qlikview-Components/issues/51#issuecomment-248841260, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ATRF_IKKN0lVLSVclhFX9okKnAlqMR_yks5qsjuNgaJpZM4KC0yU.

[awprotege]

Arjen,

I got the same error, and yes, it seems to happen only when I use Qlik Sense SERVER 3.1. Works just fine using Sense Desktop. Seems like Sense bug to me :)

Anton

[BImotive]

I made a bug request to Qlik on this issue.

[RobWunderlich]

I believe I've found the problem. Here's a workaround until I make a fix. Add a SET to clear _qvctemp.v.IncludeExtension before the include of Qvc.Qvs

SET _qvctemp.v.IncludeExtension=; SET QvcLib='lib://QVC'; $(Must_Include=$(QvcLib)\Qvc_Runtime\Qvc.qvs); SET Qvc.Global.v.QlikProduct='SENSE';