Reload in QMC - URL Requisition Conflict

tucahernandes — Tue, 05 Sep 2017 18:09:52 GMT

Hello

Since last night, my QMC's system is failing to automatically reload QVWs which contains "https://plataforma2.seekr.com.br" on their requisition URLs (which were working fine for months untill last night). If I open the same QVWs on their respectives folders, the reload is sucessful, manually.

Above, one log's example from an QVW with error:

2017-09-05 14:02:45 Execution started.

2017-09-05 14:02:45 QVB Version 12.0.20400.0

2017-09-05 14:02:45 CPU Target x64

2017-09-05 14:02:45 Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)

2017-09-05 14:02:45 Wow64 mode Not using Wow64

2017-09-05 14:02:45 Language 0416 Portuguese (Brazil) Portuguese

2017-09-05 14:02:45 Country 55 Brasil Brazil

2017-09-05 14:02:45 MDAC Version 6.1.7601.17514

2017-09-05 14:02:45 MDAC Full Install Version 6.1.7601.17514

2017-09-05 14:02:45 PreferredCompression 2

2017-09-05 14:02:45 EnableParallelReload 1

2017-09-05 14:02:45 ParallelizeQvdLoads 1

2017-09-05 14:02:45 AutoSaveAfterReload 0

2017-09-05 14:02:45 BackupBeforeReload 0

2017-09-05 14:02:45 EnableFlushLog 0

2017-09-05 14:02:45 SaveInfoWhenSavingFile 0

2017-09-05 14:02:45 UserLogfileCharset 65001

2017-09-05 14:02:45 OdbcLoginTimeout -1

2017-09-05 14:02:45 OdbcConnectionTimeout -1

2017-09-05 14:02:45 ScriptWantsDbWrite false

2017-09-05 14:02:45 ScriptWantsExe false

2017-09-05 14:02:45 LogFile CodePage Used: 65001

2017-09-05 14:02:45 UseMemoryFillPattern 1

2017-09-05 14:02:45 ScriptMode Legacy (gives greater system access) (aka qv11 mode)

2017-09-05 14:02:45 ReloadCodebase Classic

2017-09-05 14:02:45 Reload Executed By WIN-0BR5JCJRGAK\svc_qlikview

2017-09-05 14:02:45 Process Executing QVB

2017-09-05 14:02:45 Process ID 9312

2017-09-05 14:02:45 0002 SET ThousandSep='.'

2017-09-05 14:02:45 0003 SET DecimalSep=','

2017-09-05 14:02:45 0004 SET MoneyThousandSep='.'

2017-09-05 14:02:45 0005 SET MoneyDecimalSep=','

2017-09-05 14:02:45 0006 SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00'

2017-09-05 14:02:45 0007 SET TimeFormat='hh:mm:ss'

2017-09-05 14:02:45 0008 SET DateFormat='DD/MM/YYYY'

2017-09-05 14:02:45 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

2017-09-05 14:02:45 0010 SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez'

2017-09-05 14:02:45 0011 SET DayNames='seg;ter;qua;qui;sex;sáb;dom'

2017-09-05 14:02:45 0012 SET LongMonthNames='janeiro;fevereiro;março;abril;maio;junho;julho;agosto;setembro;outubro;novembro;dezembro'

2017-09-05 14:02:45 0013 SET LongDayNames='segunda-feira;terça-feira;quarta-feira;quinta-feira;sexta-feira;sábado;domingo'

2017-09-05 14:02:45 0014 SET FirstWeekDay=6

2017-09-05 14:02:45 0015 SET BrokenWeeks=1

2017-09-05 14:02:45 0016 SET ReferenceDay=0

2017-09-05 14:02:45 0017 SET FirstMonthOfYear=1

2017-09-05 14:02:45 0018 SET CollationLocale='pt-BR'

2017-09-05 14:02:45 0020 Teste:

2017-09-05 14:02:45 0021 LOAD

2017-09-05 14:02:45 0022 timestamp,

2017-09-05 14:02:45 0023 time

2017-09-05 14:02:45 0024 FROM [https://plataforma2.seekr.com.br/api/server_time.xml] (XmlSimple, Table is [seekr])

2017-09-05 14:02:52 Error: The download failed

2017-09-05 14:02:52 General Script Error

2017-09-05 14:02:52 Execution Failed

2017-09-05 14:02:52 Execution finished.

All other QVWs which make requisitions to others URLs are working fine.

Any clue of what is happening?

Re: Reload in QMC - URL Requisition Conflict

tucahernandes — Wed, 06 Sep 2017 19:17:41 GMT

Hello,

Although nobody replied yet, I found something that would help get things clearer here. When I replace the "xml" for "json" on the requisition URL (https://plataforma2.seekr.com.br/api/server_time.xml to https://plataforma2.seekr.com.br/api/server_time.json),‌, connecting through REST, the reload im QMC works fine.

It seems that the problem is related to xml requisitions in QMC's reload. Any ideas to fix it?

topic Re: Reload in QMC - URL Requisition Conflict in QlikView

Reload in QMC - URL Requisition Conflict

Re: Reload in QMC - URL Requisition Conflict