Qlik Sense Server Reload License Monitor task failure.

[kevincase]

After initial installation, the Reload License Monitor task was running successfully.  Starting last Thursday, this job started failing.  Here is the error from the log:

2015-03-17 10:11:02 0726 CALL loadBaseTable ('LogContent', 'lib://ServerLogFolder/governanceLicenseLog_1.0') 
2015-03-17 10:11:02 0727
2015-03-17 10:11:02 0126   Let baseFileSize = FileSize('lib://ServerLogFolder/governanceLicenseLog_1.0.qvd')
2015-03-17 10:11:02 0128   IF  baseFileSize > 0 THEN     
2015-03-17 10:11:02 0129  
2015-03-17 10:11:02 0130     trace Incremental reload (not first reload)
2015-03-17 10:11:02 0130     Incremental reload (not first reload)
2015-03-17 10:11:02 0131    
2015-03-17 10:11:02 0131     Let firstReload = 0
2015-03-17 10:11:02 0133     LogContent:
2015-03-17 10:11:02 0134             NoConcatenate
2015-03-17 10:11:02 0135          Load * FROM lib://ServerLogFolder/governanceLicenseLog_1.0.qvd (qvd)
2015-03-17 10:11:02 0136             WHERE LogTimeStamp >= '3/17/2014'
2015-03-17 10:11:02 0137            
2015-03-17 10:11:02          Error: Field not found - <LogTimeStamp>
2015-03-17 10:11:02          General Script Error
2015-03-17 10:11:02          Execution Failed
2015-03-17 10:11:02          Execution finished.

If I look at the last modified time for the governanceLicenseLog_1.0.dvd, it is dated 3/12/2015.

A reboot of the server does not rectify the issue nor does a restart of the Engine service.  If I try to delete the QVD, a message is displayed that the file is in use but the Engine.

Any ideas?

[korsikov · Accepted solution]

Stop all Qlik Sense Services and delete this files. Then try to start reload again

[kevincase]

Just about the only thing I didn't try! This worked.

[korsikov]

and don't foget give you permision on this file. Without you can't delete it

[korsikov]

QVD file needed for fast incrimental load. new data load from logs. Old data load from QVD on optimased speed. There is much faster then load from all data. And aslo in QVD file stored aggregated data, such as calendar. And they do not need to re-transform

[shivani_singhal]

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.