Error Count=3 in Publisher - Qlik Community

Report Inappropriate Content · ‎2010-07-20

Hi,

What is error count =3 in Publisher?

lhr · ‎2010-07-20

basically it's the number of errors encountered while executing a task. the exact errors should be in the log.

Report Inappropriate Content · ‎2010-07-20

Last Execution

(2010-07-20 11:54:40) Information: Executing ClusterID=1, QDSID=bdee3d72-b4e5-d72d-bb38-58d78e0c2b7a QDSMain.DistributeTask

(2010-07-20 11:54:40) Information: Starting task "Reload TIA" (Attempt 1 of 1)

(2010-07-20 11:54:40) Information: Max run time: 1.00:00:00

(2010-07-20 11:54:40) Information: Document is marked for refresh; Initializing Reload.

(2010-07-20 11:54:40) Information: Opening "Q:\Development\Contact_Center\LifeTimeCounter\464\TIACoverage.qvw"

(2010-07-20 11:54:40) Information: Allocating QlikView Engine

(2010-07-20 11:54:40) Information: Allocating new QlikView Engine. Current usagecount=1 of 6

(2010-07-20 11:54:40) Information: An instance of the QlikView Engine is being created

(2010-07-20 11:54:40) Information: Starting QlikView Engine

(2010-07-20 11:54:41) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 6, Ticket=574

(2010-07-20 11:54:41) Information: Loading document "Q:\Development\Contact_Center\LifeTimeCounter\464\TIACoverage.qvw" (1551.64 Mb)

(2010-07-20 11:54:42) Information: Loading. LoadTime=00:00:00.9999936

(2010-07-20 11:54:44) Information: Loading. LoadTime=00:00:02.9999808

(2010-07-20 11:54:48) Information: Loading. LoadTime=00:00:07.0155801

(2010-07-20 11:54:56) Information: Loading. LoadTime=00:00:15.0155289

(2010-07-20 11:55:12) Information: Loading. LoadTime=00:00:31.2029253

(2010-07-20 11:55:44) Information: Loading. LoadTime=00:01:03.2027205

(2010-07-20 11:56:45) Information: Loading. LoadTime=00:02:03.4054602

(2010-07-20 11:57:45) Information: Loading. LoadTime=00:03:03.6863244

(2010-07-20 11:57:58) Information: Physical FileSize=1551.64 Mb. Memory Allocation Delta for this file=8891.70 Mb. Available Physical Memory Before Open=215763.74 Mb. Available Physical Memory After Open=207216.75 Mb. Total Physical Memory=262140.59 Mb.

(2010-07-20 11:58:01) Information: The document was loaded successfully.

(2010-07-20 11:58:01) Information: Initializing Checkout (0), Loading document (750), Initializing load (750), Checking read (750), Creating QlikView Engine (766), Checking Size (828), Load (828), Load Completed (193641), Tables read (197125), Opened successfully (200250)

(2010-07-20 11:58:01) Information: Document was opened successfully

(2010-07-20 11:58:01) Information: Opened successfully (0)

(2010-07-20 11:58:01) Information: Starting reload

(2010-07-20 11:58:01) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2010-07-20 11:58:02) Information: The Source Document is being reloaded. DocumentPath=Q:\Development\Contact_Center\LifeTimeCounter\464\TIACoverage.qvw

(2010-07-20 11:58:02) Information: Waiting for the document log "Q:\Development\Contact_Center\LifeTimeCounter\464\TIACoverage.qvw" to become available..

(2010-07-20 11:58:02) Information: Reloading.

(2010-07-20 11:58:03) Information: Reloading..

(2010-07-20 11:58:04) Information: Reloading...

(2010-07-20 11:58:05) Information: Reloading....

(2010-07-20 11:58:06) Information: Document log "Q:\Development\Contact_Center\LifeTimeCounter\464\TIACoverage.qvw" was not found / not updated. Skipped.

(2010-07-20 11:58:06) Information: Reloading.....

(2010-07-20 11:58:07) Information: Reloading......

(2010-07-20 11:58:08) Information: Reloading.......

(2010-07-20 11:58:09) Information: Reloading........

(2010-07-20 11:58:10) Information: Reloading.........

(2010-07-20 11:58:11) Information: Reloading..........

(2010-07-20 11:58:12) Information: Slowing down logging. LoggingSeconds=2

(2010-07-20 11:58:12) Information: Reloading

(2010-07-20 11:58:14) Information: Reloading.

(2010-07-20 11:58:16) Information: Reloading..

(2010-07-20 11:58:18) Information: Reloading...

(2010-07-20 11:58:20) Information: Reloading....

(2010-07-20 11:58:22) Information: Reloading.....

(2010-07-20 11:58:24) Information: Reloading......

(2010-07-20 11:58:26) Information: Reloading.......

(2010-07-20 11:58:28) Information: Reloading........

(2010-07-20 11:58:30) Information: Reloading.........

(2010-07-20 11:58:32) Information: Reloading..........

(2010-07-20 11:58:34) Information: Slowing down logging. LoggingSeconds=10

(2010-07-20 11:58:34) Information: Reloading

(2010-07-20 11:58:44) Information: Reloading.

(2010-07-20 11:58:54) Information: Reloading..

(2010-07-20 11:59:04) Information: Reloading...

(2010-07-20 11:59:14) Information: Reloading....

(2010-07-20 11:59:24) Information: Reloading.....

(2010-07-20 11:59:34) Information: Reloading......

(2010-07-20 11:59:44) Information: Reloading.......

(2010-07-20 11:59:54) Information: Reloading........

(2010-07-20 12:00:04) Information: Reloading.........

(2010-07-20 12:00:14) Information: Reloading..........

(2010-07-20 12:00:24) Information: Slowing down logging. LoggingSeconds=60

(2010-07-20 12:00:24) Information: Reloading

(2010-07-20 12:01:24) Information: Reloading.

(2010-07-20 12:02:24) Information: Reloading..

(2010-07-20 12:03:24) Information: Reloading...

(2010-07-20 12:04:24) Information: Reloading....

(2010-07-20 12:05:24) Information: Reloading.....

(2010-07-20 12:06:24) Information: Reloading......

(2010-07-20 12:07:24) Information: Reloading.......

(2010-07-20 12:08:24) Information: Reloading........

(2010-07-20 12:09:24) Information: Reloading.........

(2010-07-20 12:10:24) Information: Reloading..........

(2010-07-20 12:11:24) Information: Slowing down logging. LoggingSeconds=300

(2010-07-20 12:11:24) Information: Reloading

(2010-07-20 12:16:24) Information: Reloading.

(2010-07-20 12:21:24) Information: Reloading..

(2010-07-20 12:26:24) Information: Reloading...

(2010-07-20 12:31:25) Information: Reloading....

(2010-07-20 12:37:01) Information: Reloading.....

(2010-07-20 12:42:01) Information: Reloading......

(2010-07-20 12:47:01) Information: Reloading.......

(2010-07-20 12:52:02) Information: Reloading........

(2010-07-20 12:57:02) Information: Reloading.........

(2010-07-20 13:02:02) Information: Reloading..........

(2010-07-20 13:07:02) Information: Slowing down logging. LoggingSeconds=600

(2010-07-20 13:07:02) Information: Reloading

(2010-07-20 13:17:02) Information: Reloading.

(2010-07-20 13:27:05) Information: Reloading..

(2010-07-20 13:37:07) Information: Reloading...

(2010-07-20 13:47:07) Information: Reloading....

(2010-07-20 13:57:07) Information: Reloading.....

(2010-07-20 14:07:07) Information: Reloading......

(2010-07-20 14:17:08) Information: Reloading.......

(2010-07-20 14:27:09) Information: Reloading........

(2010-07-20 14:37:13) Information: Reloading.........

(2010-07-20 14:47:14) Information: Reloading..........

(2010-07-20 14:57:14) Information: Slowing down logging. LoggingSeconds=900

(2010-07-20 14:57:14) Information: Reloading

(2010-07-20 15:12:14) Information: Reloading.

(2010-07-20 15:27:14) Information: Reloading..

(2010-07-20 15:39:07) Error: The sourcedocument failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

(2010-07-20 15:39:07) Error: at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)

(2010-07-20 15:39:07) Error: at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)

(2010-07-20 15:39:07) Information: Initializing Reload (0), Finished (13266093)

(2010-07-20 15:39:07) Error: Reload failed.

(2010-07-20 15:39:07) Information: Initializing (0), Finished (0)

(2010-07-20 15:39:07) Error: Reload failed. Distribution skipped.

(2010-07-20 15:39:07) Error: The task "Reload TIA" failed. ErrorCount=3

Could u tell wats the error occured?

lhr · ‎2010-07-20

not really im afraid. the reload failed but there isn't much detail in why. one thing you can try is to reload it from the desktop client manually and verify that it works.

Report Inappropriate Content · ‎2010-08-06

I guess you are pulling data from SQL on this reload?

Verify that the account running Distribution Service has rights to read into the datasource.

You can try with comment out any loads from the script and just verify that a connections is made to the datasource.

Report Inappropriate Content · ‎2010-09-01

Did you ever get a resolution on this? I'm having the same problem.

Thanks

Report Inappropriate Content · ‎2010-09-17

Source file is corrupted so only this pbm...