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 |
I´ve developed my 4 first qvw documents that are working fine with no errors, so I try to schedule both to reload data automatically.
On both qvw the same error occurs, when I start the task manually (play) or scheduled on a specific time.
Above follow the QMC log and QVW log.
(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. |
based on the error messages, it look like you do not have the full rights to the folder where you have your QVW file. please check. also try to use machine name (domain) while setting the permission.
I´m using a Windows 2012 Server, and gave all permissions to all-users in the Qlikview folder.
note: during the test the task extracts QVD files to the same folder where the qvw file is located sucessfully.
Do you have your qvw files on any of the system folders? (C:\Program Files, C:\Windows). You move your qvws to another folder like C:\Program Data, and try reloading, it should work. What I observed was eventhough you are an administrator, the security settings in Windows 2012 will not allow a background job to update and save binary files in the system folders (it is working fine with text type of files). See if the above works.