App reloads successfully but won't publish

[cfunkhouser]

I am moving all my QlikView qvw files to a new server.  I have two that won't publish on the new server, and I don't know why.  

On the old server, the app would reload and publish in about 15 minutes.  If I reload the app in QlikView on the new server, it reloads in about 15 minutes.  But when I try to reload and publish the app on the new server, it takes about 30 minutes, says the reload was successful, and then fails to publish.  Here are the relevant lines from the task log:

(8/14/2020 3:10:40 PM) Information: The Source Document reload complete. DocumentPath= [document path]
(8/14/2020 3:10:41 PM) Information: The Source Document was reloaded successfully.
(8/14/2020 3:10:41 PM) Information: Writing documentLog to [document log path]
(8/14/2020 3:10:41 PM) Information: Reload finished successfully
(8/14/2020 3:10:41 PM) Information: Start saving document
(8/14/2020 3:11:10 PM) Information: Closing the document.
(8/14/2020 3:11:10 PM) Information: DistributeTask[aa2aeafc-3bf3-4f55-bf2c-db5da8ae8a96] ("Revenue Summary"): TryAbort. Triggered by 'RunTimeTrigger'. Id:0000000a-000a-000a-0a0a-161616161616. ExecID:bac8d22c-bf76-4334-8d9a-3d7140e3c0d7
(8/14/2020 3:11:10 PM) Information: Closed the QlikView Engine successfully. ProcessID=8976
(8/14/2020 3:11:10 PM) Error: The task "Revenue Summary" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.TaskTimeOutException: Task <Revenue Summary> has timed out || [stack trace]
(8/14/2020 3:11:10 PM) Information: Task Execute Duration=00:30:00.9327255

The document log looks normal and has no errors.  There is no section access on this qvw.  I have other tasks that run longer than 30 minutes that don't time out.

So I'm trying to figure out 1) why the publish fails, and 2) why the time is double what it is on the old server and when I run it in QlikView on the new server.  Answers are great, but even suggestions for where else to look for answers would be good.

Let me know what other information would be helpful.

Thanks,
Chris Funkhouser

[rubenmarin]

Hi, I would try first to log on to the server with the same user that runs the services and try do a manual reload using Qv desktop to check that this user has all the needed permissions. 

Also try to compare the time it takes for each sentence compared with a log from the old computer to see if there is any part of the scripot that takes longer than before.

[cfunkhouser · Accepted solution]

Figured it out.  The main culprit was the Oracle driver.  The old server had an 11g driver.  When I installed Oracle on the new server, I used a 12c driver.  Reverting back to 11g has solved the problem.

Chris