QV Publishers reloads some documents but not others after 12.5 upgrade

[austin_james]

We just upgraded to 12.5.  We have many documents that the publisher processes nightly.  Some of the documents reload just fine while others do not.  We think there might be something with the documents themselves because the same documents do not reload.  I just cannot figure out what needs changed in the document.

For the documents that the publisher does not reload, when I open them in the client and reload the data, it works just fine.  The same credentials are used to connect to the source DB by the Publisher and the client.

Here is a sample of the Task Log from the publisher:

(12/4/2020 7:47:20 AM) Information: DistributeTask[0124f698-90ce-49cb-9bc2-06b76ef207a6] ("filename.qvw"): TryStart - Starting task. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c. ExecID:a5105d44-c804-47bb-a1bf-b0ea2e1049a4

(12/4/2020 7:47:20 AM) Information: Entering Task Execution.

(12/4/2020 7:47:20 AM) Information: ClusterID=1

(12/4/2020 7:47:20 AM) Information: QDSID=f0893642-d647-b123-dcbf-6e722fedb1b3

(12/4/2020 7:47:20 AM) Information: TaskID=0124f698-90ce-49cb-9bc2-06b76ef207a6

(12/4/2020 7:47:20 AM) Information: ExecID=a5105d44-c804-47bb-a1bf-b0ea2e1049a4

(12/4/2020 7:47:20 AM) Information: MaxRunTime=00:10:00

(12/4/2020 7:47:20 AM) Information: MachineName=QLIK-PUB

(12/4/2020 7:47:20 AM) Information: Task execution max attempts=1

(12/4/2020 7:47:20 AM) Information: Task execution current attempt=1

(12/4/2020 7:47:20 AM) Information: Task Dependencies are OK

(12/4/2020 7:47:20 AM) Information: The task "filename.qvw" is starting

(12/4/2020 7:47:20 AM) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(12/4/2020 7:47:20 AM) Information: Opening "filename.qvw"

(12/4/2020 7:47:20 AM) Information: Allocating new QlikView Engine. Current usage count=4 of 5 (of type non-reader).

(12/4/2020 7:47:20 AM) Information: Max retries:5

(12/4/2020 7:47:20 AM) Information: Attempt:01

(12/4/2020 7:47:21 AM) Information: Opened the QlikView Engine successfully. ProcessID=413596

(12/4/2020 7:47:21 AM) Information: Allocated QlikView Engine successfully. Current usage count=5 of 5 (of type non-reader). Ticket number=50.

(12/4/2020 7:47:21 AM) Information: Loading document "filename.qvw" (0.14 Mb)

(12/4/2020 7:47:21 AM) Information: Physical FileSize=0.14 Mb. Memory Allocation Delta for this file=3.14 Mb. Available Physical Memory Before Open=60247.42 Mb. Available Physical Memory After Open=60243.92 Mb. Total Physical Memory=65535.55 Mb.

(12/4/2020 7:47:21 AM) Information: Attempted to load the document without data.

(12/4/2020 7:47:21 AM) Information: The document was loaded successfully.

(12/4/2020 7:47:21 AM) Information: Document was opened successfully

(12/4/2020 7:47:21 AM) Information: Starting reload

(12/4/2020 7:47:21 AM) Information: The Source Document is being reloaded. DocumentPath=filename.qvw

(12/4/2020 7:47:22 AM) Information: Reloading.

(12/4/2020 7:47:23 AM) Information: Reloading..

(12/4/2020 7:47:24 AM) Information: Reloading...

(12/4/2020 7:47:25 AM) Information: Reloading....

(12/4/2020 7:47:26 AM) Information: Reloading.....

This Reloading... message repeats until the timeout is reached.

In the document settings Generate Logfile is checked.  However, here is the message from the Document Log tab from the QMC:

(Document Log) : No document log found for the specific task run (check if Generate Logfile is enabled).

Any ideas what I should try next?

[rubenmarin]

Hi @austin_james, you can enable document log openeing the document with Qv desktop, in document properties -> General, chek the box to generate log.

The repeated reloading message can have diffrent causes, maybe some data type is beign readed as a different sata type and causing duplicated records, it can be hanging trying to read/write some file that is locked, database can fail to return data or error.... in any case the document log can help to debug, also try manual relaod with a 12.5 desktop using the same user that executes the reload task to confirm it has enough permissions to do all the tasks

[austin_james]

Thanks @rubenmarin for the suggestion about the document log.  When I do that, the QMC reports that the document doesn't have Logging enabled, and suggests I enable it (which it already is).

I will ensure that I'm updating with the 12.5 client and see if that sheds and light on this issue.

Thanks again.

[Chip_Matejowsky · Accepted solution]

@austin_james  can you attach the full task log/document log to this thread for review?  From the snippet you posted, we can see Information: MaxRunTime=00:10:00.  So is the task exceeding this configured max runtime?  Also, does this task fail each time it is run.