topic Re: Negative allocation delta value in Brasil

Negative allocation delta value

Tue, 22 Mar 2016 16:19:50 GMT

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

Re: Negative allocation delta value

Clever_Anjos — Tue, 22 Mar 2016 21:02:38 GMT

Por favor envie o log da aplicação

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

Re: Negative allocation delta value

avinashelite — Wed, 23 Mar 2016 12:00:28 GMT

please share the complete log file ..

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

Re: Negative allocation delta value

Wed, 23 Mar 2016 23:22:33 GMT

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.

Re: Negative allocation delta value

Clever_Anjos — Thu, 24 Mar 2016 12:10:03 GMT

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

Re: Negative allocation delta value

Thu, 24 Mar 2016 18:18:55 GMT

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.

Re: Negative allocation delta value

Clever_Anjos — Thu, 24 Mar 2016 19:10:01 GMT

As outras cargas possuem a mesma conexão?

Quantas recargas simultâneas você utiliza?

Re: Negative allocation delta value

nicolett_yuri — Thu, 24 Mar 2016 19:54:06 GMT

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.

Re: Negative allocation delta value

Clever_Anjos — Mon, 01 Aug 2016 13:19:06 GMT

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