14 Replies Latest reply: Jun 27, 2017 5:46 AM by Chris Turner RSS

    Qlik Sense reload task failed

    Christoph Hebig

      Hello Community,

       

      I am trying to Schedule a Reload Task once a week. The File does binary load data from another file, which is also scheduled but there is no overlapping time or anything (original file loads on Mondays, binary file on Fridays). I checked the server for being working on capacity, but that's not the case. Both Files are created with the Qlik Sense Server Edition. We're only using one Server (no Multi-Node Setup) and all necessary rights are available on the server (read, write, update etc). I have many files set up like this, but only this single file does not load and fails the reload process after 3-4 seconds.

      If I open the file in the hub and manually reload the data, it is done in some seconds.

       

      I attach the log of the failed reload.

       

      I hope you can help me out with that.

       

      Regards

      Chris

        • Re: Qlik Sense reload task failed
          Sarvesh Srivastava

          Restart your task.

          • Re: Qlik Sense reload task failed
            Chanty 4u

            delete the task and  recreate the task and  restart your al services and machine aswell

              • Re: Qlik Sense reload task failed
                Chris Turner

                Hi Christoph

                 

                Did you ever find a solution to this issue? I've been experimenting with binary loads in Sense server and come across the same issue. From the app script log file:

                 

                2017-06-27 09:49:44 0002 BINARY D:\Qlikshare\SharedApps\f8be1d00-874b-4b44-b0ef-4dc4ee0225af

                2017-06-27 09:49:44      General Script Error

                2017-06-27 09:49:44      Execution Failed

                2017-06-27 09:49:44      Execution finished.

                 

                We run Sense in legacy mode to support explicit file paths though using a library connection makes no difference:

                 

                2017-06-27 10:00:00 0004 BINARY [lib://Qlik Sense App Folder (systems_t7689922)/f8be1d00-874b-4b44-b0ef-4dc4ee0225af]

                2017-06-27 10:00:00      General Script Error

                2017-06-27 10:00:00      Execution Failed

                2017-06-27 10:00:00      Execution finished.

                 

                Also, using no path (which according to the documentation is also supported for QVFs in the default app location) does not work:

                 

                2017-06-27 10:02:06 0004 BINARY f8be1d00-874b-4b44-b0ef-4dc4ee0225af

                2017-06-27 10:02:06      General Script Error

                2017-06-27 10:02:06      Execution Failed

                2017-06-27 10:02:06      Execution finished.

                 

                Reloading manually from the unpublished app in all cases works great, e.g.

                 

                2017-06-27 10:01:39 0004 BINARY f8be1d00-874b-4b44-b0ef-4dc4ee0225af

                2017-06-27 10:01:39 0009 SET ThousandSep=','

                2017-06-27 10:01:39 0010 SET DecimalSep='.'

                2017-06-27 10:01:39 0011 SET MoneyThousandSep=','

                2017-06-27 10:01:39 0012 SET MoneyDecimalSep='.'

                2017-06-27 10:01:39 0013 SET MoneyFormat='$#,##0.00;($#,##0.00)'

                2017-06-27 10:01:39 0014 SET TimeFormat='h:mm:ss TT'

                2017-06-27 10:01:39 0015 SET DateFormat='DD-MMM-YY'

                2017-06-27 10:01:39 0016 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

                2017-06-27 10:01:39 0017 SET FirstWeekDay=6

                2017-06-27 10:01:39 0018 SET BrokenWeeks=1

                2017-06-27 10:01:39 0019 SET ReferenceDay=0

                2017-06-27 10:01:39 0020 SET FirstMonthOfYear=1

                2017-06-27 10:01:39 0021 SET CollationLocale='en-US'

                2017-06-27 10:01:39 0022 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

                2017-06-27 10:01:39 0023 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'

                2017-06-27 10:01:39 0024 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

                2017-06-27 10:01:39 0025 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'

                2017-06-27 10:01:39 0031 Exit Script

                2017-06-27 10:01:39      Execution finished.

                 

                Is this a bug?

                 

                Regards

                Chris

              • Re: Qlik Sense reload task failed
                Dick Jansen

                Could it be that you are using Section Access without granting the user  'INTERNAL\sa_scheduler' admin rights? This would cause similar behaviour.