0 Replies Latest reply: Apr 29, 2010 6:29 AM by Tjeerd Wieberdink RSS

    QV SAP Publisher Jobs - unknown errors

    Tjeerd Wieberdink

      Hi Guys,

      Every night at 03:00 a lot of tables are loaded from SAP into qvds into qlikview. This worked smoothly until last Sunday (since 25th of april).

      My qlikview jobs that make connection to SAP seem to crash in the publisher component for some unknown reason. The error logs report that the qlikview engines aren't responding. I've tried the following:

      - recreate the jobs. This doesn't help.

      - Restart all services. This doenst help

      - Manual reload for the 'not responding' tables. This works.

      - Create a new job and add a single 'not responding' table in this new job. This works.

      - Checked at SAP support whether new updates were installed or other database management maintenance was executed. Answer: no updates or maintenance was executed.

      - Change job starting time. Job still fails.

      - Checked whether one specific table was the cause. However, the error occurs for random tables.

       

      Here I present the log file6039730 2010-04-29 09:20:01 Normal Information Starting Job "1.3 B32 PRD - Extract" (Attempt 1 of 1)
      6039731 2010-04-29 09:20:01 Normal Information
      6039732 2010-04-29 09:20:01 Normal Information --------------------------------------------------------
      6039733 2010-04-29 09:20:01 Normal Information Starting Job "1.3 B32 PRD - Extract" (Attempt 1 of 1)
      6039734 2010-04-29 09:20:01 Normal Information Date request start time=29-4-2010 9:20:00
      6039735 2010-04-29 09:20:01 Normal Information
      6039736 2010-04-29 09:20:01 Normal Information Job started (Attempt 1 of 1)
      6039738 2010-04-29 09:20:01 Normal Information ExecuteASync EXIT
      6039741 2010-04-29 09:20:01 Normal Information Waiting for "1.3 B32 PRD - Extract" to complete.
      6039745 2010-04-29 09:20:01 Normal Information Starting task "1.3 B32 PRD - Extract" (4aa60d97-5171-44e6-b1f4-782f51d65d39)
      6039746 2010-04-29 09:20:01 Normal Information Waiting for task to be started: NotExecuted
      6039747 2010-04-29 09:20:01 Normal Information Preparing "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw" for reload.
      6039748 2010-04-29 09:20:01 Normal Information Checking write permissions on "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw"
      6039749 2010-04-29 09:20:01 Normal Information Opening "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw"
      6039750 2010-04-29 09:20:01 Normal Information Allocating new QlikView Engine. Current usagecount=1 of 4
      6039751 2010-04-29 09:20:01 Normal Information An instance of the QlikView Engine is being created
      6039752 2010-04-29 09:20:01 Normal Information The QlikView Engine was started successfully. Version=8.50.6232.5 ProcessID=6048
      6039753 2010-04-29 09:20:01 Normal Information Allocated QlikView Engine successfully. Current usagecount=1 of 4, Ticket=119
      6039761 2010-04-29 09:20:01 Normal Information Loading document "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw" (0.39 Mb)
      6039762 2010-04-29 09:20:01 Normal Information Physical FileSize=0.39 Mb. Memory Allocation Delta for this file=5.12 Mb. Available Physical Memory Before Open=8728.66 Mb. Available Physical Memory After Open=8722.25 Mb. Total Physical Memory=16319.28 Mb.
      6039763 2010-04-29 09:20:02 Normal Information The document was loaded successfully.
      6039765 2010-04-29 09:20:02 Normal Information Performance data (Load): Initializing load (0), Checking read (0), Creating QlikView Engine (0), Checking Size (78), Load (78), Load Completed (187), Tables read (218), Opened successfully (281)
      6039767 2010-04-29 09:20:02 Normal Information Performance data (Checkout): Initializing Checkout (0), Loading document (391), Load completed (828), Opened successfully (828)
      6039768 2010-04-29 09:20:02 Normal Information Starting reload
      6039780 2010-04-29 09:20:02 Normal Information The Source Document is being reloaded. DocumentPath=E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw
      6039781 2010-04-29 09:20:02 Normal Information Waiting for the document log "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw.log" to become available..
      6039782 2010-04-29 09:20:06 Normal Information Document log "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw.log" was not found / not updated. Skipped.
      6043271 2010-04-29 10:28:59 Normal Warning The QlikView Engine working with document "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw" is not responding.
      6044560 2010-04-29 10:59:02 Normal Warning The QlikView Engine working with document "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw" hasn't been responding for 1800 seconds. It will be killed.
      6044576 2010-04-29 10:59:10 Normal Warning Seems like the QlikView Engine isn't responding to close command, it will be killed within 10 seconds.. (Please ignore logged errors about the kill).
      6044578 2010-04-29 10:59:18 Normal Warning The QlikView Engine didn't respond to the close command, killing!
      6044579 2010-04-29 10:59:18 Normal Information Killing the QlikView Engine. ProcessID=6048
      6044580 2010-04-29 10:59:18 Normal Warning Aborting Close (please ignore any errors regarding this)
      6044581 2010-04-29 10:59:18 Normal Information Closed the QlikView Engine successfully. ProcessID=6048
      6044582 2010-04-29 10:59:18 Normal Warning Document was forcibly closed. Clean close was not possible.
      6044583 2010-04-29 10:59:18 Normal Error The sourcedocument failed to reload. Exception=System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE) at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug) at QVBWrapper.Document.ReloadThread(Int32 i_ParentLogID, Object i_ReloadParameter)
      6044587 2010-04-29 10:59:18 Normal Information Performance data (Reload): Initializing Reload (0)
      6044589 2010-04-29 10:59:18 Normal Information The document failed to reload.
      6044590 2010-04-29 10:59:18 Normal Information ReloadASync completed
      6044591 2010-04-29 10:59:18 Normal Error Reload failed
      6044592 2010-04-29 10:59:18 Normal Information Checkin
      6044595 2010-04-29 10:59:18 Normal Information Performance data (Checkin): Initializing (0), Finished (0)
      6044596 2010-04-29 10:59:18 Normal Warning Reload skipped for document "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 02 Transform - S120 T01 1.1.qvw" because document "E:\QlikView Storage\B32\PRD - Andere Applicaties\B32 - 01 Extract - S120 1.2.qvw" failed to reload.
      6044597 2010-04-29 10:59:18 Normal Error The task "1.3 B32 PRD - Extract" failed. Cause=Warningcount=1, Errorcount=2
      6044601 2010-04-29 10:59:19 Normal Information 1 task(s) failed - Sending alertmail...
      6044602 2010-04-29 10:59:19 Normal Information Sending AlertMail to: ---
      6044603 2010-04-29 10:59:19 Normal Error Job finished with 2 error(s) and 1 warning(s).
      6044604 2010-04-29 10:59:19 Normal Information Job "1.3 B32 PRD - Extract" has exited. NextExec=30-4-2010 3:00:00
      6044605 2010-04-29 10:59:19 Normal Information Performance data (Job) :Starting job (0), Starting task: 1.3 B32 PRD - Extract (0), Errors: 2 (5958078), Warnings: 1 (5958078), Taskreport (5958078), Next task (5958078), Alertmail (5958078), Finalizing (5958406), Job fininshed (5958422)



      I'd appreciate all input!

       

      Regards,

      Tjeerd