topic Re: QlikView application failed with no error in QlikView

QlikView application failed with no error

Anonymous — Tue, 16 Oct 2018 09:01:44 GMT

Hi,

We are triggering a QlikView application from an enterprise application task.

It was reloading successfully till yesterday and would pass the status (whether success/failure) back to the the enterprise application.

Yesterday the QlikView application showed as failed in the QMC and did not pass any status back. When we checked the application log, it did not show any error and just stopped at loading a table.

We triggered the task again and the application is now successful.

I would like to know the reasons behind this kind of behaviour so that we can avoid it in the future.

Can anyone please help me in understanding the reasons.

Thanks in advance,

Manasa M.

Re: QlikView application failed with no error

YoussefBelloum — Tue, 16 Oct 2018 09:05:27 GMT

Hi,

take a look at this system variable: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ErrorVariables/ErrorMode.htm

and if you use it on the script, make sure it is not set on 0

Re: QlikView application failed with no error

Anonymous — Tue, 16 Oct 2018 09:11:19 GMT

It is not set to 0.

Re: QlikView application failed with no error

Miguel_Angel_Baeyens — Tue, 16 Oct 2018 09:16:07 GMT

What does it mean exactly "just stopped loading a table"?
Was the script waiting for the execution of any particular line?
Which are the last lines of the incomplete task?

Re: QlikView application failed with no error

Anonymous — Tue, 16 Oct 2018 09:37:26 GMT

We set some variables before loading a table and we use those variables in loading. There is no log registered just after Just setting these variables .

I don think the script is waiting for the execution of any particular line as the previous line if just setting the variables

The last lines of the incomplete task are

10/14/2018 4:06:49 AM: 0078 LET vMnDateColumnPrefix='Load'

10/14/2018 4:06:49 AM: 0004 SET vMnQVDFile=DateDim.qvd

10/14/2018 4:06:49 AM: 0008 SET vMnIncQVDFile=DateDimInc.qvd

10/14/2018 4:06:49 AM: 0009 LET vMnSourceQVD='DateDim.qvd (qvd)'

10/14/2018 4:06:49 AM: 0011 LET vMnQVDColumns='

10/14/2018 4:06:49 AM: 0012 DateId AS LoadDateId,

10/14/2018 4:06:49 AM: 0013 date(Date) as LoadDate,

10/14/2018 4:06:49 AM: 0014 Year AS LoadYear,

10/14/2018 4:06:49 AM: 0015 YearQuarter AS LoadYearQuarter,

10/14/2018 4:06:49 AM: 0016 YearMonth AS LoadYearMonth,

10/14/2018 4:06:49 AM: 0017 Quarter AS LoadQuarter,

10/14/2018 4:06:49 AM: 0018 Month AS LoadMonth

10/14/2018 4:06:49 AM: 0019 '

10/14/2018 4:06:49 AM: 0021 LET vMnDateColumnPrefix=NULL()

10/14/2018 4:06:49 AM: 0006 LET vMnQVWTable='LoadDateDim'

10/14/2018 4:06:49 AM: 0007 LET vMnPreventMissingDates=False()

After these lines, Ideally the below lines should have run, but did not run or did not get captured in the log.

10/15/2018 4:10:42 PM: 0009 LoadDateIdTable:

10/15/2018 4:10:42 PM: 0010 LOAD

10/15/2018 4:10:42 PM: 0011 Min(LoadDateId) As MinLoadDateId,

10/15/2018 4:10:42 PM: 0012 Max(LoadDateId) As MaxLoadDateId

10/15/2018 4:10:42 PM: 0013 RESIDENT

10/15/2018 4:10:42 PM: 0014 FactTable

10/15/2018 4:14:56 PM: 2 fields found: MinLoadDateId, MaxLoadDateId, 1 lines fetched

10/15/2018 4:14:56 PM: 0016 Let vMnMinLoadDateId = Peek('MinLoadDateId', 0, 'LoadDateIdTable')

10/15/2018 4:14:56 PM: 0017 Let vMnMaxLoadDateId = Peek('MaxLoadDateId', 0, 'LoadDateIdTable')

10/15/2018 4:14:56 PM: 0019 DROP TABLE LoadDateIdTable

Re: QlikView application failed with no error

Miguel_Angel_Baeyens — Tue, 16 Oct 2018 09:43:29 GMT

So the task actually was running, and the behavior was the expected, as it hadn't finished it didn't display "waiting", "warning", "queued" or "failed".

I would check the script to see if there was any issue e.g.: while connecting to another server, or the file was being blocked by the antivirus or backup software or similar.

Was any IT activity or maintenance on the server or any other related server which could have affected the execution of the script or any file lacking permissions?

Re: QlikView application failed with no error

Anonymous — Tue, 16 Oct 2018 10:05:08 GMT

The application showed up as failed in the QMC. It did not show running in the task status.

There is no issue in the script because the the same scripts were running since long time and it was also successful when re-triggered again. I think the script does not need to connect to any other server because it was just needed to load min and max of date ids stored in another table using resident load as showed up in the earlier comment.

There was no IT or maintenance activity