Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Product name | QMS Backend Core x64 | ||
Client Build Number | 11.0.11282.0 | ||
Target Platform | x64 |
Tenho 5 arquivos QVW, sendo que 4 deles são para conectar e extrair dados do banco de dados, gravando os arquivos QVD. O outro apenas lê os QVD´s gerados para exibir os dados.
Quando recarrego na mão, pelo Qlikview Personal, vai tudo sem problemas.
Entao criei os agendamentos para que a recarga fique automatica, mas tenho os erros abaixo tanto quando peço para executar (play), quanto executa pelo agendamento.
(2013-08-07 13:16:07) Information: Starting task 'Mix Vendas Leadtime.qvw'. Id:d8dbc341-4b9f-4166-be19-165cc1944584. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
(2013-08-07 13:16:07) Information: Entering Task Execution.
(2013-08-07 13:16:07) Information: ClusterID=1
(2013-08-07 13:16:07) Information: QDSID=400f89e8-828a-78ae-c20c-9efe3d019951
(2013-08-07 13:16:07) Information: TaskID=d8dbc341-4b9f-4166-be19-165cc1944584
(2013-08-07 13:16:07) Information: MaxRunTime=06:00:00
(2013-08-07 13:16:07) Information: MachineName=CPDSRV05
(2013-08-07 13:16:07) Information: Max attempts:1
(2013-08-07 13:16:07) Information: Current Attempt=0
(2013-08-07 13:16:07) Information: Task Dependencies are OK
(2013-08-07 13:16:07) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2013-08-07 13:16:07) Information: Opening "C:\Program Files\QlikView\Documents\Mix Vendas Leadtime.qvw"
(2013-08-07 13:16:07) Information: Allocating new QlikView Engine. Current usagecount=1 of 2
(2013-08-07 13:16:07) Information: Max retries:5
(2013-08-07 13:16:07) Information: Attempt:01
(2013-08-07 13:16:08) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=4
(2013-08-07 13:16:08) Information: Loading document "C:\Program Files\QlikView\Documents\Mix Vendas Leadtime.qvw" (159.65 Mb)
(2013-08-07 13:16:08) Information: Physical FileSize=159.65 Mb. Memory Allocation Delta for this file=31.11 Mb. Available Physical Memory Before Open=21661.34 Mb. Available Physical Memory After Open=21626.18 Mb. Total Physical Memory=32733.38 Mb.
(2013-08-07 13:16:08) Information: Attempted to load the document without data.
(2013-08-07 13:16:08) Information: The document was loaded successfully.
(2013-08-07 13:16:08) Information: Document was opened successfully
(2013-08-07 13:16:08) Information: Starting reload
(2013-08-07 13:16:08) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
(2013-08-07 13:16:08) Information: The Source Document is being reloaded. DocumentPath=C:\Program Files\QlikView\Documents\Mix Vendas Leadtime.qvw
(2013-08-07 13:16:09) Information: Reloading.
(2013-08-07 13:16:10) Information: Reloading..
(2013-08-07 13:16:11) Information: Reloading...
(2013-08-07 13:16:12) Information: Reloading....
(2013-08-07 13:16:13) Information: Reloading.....
(2013-08-07 13:16:14) Information: Reloading......
(2013-08-07 13:16:15) Information: Reloading.......
(2013-08-07 13:16:16) Information: Reloading........
(2013-08-07 13:16:17) Information: Reloading.........
(2013-08-07 13:16:18) Information: Reloading..........
(2013-08-07 13:16:19) Information: Slow down logging. Log every <2> seconds.
(2013-08-07 13:16:19) Information: Reloading
(2013-08-07 13:16:21) Information: Reloading.
(2013-08-07 13:16:23) Information: Reloading..
(2013-08-07 13:16:25) Information: Reloading...
(2013-08-07 13:16:27) Information: Reloading....
(2013-08-07 13:16:29) Information: Reloading.....
(2013-08-07 13:16:31) Information: Reloading......
(2013-08-07 13:16:33) Information: Reloading.......
(2013-08-07 13:16:35) Information: Reloading........
(2013-08-07 13:16:37) Information: Reloading.........
(2013-08-07 13:16:39) Information: Reloading..........
(2013-08-07 13:16:41) Information: Slow down logging. Log every <10> seconds.
(2013-08-07 13:16:41) Information: Reloading
(2013-08-07 13:16:51) Information: Reloading.
(2013-08-07 13:17:01) Information: Reloading..
(2013-08-07 13:17:11) Information: Reloading...
(2013-08-07 13:17:21) Information: Reloading....
(2013-08-07 13:17:31) Information: Reloading.....
(2013-08-07 13:17:41) Information: Reloading......
(2013-08-07 13:17:51) Information: Reloading.......
(2013-08-07 13:18:01) Information: Reloading........
(2013-08-07 13:18:11) Information: Reloading.........
(2013-08-07 13:18:21) Information: Reloading..........
(2013-08-07 13:18:31) Information: Slow down logging. Log every <60> seconds.
(2013-08-07 13:18:31) Information: Reloading
(2013-08-07 13:18:44) Information: The Source Document reload complete. DocumentPath=C:\Program Files\QlikView\Documents\Mix Vendas Leadtime.qvw
(2013-08-07 13:18:44) Information: Memory Allocation Delta for this file=1568.50 Mb. Available Physical Memory Before Reload=21626.17 Mb. Available Physical Memory After Reload=20262.13 Mb. Total Physical Memory=20262.13 Mb.
(2013-08-07 13:18:44) Information: The Source Document was reloaded successfully.
(2013-08-07 13:18:44) Information: Reload finished successfully
(2013-08-07 13:18:44) Information: Start saving document
(2013-08-07 13:18:44) Error: Exception=System.Security.Principal.IdentityNotMappedException: Não foi possível converter algumas ou todas as referências de identidade.
(2013-08-07 13:18:44) Error: em System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess)
(2013-08-07 13:18:44) Error: em System.Security.Principal.NTAccount.Translate(Type targetType)
(2013-08-07 13:18:44) Error: em System.Security.AccessControl.CommonObjectSecurity.ModifyAccess(AccessControlModification modification, AccessRule rule, Boolean& modified)
(2013-08-07 13:18:44) Error: em System.Security.AccessControl.CommonObjectSecurity.AddAccessRule(AccessRule rule)
(2013-08-07 13:18:44) Error: em QVBWrapper.Document.CopyPermissionsToEmptyFile(ILogBucket i_LogBucket, String i_SourceFilename, String i_DestinationFileName)
(2013-08-07 13:18:44) Error: Could not touch target file
(2013-08-07 13:18:45) Information: Closing the document.
(2013-08-07 13:18:45) Information: Closed the QlikView Engine successfully. ProcessID=10336
(2013-08-07 13:18:45) Error: The task "Mix Vendas Leadtime.qvw" failed. Exception:
(2013-08-07 13:18:45) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: Could not touch target file
(2013-08-07 13:18:45) Error: em QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-08-07 13:18:45) Error: --- Fim do rastreamento de pilha de exceções internas ---
(2013-08-07 13:18:45) Error: em QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-08-07 13:18:45) Error: em QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-08-07 13:18:45) Error: --- Fim do rastreamento de pilha de exceções internas ---
(2013-08-07 13:18:45) Error: em QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-08-07 13:18:45) Error: em QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2013-08-07 13:18:45) Information: Task Execute Duration=00:02:38.0783118
(2013-08-07 13:18:45) Information: TaskResult.status=Finished
(2013-08-07 13:18:45) Information: Notifying all triggers of new state:FinishedWithErrors
(2013-08-07 13:18:45) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2013-08-07 13:18:45) Information: Saving Task Result
QVW LOG:
08/08/2013 14:29:43: | Execution started. | |
08/08/2013 14:29:43: | QlikView Version:11.00.11282.0 | |
08/08/2013 14:29:43: | CPU Target | x64 |
08/08/2013 14:29:43: | Operating System | Windows Server 2012 Standard (64 bit edition) |
08/08/2013 14:29:43: | Wow64 mode | Not using Wow64 |
08/08/2013 14:29:43: | MDAC Version | 6.2.9200.16384 |
08/08/2013 14:29:43: | MDAC Full Install Version | 6.2.9200.16384 |
08/08/2013 14:29:43: | PreferredCompression | 2 |
08/08/2013 14:29:43: | EnableParallelReload | 1 |
08/08/2013 14:29:43: | ParallelizeQvdLoads | 1 |
08/08/2013 14:29:43: | AutoSaveAfterReload | 0 |
08/08/2013 14:29:43: | BackupBeforeReload | 0 |
08/08/2013 14:29:43: | EnableFlushLog | 0 |
08/08/2013 14:29:43: | SaveInfoWhenSavingFile | 0 |
08/08/2013 14:29:43: | UserLogfileCharset | 0 |
08/08/2013 14:29:43: | OdbcLoginTimeout | -1 |
08/08/2013 14:29:43: | OdbcConnectionTimeout | -1 |
08/08/2013 14:29:43: | ScriptWantsDbWrite | false |
08/08/2013 14:29:43: | ScriptWantsExe | false |
08/08/2013 14:29:43: | LogFile CodePage Used: | 1252 |
08/08/2013 14:29:43: 0002 SET ThousandSep='.'
08/08/2013 14:29:43: 0003 SET DecimalSep=','
08/08/2013 14:29:43: 0004 SET MoneyThousandSep='.'
08/08/2013 14:29:43: 0005 SET MoneyDecimalSep=','
08/08/2013 14:29:43: 0006 SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00'
08/08/2013 14:29:43: 0007 SET TimeFormat='hh:mm:ss'
08/08/2013 14:29:43: 0008 SET DateFormat='DD/MM/YYYY'
08/08/2013 14:29:43: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'
08/08/2013 14:29:43: 0010 SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez'
08/08/2013 14:29:43: 0011 SET DayNames='seg;ter;qua;qui;sex;sáb;dom'
08/08/2013 14:29:43: 0013 OLEDB CONNECT32*Provider*XPassword*
08/08/2013 14:29:44: 0015 [CLIENTE]:
08/08/2013 14:29:44: 0016 SQL SELECT "cod-emitente",
08/08/2013 14:29:44: 0017 | "cod-gr-cli", |
08/08/2013 14:29:44: 0018 | "cod-rep", |
08/08/2013 14:29:44: 0019 | "data-implant", |
08/08/2013 14:29:44: 0020 | "nome-emit", |
08/08/2013 14:29:44: 0021 | "nome-matriz", |
08/08/2013 14:29:44: 0022 | estado, |
08/08/2013 14:29:44: 0023 | cidade, |
08/08/2013 14:29:44: 0024 | pais, |
08/08/2013 14:29:44: 0025 | cgc |
08/08/2013 14:29:44: 0026 FROM PUB.emitente
08/08/2013 14:29:44: | 10 fields found: cod-emitente, cod-gr-cli, cod-rep, data-implant, nome-emit, nome-matriz, estado, cidade, pais, cgc, 80.757 lines fetched |
08/08/2013 14:29:47: 0028 STORE CLIENTE INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\CLIENTE.QVD
08/08/2013 14:29:47: 0030 [GRUPO_CLIENTE]:
08/08/2013 14:29:47: 0031 SQL SELECT "cod-gr-cli",
08/08/2013 14:29:47: 0032 | descricao |
08/08/2013 14:29:47: 0033 FROM PUB."gr-cli"
08/08/2013 14:29:47: | 2 fields found: cod-gr-cli, descricao, 35 lines fetched |
08/08/2013 14:29:47: 0035 STORE GRUPO_CLIENTE INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\GRUPO_CLIENTE.QVD
08/08/2013 14:29:47: 0038 [ITEM]:
08/08/2013 14:29:47: 0039 SQL SELECT "desc-item",
08/08/2013 14:29:47: 0040 | "fm-cod-com", |
08/08/2013 14:29:47: 0041 | "it-codigo", |
08/08/2013 14:29:47: 0042 | un |
08/08/2013 14:29:47: 0043 FROM PUB.item
08/08/2013 14:29:47: | 4 fields found: desc-item, fm-cod-com, it-codigo, un, 26.389 lines fetched |
08/08/2013 14:29:48: 0045 STORE ITEM INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\ITEM.QVD
08/08/2013 14:29:48: 0047 [REGIAO]:
08/08/2013 14:29:48: 0048 SQL SELECT "nome-ab-reg",
08/08/2013 14:29:48: 0049 | "nome-regiao" |
08/08/2013 14:29:48: 0050 FROM PUB.regiao
08/08/2013 14:29:48: | 2 fields found: nome-ab-reg, nome-regiao, 12 lines fetched |
08/08/2013 14:29:48: 0052 STORE REGIAO INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\REGIAO.QVD
08/08/2013 14:29:48: 0054 [VENDEDOR]:
08/08/2013 14:29:48: 0055 SQL SELECT "cod-rep",
08/08/2013 14:29:48: 0056 | cidade, |
08/08/2013 14:29:48: 0057 | estado, |
08/08/2013 14:29:48: 0058 | pais, |
08/08/2013 14:29:48: 0059 | nome, |
08/08/2013 14:29:48: 0060 | "nome-ab-reg", |
08/08/2013 14:29:48: 0061 | "rep-indireto" |
08/08/2013 14:29:48: 0062 FROM PUB.repres
08/08/2013 14:29:48: | 7 fields found: cod-rep, cidade, estado, pais, nome, nome-ab-reg, rep-indireto, 323 lines fetched |
08/08/2013 14:29:48: 0064 STORE VENDEDOR INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\VENDEDOR.QVD
08/08/2013 14:29:48: 0066 [Natureza]:
08/08/2013 14:29:48: 0067 SQL SELECT "cd-trib-icm",
08/08/2013 14:29:48: 0068 | "nat-operacao", |
08/08/2013 14:29:48: 0069 | tipo |
08/08/2013 14:29:48: 0070 FROM PUB."natur-oper"
08/08/2013 14:29:48: | 3 fields found: cd-trib-icm, nat-operacao, tipo, 1.391 lines fetched |
08/08/2013 14:29:48: 0072 STORE Natureza INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\Natureza.QVD
08/08/2013 14:29:48: 0074 [ESTABELECIMENTO]:
08/08/2013 14:29:48: 0075 SQL SELECT "cod-estabel",
08/08/2013 14:29:48: 0076 | nome |
08/08/2013 14:29:48: 0077 FROM PUB.estabelec
08/08/2013 14:29:48: | 2 fields found: cod-estabel, nome, 6 lines fetched |
08/08/2013 14:29:48: 0079 STORE ESTABELECIMENTO INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\ESTABELECIMENTO.QVD
08/08/2013 14:29:49: | $Syn 1 = cod-rep+estado+cidade+pais |
08/08/2013 14:29:49: | Execution finished. |
Sim, cliente e servidor mesmas versões.
Veja, o problema aparentemente nao é na conexao, pois eu tenho outro qvw que lê apenas os QVD, nao fazem conexao ao banco, e o erro é idêntico. (erro somente quando a execução eh feita pelo Task).
abaixo no log do qvw, na ultima linha perceba que ele da como FINISHED.
13/08/2013 14:16:08: | Execution started. | |
13/08/2013 14:16:08: | QlikView Version:11.00.11282.0 | |
13/08/2013 14:16:08: | CPU Target | x64 |
13/08/2013 14:16:08: | Operating System | Windows Server 2012 Standard (64 bit edition) |
13/08/2013 14:16:08: | Wow64 mode | Not using Wow64 |
13/08/2013 14:16:08: | MDAC Version | 6.2.9200.16384 |
13/08/2013 14:16:08: | MDAC Full Install Version | 6.2.9200.16384 |
13/08/2013 14:16:08: | PreferredCompression | 2 |
13/08/2013 14:16:08: | EnableParallelReload | 1 |
13/08/2013 14:16:08: | ParallelizeQvdLoads | 1 |
13/08/2013 14:16:08: | AutoSaveAfterReload | 0 |
13/08/2013 14:16:08: | BackupBeforeReload | 0 |
13/08/2013 14:16:08: | EnableFlushLog | 0 |
13/08/2013 14:16:08: | SaveInfoWhenSavingFile | 0 |
13/08/2013 14:16:08: | UserLogfileCharset | 0 |
13/08/2013 14:16:08: | OdbcLoginTimeout | -1 |
13/08/2013 14:16:08: | OdbcConnectionTimeout | -1 |
13/08/2013 14:16:08: | ScriptWantsDbWrite | false |
13/08/2013 14:16:08: | ScriptWantsExe | false |
13/08/2013 14:16:08: | LogFile CodePage Used: | 1252 |
13/08/2013 14:16:08: 0002 SET ThousandSep='.'
13/08/2013 14:16:08: 0003 SET DecimalSep=','
13/08/2013 14:16:08: 0004 SET MoneyThousandSep='.'
13/08/2013 14:16:08: 0005 SET MoneyDecimalSep=','
13/08/2013 14:16:08: 0006 SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00'
13/08/2013 14:16:08: 0007 SET TimeFormat='hh:mm:ss'
13/08/2013 14:16:08: 0008 SET DateFormat='DD/MM/YYYY'
13/08/2013 14:16:08: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'
13/08/2013 14:16:08: 0010 SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez'
13/08/2013 14:16:08: 0011 SET DayNames='seg;ter;qua;qui;sex;sáb;dom'
13/08/2013 14:16:08: 0012 SET vPath = 'C:\Program Files\QlikView\Documents\Extracao\QVDS\'
13/08/2013 14:16:08: 0014 OLEDB CONNECT32*Provider*XPassword*
13/08/2013 14:16:08: 0016 [CLIENTE]:
13/08/2013 14:16:08: 0017 SQL SELECT "cod-emitente",
13/08/2013 14:16:08: 0018 | "cod-gr-cli", |
13/08/2013 14:16:08: 0019 | "cod-rep", |
13/08/2013 14:16:08: 0020 | "data-implant", |
13/08/2013 14:16:08: 0021 | "nome-emit", |
13/08/2013 14:16:08: 0022 | "nome-matriz", |
13/08/2013 14:16:08: 0023 | estado, |
13/08/2013 14:16:08: 0024 | cidade, |
13/08/2013 14:16:08: 0025 | pais, |
13/08/2013 14:16:08: 0026 | cgc |
13/08/2013 14:16:08: 0027 FROM PUB.emitente
13/08/2013 14:16:08: | 10 fields found: cod-emitente, cod-gr-cli, cod-rep, data-implant, nome-emit, nome-matriz, estado, cidade, pais, cgc, 80.757 lines fetched |
13/08/2013 14:16:11: 0029 STORE CLIENTE INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\CLIENTE.QVD
13/08/2013 14:16:11: 0030 DROP Table CLIENTE
13/08/2013 14:16:11: 0032 [GRUPO_CLIENTE]:
13/08/2013 14:16:11: 0033 SQL SELECT "cod-gr-cli",
13/08/2013 14:16:11: 0034 | descricao |
13/08/2013 14:16:11: 0035 FROM PUB."gr-cli"
13/08/2013 14:16:11: | 2 fields found: cod-gr-cli, descricao, 35 lines fetched |
13/08/2013 14:16:12: 0037 STORE GRUPO_CLIENTE INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\GRUPO_CLIENTE.QVD
13/08/2013 14:16:12: 0038 DROP TABLE GRUPO_CLIENTE
13/08/2013 14:16:12: 0041 [ITEM]:
13/08/2013 14:16:12: 0042 SQL SELECT "desc-item",
13/08/2013 14:16:12: 0043 | "fm-cod-com", |
13/08/2013 14:16:12: 0044 | "it-codigo", |
13/08/2013 14:16:12: 0045 | un |
13/08/2013 14:16:12: 0046 FROM PUB.item
13/08/2013 14:16:12: | 4 fields found: desc-item, fm-cod-com, it-codigo, un, 26.389 lines fetched |
13/08/2013 14:16:12: 0048 STORE ITEM INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\ITEM.QVD
13/08/2013 14:16:12: 0049 DROP TABLE ITEM
13/08/2013 14:16:12: 0051 [REGIAO]:
13/08/2013 14:16:12: 0052 SQL SELECT "nome-ab-reg",
13/08/2013 14:16:12: 0053 | "nome-regiao" |
13/08/2013 14:16:12: 0054 FROM PUB.regiao
13/08/2013 14:16:12: | 2 fields found: nome-ab-reg, nome-regiao, 12 lines fetched |
13/08/2013 14:16:13: 0056 STORE REGIAO INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\REGIAO.QVD
13/08/2013 14:16:13: 0057 DROP TABLE REGIAO
13/08/2013 14:16:13: 0059 [VENDEDOR]:
13/08/2013 14:16:13: 0060 SQL SELECT "cod-rep",
13/08/2013 14:16:13: 0061 | cidade, |
13/08/2013 14:16:13: 0062 | estado, |
13/08/2013 14:16:13: 0063 | pais, |
13/08/2013 14:16:13: 0064 | nome, |
13/08/2013 14:16:13: 0065 | "nome-ab-reg", |
13/08/2013 14:16:13: 0066 | "rep-indireto" |
13/08/2013 14:16:13: 0067 FROM PUB.repres
13/08/2013 14:16:13: | 7 fields found: cod-rep, cidade, estado, pais, nome, nome-ab-reg, rep-indireto, 323 lines fetched |
13/08/2013 14:16:13: 0069 STORE VENDEDOR INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\VENDEDOR.QVD
13/08/2013 14:16:13: 0070 DROP TABLE VENDEDOR
13/08/2013 14:16:13: 0072 [Natureza]:
13/08/2013 14:16:13: 0073 SQL SELECT "cd-trib-icm",
13/08/2013 14:16:13: 0074 | "nat-operacao", |
13/08/2013 14:16:13: 0075 | tipo |
13/08/2013 14:16:13: 0076 FROM PUB."natur-oper"
13/08/2013 14:16:13: | 3 fields found: cd-trib-icm, nat-operacao, tipo, 1.391 lines fetched |
13/08/2013 14:16:13: 0078 STORE Natureza INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\Natureza.QVD
13/08/2013 14:16:13: 0079 DROP TABLE Natureza
13/08/2013 14:16:13: 0081 [ESTABELECIMENTO]:
13/08/2013 14:16:13: 0082 SQL SELECT "cod-estabel",
13/08/2013 14:16:13: 0083 | nome |
13/08/2013 14:16:13: 0084 FROM PUB.estabelec
13/08/2013 14:16:13: | 2 fields found: cod-estabel, nome, 6 lines fetched |
13/08/2013 14:16:13: 0086 STORE ESTABELECIMENTO INTO C:\Program Files\QlikView\Documents\Extracao\QVDS\ESTABELECIMENTO.QVD
13/08/2013 14:16:13: 0087 DROP TABLE ESTABELECIMENTO
13/08/2013 14:16:13: | Execution finished. |
Só uma pergunta qual a sua versão do Qlikview Server ? lembro que teve gente reclamando disso na versão 11
A versão é 11.0.11282.0, se é que estou consultando no lugar correto.
A Chance de ser o Bug agora aumento muito
Por que Sr 1
achei até um Link falando sobre isso:
http://community.qlik.com/thread/56257
Da uma conversada com a Sua MasterSeller Eles devem estar ciente desse Bug e vão te auxiliar como fazer Update da versão, ta muito parecido com que vi reclamando aqui.
No artigo falam da tarefa ficar como "pendente" e no log esta como concluída. Não é o meu caso.
Puxa, essa é a 1a e única versão que instalei, nem sei como são liberadas as atualizações, onde as encontro, se aplico em cima da atual ou precisa reinstalar do zero, poderia me ajudar ?
Que dureza, tarefa simples e comum de fazer, ja perdi 3 dias tentando achar o problema, fiquei preocupado agora quando me deparar com problemas mais complexos, melhor acender uma vela, rs.
Entra em contato com a empresa que te vendeu o Qlikview, deve ser uma MasterSeller, se for SP ou foi a Nordica ou Tocatto (nao sei existe outr no brasil)
Qual a versão que voce utiliza ?
Aqui eu uso v 10 sr4
tava pensando ,faz um pequeno teste, esse Qvw que esta dando problema seria o Doccument que faria a leitura do que você extraiu da base de dados certo?
Notei que erro mudou na verdade (ou não?)
Pelo novo erro achei esse artigo
http://community.qlik.com/thread/51397
erro: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow
entao....são 2 tipos de document...o primeiro mais simples, conecta no servidor de banco de dados e apenas gera as QVD. durante a execução ocorre erro abaixo (apenas quando executado pelo Task)
(2013-08-13 16:30:48) Information: Starting task 'Extracao/gera-qvd-ems2cad.qvw'. Id:9b5a006b-5bdb-4ec6-818d-ab12cd77e134. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c (2013-08-13 16:30:48) Information: Entering Task Execution. (2013-08-13 16:30:48) Information: ClusterID=1 (2013-08-13 16:30:48) Information: QDSID=400f89e8-828a-78ae-c20c-9efe3d019951 (2013-08-13 16:30:48) Information: TaskID=9b5a006b-5bdb-4ec6-818d-ab12cd77e134 (2013-08-13 16:30:48) Information: MaxRunTime=06:00:00 (2013-08-13 16:30:48) Information: MachineName=CPDSRV05 (2013-08-13 16:30:48) Information: Max attempts:1 (2013-08-13 16:30:48) Information: Current Attempt=0 (2013-08-13 16:30:48) Information: Task Dependencies are OK (2013-08-13 16:30:48) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution. (2013-08-13 16:30:48) Information: Opening "C:\Program Files\QlikView\Documents\Extracao\gera-qvd-ems2cad.qvw" (2013-08-13 16:30:48) Information: Allocating new QlikView Engine. Current usagecount=1 of 2 (2013-08-13 16:30:48) Information: Max retries:5 (2013-08-13 16:30:48) Information: Attempt:01 (2013-08-13 16:30:49) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=2 (2013-08-13 16:30:49) Information: Loading document "C:\Program Files\QlikView\Documents\Extracao\gera-qvd-ems2cad.qvw" (0.14 Mb) (2013-08-13 16:30:49) Information: Physical FileSize=0.14 Mb. Memory Allocation Delta for this file=2.49 Mb. Available Physical Memory Before Open=24978.43 Mb. Available Physical Memory After Open=24972.81 Mb. Total Physical Memory=32733.38 Mb. (2013-08-13 16:30:49) Information: Attempted to load the document without data. (2013-08-13 16:30:49) Information: The document was loaded successfully. (2013-08-13 16:30:49) Information: Document was opened successfully (2013-08-13 16:30:49) Information: Starting reload (2013-08-13 16:30:49) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier. (2013-08-13 16:30:49) Information: Waiting for the document log "C:\Program Files\QlikView\Documents\Extracao\gera-qvd-ems2cad.qvw" to become available.. (2013-08-13 16:30:49) Information: The Source Document is being reloaded. DocumentPath=C:\Program Files\QlikView\Documents\Extracao\gera-qvd-ems2cad.qvw (2013-08-13 16:30:49) Information: Found a document log. FileName=C:\Program Files\QlikView\Documents\Extracao\gera-qvd-ems2cad.qvw.log (2013-08-13 16:30:49) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20130813\163048 - Extracao_gera-qvd-ems2cad.qvw\DocumentLog.txt (2013-08-13 16:30:50) Information: Reloading. (2013-08-13 16:30:51) Information: Reloading.. (2013-08-13 16:30:52) Information: Reloading... (2013-08-13 16:30:53) Information: Reloading.... (2013-08-13 16:30:54) Information: Reloading..... (2013-08-13 16:30:54) Information: The Source Document reload complete. DocumentPath=C:\Program Files\QlikView\Documents\Extracao\gera-qvd-ems2cad.qvw (2013-08-13 16:30:54) Information: Memory Allocation Delta for this file=125.83 Mb. Available Physical Memory Before Reload=24972.80 Mb. Available Physical Memory After Reload=24875.90 Mb. Total Physical Memory=24875.90 Mb. (2013-08-13 16:30:54) Information: The Source Document was reloaded successfully. (2013-08-13 16:30:54) Information: Reload finished successfully (2013-08-13 16:30:54) Information: Start saving document (2013-08-13 16:30:54) Error: Exception=System.Security.Principal.IdentityNotMappedException: Não foi possível converter algumas ou todas as referências de identidade. (2013-08-13 16:30:54) Error: em System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess) (2013-08-13 16:30:54) Error: em System.Security.Principal.NTAccount.Translate(Type targetType) (2013-08-13 16:30:54) Error: em System.Security.AccessControl.CommonObjectSecurity.ModifyAccess(AccessControlModification modification, AccessRule rule, Boolean& modified) (2013-08-13 16:30:54) Error: em System.Security.AccessControl.CommonObjectSecurity.AddAccessRule(AccessRule rule) (2013-08-13 16:30:54) Error: em QVBWrapper.Document.CopyPermissionsToEmptyFile(ILogBucket i_LogBucket, String i_SourceFilename, String i_DestinationFileName) (2013-08-13 16:30:54) Error: Could not touch target file (2013-08-13 16:30:54) Information: Closing the document. (2013-08-13 16:30:55) Information: Closed the QlikView Engine successfully. ProcessID=10532 (2013-08-13 16:30:55) Error: The task "Extracao/gera-qvd-ems2cad.qvw" failed. Exception: (2013-08-13 16:30:55) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: Could not touch target file (2013-08-13 16:30:55) Error: em QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) (2013-08-13 16:30:55) Error: --- Fim do rastreamento de pilha de exceções internas --- (2013-08-13 16:30:55) Error: em QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) (2013-08-13 16:30:55) Error: em QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) (2013-08-13 16:30:55) Error: --- Fim do rastreamento de pilha de exceções internas --- (2013-08-13 16:30:55) Error: em QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) (2013-08-13 16:30:55) Error: em QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult) (2013-08-13 16:30:55) Information: Task Execute Duration=00:00:06.8515273 (2013-08-13 16:30:55) Information: Sending Alert mail (2013-08-13 16:30:55) Information: TaskResult.status=Finished (2013-08-13 16:30:55) Information: Notifying all triggers of new state:FinishedWithErrors (2013-08-13 16:30:55) Information: Notifying all triggers of new state:FinishedWithErrors - completed (2013-08-13 16:30:55) Information: Saving Task Result |
Realmente é estranho, o ideal é sempre utilizar as ultimas atualizações da versão para garantir que não é um bug corrigido.
Vou ver por aqui se descubro algo a mais.
Abraços