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: 
rpacheco
Contributor III
Contributor III

Erro de recarga em aplicação

Bom Dia ! 

Tudo bem ?

Teve um aplicação que deu erro de recarga...vi o log mas não achei.

Alguém poderia me ajdar a entender, POR FAVOR !?!?!

Abaixo o log:

 

14/12/2018 02:30:03: Execution started.
14/12/2018 02:30:03: QlikView Version:11.20.13206.0
14/12/2018 02:30:03: CPU Target x64
14/12/2018 02:30:03: Operating System Windows Server 2012 R2 Standard (64 bit edition)
14/12/2018 02:30:03: Wow64 mode Not using Wow64
14/12/2018 02:30:03: MDAC Version 6.3.9600.16384
14/12/2018 02:30:03: MDAC Full Install Version 6.3.9600.16384
14/12/2018 02:30:03: PreferredCompression 2
14/12/2018 02:30:03: EnableParallelReload 1
14/12/2018 02:30:03: ParallelizeQvdLoads 1
14/12/2018 02:30:03: AutoSaveAfterReload 0
14/12/2018 02:30:03: BackupBeforeReload 0
14/12/2018 02:30:03: EnableFlushLog 0
14/12/2018 02:30:03: SaveInfoWhenSavingFile 0
14/12/2018 02:30:03: UserLogfileCharset 1200
14/12/2018 02:30:03: OdbcLoginTimeout -1
14/12/2018 02:30:03: OdbcConnectionTimeout -1
14/12/2018 02:30:03: ScriptWantsDbWrite false
14/12/2018 02:30:03: ScriptWantsExe false
14/12/2018 02:30:03: LogFile CodePage Used: 1200
14/12/2018 02:30:03: Reload Executed By LMTBI1\qlikview
14/12/2018 02:30:03: Process Executing: QVB
14/12/2018 02:30:03: Process ID: 7244
14/12/2018 02:30:03: 0003 SET ThousandSep=' '
14/12/2018 02:30:03: 0004 SET DecimalSep='.'
14/12/2018 02:30:03: 0005 SET MoneyThousandSep='.'
14/12/2018 02:30:03: 0006 SET MoneyDecimalSep=','
14/12/2018 02:30:03: 0007 SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00'
14/12/2018 02:30:03: 0008 SET TimeFormat='hh:mm:ss'
14/12/2018 02:30:03: 0009 SET DateFormat='DD/MM/YYYY'
14/12/2018 02:30:03: 0010 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'
14/12/2018 02:30:03: 0011 SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez'
14/12/2018 02:30:03: 0012 SET DayNames='seg;ter;qua;qui;sex;sáb;dom'
14/12/2018 02:30:03: 0016 Section Access
14/12/2018 02:30:03: 0017 Star is *
14/12/2018 02:30:03: 0018 LOAD [ACCESS],
14/12/2018 02:30:03: 0019 [USERID],
14/12/2018 02:30:03: 0020 [PASSWORD],
14/12/2018 02:30:03: 0021 NTNAME,
14/12/2018 02:30:03: 0022 PROFILE,
14/12/2018 02:30:03: 0023 MODALIDADE,
14/12/2018 02:30:03: 0024 AGENCIA,
14/12/2018 02:30:03: 0025 ACESSOS
14/12/2018 02:30:03: 0026 FROM
14/12/2018 02:30:03: 0027 [D:\Qlikview\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:03: 0028 (ooxml, embedded labels, table is user)
14/12/2018 02:30:03: 8 fields found: ACCESS, USERID, PASSWORD, NTNAME, PROFILE, MODALIDADE, AGENCIA, ACESSOS, 183 lines fetched
14/12/2018 02:30:03: 0031 Section Application
14/12/2018 02:30:03: 0032 Star is *
14/12/2018 02:30:03: 0033 LOAD PROFILE,
14/12/2018 02:30:03: 0034 idcliente,
14/12/2018 02:30:03: 0035 idclienteacesso
14/12/2018 02:30:03: 0036
14/12/2018 02:30:03: 0037 FROM
14/12/2018 02:30:03: 0038 [D:\Qlikview\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:03: 0039 (ooxml, embedded labels, table is profile)
14/12/2018 02:30:03: 3 fields found: PROFILE, idcliente, idclienteacesso, 2.072 lines fetched
14/12/2018 02:30:04: 0041 SECTION Application
14/12/2018 02:30:04: 0042 Star is *
14/12/2018 02:30:04: 0043 LOAD MODALIDADE,
14/12/2018 02:30:04: 0044 tipo_modalidade
14/12/2018 02:30:04: 0045
14/12/2018 02:30:04: 0046
14/12/2018 02:30:04: 0047 FROM
14/12/2018 02:30:04: 0048 [D:\Qlikview\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:04: 0049 (ooxml, embedded labels, table is modalidade)
14/12/2018 02:30:04: 2 fields found: MODALIDADE, tipo_modalidade, 3 lines fetched
14/12/2018 02:30:04: 0051 SECTION Application
14/12/2018 02:30:04: 0052 Star is *
14/12/2018 02:30:04: 0053 LOAD AGENCIA,
14/12/2018 02:30:04: 0054 idagencia
14/12/2018 02:30:04: 0055 FROM
14/12/2018 02:30:04: 0056 [D:\qlikview\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:04: 0057 (ooxml, embedded labels, table is agencia)
14/12/2018 02:30:04: 2 fields found: AGENCIA, idagencia, 115 lines fetched
14/12/2018 02:30:04: 0059 SECTION Application
14/12/2018 02:30:04: 0060 Star is *
14/12/2018 02:30:04: 0061 LOAD PROFILE,
14/12/2018 02:30:04: 0062 IDBUDGETCLIENTE
14/12/2018 02:30:04: 0063 FROM
14/12/2018 02:30:04: 0064 [D:\qlikview\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:04: 0065 (ooxml, embedded labels, table is Budget)
14/12/2018 02:30:04: 2 fields found: PROFILE, IDBUDGETCLIENTE, 269 lines fetched
14/12/2018 02:30:04: 0068 SECTION Application
14/12/2018 02:30:04: 0069 Star is *
14/12/2018 02:30:04: 0070 LOAD PROFILE,
14/12/2018 02:30:04: 0071 EXTRATO_DU,
14/12/2018 02:30:04: 0072 EXTRATO_SANTANDER,
14/12/2018 02:30:04: 0073 PERFIL
14/12/2018 02:30:04: 0074 FROM
14/12/2018 02:30:04: 0075 [D:\qlikview\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:04: 0076 (ooxml, embedded labels, table is Extratos)
14/12/2018 02:30:04: 4 fields found: PROFILE, EXTRATO_DU, EXTRATO_SANTANDER, PERFIL, 7 lines fetched
14/12/2018 02:30:04: 0078 SECTION Application
14/12/2018 02:30:04: 0079 Star is *
14/12/2018 02:30:04: 0080 LOAD ACESSOS,
14/12/2018 02:30:04: 0081 AEREO,
14/12/2018 02:30:04: 0082 BILHETE,
14/12/2018 02:30:04: 0083 CARRO,
14/12/2018 02:30:04: 0084 HOTEL,
14/12/2018 02:30:04: 0085 ROTA,
14/12/2018 02:30:04: 0086 SEGURO
14/12/2018 02:30:04: 0087 FROM
14/12/2018 02:30:04: 0088 [D:\QlikView\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:04: 0089 (ooxml, embedded labels, table is LimitExtratos)
14/12/2018 02:30:04: 7 fields found: ACESSOS, AEREO, BILHETE, CARRO, HOTEL, ROTA, SEGURO, 176 lines fetched
14/12/2018 02:30:04: 0091 SECTION Application
14/12/2018 02:30:04: 0092 Star is *
14/12/2018 02:30:04: 0093 LOAD
14/12/2018 02:30:04: 0094 PROFILE,
14/12/2018 02:30:04: 0095 TIPODOCLIENTE
14/12/2018 02:30:04: 0096 FROM
14/12/2018 02:30:04: 0097 [D:\qlikview\Arquivos\FONTE_DADOS\XLS\SEGURANCA_VIAJE.xlsx]
14/12/2018 02:30:04: 0098 (ooxml, embedded labels, table is Tipo)
14/12/2018 02:30:04: 2 fields found: PROFILE, TIPODOCLIENTE, 147 lines fetched
14/12/2018 02:30:04: 0103 LOAD id as id_projeto,
14/12/2018 02:30:04: 0104 codigo as projetos
14/12/2018 02:30:04: 0105 FROM
14/12/2018 02:30:04: 0106 [D:\QVD Store\D\Gerencial\Projetos.qvd]
14/12/2018 02:30:04: 0107 (qvd)
14/12/2018 02:30:04: 2 fields found: id_projeto, projetos, 20.554 lines fetched
14/12/2018 02:30:04: 0109 ConfiguracaoExibir:
14/12/2018 02:30:04: 0110
14/12/2018 02:30:04: 0111 LOAD idcliente,
14/12/2018 02:30:04: 0112 exibirtaxas
14/12/2018 02:30:04: 0113 FROM
14/12/2018 02:30:04: 0114 [D:\QVD Store\D\Gerencial\Configuracao.qvd]
14/12/2018 02:30:04: 0115 (qvd)
14/12/2018 02:30:04: 2 fields found: idcliente, exibirtaxas, 2.159 lines fetched
14/12/2018 02:30:04: 0118 DescMes:
14/12/2018 02:30:04: 0119 LOAD * INLINE [
14/12/2018 02:30:04: 0120 mes, descMes, descMesSoli, Trimestre, Semestre
14/12/2018 02:30:04: 0121 1 , Jan , jan , 1 , 1
14/12/2018 02:30:04: 0122 2 , Fev , fev , 1 , 1
14/12/2018 02:30:04: 0123 3 , Mar , mar , 1 , 1
14/12/2018 02:30:04: 0124 4 , Abr , abr , 2 , 1
14/12/2018 02:30:04: 0125 5 , Mai , mai , 2 , 1
14/12/2018 02:30:04: 0126 6 , Jun , jun , 2 , 1
14/12/2018 02:30:04: 0127 7 , Jul , jul , 3 , 2
14/12/2018 02:30:04: 0128 8 , Ago , ago , 3 , 2
14/12/2018 02:30:04: 0129 9 , Set , set , 3 , 2
14/12/2018 02:30:04: 0130 10 , Out , out , 4 , 2
14/12/2018 02:30:04: 0131 11 , Nov , nov , 4 , 2
14/12/2018 02:30:04: 0132 12 , Dez , dez , 4 , 2
14/12/2018 02:30:04: 0133 ]
14/12/2018 02:30:04: 5 fields found: mes, descMes, descMesSoli, Trimestre, Semestre, 12 lines fetched
14/12/2018 02:30:04: 0135 Hotel:
14/12/2018 02:30:04: 0136 load
14/12/2018 02:30:04: 0137 Distinct
14/12/2018 02:30:04: 0138 Capitalize(Month(dtin)) & '/' & Year(dtin) as dtinmesano,
14/12/2018 02:30:04: 0139 Capitalize(Day(dtin)) & '/' & Month(dtin) as dtindiames,
14/12/2018 02:30:04: 0140 Capitalize(Month(dtout)) & '/' & Year(dtout) as dtoutmesano,
14/12/2018 02:30:04: 0141 Capitalize(Day(dtout)) & '/' & Month(dtout) as dtoutdiames,
14/12/2018 02:30:04: 0142 idsv,
14/12/2018 02:30:04: 0143 idhotel,
14/12/2018 02:30:04: 0144 timestamp(dtin, 'DD/MM/YYYY hh:mm') as dtin,
14/12/2018 02:30:04: 0145 timestamp(dtout, 'DD/MM/YYYY hh:mm') as dtout,
14/12/2018 02:30:04: 0146 antecedencia,
14/12/2018 02:30:04: 0147 nomehotel,
14/12/2018 02:30:04: 0148 voucher,
14/12/2018 02:30:04: 0149 obs,
14/12/2018 02:30:04: 0150 if(selfbooking = 1, 'Online', 'Offline') as Online,
14/12/2018 02:30:04: 0151 diarias,
14/12/2018 02:30:04: 0152 categoria,
14/12/2018 02:30:04: 0153 sourcehotel,
14/12/2018 02:30:04: 0154 tipo_apartamento,
14/12/2018 02:30:04: 0155 cancelado,
14/12/2018 02:30:04: 0156 obsemissor,
14/12/2018 02:30:04: 0157 vlrdiaria,
14/12/2018 02:30:04: 0158 vlrtaxa,
14/12/2018 02:30:04: 0159 vlrextras,
14/12/2018 02:30:04: 0160 taxaadicional,
14/12/2018 02:30:04: 0161 vlrtotal,
14/12/2018 02:30:04: 0162 vlrtotalcomtaxa,
14/12/2018 02:30:04: 0163 vlrtotalcomtaxa + vlrextras as vlrtotalextras,
14/12/2018 02:30:04: 0164 forma_pagamento,
14/12/2018 02:30:04: 0165 codreserva,
14/12/2018 02:30:04: 0166 hotelcancelado,
14/12/2018 02:30:04: 0167 timestamp(datacancelada, 'DD/MM/YYYY hh:mm') as datacancelada,
14/12/2018 02:30:04: 0168 nome as EmissorReserva
14/12/2018 02:30:04: 0169 FROM
14/12/2018 02:30:04: 0170 [D:\QVD Store\F\Hotel\Hotel.qvd]
14/12/2018 02:30:04: 0171 (qvd)
14/12/2018 02:30:04: 31 fields found: dtinmesano, dtindiames, dtoutmesano, dtoutdiames, idsv, idhotel, dtin, dtout, antecedencia, nomehotel, voucher, obs, Online, diarias, categoria, sourcehotel, tipo_apartamento, cancelado, obsemissor, vlrdiaria, vlrtaxa, vlrextras, taxaadicional, vlrtotal, vlrtotalcomtaxa, vlrtotalextras, forma_pagamento, codreserva, hotelcancelado, datacancelada, EmissorReserva, 1.170.831 lines fetched
14/12/2018 02:31:11: 0173 inner join
14/12/2018 02:31:11: 0174
14/12/2018 02:31:11: 0175 Soli_hotel:
14/12/2018 02:31:11: 0176 load
14/12/2018 02:31:11: 0177 Distinct
14/12/2018 02:31:11: 0178 idsv,
14/12/2018 02:31:11: 0179 Year(dtcadsv) as ano,
14/12/2018 02:31:11: 0180 Month(dtcadsv) as mes,
14/12/2018 02:31:11: 0181 Day(dtcadsv) as dia,
14/12/2018 02:31:11: 0182 Capitalize(Month(dtcadsv)) & '/' & Year(dtcadsv) as mesano,
14/12/2018 02:31:11: 0183 Capitalize(Day(dtcadsv)) & '/' & Month(dtcadsv) as diames,
14/12/2018 02:31:11: 0184 Capitalize(Month(dtconclusao)) & '/' & Year(dtconclusao) as mesano_conclusao,
14/12/2018 02:31:11: 0185 Capitalize(Day(dtconclusao)) & '/' & Month(dtconclusao) as diames_conclusao,
14/12/2018 02:31:11: 0186 id_projeto,
14/12/2018 02:31:11: 0187 unidadedenegocio,
14/12/2018 02:31:11: 0188 timestamp(dtcadsv, 'DD/MM/YYYY hh:mm') as dtcadsv,
14/12/2018 02:31:11: 0189 timestamp(dtorcamento, 'DD/MM/YYYY hh:mm') as dtorcamento,
14/12/2018 02:31:11: 0190 timestamp(dtaprovacao, 'DD/MM/YYYY hh:mm') as dtaprovacao,
14/12/2018 02:31:11: 0191 timestamp(dtconclusao, 'DD/MM/YYYY hh:mm') as dtconclusao,
14/12/2018 02:31:11: 0192 idregional,
14/12/2018 02:31:11: 0193 idcentrocusto,
14/12/2018 02:31:11: 0194 cthotel as codcontacontabil,
14/12/2018 02:31:11: 0195 if(tipoviagem = 'N', 'Nacional',if(tipoviagem = 'C', 'Internacional Continental',
14/12/2018 02:31:11: 0196 if(tipoviagem = 'IC', 'Internacional Intercontinental'))) as tipoviagem,
14/12/2018 02:31:11: 0197 idsolicitante,
14/12/2018 02:31:11: 0198 idpassageiro,
14/12/2018 02:31:11: 0199 idaprovador,
14/12/2018 02:31:11: 0200 idemissor,
14/12/2018 02:31:11: 0201 pc,
14/12/2018 02:31:11: 0202 obssolicitacao,
14/12/2018 02:31:11: 0203 Capitalize(trim(justificativasv)) as justificativasv,
14/12/2018 02:31:11: 0204 controlecliente,
14/12/2018 02:31:11: 0205 adiantamento,
14/12/2018 02:31:11: 0206 nomestatus,
14/12/2018 02:31:11: 0207 perfil,
14/12/2018 02:31:11: 0208 controle_fixo,
14/12/2018 02:31:11: 0209 justificativapt as just_politica_antecedencia,
14/12/2018 02:31:11: 0210 complento_justificativa_politica_antecedencia,
14/12/2018 02:31:11: 0211 complemento_motivo_viagem,
14/12/2018 02:31:11: 0212 tipo_modalidade,
14/12/2018 02:31:11: 0213 tipo_solicitacao,
14/12/2018 02:31:11: 0214 idformulario,
14/12/2018 02:31:11: 0215 autoconclusao
14/12/2018 02:31:11: 0216 From
14/12/2018 02:31:11: 0217 [D:\QVD Store\F\Gerencial\Solicitacao.qvd]
14/12/2018 02:31:11: 0218 (qvd)
14/12/2018 02:31:12: 37 fields found: idsv, ano, mes, dia, mesano, diames, mesano_conclusao, diames_conclusao, id_projeto, unidadedenegocio, dtcadsv, dtorcamento, dtaprovacao, dtconclusao, idregional, idcentrocusto, codcontacontabil, tipoviagem, idsolicitante, idpassageiro, idaprovador, idemissor, pc, obssolicitacao, justificativasv, controlecliente, adiantamento, nomestatus, perfil, controle_fixo, just_politica_antecedencia, complento_justificativa_politica_antecedencia, complemento_motivo_viagem, tipo_modalidade, tipo_solicitacao, idformulario, autoconclusao, 2.296.832 lines fetched
14/12/2018 02:33:24: Joining/Keeping
14/12/2018 02:33:28: 0220 inner join
14/12/2018 02:33:28: 0221
14/12/2018 02:33:28: 0222 Cliente:
14/12/2018 02:33:28: 0223 LOAD idcliente,
14/12/2018 02:33:28: 0224 nomecliente,
14/12/2018 02:33:28: 0225 idagencia,
14/12/2018 02:33:28: 0226 nomeagencia,
14/12/2018 02:33:28: 0227 idregional,
14/12/2018 02:33:28: 0228 nomeregional
14/12/2018 02:33:28: 0229 FROM
14/12/2018 02:33:28: 0230 [D:\QVD Store\D\Gerencial\Cliente.qvd]
14/12/2018 02:33:28: 0231 (qvd)
14/12/2018 02:33:28: 6 fields found: idcliente, nomecliente, idagencia, nomeagencia, idregional, nomeregional, 6.613 lines fetched
14/12/2018 02:33:28: Joining/Keeping
14/12/2018 02:33:31: 0233 inner join
14/12/2018 02:33:31: 0234
14/12/2018 02:33:31: 0235 CentroCusto:
14/12/2018 02:33:31: 0236 Load
14/12/2018 02:33:31: 0237 idcentrocusto,
14/12/2018 02:33:31: 0238 nomecentrocusto,
14/12/2018 02:33:31: 0239 idpai,
14/12/2018 02:33:31: 0240 descricaocc,
14/12/2018 02:33:31: 0241 nomecentrocustopai,
14/12/2018 02:33:31: 0242 descricaoccpai
14/12/2018 02:33:31: 0243 FROM
14/12/2018 02:33:31: 0244 [D:\QVD Store\D\Gerencial\CentroCusto.qvd]
14/12/2018 02:33:31: 0245 (qvd)
14/12/2018 02:33:31: 6 fields found: idcentrocusto, nomecentrocusto, idpai, descricaocc, nomecentrocustopai, descricaoccpai, 62.303 lines fetched
14/12/2018 02:33:31: Joining/Keeping
14/12/2018 02:33:34: 0247 left join
14/12/2018 02:33:34: 0248
14/12/2018 02:33:34: 0249 Solicitante:
14/12/2018 02:33:34: 0250 Load
14/12/2018 02:33:34: 0251 idsolicitante,
14/12/2018 02:33:34: 0252 nomesolicitante
14/12/2018 02:33:34: 0253 From
14/12/2018 02:33:34: 0254 [D:\QVD Store\D\Gerencial\Solicitante.qvd]
14/12/2018 02:33:34: 0255 (qvd)
14/12/2018 02:33:34: 2 fields found: idsolicitante, nomesolicitante, 71.337 lines fetched
14/12/2018 02:33:34: Joining/Keeping
14/12/2018 02:33:35: 0257 left join
14/12/2018 02:33:35: 0258
14/12/2018 02:33:35: 0259 Passageiro:
14/12/2018 02:33:35: 0260 LOAD idpassageiro,
14/12/2018 02:33:35: 0261 nomepassageiro,
14/12/2018 02:33:35: 0262 deptopax,
14/12/2018 02:33:35: 0263 matriculapax,
14/12/2018 02:33:35: 0264 cargopassageiro,
14/12/2018 02:33:35: 0265 tipo_perfil
14/12/2018 02:33:35: 0266 FROM
14/12/2018 02:33:35: 0267 [D:\QVD Store\D\Gerencial\Passageiro.qvd]
14/12/2018 02:33:35: 0268 (qvd)
14/12/2018 02:33:35: 6 fields found: idpassageiro, nomepassageiro, deptopax, matriculapax, cargopassageiro, tipo_perfil, 257.934 lines fetched
14/12/2018 02:33:36: Joining/Keeping
14/12/2018 02:33:38: 0270 left join
14/12/2018 02:33:38: 0271
14/12/2018 02:33:38: 0272 Aprovador:
14/12/2018 02:33:38: 0273 Load
14/12/2018 02:33:38: 0274 idaprovador,
14/12/2018 02:33:38: 0275 nomeaprovador
14/12/2018 02:33:38: 0276 From
14/12/2018 02:33:38: 0277 [D:\QVD Store\D\Gerencial\Aprovador.qvd]
14/12/2018 02:33:38: 0278 (qvd)
14/12/2018 02:33:38: 2 fields found: idaprovador, nomeaprovador, 22.591 lines fetched
14/12/2018 02:33:38: Joining/Keeping
14/12/2018 02:33:40: 0280 left join
14/12/2018 02:33:40: 0281 Emissor:
14/12/2018 02:33:40: 0282 Load
14/12/2018 02:33:40: 0283 idemissor,
14/12/2018 02:33:40: 0284 Capitalize(nomeemissor) as nomeemissor
14/12/2018 02:33:40: 0285 From
14/12/2018 02:33:40: 0286 [D:\QVD Store\D\Gerencial\Emissor.qvd]
14/12/2018 02:33:40: 0287 (qvd)
14/12/2018 02:33:40: 2 fields found: idemissor, nomeemissor, 1.058 lines fetched
14/12/2018 02:33:40: Joining/Keeping
14/12/2018 02:33:42: 0289 left join
14/12/2018 02:33:42: 0290
14/12/2018 02:33:42: 0291 CidadeDestinoHotel:
14/12/2018 02:33:42: 0292 LOAD idhotel,
14/12/2018 02:33:42: 0293 nomeestadodestinohotel,
14/12/2018 02:33:42: 0294 nomecidadedestinohotel,
14/12/2018 02:33:42: 0295 nomecidadeestadodestinohotel,
14/12/2018 02:33:42: 0296 nomepaisdestinohotel
14/12/2018 02:33:42: 0297 FROM
14/12/2018 02:33:42: 0298 [D:\QVD Store\D\Hotel\CidadeDestinoHotel.qvd]
14/12/2018 02:33:42: 0299 (qvd)
14/12/2018 02:33:42: 5 fields found: idhotel, nomeestadodestinohotel, nomecidadedestinohotel, nomecidadeestadodestinohotel, nomepaisdestinohotel, 1.170.831 lines fetched
14/12/2018 02:33:43: Joining/Keeping
14/12/2018 02:33:46: 0301 left join
14/12/2018 02:33:46: 0302
14/12/2018 02:33:46: 0303 JustificativaHotel:
14/12/2018 02:33:46: 0304 LOAD idsv,
14/12/2018 02:33:46: 0305 justificativamaiortarifa,
14/12/2018 02:33:46: 0306 justificativamtfixa
14/12/2018 02:33:46: 0307 FROM
14/12/2018 02:33:46: 0308 [D:\QVD Store\D\Hotel\JustificativaHotel.qvd]
14/12/2018 02:33:46: 0309 (qvd)
14/12/2018 02:33:46: 3 fields found: idsv, justificativamaiortarifa, justificativamtfixa, 204.654 lines fetched
14/12/2018 02:33:46: Joining/Keeping
14/12/2018 02:33:48: 0311 left join
14/12/2018 02:33:48: 0312
14/12/2018 02:33:48: 0313 acompanhante:
14/12/2018 02:33:48: 0314 LOAD idsv,
14/12/2018 02:33:48: 0315 if(IsNull(nomaco_1) and IsNull(nomaco_2) and IsNull(nomaco_3) and IsNull(nomaco_4), 'Sem Acompanhante',
14/12/2018 02:33:48: 0316 if(not IsNull(nomaco_1) and IsNull(nomaco_2) and IsNull(nomaco_3) and IsNull(nomaco_4), nomaco_1,
14/12/2018 02:33:48: 0317 if(not IsNull(nomaco_1) and not IsNull(nomaco_2) and IsNull(nomaco_3) and IsNull(nomaco_4), nomaco_1 & ' | ' & nomaco_2,
14/12/2018 02:33:48: 0318 if(not IsNull(nomaco_1) and not IsNull(nomaco_2) and not IsNull(nomaco_3) and IsNull(nomaco_4), nomaco_1 & ' | ' & nomaco_2 & ' | ' & nomaco_3,
14/12/2018 02:33:48: 0319 if(not IsNull(nomaco_1) and not IsNull(nomaco_2) and not IsNull(nomaco_3) and not IsNull(nomaco_4), nomaco_1 & ' | ' & nomaco_2 & ' | ' & nomaco_3 & ' | ' & nomaco_4, 'Sem Acompanhante'
14/12/2018 02:33:48: 0320 ))))) as nomes
14/12/2018 02:33:48: 0321 FROM
14/12/2018 02:33:48: 0322 [D:\QVD Store\D\Hotel\HotelAcomp.qvd]
14/12/2018 02:33:48: 0323 (qvd)
14/12/2018 02:33:48: 2 fields found: idsv, nomes, 114.289 lines fetched
14/12/2018 02:33:49: Joining/Keeping
14/12/2018 02:33:51: 0326 Translations:
14/12/2018 02:33:51: 0327 LOAD Reference,
14/12/2018 02:33:51: 0328 PT,
14/12/2018 02:33:51: 0329 EN,
14/12/2018 02:33:51: 0330 ES
14/12/2018 02:33:51: 0331 FROM
14/12/2018 02:33:51: 0332 [D:\Qlikview\Arquivos\FONTE_DADOS\XLS\LanguageMapping_new.xls]
14/12/2018 02:33:51: 0333 (biff, embedded labels, table is Wordlist$)
14/12/2018 02:33:51: 4 fields found: Reference, PT, EN, ES, 1.468 lines fetched
14/12/2018 02:33:51: 0335 Languagens:
14/12/2018 02:33:51: 0336 LOAD
14/12/2018 02:33:51: 0337 Language,
14/12/2018 02:33:51: 0338 Description,
14/12/2018 02:33:51: 0339 Abrev
14/12/2018 02:33:51: 0340 FROM
14/12/2018 02:33:51: 0341 D:\Qlikview\Arquivos\FONTE_DADOS\XLS\LanguageMapping_new.xls
14/12/2018 02:33:51: 0342 (biff, embedded labels, Table is [Languagens$])
14/12/2018 02:33:51: 3 fields found: Language, Description, Abrev, 3 lines fetched
14/12/2018 02:33:51: 0344 Qualify *
14/12/2018 02:33:51: 0345 glossario:
14/12/2018 02:33:51: 0346 LOAD [Codigo busca],
14/12/2018 02:33:51: 0347 Cod,
14/12/2018 02:33:51: 0348 Titulo,
14/12/2018 02:33:51: 0349 Descrição,
14/12/2018 02:33:51: 0350 ABA
14/12/2018 02:33:51: 0351 FROM
14/12/2018 02:33:51: 0352 [D:\Documentos Qlikview\Glossario\glossario atualizado.xlsx]
14/12/2018 02:33:51: 0353 (ooxml, embedded labels, table is extrato_hotel)
14/12/2018 02:33:51: 5 fields found: glossario.Codigo busca, glossario.Cod, glossario.Titulo, glossario.Descrição, glossario.ABA, 1 lines fetched
14/12/2018 02:33:53: Execution finished.

0 Replies