topic Re: Qlik Sense Triggers not working in Management & Governance

Qlik Sense Triggers not working

amrinder — Sat, 16 Nov 2024 05:56:44 GMT

I have installed Qlik Sense Multi-Node Architecture and when i am reloading data in QVF it is getting successful but in QMC my Triggers are getting failed.

Could anyone assist to resolve this issue.

~Amrinder

Re: Qlik Sense Triggers not working

miskinmaz — Thu, 02 May 2019 09:03:52 GMT

Hi,
Can you share the screen shot of error message while loading it from the QMC.

Re: Qlik Sense Triggers not working

Giuseppe_Novello — Thu, 02 May 2019 14:17:56 GMT

Well it could several things, I would look into QMC > task > under "status", there a "i", does it errors out,

Does it give you the option to download the script log?

Yes- Download the script log and see whats the error:

Possibly: The Connector used for the script is missing in the System DSN within that scheduler/engine node was assign.

No- The the issue is a engine error, check engine logs for more information.

Re: Qlik Sense Triggers not working

amrinder — Fri, 03 May 2019 06:43:33 GMT

Hi,

its not every time reloads are failing...for example 5 tasks have been scheduled out of which 2 are reloaded in qmc and 3 are failed.

BR,

Amrinder

Re: Qlik Sense Triggers not working

shra1kumar — Fri, 03 May 2019 07:38:27 GMT

Hi, Can you download the log for the failed job and see the error message and post here so we could know why it failed.

Re: Qlik Sense Triggers not working

amrinder — Mon, 06 May 2019 06:33:01 GMT

Below is the log content:

2019-05-06 11:50:24 Execution started.
2019-05-06 11:50:24 Qlik Sense Server Version 12.108.2
2019-05-06 11:50:24 CPU Target x64
2019-05-06 11:50:24 Operating System Windows Server 2012 R2 Standard (64 bit edition)
2019-05-06 11:50:24 Wow64 mode Not using Wow64
2019-05-06 11:50:24 Language 0409 English English
2019-05-06 11:50:24 Country USA United States United States
2019-05-06 11:50:24 MDAC Version 6.3.9600.16384
2019-05-06 11:50:24 MDAC Full Install Version 6.3.9600.16384
2019-05-06 11:50:24 PreferredCompression 2
2019-05-06 11:50:24 EnableParallelReload 1
2019-05-06 11:50:24 ParallelizeQvdLoads 1
2019-05-06 11:50:24 EnableFlushLog 0
2019-05-06 11:50:24 UserLogfileCharset 65001
2019-05-06 11:50:24 OdbcLoginTimeout -1
2019-05-06 11:50:24 OdbcConnectionTimeout -1
2019-05-06 11:50:24 LongestPossibleLine 1048576
2019-05-06 11:50:24 ScriptWantsDbWrite false
2019-05-06 11:50:24 ScriptWantsExe false
2019-05-06 11:50:24 ICU_FOR_CHARACTER_CLASSIFICATION true
2019-05-06 11:50:24 ICU_FOR_CODE_PAGES true
2019-05-06 11:50:24 ICU_FOR_COLLATION true
2019-05-06 11:50:24 ICU_FOR_LOCALE_INFO true
2019-05-06 11:50:24 ICU_FOR_SUPPORT_INFO true
2019-05-06 11:50:24 ICU_FOR_TIME_ZONE_INFO true
2019-05-06 11:50:24 LogFile CodePage Used: 65001
2019-05-06 11:50:24 UseMemoryFillPattern 1
2019-05-06 11:50:24 ScriptMode Standard (limits system access)
2019-05-06 11:50:24 SequentialThreadCount 26
2019-05-06 11:50:24 NumberOfCores (effective) 8
2019-05-06 11:50:24 ReloadCodebase Bnf
2019-05-06 11:50:24 Reload Executed By UserDirectory=INTERNAL; UserId=sa_scheduler
2019-05-06 11:50:24 Process Executing Qlik Sense Server
2019-05-06 11:50:24 Process ID 2440
2019-05-06 11:50:24 Grpc version 3.0.0
2019-05-06 11:50:24 Protobuf version 3.2.0
2019-05-06 11:50:24 0002 SET ThousandSep=','
2019-05-06 11:50:24 0003 SET DecimalSep='.'
2019-05-06 11:50:24 0004 SET MoneyThousandSep=','
2019-05-06 11:50:24 0005 SET MoneyDecimalSep='.'
2019-05-06 11:50:24 0006 SET MoneyFormat='Rs. #,##0.00;Rs. -#,##0.00'
2019-05-06 11:50:24 0007 SET TimeFormat='hh:mm:ss'
2019-05-06 11:50:24 0008 SET DateFormat='DD-MM-YYYY'
2019-05-06 11:50:24 0009 SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]'
2019-05-06 11:50:24 0010 SET FirstWeekDay=0
2019-05-06 11:50:24 0011 SET BrokenWeeks=1
2019-05-06 11:50:24 0012 SET ReferenceDay=0
2019-05-06 11:50:24 0013 SET FirstMonthOfYear=1
2019-05-06 11:50:24 0014 SET CollationLocale='en-IN'
2019-05-06 11:50:24 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2019-05-06 11:50:24 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
2019-05-06 11:50:24 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2019-05-06 11:50:24 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
2019-05-06 11:50:24 0024 Set vExtractPath="[lib://SharedStorage (oneairtel_qlikadministrator)/RFQ RA Analytics\Stage 1\Source\"
2019-05-06 11:50:24 0025 Set vStoragePath="[lib://SharedStorage (oneairtel_qlikadministrator)/RFQ RA Analytics\Stage 1\QVD\"
2019-05-06 11:50:24 0038 LIB CONNECT TO 'FINPRD (oneairtel_qlikadministrator)'
2019-05-06 11:50:54 Error: Connection aborted (System error: ***)
2019-05-06 11:50:54 Execution Failed
2019-05-06 11:50:54 Execution finished.

Re: Qlik Sense Triggers not working

amrinder — Mon, 06 May 2019 06:34:32 GMT

Hi Gio,

Could you please look into log content and help me out:

Re: Qlik Sense Triggers not working

Giuseppe_Novello — Mon, 06 May 2019 11:45:57 GMT

It seems that the issue goes back to the ODBC connection. Something is canceling out the request. IS this multi-node, if it is, are you sure that the RIM nodes has the ODBC connector installed within the system DSN? If it is, and still failing, then enable ODBC trace logging :

https://docs.oracle.com/cd/E17952_01/connector-odbc-en/connector-odbc-configuration-trace-windows.html

This might give you more clarity about the issue.

Gio