8 Replies Latest reply: Aug 1, 2016 9:19 AM by Clever Anjos RSS

    Negative allocation delta value

    Augusto VILARINHO

      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

          Por favor envie o log da aplicação

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

            • Re: Negative allocation delta value
              Augusto VILARINHO

              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
              Avinash R

              please share the complete log file ..

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

              • Re: Negative allocation delta value
                Clever Anjos

                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