Application Development

[parvez933]

Hi!

How to build a dashboard, that shows only "Error Messages" from the task log of QMC.

Not sure, but the expectation is there is a place/Dump where the log files of both Success/Failure will be placed on the server ( if possible, please help where is that location from where the log files will be located).

Dashboard Requirements: 

A table which should be able to show only the "Failure Message" as below. 

Example:

Date	Task Name	App Name	Error Message
1/11/2021	ABC Task	ABC Data Model	Hive Reload is in progress
1/11/2021	ABC Task	ABC Data Model	IO Exception
1/11/2021	ABC Task	ABC Data Model	DSN Error
1/11/2021	ABC Task	ABC Data Model	SSL Error

Regards,

M. Parvez

[Tanalex]

This should help in locating the log files. Storage 

[parvez933]

@Tanalex  Thank You for sharing the info for the Log storage location.

Hi All,

Can anyone please help me with the complete code, that can fulfill the requirement.

By filtering the dates, the "error message" which caused for task failure (only error message) has to be visualized.

Regards,

M. Parvez

[Ksrinivasan]

hi,

find the article

https://support.qlik.com/articles/000059077

please check whether the task working by Manual mode,

then start task analysis,

Regards,

K. Srinivasan.

[parvez933]

@Ksrinivasan , Thank You for the article.

The expectation is to build a application that shows Error Message for the tasks which are actively running on QMC.

By reading few articles I understand, mostly the log files will be available in %ProgramData%\Qlik\Sense\Log. Please correct me.

Date                      App Name                 Task Name                     Error Message/Failure Reason

12-01-2021        ABC Data Model      ABC Reload Task          Error: Failed to establish connection with DB

12-01-2021        ACC Data Model      ACC Reload Task          Error: SSL Error

12-01-2021        AAC Data Model      AAC Reload Task          Error: DSN mismatch

12-01-2021        BBC Data Model      BBC Reload Task          Error: IO Exception

12-01-2021        CBC Data Model      CBC Reload Task          Error: Cannot open file: 'LIB://EA Sales Ops QVD/R3.3_AAR1184_1191_chamnlptnr_doal_dmnsn.qvd' (Native Path: \\qlik\Sales\QVD\QlikSense\EAA_Mount\R3.3_EAR1184_1291_chamnlptnr_doal_dmnsn.qvd

Please help!

Regards,

M. Parvez

[Ksrinivasan]

hi,

i have workaround solution

but daily you have to download task status from QMC and upload into load file and execute APP and get Your Dashboard.

1. open QMC Task page

2. Right click and save as  Save as Type: Web page Single file

3. open the saved file

4. Ctrl + All and copy

5. Paste into your Excel file

6. delete unwanted data and column

7. load the Task and status into source file of the Dashboard APP.

8. you will your expected Error Message APP .

Regards,

Ksrinivasan.

[parvez933]

Hi @Ksrinivasan , Thank You for sharing the details.

By following the shared steps, we will be able to create a page with Task Name and STATUS(Failure/Success). From the Task Log Viewer, we will be able to view the success/Failure status.

Hi All,

Please help!

QMC> Task> list of task> By clicking i option gives you Task Log file for both Failure and Success.

If we download the task log file for a failure task, it will show you the error message or the failure reason.

We have to created a dashboard, which should connect to the folder/location where all the log files will be stored both success and failure.

{ We should be able to read each task log message (both error /success). We are interested in Error/failure messages. }

In the front end, we have to create a table with Task Name and Error/Failure Message.

When we make a selection on date, we should get all the Tasks which are failed on the same date and the reason of failure.

Example Reason of Failure:

Error: Cannot open file: 'LIB://EA Sales Ops QVD/R3.3_AAR1184_1191_chamnlptnr_doal_dmnsn.qvd' (Native Path: \\qlik\Sales\QVD\QlikSense\EAA_Mount\R3.3_EAR1184_1291_chamnlptnr_doal_dmnsn.qvd

Please help!

Regards,

M. Parvez

[Ksrinivasan]

hi M. Parvez,

did you create Excel from webpage single file,

ksrinivasan

[parvez933]

Hi @Ksrinivasan ,

Yes! I have tried creating an excel with the shared points.

But, the columns are not organized.

The  status details are misaligned or the reload time is getting overlapped into the other columns.

However, post organizing the table, we will reach to a page which shows only "Stauts". But not the error message from a task log file.

Hi All,

Please help! We have to read the error message from a task log file.

Regards,

M. Parvez

[parvez933]

Hi All,

Please help, as the requirement is on strings to be pulled.

Regards,

M. Parvez