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: 
Not applicable

Negative allocation delta value

Hi,

When trying to perform a refill of a qvw sometimes occurs the document does not end the load indicating error allocation Negative delta value.

Anyone know what may indicate what may be causing the error.

See the log below:

Information: Executing ClusterID = 1, QDSID = c4f84d71-8c32-fe9e-7948-fae64b4123d9 QDSMain.DistributeTask

Information: Starting task "Applications / qvwAntigo / PRC / capex_PRC.qvw" (Attempt 1 of 1)

Information: Max run time: 06:00:00

Information: Document is marked for refresh; Initializing Reload.

Information: Opening "E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw"

Information: Allocating QlikView Engine

Information: Allocating new QlikView engine. Current usagecount = 6 of 6

Information: An instance of the QlikView engine is being created

Information: Starting QlikView Engine

Information: Allocated QlikView engine successfully. Current usagecount = 6 of 6, Ticket = 3020

Information: Loading document "E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw" (2:52 Mb)

Information: Loading. Loadtime = 00: 00: 01

Information:. Physical filesize = 2.52 Mb Memory Allocation Delta for this file = 29.35 Mb Available Physical Memory Before Open = 6208.42 Mb Available Physical Memory After Open = 6121.24 MB Total Physical Memory = 12287.55 Mb....

Information: The document was loaded successfully.

Information: Initializing Checkout (0) Loading document (6047), Initializing load (6047) Checking read (6047), Creating QlikView Engine (6047) Checking Size (6063), Load (S & A) (6094), Load Completed ( 6594), Tables read (8109) Opened successfully (8156)

Information: Document was opened successfully

Information: Opened successfully (0)

Information: Starting reload

Information: QlikView-> Settings-> Document Preferences-> Generate Logfile document is in September Enabling Log Copier.

Information: Waiting for the document log "E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw" to Become available ..

Information: The Source Document is being reloaded. DocumentPath = E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw

Information: Found a document log. FileName = E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw.log

Information: Writing documentLog to C: \ ProgramData \ QlikTech \ DistributionService \ 1 \ Log \ 20160322 \ 102000 - Aplicativos_qvwAntigo_PRC_capex_PRC.qvw \ DocumentLog.txt

Information: The Source Document reload complete. DocumentPath = E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw

Information: Memory Allocation Delta for this file = -1.38 Mb Available Physical Memory Before Reload = 6109.52 Mb Available Physical Memory After Reload = 6111.84 MB Total Physical Memory = 6111.84 Mb....

Error: The Source Document was NOT reloaded successfully. DocumentPath = E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw.

Information: Initializing Reload (0) Finished (547)

Error: Reload failed.

Information: Closing the document.

Information: Closed the QlikView engine successfully. ProcessID = 2220

Information: Initializing (0) Finished (281)

Error: Reload failed. Distribution skipped.

Error: The task "Applications / qvwAntigo / PRC / capex_PRC.qvw" failed. ErrorCount = 3

Information: Sending Mail Alert to 1 recipients.

Google Tradutor para Empresas:Ferramentas do Google TradutorTradutor de Web sites

8 Replies
Clever_Anjos
Employee
Employee

Por favor envie o log da aplicação

E: \ QVRoot \ Application \ qvwAntigo \ PRC \ capex_PRC.qvw.log

avinashelite

please share the complete log file ..

it will be in the document source folder with the extension .log

Not applicable
Author

Segue o log.

23/03/2016 19:20:06: 0012  SET ThousandSep='.'

23/03/2016 19:20:06: 0013  SET DecimalSep=','

23/03/2016 19:20:06: 0014  SET MoneyThousandSep='.'

23/03/2016 19:20:06: 0015  SET MoneyDecimalSep=','

23/03/2016 19:20:06: 0016  SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00'

23/03/2016 19:20:06: 0017  SET TimeFormat='hh:mm:ss'

23/03/2016 19:20:06: 0018  SET DateFormat='DD/MM/YYYY'

23/03/2016 19:20:06: 0019  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

23/03/2016 19:20:06: 0020  SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez'

23/03/2016 19:20:06: 0021  SET DayNames='seg;ter;qua;qui;sex;sáb;dom'

23/03/2016 19:20:06: 0026  OLEDB CONNECT32*Provider*XPassword*

23/03/2016 19:20:06: 0008  SET Tema = 2

23/03/2016 19:20:06: 0032  SECTION Access

23/03/2016 19:20:06: 0033  ACESSO:

23/03/2016 19:20:06: 0034  LOAD   'USER' AS ACCESS,

23/03/2016 19:20:06: 0035     '*'    AS USERID,

23/03/2016 19:20:06: 0036     '*'    AS PASSWORD,

23/03/2016 19:20:06: 0037     UPPER(TRIM(NTNAME)) AS NTNAME,

23/03/2016 19:20:06: 0038     NO_ARVORE AS DEPT_ID_CHAVE

23/03/2016 19:20:06: 0039  SQL    SELECT

23/03/2016 19:20:06: 0040          USERID AS NTNAME,

23/03/2016 19:20:06: 0041          TREE_NODE_NUM AS NO_ARVORE

23/03/2016 19:20:06: 0042  FROM

23/03/2016 19:20:06: 0043          SYSADM.MMC_ACS_INVEST_PRJ

23/03/2016 19:20:06: 0044  WHERE

23/03/2016 19:20:06: 0045          STATUS = 'A'

23/03/2016 19:20:06: 0046  AND TIPO_ARVORE = 'INVEST_PROJ'

23/03/2016 19:20:06:       Error: OLEDB connection failed

23/03/2016 19:20:06:       General Script Error

23/03/2016 19:20:06:       Execution Failed

23/03/2016 19:20:06:      Execution finished.

Clever_Anjos
Employee
Employee

Possíveis causas que posso imaginar para esse "OLEDB connection failed"

  • Banco naquele momento estava fora do ar
  • Rede com problema de conectividade
  • Usuário sem permissão de leitura naquela tabela SYSADM.MMC_ACS_INVEST_PRJ
Not applicable
Author

Ok,

Mas o problema é que tive outras recargas começando na mesma hora que terminaram com sucesso.

E o problema não ocorre na mesma hora todos os dias.

Clever_Anjos
Employee
Employee

As outras cargas possuem a mesma conexão?

Quantas recargas simultâneas você utiliza?

nicolett_yuri

Augusto, conforme o Clever explicou, talvez você utilize várias cargas ao mesmo tempo neste banco e ele matou esta devido ao número de conexões realizadas do mesmo local.

Clever_Anjos
Employee
Employee

Já achou uma solução? Se sim, marque a resposta que  ajudou como "Correta" nos ajudando a manter os forum organizados.

Como obter ajuda? Leia antes de postar