QlikView application failed with no error

[Anonymous]

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.

[YoussefBelloum]

Hi,

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

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

[Anonymous]

It is not set to 0.

[Miguel_Angel_Baeyens]

• 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?

[Anonymous]

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

[Miguel_Angel_Baeyens]

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?

[Anonymous]

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