Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
r_gourabi1
Contributor II
Contributor II

Error in reload task in qlik sense management consol

i have a error when i reload app in qlik sense this error is

20240828T160355.446+0330 Execution started.
20240828T160355.446+0330 Qlik Sense Server Version 12.2056.4
20240828T160355.446+0330 CPU Target x64
20240828T160355.492+0330 Operating System Microsoft Windows Server 2022 Standard (64 bit edition)
20240828T160355.492+0330 Wow64 mode Not using Wow64
20240828T160355.492+0330 Language 0409 English English
20240828T160355.493+0330 Country USA United States United States
20240828T160355.493+0330 MDAC Version 6.3.9600.16384
20240828T160355.493+0330 MDAC Full Install Version 6.3.9600.16384
20240828T160355.493+0330 PreferredCompression 2
20240828T160355.493+0330 EnableParallelReload 1
20240828T160355.493+0330 AutoSaveAfterReload 0
20240828T160355.493+0330 BackupBeforeReload 0
20240828T160355.493+0330 EnableFlushLog 0
20240828T160355.493+0330 UserLogfileCharset 65001
20240828T160355.493+0330 OdbcLoginTimeout -1
20240828T160355.493+0330 OdbcConnectionTimeout -1
20240828T160355.493+0330 ConnectorSettingsFile
20240828T160355.493+0330 LongestPossibleLine 1048576
20240828T160355.493+0330 MaxCoreMask -1
20240828T160355.493+0330 WebFileTimeout 0
20240828T160355.493+0330 WebFileUserAgent Mozilla/5.0
20240828T160355.493+0330 DontUseInternetCache 1
20240828T160355.493+0330 ReloadInstrTraceLevel 0
20240828T160355.493+0330 ConcatCalcTermLen 2147483646
20240828T160355.493+0330 ScriptWantsDbWrite false
20240828T160355.493+0330 ScriptWantsExe false
20240828T160355.493+0330 LogFile CodePage Used: 65001
20240828T160355.493+0330 UseMemoryFillPattern 1
20240828T160355.493+0330 ScriptMode Standard (limits system access)
20240828T160355.493+0330 SequentialThreadCount 50
20240828T160355.493+0330 NumberOfCores (effective) 16
20240828T160355.493+0330 ReloadCodebase Bnf
20240828T160355.493+0330 Reload ID
20240828T160355.493+0330 Reload Executed By UserDirectory=INTERNAL; UserId=sa_scheduler
20240828T160355.493+0330 Process Executing Qlik Sense Server
20240828T160355.493+0330 Process ID 13436
20240828T160355.493+0330 Grpc version 30.0.0
20240828T160355.493+0330 Protobuf version 3.15.6
20240828T160355.493+0330 Effective strict level 0
20240828T160355.821+0330 0002 SET ThousandSep=','
20240828T160355.822+0330 0003 SET DecimalSep='.'
20240828T160355.822+0330 0004 SET MoneyThousandSep=','
20240828T160355.822+0330 0005 SET MoneyDecimalSep='.'
20240828T160355.822+0330 0006 SET MoneyFormat='$#,##0.00;-$#,##0.00'
20240828T160355.822+0330 0007 SET TimeFormat='h:mm:ss TT'
20240828T160355.822+0330 0008 SET DateFormat='YYYY-MM-DD'
20240828T160355.822+0330 0009 SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff] TT'
20240828T160355.822+0330 0010 SET FirstWeekDay=6
20240828T160355.822+0330 0011 SET BrokenWeeks=1
20240828T160355.822+0330 0012 SET ReferenceDay=0
20240828T160355.822+0330 0013 SET FirstMonthOfYear=1
20240828T160355.822+0330 0014 SET CollationLocale='en-US'
20240828T160355.822+0330 0015 SET CreateSearchIndexOnReload=1
20240828T160355.822+0330 0016 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
20240828T160355.823+0330 0017 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
20240828T160355.823+0330 0018 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
20240828T160355.823+0330 0019 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
20240828T160355.823+0330 0020 SET NumericalAbbreviation='3:k;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y'
20240828T160355.823+0330 0021 SET vSize = Div(Log10(fabs($1)),3)
20240828T160355.825+0330 0022 SET vFormatNumber = Dual(Num($1/Pow(10,3*Div(Log10(fabs($1)),3)),'#,##0.00')&' '&Pick(Div(Log10(fabs($1)),3),'K','M','B','T'),$1)
20240828T160355.825+0330 0023 SET DISABLE_AUTO_CHART=1
20240828T160355.825+0330 0024 SET DISABLE_INSIGHTS=1
20240828T160355.825+0330 0027 LIB CONNECT TO 'Microsoft_SQL_Server_192.168.20.25'
20240828T160425.913+0330 Error: Connection aborted (System error: The handle is invalid.)
20240828T160425.914+0330 Execution Failed
20240828T160425.916+0330 Execution finished.

Labels (2)
4 Replies
Mike_Dickson
Support
Support

@r_gourabi1 
Does this reload work within the HUB and only fails within the QMC?
If you are using a specific driver for your connection "LIB CONNECT TO 'Microsoft_SQL_Server_192.168.20.25'", then you need to make sure that this is available on ALL nodes. IE: if you have a scheduler node, you need to make sure this connection work from there as well.

Sr. Technical Support Engineer with Qlik Support
Don't forget to mark a solution that worked for you!
Rohan
Partner - Specialist
Partner - Specialist

Hi @r_gourabi1 ,

You will have to make the ODBC Driver it seems on all your nodes, Or maybe you have to provide the access to the data connection to your service user if it is made using another account than your service account...

 

Regards,

Rohan.

r_gourabi1
Contributor II
Contributor II
Author

thanks mike but problem solved with OLEDB connection .

r_gourabi1
Contributor II
Contributor II
Author

thanks Rohan my problem solved when i change connection to OLEDB.