Re: Qlik Sense Server Reload License Monitor task failure.

shivani_singhal — Wed, 20 Feb 2019 04:23:20 GMT

Hi,

I am facing same issue but error is different. Could you please help me in this.Please find the log file script.

2019-02-20 09:40:10 Execution started.
2019-02-20 09:40:10 Qlik Sense Server Version 12.108.2
2019-02-20 09:40:10 CPU Target x64
2019-02-20 09:40:10 Operating System Windows Server 2016 Standard (64 bit edition)
2019-02-20 09:40:10 Wow64 mode Not using Wow64
2019-02-20 09:40:10 Language 4009 English English
2019-02-20 09:40:10 Country IND India India
2019-02-20 09:40:10 MDAC Version 6.3.9600.16384
2019-02-20 09:40:10 MDAC Full Install Version 6.3.9600.16384
2019-02-20 09:40:10 PreferredCompression 2
2019-02-20 09:40:10 EnableParallelReload 1
2019-02-20 09:40:10 ParallelizeQvdLoads 1
2019-02-20 09:40:10 EnableFlushLog 0
2019-02-20 09:40:10 UserLogfileCharset 65001
2019-02-20 09:40:10 OdbcLoginTimeout -1
2019-02-20 09:40:10 OdbcConnectionTimeout -1
2019-02-20 09:40:10 LongestPossibleLine 1048576
2019-02-20 09:40:10 ScriptWantsDbWrite false
2019-02-20 09:40:10 ScriptWantsExe false
2019-02-20 09:40:10 ICU_FOR_CHARACTER_CLASSIFICATION true
2019-02-20 09:40:10 ICU_FOR_CODE_PAGES true
2019-02-20 09:40:10 ICU_FOR_COLLATION true
2019-02-20 09:40:10 ICU_FOR_LOCALE_INFO true
2019-02-20 09:40:10 ICU_FOR_SUPPORT_INFO true
2019-02-20 09:40:10 ICU_FOR_TIME_ZONE_INFO true
2019-02-20 09:40:10 LogFile CodePage Used: 65001
2019-02-20 09:40:10 UseMemoryFillPattern 1
2019-02-20 09:40:10 ScriptMode Standard (limits system access)
2019-02-20 09:40:10 SequentialThreadCount 50
2019-02-20 09:40:10 NumberOfCores (effective) 16
2019-02-20 09:40:10 ReloadCodebase Bnf
2019-02-20 09:40:10 Reload Executed By UserDirectory=INTERNAL; UserId=sa_scheduler
2019-02-20 09:40:10 Process Executing Qlik Sense Server
2019-02-20 09:40:10 Process ID 11356
2019-02-20 09:40:10 Grpc version 3.0.0
2019-02-20 09:40:10 Protobuf version 3.2.0
2019-02-20 09:40:10 0005 REM *** *** *** *** *** *** *** *** ****** *** *** *** *** *** *** ******
2019-02-20 09:40:10 0006 *** *** *** *** *** *** *** *** *** *** *** *** ***
2019-02-20 09:40:10 0007 *** *** *** *** *** ****** *** *** ******
2019-02-20 09:40:10 0008 *** *** *** *** *** ****** *** *** *** *** *** *** *** *** *** *** *** *** ***
2019-02-20 09:40:10 0010 SET db_v_file_override = 0
2019-02-20 09:40:10 0012 REM *** *** *** *** *** *** *** *** ****** *** *** *** *** *** *** *** *** *********
2019-02-20 09:40:10 0015 Let ReloadStartTime = now(1)
2019-02-20 09:40:10 0016 SET app_version = '7.7.0'
2019-02-20 09:40:10 0017 Let comp = ComputerName()
2019-02-20 09:40:10 0018 LET ProdVer = PurgeChar(ProductVersion(),chr(39))
2019-02-20 09:40:10 0019 LET startMsg = 'Reloading License Monitor 7.7.0 from RRHO-QS2 running version 4.0.X'
2019-02-20 09:40:10 0020 TRACE Reloading License Monitor 7.7.0 from RRHO-QS2 running version 4.0.X
2019-02-20 09:40:10 0020 Reloading License Monitor 7.7.0 from RRHO-QS2 running version 4.0.X
2019-02-20 09:40:10 0021
2019-02-20 09:40:10 0022 SET monthsOfHistory = 12
2019-02-20 09:40:10 0023 LET cutoffDate = AddMonths(today(),-12,1)
2019-02-20 09:40:10 0024 Let LastReloadTime = timestamp(if(isnull(LastSuccessfulReloadStartTime),cutoffDate,LastSuccessfulReloadStartTime))
2019-02-20 09:40:10 0025 Let lastReloadCompare = num(LastReloadTime)-1
2019-02-20 09:40:10 0026 SET minSenseActivityDate = 42005
2019-02-20 09:40:10 0028 SET hideprefix = 'log'
2019-02-20 09:40:10 0029 SET firstReload = 0
2019-02-20 09:40:10 0030 SET va_LoginToUserPass = 10
2019-02-20 09:40:10 0032 LET serverLogFolder = 'lib://ServerLogFolder/'
2019-02-20 09:40:10 0033 LET archivedLogsFolder = 'lib://ArchivedLogsFolder/'
2019-02-20 09:40:10 0034 SET central_node_name =
2019-02-20 09:40:10 0036 LET baseFileName = 'governanceLicenseLog_7.7.0'
2019-02-20 09:40:10 0037 LET baseTableName = 'lib://ServerLogFolder/governanceLicenseLog_7.7.0'
2019-02-20 09:40:10 0039 LET SessionFileName = 'governanceSession_7.7.0'
2019-02-20 09:40:10 0040 LET sessionTableName = 'lib://ServerLogFolder/governanceSession_7.7.0'
2019-02-20 09:40:10 0041 LET monitorAppStatsFile = 'lib://ServerLogFolder/License_Monitor_Reload_Stats_7.7.0.txt'
2019-02-20 09:40:10 0043 SET storeBaseTableFail = 0
2019-02-20 09:40:10 0044 LET tempErrorDetails =
2019-02-20 09:40:10 0047 SET TimeFormat = 'hh:mm:ss'
2019-02-20 09:40:10 0048 SET DateFormat = 'YYYY-MM-DD'
2019-02-20 09:40:10 0049 SET TimestampFormat = 'YYYY-MM-DD hh:mm:ss'
2019-02-20 09:40:10 0051 Let vLast4Hours = Num(timestamp(Now(1)-1/6))
2019-02-20 09:40:10 0052 Let vLast24Hours = Num(timestamp(Now(1)-1))
2019-02-20 09:40:10 0053 Let vLast72Hours = Num(timestamp(Now(1)-3))
2019-02-20 09:40:10 0056 set c_red = 'RGB(204,102,119)'
2019-02-20 09:40:10 0057 set c_yellow = 'RGB(221,204,119)'
2019-02-20 09:40:10 0058 set c_blue = 'RGB(68,119,170)'
2019-02-20 09:40:10 0059 set c_green = 'RGB(17,119,51)'
2019-02-20 09:40:10 0060 set c_gray = 'RGB(150,150,150)'
2019-02-20 09:40:10 0061 set c_lightred = 'RGB(240,209,214)'
2019-02-20 09:40:10 0062 set c_lightblue = 'RGB(188,181,201)'
2019-02-20 09:40:10 0065 SUB verify_database
2019-02-20 09:40:10 0149 SUB logList
2019-02-20 09:40:10 0160 SUB defineFields
2019-02-20 09:40:10 0170 SUB CommandList
2019-02-20 09:40:10 0192 SUB loadBaseTable (nombre, archivo)
2019-02-20 09:40:10 0240 SUB multiNodeConfig
2019-02-20 09:40:10 0267 SUB logFolderList
2019-02-20 09:40:10 0310 SUB loadFiles (fdr,iter)
2019-02-20 09:40:10 0401 SUB load_database_logs
2019-02-20 09:40:10 0472 SUB concatTables (concatToTable, incrementalTable, concatField)
2019-02-20 09:40:10 0513 SUB sessionData (fdr)
2019-02-20 09:40:10 0554 SUB storeFiles (nombre, archivo)
2019-02-20 09:40:10 0575 SUB monitor_app_stats_incremental
2019-02-20 09:40:10 0589 SUB monitor_app_reload_stats (sev, obj, message, description)
2019-02-20 09:40:10 0621 SUB QRS
2019-02-20 09:40:10 0648 SUB monitor_apps_REST_license_user
2019-02-20 09:40:10 0734 SUB monitor_apps_REST_license_login
2019-02-20 09:40:10 0768 SUB monitor_apps_REST_user
2019-02-20 09:40:10 0878 SUB monitor_apps_REST_license_access
2019-02-20 09:40:10 0940 SUB monitor_apps_REST_app
2019-02-20 09:40:10 0975 SUB calendarization
2019-02-20 09:40:10 1079 SUB supportingLogic
2019-02-20 09:40:10 1120 SUB finalize
2019-02-20 09:40:10 1157 CALL monitor_app_reload_stats('INFO','License Monitor', startMsg,'Reload Start')
2019-02-20 09:40:10 0591 IF description = 'Reload Start' THEN
2019-02-20 09:40:10 0593 IF FileSize('lib://ServerLogFolder/License_Monitor_Reload_Stats_7.7.0.txt') > 0 THEN
2019-02-20 09:40:10 0594 monitor_app_reload_stats:
2019-02-20 09:40:10 0595 Load * From 'lib://ServerLogFolder/License_Monitor_Reload_Stats_7.7.0.txt' (txt, utf8, embedded labels, delimiter is '\t', msq)
2019-02-20 09:40:10 7 fields found: Log Entry, Log Timestamp, Log Severity, Host, Description, Log Message, Object,
2019-02-20 09:40:10 1,479 lines fetched
2019-02-20 09:40:10 0596 ELSE
2019-02-20 09:40:10 0602 Let appMonitorStatsRowsInit = NoOfRows('monitor_app_reload_stats')
2019-02-20 09:40:10 0603 CALL monitor_app_stats_incremental
2019-02-20 09:40:10 0576 Concatenate (monitor_app_reload_stats)
2019-02-20 09:40:10 0577 Load
2019-02-20 09:40:10 0578 RowNo() as [Log Entry],
2019-02-20 09:40:10 0579 timestamp(now(1)) as [Log Timestamp],
2019-02-20 09:40:10 0580 'INFO' as [Log Severity],
2019-02-20 09:40:10 0581 'RRHO-QS2' as Host,
2019-02-20 09:40:10 0582 'Reload Start' as Description,
2019-02-20 09:40:10 0583 'Reloading License Monitor 7.7.0 from RRHO-QS2 running version 4.0.X' as [Log Message],
2019-02-20 09:40:10 0584 'License Monitor' as Object
2019-02-20 09:40:10 0585 AutoGenerate (1)
2019-02-20 09:40:10 7 fields found: Log Entry, Log Timestamp, Log Severity, Host, Description, Log Message, Object,
2019-02-20 09:40:10 1,480 lines fetched
2019-02-20 09:40:10 0587 ENDSUB
2019-02-20 09:40:10 0605 ELSEIF description = 'Status Message' THEN
2019-02-20 09:40:10 0618 ENDSUB
2019-02-20 09:40:10 1159 CALL verify_database
2019-02-20 09:40:10 0067 TRACE Verifying logging database.
2019-02-20 09:40:10 0067 Verifying logging database.
2019-02-20 09:40:10 0068
2019-02-20 09:40:10 0069 REM *** *** *** *** *** *** *** *** *** *** *** ***
2019-02-20 09:40:10 0071 IF db_v_file_override = 1 THEN
2019-02-20 09:40:10 0082 LET db_check_time = timestamp(now(1)-0.01)
2019-02-20 09:40:10 0083 Set errormode = 0
2019-02-20 09:40:10 0085 LIB CONNECT TO 'QLogs'
2019-02-20 09:40:11 0088 LET tempErrorDetails = ScriptErrorDetails
2019-02-20 09:40:11 0089 IF Len(tempErrorDetails) > 0 THEN
2019-02-20 09:40:11 0103 db_check:
2019-02-20 09:40:11 0104 SELECT "id"
2019-02-20 09:40:11 0105 FROM "public"."log_entries"
2019-02-20 09:40:11 0106 WHERE "entry_timestamp" >= '2019-02-20 09:25:46'
2019-02-20 09:40:11 1 fields found: id,
2019-02-20 09:40:11 252 lines fetched
2019-02-20 09:40:11 0110 LET tempErrorDetails = ScriptErrorDetails
2019-02-20 09:40:11 0111 IF Len(tempErrorDetails) > 0 THEN
2019-02-20 09:40:11 0125 Let NoOfRows_db_check = NoOfRows('db_check')
2019-02-20 09:40:11 0127 IF 252>1 THEN
2019-02-20 09:40:11 0128 TRACE Database logging exists. Sourcing from log database.
2019-02-20 09:40:11 0128 Database logging exists. Sourcing from log database.
2019-02-20 09:40:11 0129
2019-02-20 09:40:11 0129 SET db_v_file = 2
2019-02-20 09:40:11 0130 LET baseTableName = 'lib://ServerLogFolder/governanceLicenseLog_7.7.0_db'
2019-02-20 09:40:11 0131 LET lastReloadCompare = If(LastReloadSource=2,lastReloadCompare,cutoffDate)
2019-02-20 09:40:11 0133 TRACE Last Reload Compare time = 2018-02-20. CutoffDate = 2018-02-20.
2019-02-20 09:40:11 0133 Last Reload Compare time = 2018-02-20. CutoffDate = 2018-02-20.
2019-02-20 09:40:11 0134
2019-02-20 09:40:11 0134 ELSE
2019-02-20 09:40:11 0144 SET errormode = 1
2019-02-20 09:40:11 0146 ENDIF
2019-02-20 09:40:11 0147 ENDSUB
2019-02-20 09:40:11 1161 REM *** *** *** ********* *** *** *** ***
2019-02-20 09:40:11 1162 CALL loadBaseTable ('LogContent', 'lib://ServerLogFolder/governanceLicenseLog_7.7.0_db')
2019-02-20 09:40:11 0194 Let baseFileSize = FileSize('lib://ServerLogFolder/governanceLicenseLog_7.7.0_db.qvd')
2019-02-20 09:40:11 0196 IF baseFileSize > 0 THEN
2019-02-20 09:40:11 0198 trace Incremental reload (not first reload)
2019-02-20 09:40:11 0198 Incremental reload (not first reload)
2019-02-20 09:40:11 0199
2019-02-20 09:40:11 0199 Let firstReload = 0
2019-02-20 09:40:11 0201 LogContent:
2019-02-20 09:40:11 0202 NoConcatenate
2019-02-20 09:40:11 0203 Load * FROM lib://ServerLogFolder/governanceLicenseLog_7.7.0_db.qvd (qvd)
2019-02-20 09:40:11 0204 WHERE LogTimeStamp >= '2018-02-20'
2019-02-20 09:40:11 29 fields found: Id, LogEntryPeriodStart, LogTimeStamp, Hostname, Message, Description, ProxySessionId, Command, ProxyPackageId, RequestSequenceId, process_name, Logger, Severity, _proxySessionPackage, Service, Context, Result, ObjectId, ObjectName, UserDirectory, UserId, Status, Access Type, UsageDenied, UsageId, Login Access Rule, License Allocation, Affected Entity, _TimeDIM_Link,
2019-02-20 09:40:11 0 lines fetched
2019-02-20 09:40:11 0207 LET tempErrorDetails = ScriptErrorDetails
2019-02-20 09:40:11 0208 IF Len(tempErrorDetails)>0 THEN
2019-02-20 09:40:11 0213 ELSE
2019-02-20 09:40:11 0235 LET NoOfRowsLogContentBASE = NoOfRows('LogContent')
2019-02-20 09:40:11 0237 ENDSUB
2019-02-20 09:40:11 1163 CALL loadBaseTable ('sessionData','lib://ServerLogFolder/governanceSession_7.7.0')
2019-02-20 09:40:11 0194 Let baseFileSize = FileSize('lib://ServerLogFolder/governanceSession_7.7.0.qvd')
2019-02-20 09:40:11 0196 IF baseFileSize > 0 THEN
2019-02-20 09:40:11 0198 trace Incremental reload (not first reload)
2019-02-20 09:40:11 0198 Incremental reload (not first reload)
2019-02-20 09:40:11 0199
2019-02-20 09:40:11 0199 Let firstReload = 0
2019-02-20 09:40:11 0201 sessionData:
2019-02-20 09:40:11 0202 NoConcatenate
2019-02-20 09:40:11 0203 Load * FROM lib://ServerLogFolder/governanceSession_7.7.0.qvd (qvd)
2019-02-20 09:40:11 0204 WHERE LogTimeStamp >= '2018-02-20'
2019-02-20 09:40:11 5 fields found: ProxySessionId, LogTimeStamp, Id, AppId, App Name,
2019-02-20 09:40:11 22,057 lines fetched
2019-02-20 09:40:11 0207 LET tempErrorDetails = ScriptErrorDetails
2019-02-20 09:40:11 0208 IF Len(tempErrorDetails)>0 THEN
2019-02-20 09:40:11 0213 ELSE
2019-02-20 09:40:11 0235 LET NoOfRowssessionDataBASE = NoOfRows('sessionData')
2019-02-20 09:40:11 0237 ENDSUB
2019-02-20 09:40:11 1165 REM *** *** ***
2019-02-20 09:40:11 1166 CALL CommandList
2019-02-20 09:40:11 0172 CommandList:
2019-02-20 09:40:11 0173 LOAD
2019-02-20 09:40:11 0174 Command,
2019-02-20 09:40:11 0175 CommandType
2019-02-20 09:40:11 0176 Inline [
2019-02-20 09:40:11 0177 Command, CommandType
2019-02-20 09:40:11 0178 Add license, Allocation
2019-02-20 09:40:11 0179 Add user access, Usage
2019-02-20 09:40:11 0180 Delete user access, Allocation
2019-02-20 09:40:11 0181 License maintenance, Usage
2019-02-20 09:40:11 0182 License user access, Usage
2019-02-20 09:40:11 0183 License user access request, Usage
2019-02-20 09:40:11 0184 Request access type, Usage
2019-02-20 09:40:11 0185 Update license, Allocation
2019-02-20 09:40:11 0186 Update user access, Allocation
2019-02-20 09:40:11 0187 ]
2019-02-20 09:40:11 2 fields found: Command, CommandType,
2019-02-20 09:40:11 9 lines fetched
2019-02-20 09:40:11 0189 ENDSUB
2019-02-20 09:40:11 1168 REM *** *** ***
2019-02-20 09:40:11 1169 working:
2019-02-20 09:40:11 1170 Load * inline [ProxyPackageId,RequestSequenceId]
2019-02-20 09:40:11 2 fields found: ProxyPackageId, RequestSequenceId,
2019-02-20 09:40:11 0 lines fetched
2019-02-20 09:40:11 1171 working_session:
2019-02-20 09:40:11 1172 NoConcatenate Load * Inline [ProxySessionId, LogTimeStamp]
2019-02-20 09:40:11 2 fields found: ProxySessionId, LogTimeStamp,
2019-02-20 09:40:11 0 lines fetched
2019-02-20 09:40:11 1174 REM *** *** *** ****** *** ****** *** *** *** *** *** *** ****** *** *** *** ***
2019-02-20 09:40:11 1175 IF db_v_file = 1 THEN
2019-02-20 09:40:11 1192 CALL load_database_logs
2019-02-20 09:40:11 0403 LIB CONNECT TO 'QLogs'
2019-02-20 09:40:11 0405 TRACE Loading AuditActivity_AuditSecurity data for license entries
2019-02-20 09:40:11 0405 Loading AuditActivity_AuditSecurity data for license entries
2019-02-20 09:40:11 0406
2019-02-20 09:40:11 0406 CONCATENATE (working)
2019-02-20 09:40:11 0407 LOAD
2019-02-20 09:40:11 0408 Timestamp((entry_timestamp)) AS LogEntryPeriodStart,
2019-02-20 09:40:11 0409 Timestamp((entry_timestamp)) AS LogTimeStamp,
2019-02-20 09:40:11 0410 id AS Id_temp,
2019-02-20 09:40:11 0411 lower(process_host) AS Hostname,
2019-02-20 09:40:11 0412 process_name,
2019-02-20 09:40:11 0413 logger AS Logger,
2019-02-20 09:40:11 0414 entry_level AS Severity,
2019-02-20 09:40:11 0415 message AS Message,
2019-02-20 09:40:11 0416 description AS Description,
2019-02-20 09:40:11 0417 proxy_session_id & proxy_package_id AS _proxySessionPackage,
2019-02-20 09:40:11 0418 proxy_session_id AS ProxySessionId,
2019-02-20 09:40:11 0419 proxy_package_id AS ProxyPackageId,
2019-02-20 09:40:11 0420 request_sequence_id AS RequestSequenceId,
2019-02-20 09:40:11 0421 service AS Service,
2019-02-20 09:40:11 0422 context AS Context,
2019-02-20 09:40:11 0423 command AS Command,
2019-02-20 09:40:11 0424 result AS Result,
2019-02-20 09:40:11 0425 object_id AS ObjectId,
2019-02-20 09:40:11 0426 object_name AS ObjectName,
2019-02-20 09:40:11 0427 user_directory AS UserDirectory,
2019-02-20 09:40:11 0428 user_directory & chr(92) & user_id AS UserId,
2019-02-20 09:40:11 0429
2019-02-20 09:40:11 0430 If(result=0 or (result >=200 and result <=226),dual('OK',0), if(result=' ',dual('Blank',0), dual('NOK',1))) AS Status,
2019-02-20 09:40:11 0431 IF(left(message,20)='Login access granted','Login Access',
2019-02-20 09:40:11 0432 IF(left(message,19)='User access granted','User Access'
2019-02-20 09:40:11 0433 )) AS [Access Type],
2019-02-20 09:40:11 0434 IF(result=403,1) AS UsageDenied,
2019-02-20 09:40:11 0435 IF(left(message,20)='Login access granted',purgechar(TextBetween(message,'UsageID: ',','),chr(39))) AS UsageId,
2019-02-20 09:40:11 0436 IF(left(message,20)='Login access granted',purgechar(TextBetween(message,'Accessname: ',','),chr(34)&chr(39)),
2019-02-20 09:40:11 0437 IF(left(message,24)='Login access for license',purgechar(TextBetween(message,' Name: ',','),chr(34)&chr(39)))) AS [Login Access Rule],
2019-02-20 09:40:11 0438 IF(((context='/qrs/licenseadd' and not origin = 'ManagementAccess') OR context='/qrs/licenseupdate' or context='/qrs/license/datamarket')
2019-02-20 09:40:11 0439 OR command='Add user access' OR command='Delete user access' OR command='Updated user access' OR command='Delete license' OR command like '*rule',
2019-02-20 09:40:11 0440 1) AS [License Allocation],
2019-02-20 09:40:11 0441 IF(context='/qrs/license/datamarket','DataMarket License',
2019-02-20 09:40:11 0442 IF(context='/qrs/licenseadd' and origin = 'ManagementAccess',null(),
2019-02-20 09:40:11 0443 IF(context='/qrs/licenseadd' OR context='/qrs/licenseupdate','Site License',
2019-02-20 09:40:11 0444 IF(left(message,24)='Login access for license',purgechar(TextBetween(message,' Name: ',','),chr(34)&chr(39)),
2019-02-20 09:40:11 0445 object_name)))) AS [Affected Entity]
2019-02-20 09:40:11 0447 SELECT * FROM "public"."view_audit_activity_audit_security"
2019-02-20 09:40:11 0448 WHERE entry_timestamp >= '2019-02-04 08:55:38'
2019-02-20 09:40:11 0449 AND security_class='License'
2019-02-20 09:40:11 0450 OR (security_class='Security' and message like '%License%')
2019-02-20 09:40:24 28 fields found: LogEntryPeriodStart, LogTimeStamp, Id_temp, Hostname, process_name, Logger, Severity, Message, Description, _proxySessionPackage, ProxySessionId, ProxyPackageId, RequestSequenceId, Service, Context, Command, Result, ObjectId, ObjectName, UserDirectory, UserId, Status, Access Type, UsageDenied, UsageId, Login Access Rule, License Allocation, Affected Entity,
2019-02-20 09:40:24 5,282 lines fetched
2019-02-20 09:40:24 0452 TRACE Loading Session Data now.
2019-02-20 09:40:24 0452 Loading Session Data now.
2019-02-20 09:40:24 0453
2019-02-20 09:40:24 0453 CONCATENATE (working_session)
2019-02-20 09:40:24 0454 Load
2019-02-20 09:40:24 0455 proxy_session_id AS ProxySessionId,
2019-02-20 09:40:24 0456 Timestamp((entry_timestamp)) AS LogTimeStamp,
2019-02-20 09:40:24 0457 object_id AS AppId,
2019-02-20 09:40:24 0458 object_name AS [App Name],
2019-02-20 09:40:24 0459 id AS Id_temp
2019-02-20 09:40:24 0461 SELECT * FROM "public"."view_audit_activity_audit_security"
2019-02-20 09:40:24 0462 WHERE entry_timestamp >= '2019-02-04 08:55:38'
2019-02-20 09:40:24 0463 AND process_name='repository'
2019-02-20 09:40:24 0464 AND Left(command,8)='Open app'
2019-02-20 09:40:24 0465 AND not proxy_session_id='0'
2019-02-20 09:40:24 0466 AND not object_name='Not available'
2019-02-20 09:40:27 5 fields found: ProxySessionId, LogTimeStamp, AppId, App Name, Id_temp,
2019-02-20 09:40:27 1,842 lines fetched
2019-02-20 09:40:27 0468 TRACE Finished loading data incrementally from database. Nice job!
2019-02-20 09:40:27 0468 Finished loading data incrementally from database. Nice job!
2019-02-20 09:40:27 0469
2019-02-20 09:40:27 0470 ENDSUB
2019-02-20 09:40:27 1193 SET logSource = 'Log Database'
2019-02-20 09:40:27 1194 SET LastReloadSource = 2
2019-02-20 09:40:27 1195 ELSE
2019-02-20 09:40:27 1200 Let rowsWorkingFinal = num(NoOfRows('working'),'#,##0')
2019-02-20 09:40:27 1201 trace 5,282 incremental rows loaded
2019-02-20 09:40:27 1201 5,282 incremental rows loaded
2019-02-20 09:40:27 1202
2019-02-20 09:40:27 1203 CALL concatTables ('LogContent', 'working','Id')
2019-02-20 09:40:27 0474 TRACE Concatenating tables...
2019-02-20 09:40:27 0474 Concatenating tables...
2019-02-20 09:40:27 0475
2019-02-20 09:40:27 0476 Let rowsworkingFinal = num(NoOfRows('working'),'#,##0')
2019-02-20 09:40:27 0477 trace 5,282 incremental rows loaded
2019-02-20 09:40:27 0477 5,282 incremental rows loaded
2019-02-20 09:40:27 0478
2019-02-20 09:40:27 0479 IF NoOfRows('working')>0 then
2019-02-20 09:40:27 0481 IF concatToTable = 'LogContent' THEN
2019-02-20 09:40:27 0482 CONCATENATE (LogContent)
2019-02-20 09:40:27 0483 LOAD
2019-02-20 09:40:27 0484 *,
2019-02-20 09:40:27 0485 Id_temp as Id,
2019-02-20 09:40:27 0486 (round(num(LogEntryPeriodStart),0.0006)&'|'&round(num(LogTimeStamp),0.0006)) as _TimeDIM_Link
2019-02-20 09:40:27 0487 RESIDENT working
2019-02-20 09:40:27 0488 WHERE NOT Exists (Id,Id_temp)
2019-02-20 09:40:27 30 fields found: ProxyPackageId, RequestSequenceId, Description, LogEntryPeriodStart, LogTimeStamp, Hostname, Message, ProxySessionId, Command, process_name, Logger, Severity, _proxySessionPackage, Service, Context, Result, ObjectId, ObjectName, UserDirectory, UserId, Status, Access Type, UsageDenied, UsageId, Login Access Rule, License Allocation, Affected Entity, Id_temp, Id, _TimeDIM_Link,
2019-02-20 09:40:27 5,282 lines fetched
2019-02-20 09:40:27 0490 ELSE
2019-02-20 09:40:27 0501 drop field Id_temp from LogContent
2019-02-20 09:40:27 0503 ELSE
2019-02-20 09:40:27 0508 drop table working
2019-02-20 09:40:27 0510 ENDSUB
2019-02-20 09:40:27 1204 CALL storeFiles ('LogContent', 'lib://ServerLogFolder/governanceLicenseLog_7.7.0_db')
2019-02-20 09:40:27 0556 Store 'LogContent' into [lib://ServerLogFolder/governanceLicenseLog_7.7.0_db.qvd]
2019-02-20 09:40:27 0558 LET tempErrorDetails = ScriptErrorDetails
2019-02-20 09:40:27 0559 IF LEN(tempErrorDetails) > 0 THEN
2019-02-20 09:40:27 0564 SET storeBaseTableFail = 0
2019-02-20 09:40:27 0565 END IF
2019-02-20 09:40:27 0567 LET NoOfRowsLogContent = num(NoOfRows('LogContent'),'#,##0')
2019-02-20 09:40:27 0568 LET NoOfRowsIncremental = NoOfRowsLogContent - NoOfRowsLogContentBASE
2019-02-20 09:40:27 0569 Let storeTime = now(1)
2019-02-20 09:40:27 0570 TRACE LogContent table stored at 2019-02-20 09:40:27 with 5,282 rows
2019-02-20 09:40:27 0570 LogContent table stored at 2019-02-20 09:40:27 with 5,282 rows
2019-02-20 09:40:27 0571
2019-02-20 09:40:27 0572 ENDSUB
2019-02-20 09:40:27 1206 Let sessionTableCount = NoOfRows('working_session')
2019-02-20 09:40:27 1207 IF 1842 > 0 THEN
2019-02-20 09:40:27 1208 CALL concatTables ('sessionData', 'working_session','Id')
2019-02-20 09:40:27 0474 TRACE Concatenating tables...
2019-02-20 09:40:27 0474 Concatenating tables...
2019-02-20 09:40:27 0475
2019-02-20 09:40:27 0476 Let rowsworking_sessionFinal = num(NoOfRows('working_session'),'#,##0')
2019-02-20 09:40:27 0477 trace 1,842 incremental rows loaded
2019-02-20 09:40:27 0477 1,842 incremental rows loaded
2019-02-20 09:40:27 0478
2019-02-20 09:40:27 0479 IF NoOfRows('working_session')>0 then
2019-02-20 09:40:27 0481 IF concatToTable = 'LogContent' THEN
2019-02-20 09:40:27 0492 CONCATENATE (sessionData)
2019-02-20 09:40:27 0493 LOAD
2019-02-20 09:40:27 0494 *,
2019-02-20 09:40:27 0495 Id_temp as Id
2019-02-20 09:40:27 0496 RESIDENT working_session
2019-02-20 09:40:27 0497 WHERE NOT Exists (Id,Id_temp)
2019-02-20 09:40:27 6 fields found: ProxySessionId, LogTimeStamp, AppId, App Name, Id_temp, Id,
2019-02-20 09:40:27 23,899 lines fetched
2019-02-20 09:40:27 0499 END IF
2019-02-20 09:40:27 0501 drop field Id_temp from sessionData
2019-02-20 09:40:27 0503 ELSE
2019-02-20 09:40:27 0508 drop table working_session
2019-02-20 09:40:27 0510 ENDSUB
2019-02-20 09:40:27 1209 CALL storeFiles ('sessionData', 'lib://ServerLogFolder/governanceSession_7.7.0')
2019-02-20 09:40:27 0556 Store 'sessionData' into [lib://ServerLogFolder/governanceSession_7.7.0.qvd]
2019-02-20 09:40:27 0558 LET tempErrorDetails = ScriptErrorDetails
2019-02-20 09:40:27 0559 IF LEN(tempErrorDetails) > 0 THEN
2019-02-20 09:40:27 0564 SET storeBaseTableFail = 0
2019-02-20 09:40:27 0565 END IF
2019-02-20 09:40:27 0567 LET NoOfRowsLogContent = num(NoOfRows('sessionData'),'#,##0')
2019-02-20 09:40:27 0568 LET NoOfRowsIncremental = NoOfRowsLogContent - NoOfRowsLogContentBASE
2019-02-20 09:40:27 0569 Let storeTime = now(1)
2019-02-20 09:40:27 0570 TRACE sessionData table stored at 2019-02-20 09:40:27 with 23,899 rows
2019-02-20 09:40:27 0570 sessionData table stored at 2019-02-20 09:40:27 with 23,899 rows
2019-02-20 09:40:27 0571
2019-02-20 09:40:27 0572 ENDSUB
2019-02-20 09:40:27 1210 Drop fields LogTimeStamp, Id from sessionData
2019-02-20 09:40:27 1212 ELSEIF NoOfRows('sessionData') >0 then
2019-02-20 09:40:27 1220 CALL QRS
2019-02-20 09:40:27 0625 LET NumRowsQRS = 0
2019-02-20 09:40:27 0626 SET QRS_RowCounts = 'QRS Row Counts: '
2019-02-20 09:40:27 0628 For each endpoint in 'monitor_apps_REST_license_user','monitor_apps_REST_license_login','monitor_apps_REST_user','monitor_apps_REST_license_access','monitor_apps_REST_app'
2019-02-20 09:40:27 0629 CALL monitor_apps_REST_license_user
2019-02-20 09:40:27 0649 LIB CONNECT TO 'monitor_apps_REST_license_user'
2019-02-20 09:40:28 0651 RestConectorMasterTable:
2019-02-20 09:40:28 0652 SQL SELECT
2019-02-20 09:40:28 0653 "id" AS "id_u0",
2019-02-20 09:40:28 0654 "createdDate",
2019-02-20 09:40:28 0655 "modifiedDate",
2019-02-20 09:40:28 0656 "modifiedByUserName",
2019-02-20 09:40:28 0657 "lastUsed",
2019-02-20 09:40:28 0658 "quarantined",
2019-02-20 09:40:28 0659 "quarantineEnd",
2019-02-20 09:40:28 0660 "__KEY_root",
2019-02-20 09:40:28 0661 (SELECT
2019-02-20 09:40:28 0662 "id",
2019-02-20 09:40:28 0663 "userId",
2019-02-20 09:40:28 0664 "userDirectory",
2019-02-20 09:40:28 0665 "name",
2019-02-20 09:40:28 0666 "__FK_user"
2019-02-20 09:40:28 0667 FROM "user" FK "__FK_user")
2019-02-20 09:40:28 0668 FROM JSON (wrap on) "root" PK "__KEY_root"
2019-02-20 09:40:28 14 fields found: id, userId, userDirectory, name, __FK_user, id_u0, createdDate, modifiedDate, modifiedByUserName, lastUsed, quarantined, quarantineEnd, __KEY_root, __extra_,
2019-02-20 09:40:28 32 lines fetched
2019-02-20 09:40:28 0670 LET NumRows_monitor_apps_REST_license_user = NoOfRows('RestConectorMasterTable')
2019-02-20 09:40:28 0672 user_map:
2019-02-20 09:40:28 0673 Mapping
2019-02-20 09:40:28 0674 LOAD
2019-02-20 09:40:28 0675 [__FK_user] AS [__KEY_root],
2019-02-20 09:40:28 0676
2019-02-20 09:40:28 0677 userDirectory & '\' & userId as UserId
2019-02-20 09:40:28 0678 RESIDENT RestConectorMasterTable
2019-02-20 09:40:28 0679 WHERE NOT IsNull([__FK_user])
2019-02-20 09:40:28 2 fields found: __KEY_root, UserId,
2019-02-20 09:40:28 16 lines fetched
2019-02-20 09:40:28 0681 License_UserAccess:
2019-02-20 09:40:28 0682 LOAD
2019-02-20 09:40:28 0683 *,
2019-02-20 09:40:28 0684 if(ualu > 42005,null(), UserId) as [Unused UserId],
2019-02-20 09:40:28 0685 if(ualu > 42005, ualu,'Never') as [User Access Last Used],
2019-02-20 09:40:28 0686 if(lower([User Access Quarantined])='true',UserId) as [Quarantined UserId],
2019-02-20 09:40:28 0687 if(uaqe > 42005,uaqe,null()) as [User Access Quarantine End]
2019-02-20 09:40:28 0689 LOAD
2019-02-20 09:40:28 0690 date(
2019-02-20 09:40:28 0691 alt(
2019-02-20 09:40:28 0692 date#(left(modifiedDate,10),'YYYY-MM-DD'),
2019-02-20 09:40:28 0693 date#(left(modifiedDate,10),'YYYY/MM/DD'),
2019-02-20 09:40:28 0694 date#(left(modifiedDate,10),'MM-DD-YYYY'),
2019-02-20 09:40:28 0695 date#(left(modifiedDate,10),'MM/DD/YYYY'),
2019-02-20 09:40:28 0696 date#(left(modifiedDate,10),'YYYY.MM.DD'),
2019-02-20 09:40:28 0697 'No valid date')
2019-02-20 09:40:28 0698 ) as [User Access Modified],
2019-02-20 09:40:28 0699 [modifiedByUserName] as [User Access Modified by],
2019-02-20 09:40:28 0700 date(
2019-02-20 09:40:28 0701 alt(
2019-02-20 09:40:28 0702 date#(left(lastUsed,10),'YYYY-MM-DD'),
2019-02-20 09:40:28 0703 date#(left(lastUsed,10),'YYYY/MM/DD'),
2019-02-20 09:40:28 0704 date#(left(lastUsed,10),'MM-DD-YYYY'),
2019-02-20 09:40:28 0705 date#(left(lastUsed,10),'MM/DD/YYYY'),
2019-02-20 09:40:28 0706 date#(left(lastUsed,10),'YYYY.MM.DD'),
2019-02-20 09:40:28 0707 'No valid date')
2019-02-20 09:40:28 0708 ) as ualu,
2019-02-20 09:40:28 0709
2019-02-20 09:40:28 0710 if(quarantined='True',
2019-02-20 09:40:28 0711 date(
2019-02-20 09:40:28 0712 alt(
2019-02-20 09:40:28 0713 date#(left(quarantineEnd,10),'YYYY-MM-DD'),
2019-02-20 09:40:28 0714 date#(left(quarantineEnd,10),'YYYY/MM/DD'),
2019-02-20 09:40:28 0715 date#(left(quarantineEnd,10),'MM-DD-YYYY'),
2019-02-20 09:40:28 0716 date#(left(quarantineEnd,10),'MM/DD/YYYY'),
2019-02-20 09:40:28 0717 date#(left(quarantineEnd,10),'YYYY.MM.DD'),
2019-02-20 09:40:28 0718 'No valid date')
2019-02-20 09:40:28 0719 )) as uaqe,
2019-02-20 09:40:28 0720 quarantined as [User Access Quarantined],
2019-02-20 09:40:28 0721 1 as [User Access Token Count],
2019-02-20 09:40:28 0722
2019-02-20 09:40:28 0723 applymap('user_map',__KEY_root,'Unknown') as UserId
2019-02-20 09:40:28 0724 RESIDENT RestConectorMasterTable
2019-02-20 09:40:28 0725 WHERE NOT IsNull([__KEY_root])
2019-02-20 09:40:28 11 fields found: User Access Modified, User Access Modified by, ualu, uaqe, User Access Quarantined, User Access Token Count, UserId, Unused UserId, User Access Last Used, Quarantined UserId, User Access Quarantine End,
2019-02-20 09:40:28 16 lines fetched
2019-02-20 09:40:28 0727 DROP TABLE RestConectorMasterTable
2019-02-20 09:40:28 0728 DROP FIELDs uaqe, ualu
2019-02-20 09:40:28 0731 ENDSUB
2019-02-20 09:40:28 0630 DisConnect
2019-02-20 09:40:28 0631 LET rose = evaluate(NumRows_monitor_apps_REST_license_user)
2019-02-20 09:40:28 0632 LET rose = if(isnull(rose),0,rose)
2019-02-20 09:40:28 0633 LET NumRowsQRS = 0 + 32
2019-02-20 09:40:28 0634 LET QRS_RowCounts = 'QRS Row Counts: monitor_apps_REST_license_user = 32 lines,'
2019-02-20 09:40:28 0635 Next endpoint
2019-02-20 09:40:28 0629 CALL monitor_apps_REST_license_login
2019-02-20 09:40:28 0736 LIB CONNECT TO 'monitor_apps_REST_license_login'
2019-02-20 09:40:28 0739 License_LoginAccessGroups:
2019-02-20 09:40:28 0740 Load
2019-02-20 09:40:28 0741
2019-02-20 09:40:28 0742
2019-02-20 09:40:28 0743 timestamp("createdDate",'YYYY-MM-DD hh:mm') as [Login Access Created],
2019-02-20 09:40:28 0744 timestamp("modifiedDate",'YYYY-MM-DD hh:mm') as [Login Access Modified],
2019-02-20 09:40:28 0745 "modifiedByUserName" as [Login Access Modified by],
2019-02-20 09:40:28 0746 "name" as [Login Access Rule],
2019-02-20 09:40:28 0747 "usedAccessTypes" as [Login Passes Used],
2019-02-20 09:40:28 0748 "remainingAccessTypes" as [Login Passes Remaining],
2019-02-20 09:40:28 0749 "assignedAccessTypes" as [Login Passes Assigned],
2019-02-20 09:40:28 0750 "assignedTokens" as [Login Access Token Count]
2019-02-20 09:40:28 0751 SQL SELECT
2019-02-20 09:40:28 0752 "createdDate",
2019-02-20 09:40:28 0753 "modifiedDate",
2019-02-20 09:40:28 0754 "modifiedByUserName",
2019-02-20 09:40:28 0755 "name",
2019-02-20 09:40:28 0756 "usedAccessTypes",
2019-02-20 09:40:28 0757 "remainingAccessTypes",
2019-02-20 09:40:28 0758 "assignedAccessTypes",
2019-02-20 09:40:28 0759 "assignedTokens"
2019-02-20 09:40:28 0760
2019-02-20 09:40:28 0761 FROM JSON (wrap on) "root"
2019-02-20 09:40:28 8 fields found: Login Access Created, Login Access Modified, Login Access Modified by, Login Access Rule, Login Passes Used, Login Passes Remaining, Login Passes Assigned, Login Access Token Count,
2019-02-20 09:40:28 0 lines fetched
2019-02-20 09:40:28 0763 LET NumRows_monitor_apps_REST_license_login = NoOfRows('License_LoginAccessGroups')
2019-02-20 09:40:28 0765 ENDSUB
2019-02-20 09:40:28 0630 DisConnect
2019-02-20 09:40:28 0631 LET rose = evaluate(NumRows_monitor_apps_REST_license_login)
2019-02-20 09:40:28 0632 LET rose = if(isnull(rose),0,rose)
2019-02-20 09:40:28 0633 LET NumRowsQRS = 32 + 0
2019-02-20 09:40:28 0634 LET QRS_RowCounts = 'QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines,'
2019-02-20 09:40:28 0635 Next endpoint
2019-02-20 09:40:28 0629 CALL monitor_apps_REST_user
2019-02-20 09:40:28 0770 LIB CONNECT TO 'monitor_apps_REST_user'
2019-02-20 09:40:29 0772 RestConnectorMasterTable:
2019-02-20 09:40:29 0773 SQL SELECT
2019-02-20 09:40:29 0774 "id" AS "id_u2",
2019-02-20 09:40:29 0775 "createdDate" AS "createdDate_u1",
2019-02-20 09:40:29 0776 "modifiedDate" AS "modifiedDate_u1",
2019-02-20 09:40:29 0777 "modifiedByUserName" AS "modifiedByUserName_u1",
2019-02-20 09:40:29 0778 "userId",
2019-02-20 09:40:29 0779 "userDirectory",
2019-02-20 09:40:29 0780 "name" AS "name_u0",
2019-02-20 09:40:29 0781 "inactive",
2019-02-20 09:40:29 0782 "removedExternally",
2019-02-20 09:40:29 0783 "blacklisted",
2019-02-20 09:40:29 0784 "__KEY_root",
2019-02-20 09:40:29 0785
2019-02-20 09:40:29 0786
2019-02-20 09:40:29 0787
2019-02-20 09:40:29 0788
2019-02-20 09:40:29 0789
2019-02-20 09:40:29 0790
2019-02-20 09:40:29 0791
2019-02-20 09:40:29 0792
2019-02-20 09:40:29 0793
2019-02-20 09:40:29 0794
2019-02-20 09:40:29 0795 (SELECT
2019-02-20 09:40:29 0796 "@Value" AS "@Value_u0",
2019-02-20 09:40:29 0797 "__FK_roles"
2019-02-20 09:40:29 0798 FROM "roles" FK "__FK_roles" ArrayValueAlias "@Value_u0"),
2019-02-20 09:40:29 0799 (SELECT
2019-02-20 09:40:29 0800 "id" AS "id_u1",
2019-02-20 09:40:29 0801 "createdDate" AS "createdDate_u0",
2019-02-20 09:40:29 0802 "modifiedDate" AS "modifiedDate_u0",
2019-02-20 09:40:29 0803 "modifiedByUserName" AS "modifiedByUserName_u0",
2019-02-20 09:40:29 0804 "attributeType",
2019-02-20 09:40:29 0805 "attributeValue",
2019-02-20 09:40:29 0806 "externalId",
2019-02-20 09:40:29 0807 "__FK_attributes"
2019-02-20 09:40:29 0808 FROM "attributes" FK "__FK_attributes")
2019-02-20 09:40:29 0809
2019-02-20 09:40:29 0810
2019-02-20 09:40:29 0811
2019-02-20 09:40:29 0812
2019-02-20 09:40:29 0813 FROM JSON (wrap on) "root" PK "__KEY_root"
2019-02-20 09:40:30 22 fields found: @Value_u0, __FK_roles, id_u1, createdDate_u0, modifiedDate_u0, modifiedByUserName_u0, attributeType, attributeValue, externalId, __FK_attributes, id_u2, createdDate_u1, modifiedDate_u1, modifiedByUserName_u1, userId, userDirectory, name_u0, inactive, removedExternally, blacklisted, __KEY_root, __extra_,
2019-02-20 09:40:30 1,449 lines fetched
2019-02-20 09:40:30 0815 LET NumRows_monitor_apps_REST_user = NoOfRows('RestConnectorMasterTable')
2019-02-20 09:40:30 0817 User:
2019-02-20 09:40:30 0818 LOAD
2019-02-20 09:40:30 0819 [createdDate_u1] AS [User Created],
2019-02-20 09:40:30 0820 [modifiedDate_u1] AS [User Modified],
2019-02-20 09:40:30 0821 [modifiedByUserName_u1] AS [User Modified By],
2019-02-20 09:40:30 0822 userDirectory & '\' & userId AS UserId,
2019-02-20 09:40:30 0823
2019-02-20 09:40:30 0824 [name_u0] AS [User Name],
2019-02-20 09:40:30 0825 [inactive] AS [User Inactive],
2019-02-20 09:40:30 0826 [removedExternally] AS [User Removed Externally],
2019-02-20 09:40:30 0827 [blacklisted] AS [User Blacklisted],
2019-02-20 09:40:30 0828 [__KEY_root] AS _userKey
2019-02-20 09:40:30 0829 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:30 0830 WHERE NOT IsNull([__KEY_root])
2019-02-20 09:40:30 9 fields found: User Created, User Modified, User Modified By, UserId, User Name, User Inactive, User Removed Externally, User Blacklisted, _userKey,
2019-02-20 09:40:30 507 lines fetched
2019-02-20 09:40:30 0832 userRoles:
2019-02-20 09:40:30 0833 LOAD [@Value_u0] AS [User Role],
2019-02-20 09:40:30 0834 [__FK_roles] AS _userKey
2019-02-20 09:40:30 0835 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:30 0836 WHERE NOT IsNull([__FK_roles])
2019-02-20 09:40:30 0837 and exists(_userKey,__FK_roles)
2019-02-20 09:40:30 2 fields found: User Role, _userKey,
2019-02-20 09:40:30 1 lines fetched
2019-02-20 09:40:30 0839 userAttributes:
2019-02-20 09:40:30 0840 LOAD
2019-02-20 09:40:30 0841 [createdDate_u0] AS [User Attribute Created],
2019-02-20 09:40:30 0842 [modifiedDate_u0] AS [User Attribute Modified],
2019-02-20 09:40:30 0843 [modifiedByUserName_u0] AS [User Attribute Modified By],
2019-02-20 09:40:30 0844 [attributeType] AS [User Attribute Type],
2019-02-20 09:40:30 0845 [attributeValue] AS [User Attribute Value],
2019-02-20 09:40:30 0846 [externalId] AS [User Attribute External Id],
2019-02-20 09:40:30 0847 [__FK_attributes] AS _userKey
2019-02-20 09:40:30 0848 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:30 0849 WHERE NOT IsNull([__FK_attributes])
2019-02-20 09:40:30 0850 and exists(_userKey,__FK_attributes)
2019-02-20 09:40:30 7 fields found: User Attribute Created, User Attribute Modified, User Attribute Modified By, User Attribute Type, User Attribute Value, User Attribute External Id, _userKey,
2019-02-20 09:40:30 941 lines fetched
2019-02-20 09:40:30 0873 DROP TABLE RestConnectorMasterTable
2019-02-20 09:40:30 0875 ENDSUB
2019-02-20 09:40:30 0630 DisConnect
2019-02-20 09:40:30 0631 LET rose = evaluate(NumRows_monitor_apps_REST_user)
2019-02-20 09:40:30 0632 LET rose = if(isnull(rose),0,rose)
2019-02-20 09:40:30 0633 LET NumRowsQRS = 32 + 1449
2019-02-20 09:40:30 0634 LET QRS_RowCounts = 'QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines, monitor_apps_REST_user = 1449 lines,'
2019-02-20 09:40:30 0635 Next endpoint
2019-02-20 09:40:30 0629 CALL monitor_apps_REST_license_access
2019-02-20 09:40:30 0880 LIB CONNECT TO 'monitor_apps_REST_license_access'
2019-02-20 09:40:31 0882 RestConnectorMasterTable:
2019-02-20 09:40:31 0883 SQL SELECT
2019-02-20 09:40:31 0884 "totalTokens",
2019-02-20 09:40:31 0885 "availableTokens",
2019-02-20 09:40:31 0886 "__KEY_root",
2019-02-20 09:40:31 0887 (SELECT
2019-02-20 09:40:31 0888 "tokenCost",
2019-02-20 09:40:31 0889 "allocatedTokens",
2019-02-20 09:40:31 0890 "usedTokens",
2019-02-20 09:40:31 0891 "quarantinedTokens",
2019-02-20 09:40:31 0892 "__FK_userAccessType"
2019-02-20 09:40:31 0893 FROM "userAccessType" FK "__FK_userAccessType"),
2019-02-20 09:40:31 0894 (SELECT
2019-02-20 09:40:31 0895 "tokenCost" AS "tokenCost_u0",
2019-02-20 09:40:31 0896 "allocatedTokens" AS "allocatedTokens_u0",
2019-02-20 09:40:31 0897 "usedTokens" AS "usedTokens_u0",
2019-02-20 09:40:31 0898 "unavailableTokens",
2019-02-20 09:40:31 0899 "__FK_loginAccessType"
2019-02-20 09:40:31 0900 FROM "loginAccessType" FK "__FK_loginAccessType")
2019-02-20 09:40:31 0901 FROM JSON (wrap on) "root" PK "__KEY_root"
2019-02-20 09:40:31 14 fields found: tokenCost, allocatedTokens, usedTokens, quarantinedTokens, __FK_userAccessType, tokenCost_u0, allocatedTokens_u0, usedTokens_u0, unavailableTokens, __FK_loginAccessType, totalTokens, availableTokens, __KEY_root, __extra_,
2019-02-20 09:40:31 3 lines fetched
2019-02-20 09:40:31 0903 LET NumRows_monitor_apps_REST_license_access = NoOfRows('RestConnectorMasterTable')
2019-02-20 09:40:31 0906 License_Summary:
2019-02-20 09:40:31 0907 Load
2019-02-20 09:40:31 0908 'User Access' as [License Token Type],
2019-02-20 09:40:31 0909 [tokenCost] AS [License Token Cost],
2019-02-20 09:40:31 0910 [allocatedTokens] AS [License Allocated Tokens],
2019-02-20 09:40:31 0911 [usedTokens] AS [License Used Tokens],
2019-02-20 09:40:31 0912 [quarantinedTokens] AS [License Quarantined Tokens]
2019-02-20 09:40:31 0913 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:31 0914 WHERE NOT IsNull([__FK_userAccessType])
2019-02-20 09:40:31 5 fields found: License Token Type, License Token Cost, License Allocated Tokens, License Used Tokens, License Quarantined Tokens,
2019-02-20 09:40:31 1 lines fetched
2019-02-20 09:40:31 0917 Concatenate (License_Summary) LOAD
2019-02-20 09:40:31 0918 'Login Access' as [License Token Type],
2019-02-20 09:40:31 0919 [tokenCost_u0] AS [License Token Cost],
2019-02-20 09:40:31 0920 [allocatedTokens_u0] AS [License Allocated Tokens],
2019-02-20 09:40:31 0921 [usedTokens_u0] AS [License Used Tokens],
2019-02-20 09:40:31 0922 [unavailableTokens] AS [License Unavailable Tokens]
2019-02-20 09:40:31 0923 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:31 0924 WHERE NOT IsNull([__FK_loginAccessType])
2019-02-20 09:40:31 5 fields found: License Token Type, License Token Cost, License Allocated Tokens, License Used Tokens, License Unavailable Tokens,
2019-02-20 09:40:31 2 lines fetched
2019-02-20 09:40:31 0927 Concatenate (License_Summary) LOAD
2019-02-20 09:40:31 0928 'Total' as [License Token Type],
2019-02-20 09:40:31 0929 1 as [License Token Cost],
2019-02-20 09:40:31 0930 [totalTokens] AS [License Total Tokens],
2019-02-20 09:40:31 0931 [availableTokens] AS [License Total Available Tokens]
2019-02-20 09:40:31 0932 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:31 0933 WHERE NOT IsNull([__KEY_root])
2019-02-20 09:40:31 4 fields found: License Token Type, License Token Cost, License Total Tokens, License Total Available Tokens,
2019-02-20 09:40:31 3 lines fetched
2019-02-20 09:40:31 0936 DROP TABLE RestConnectorMasterTable
2019-02-20 09:40:31 0938 ENDSUB
2019-02-20 09:40:31 0630 DisConnect
2019-02-20 09:40:31 0631 LET rose = evaluate(NumRows_monitor_apps_REST_license_access)
2019-02-20 09:40:31 0632 LET rose = if(isnull(rose),0,rose)
2019-02-20 09:40:31 0633 LET NumRowsQRS = 1481 + 3
2019-02-20 09:40:31 0634 LET QRS_RowCounts = 'QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines, monitor_apps_REST_user = 1449 lines, monitor_apps_REST_license_access = 3 lines,'
2019-02-20 09:40:31 0635 Next endpoint
2019-02-20 09:40:31 0629 CALL monitor_apps_REST_app
2019-02-20 09:40:31 0943 LIB CONNECT TO 'monitor_apps_REST_app'
2019-02-20 09:40:31 0945 RestConnectorMasterTable:
2019-02-20 09:40:31 0946 SQL SELECT
2019-02-20 09:40:31 0947 "id" AS "id_u1",
2019-02-20 09:40:31 0948 "__KEY_root",
2019-02-20 09:40:31 0949 (SELECT
2019-02-20 09:40:31 0950 "id" AS "id_u0",
2019-02-20 09:40:31 0951 "name" AS "name_u0",
2019-02-20 09:40:31 0952 "__FK_stream"
2019-02-20 09:40:31 0953 FROM "stream" FK "__FK_stream")
2019-02-20 09:40:31 0954 FROM JSON (wrap on) "root" PK "__KEY_root"
2019-02-20 09:40:32 6 fields found: id_u0, name_u0, __FK_stream, id_u1, __KEY_root, __extra_,
2019-02-20 09:40:32 548 lines fetched
2019-02-20 09:40:32 0956 LET NumRows_monitor_apps_REST_app = NoOfRows('RestConnectorMasterTable')
2019-02-20 09:40:32 0958 mapStream:
2019-02-20 09:40:32 0959 MAPPING LOAD
2019-02-20 09:40:32 0960 [__FK_stream],
2019-02-20 09:40:32 0961 [name_u0] as streamName
2019-02-20 09:40:32 0962 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:32 0963 WHERE NOT IsNull([__FK_stream])
2019-02-20 09:40:32 2 fields found: __FK_stream, streamName,
2019-02-20 09:40:32 26 lines fetched
2019-02-20 09:40:32 0965 App:
2019-02-20 09:40:32 0966 LOAD [id_u1] AS AppId,
2019-02-20 09:40:32 0967 ApplyMap('mapStream',__KEY_root,'Unpublished') as [App Stream]
2019-02-20 09:40:32 0968 RESIDENT RestConnectorMasterTable
2019-02-20 09:40:32 0969 WHERE NOT IsNull([__KEY_root])
2019-02-20 09:40:32 2 fields found: AppId, App Stream,
2019-02-20 09:40:32 522 lines fetched
2019-02-20 09:40:32 0971 DROP TABLE RestConnectorMasterTable
2019-02-20 09:40:32 0973 ENDSUB
2019-02-20 09:40:32 0630 DisConnect
2019-02-20 09:40:32 0631 LET rose = evaluate(NumRows_monitor_apps_REST_app)
2019-02-20 09:40:32 0632 LET rose = if(isnull(rose),0,rose)
2019-02-20 09:40:32 0633 LET NumRowsQRS = 1484 + 548
2019-02-20 09:40:32 0634 LET QRS_RowCounts = 'QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines, monitor_apps_REST_user = 1449 lines, monitor_apps_REST_license_access = 3 lines, monitor_apps_REST_app = 548 lines,'
2019-02-20 09:40:32 0635 Next endpoint
2019-02-20 09:40:32 0637 If NumRowsQRS > 0 Then
2019-02-20 09:40:32 0638 CALL monitor_app_reload_stats('INFO','License Monitor', 'QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines, monitor_apps_REST_user = 1449 lines, monitor_apps_REST_license_access = 3 lines, monitor_apps_REST_app = 548 lines,','Status Message')
2019-02-20 09:40:32 0591 IF description = 'Reload Start' THEN
2019-02-20 09:40:32 0606 CALL monitor_app_stats_incremental
2019-02-20 09:40:32 0576 Concatenate (monitor_app_reload_stats)
2019-02-20 09:40:32 0577 Load
2019-02-20 09:40:32 0578 RowNo() as [Log Entry],
2019-02-20 09:40:32 0579 timestamp(now(1)) as [Log Timestamp],
2019-02-20 09:40:32 0580 'INFO' as [Log Severity],
2019-02-20 09:40:32 0581 'RRHO-QS2' as Host,
2019-02-20 09:40:32 0582 'Status Message' as Description,
2019-02-20 09:40:32 0583 'QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines, monitor_apps_REST_user = 1449 lines, monitor_apps_REST_license_access = 3 lines, monitor_apps_REST_app = 548 lines,' as [Log Message],
2019-02-20 09:40:32 0584 'License Monitor' as Object
2019-02-20 09:40:32 0585 AutoGenerate (1)
2019-02-20 09:40:32 7 fields found: Log Entry, Log Timestamp, Log Severity, Host, Description, Log Message, Object,
2019-02-20 09:40:32 1,481 lines fetched
2019-02-20 09:40:32 0587 ENDSUB
2019-02-20 09:40:32 0608 ELSEIF description = 'Reload Finish' THEN
2019-02-20 09:40:32 0618 ENDSUB
2019-02-20 09:40:32 0639 TRACE Reload Status: QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines, monitor_apps_REST_user = 1449 lines, monitor_apps_REST_license_access = 3 lines, monitor_apps_REST_app = 548 lines,
2019-02-20 09:40:32 0639 Reload Status: QRS Row Counts: monitor_apps_REST_license_user = 32 lines, monitor_apps_REST_license_login = 0 lines, monitor_apps_REST_user = 1449 lines, monitor_apps_REST_license_access = 3 lines, monitor_apps_REST_app = 548 lines,
2019-02-20 09:40:32 0640
2019-02-20 09:40:32 0640 ELSE
2019-02-20 09:40:32 0646 ENDSUB
2019-02-20 09:40:32 1222 CALL calendarization
2019-02-20 09:40:32 0978 Range:
2019-02-20 09:40:32 0979 LOAD
2019-02-20 09:40:32 0980 DayStart(min) as startdate,
2019-02-20 09:40:32 0981 DayStart(max) as enddate,
2019-02-20 09:40:32 0982 timestamp(max) as maxLogTimeStamp
2019-02-20 09:40:32 0983 LOAD
2019-02-20 09:40:32 0984 min(LogEntryPeriodStart) as min,
2019-02-20 09:40:32 0985 max(LogTimeStamp) as max
2019-02-20 09:40:32 0986 resident LogContent
2019-02-20 09:40:32 3 fields found: startdate, enddate, maxLogTimeStamp,
2019-02-20 09:40:32 1 lines fetched
2019-02-20 09:40:32 0988 let startdate= num(peek('startdate',-1,'Range'),'###0.#####','.')
2019-02-20 09:40:32 0989 let enddate= num(num(peek('enddate',-1,'Range')) +1,'###0.#####','.')
2019-02-20 09:40:32 0990 let maxLogTimeStamp = peek('maxLogTimeStamp',-1,'Range')
2019-02-20 09:40:32 0991 Let maxLogTimeStamp_Hour = hour(maxLogTimeStamp)
2019-02-20 09:40:32 0994 drop table Range
2019-02-20 09:40:32 0996 do while startdate <= enddate
2019-02-20 09:40:32 1006 Let hour_now = maxLogTimeStamp_Hour
2019-02-20 09:40:32 1007 hour_temp:
2019-02-20 09:40:32 1008 mapping Load
2019-02-20 09:40:32 1009 recno()-1 & ':00' as Hour,
2019-02-20 09:40:32 1010 if(-(recno()-1)>=0, -(recno()-1),23+(-(recno()-1))+1) as hour_sort
2019-02-20 09:40:32 1011 autogenerate (24)
2019-02-20 09:40:32 2 fields found: Hour, hour_sort,
2019-02-20 09:40:32 24 lines fetched
2019-02-20 09:40:32 1015 TimeDIM:
2019-02-20 09:40:32 1016 LOAD
2019-02-20 09:40:32 1017 DISTINCT DateTime,
2019-02-20 09:40:32 1018 Year(DateTime) as Year,
2019-02-20 09:40:32 1019 MonthName(DateTime) as Month,
2019-02-20 09:40:32 1020
2019-02-20 09:40:32 1021 WeekStart(DateTime) as [Week Beginning],
2019-02-20 09:40:32 1022 date(dayname(DateTime),'MMM-DD') as Day,
2019-02-20 09:40:32 1023 WeekDay(DateTime) as Weekday,
2019-02-20 09:40:32 1024 makedate(year(DateTime),month(DateTime),day(DateTime)) as Date,
2019-02-20 09:40:32 1025 Hour(DateTime)&':00' as Hour,
2019-02-20 09:40:32 1026 ApplyMap('hour_temp',Hour(DateTime)&':00' ) as hour_sort,
2019-02-20 09:40:32 1027 Minute(DateTime) as [Minute of Hour],
2019-02-20 09:40:32 1028
2019-02-20 09:40:32 1029 timestamp(floor(DateTime,1/(24)),'MMM-DD hh:00') as [Hour Timeline],
2019-02-20 09:40:32 1030 timestamp(floor(DateTime,10/(24*60)),'MMM-DD hh:mm') as [Ten-Minute Timeline],
2019-02-20 09:40:32 1031 timestamp(floor(DateTime,5/(24*60)),'MMM-DD hh:mm') as [Five-Minute Timeline],
2019-02-20 09:40:32 1032 timestamp(floor(DateTime,1/(24*60)),'MMM-DD hh:mm') as [One-Minute Timeline],
2019-02-20 09:40:32 1033 If(DateTime>=43516.236226852,Dual('Last 4 Hours',1)) AS [Last 4 Hours],
2019-02-20 09:40:32 1034 If(DateTime>=43515.402893519,Dual('Last 24 Hours',1)) AS [Last 24 Hours],
2019-02-20 09:40:32 1035 If(DateTime>=43513.402893519,Dual('Last 72 Hours',1)) AS [Last 72 Hours],
2019-02-20 09:40:32 1036 If(DateTime>=43516.236226852,1) AS last4hours,
2019-02-20 09:40:32 1037 If(DateTime>=43515.402893519,1) AS last24hours,
2019-02-20 09:40:32 1038 If(DateTime>=43513.402893519,1) AS last72hours
2019-02-20 09:40:32 1039 resident tempDateTimeList
2019-02-20 09:40:32 Error: Table 'tempDateTimeList' not found
2019-02-20 09:40:32 Execution Failed
2019-02-20 09:40:32 Execution finished

Thanks in advance.

topic Re: Qlik Sense Server Reload License Monitor task failure. in Management & Governance

Qlik Sense Server Reload License Monitor task failure.

Re: Qlik Sense Server Reload License Monitor task failure.

Re: Qlik Sense Server Reload License Monitor task failure.

Re: Qlik Sense Server Reload License Monitor task failure.

Re: Qlik Sense Server Reload License Monitor task failure.

Re: Qlik Sense Server Reload License Monitor task failure.