Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amrinder
Creator
Creator

Qlik Sense Triggers not working

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

Labels (4)
7 Replies
miskinmaz
Creator III
Creator III

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

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. 

 

 

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
amrinder
Creator
Creator
Author

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. Relaod Error.png

    

 

Relaod done.png

 

BR,

Amrinder

shra1kumar
Contributor
Contributor

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.

amrinder
Creator
Creator
Author

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.

amrinder
Creator
Creator
Author

Hi Gio,

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

 

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.

Giuseppe_Novello

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.ht...

This might give you more clarity about the issue. 

BR

 

Gio

Giuseppe Novello
Principal Technical Support Engineer @ Qlik