Solved: Log Files - Qlik Sense Hub - Qlik Community

Report Inappropriate Content · ‎2016-05-16

I have been using Qlik Sense Hub for less than a week....

Where are log files stored on Qlik Sense Hub?

I imported a .qvf file in QMC and received

“Failed to import error. Please check log file."

Thanks for your help....

David

Levi_Turner · ‎2016-05-16

I'd bookmark this page: https://help.qlik.com/en-US/sense/2.2/pdf/Troubleshoot%20Qlik%20Sense%20using%20logs.pdf

In general app migration issues are logged in:

C:\ProgramData\Qlik\Sense\Log\AppMigration

C:\ProgramData\Qlik\Sense\Log\Repository\Trace <-- The System log

C:\ProgramData\Qlik\Sense\Log\Engine\Trace <-- The System log

View solution in original post

kevincase · ‎2016-05-16

David,

Your log files could be located in one of two places on the server. Prior to release 2.1.1:

C:\ProgramData\Qlik\Sense\Log\Script

Release 2.1.1 and greater:

C:\ProgramData\Qlik\Sense\Log\Script

or

C:\ProgramData\Qlik\Sense\Repository\Archived Logs\your_server_name\Script

Report Inappropriate Content · ‎2016-05-16

I was able to find the directory...

However, it does not seem to update with current log error. The last log entry is from 10:58 AM when I received the error, but I have tried to import .qvf file a couple hours after that time, with no update in the script directory.

I get error message "Failed to import app. Please check the log file"

Please advise...

kevincase · ‎2016-05-16

David,

What does the log contain? Is there an error?

Also, based on a quick search, some people restarted the repository service and the error went away and they were able to import. Have you tried this?

If you search the forum for 'Failed to import app', you will see what others did to get around this issue.

Report Inappropriate Content · ‎2016-05-16

I will search the forum and see what I can find. I did restart the Qlik Management Console and still got error. Below is a copy of what most recent log file contains:

Does not mean a whole lot to me...

Execution started.

2016-05-16 10:58:33 Qlik Sense Server Version 2.0.1+Build:46.QSM12-CIGS

2016-05-16 10:58:33 CPU Target x64

2016-05-16 10:58:33 Operating System Windows Server 2012 Datacenter (64 bit edition)

2016-05-16 10:58:33 Wow64 mode Not using Wow64

2016-05-16 10:58:33 Language 0409 English (United States) English

2016-05-16 10:58:33 Country 1 United States United States

2016-05-16 10:58:33 MDAC Version 6.2.9200.16384

2016-05-16 10:58:33 MDAC Full Install Version 6.2.9200.16384

2016-05-16 10:58:33 PreferredCompression 2

2016-05-16 10:58:33 EnableParallelReload 1

2016-05-16 10:58:33 ParallelizeQvdLoads 1

2016-05-16 10:58:33 AutoSaveAfterReload 0

2016-05-16 10:58:33 BackupBeforeReload 0

2016-05-16 10:58:33 EnableFlushLog 0

2016-05-16 10:58:33 SaveInfoWhenSavingFile 0

2016-05-16 10:58:33 UserLogfileCharset 65001

2016-05-16 10:58:33 OdbcLoginTimeout -1

2016-05-16 10:58:33 OdbcConnectionTimeout -1

2016-05-16 10:58:33 ScriptWantsDbWrite false

2016-05-16 10:58:33 ScriptWantsExe false

2016-05-16 10:58:33 LogFile CodePage Used: 65001

2016-05-16 10:58:33 UseMemoryFillPattern 1

2016-05-16 10:58:33 ScriptMode Standard (limits system access)

2016-05-16 10:58:33 ReloadCodebase Classic

2016-05-16 10:58:33 Reload Executed By UserDirectory=INTERNAL; UserId=sa_scheduler

2016-05-16 10:58:33 Process Executing Qlik Sense Server

2016-05-16 10:58:33 Process ID 4000

2016-05-16 10:58:33 0005 SET app_version = '2.0'

2016-05-16 10:58:33 0006 TRACE Reloading Operations Monitor 2.0

2016-05-16 10:58:33 0006 Reloading Operations Monitor 2.0

2016-05-16 10:58:33 0007

2016-05-16 10:58:33 0008 Let ReloadStartTime = now()

2016-05-16 10:58:33 0009 SET monthsOfHistory = 13

2016-05-16 10:58:33 0010 LET cutoffDate = AddMonths(today(),-13,1)

2016-05-16 10:58:33 0012 Let comp = ComputerName()

2016-05-16 10:58:33 0012 LET ProdVer = PurgeChar(ProductVersion(),chr(39))

2016-05-16 10:58:33 0013 TRACE ... from WIN-CS6KR6SD3TS running version 2.0.1+Build:46.QSM12-CIGS

2016-05-16 10:58:33 0013 ... from WIN-CS6KR6SD3TS running version 2.0.1+Build:46.QSM12-CIGS

2016-05-16 10:58:33 0014

2016-05-16 10:58:33 0015 Let LastReloadTime = timestamp(if(isnull(LastSuccessfulReloadStartTime),cutoffDate,LastSuccessfulReloadStartTime))

2016-05-16 10:58:33 0016 Let lastReloadCompare = num(LastReloadTime)-1

2016-05-16 10:58:33 0018 LET serverLogFolder = 'lib://ServerLogFolder/'

2016-05-16 10:58:33 0019 LET archivedLogsFolder = 'lib://ArchivedLogsFolder/'

2016-05-16 10:58:33 0021 LET baseFileName = 'governanceLogContent_2.0'

2016-05-16 10:58:33 0022 LET baseTableName = 'lib://ServerLogFolder/governanceLogContent_2.0'

2016-05-16 10:58:33 0023 LET serviceFileName = 'governanceServiceLog_2.0'

2016-05-16 10:58:33 0024 LET serviceTableName = 'lib://ServerLogFolder/governanceServiceLog_2.0'

2016-05-16 10:58:33 0026 SET hideprefix = 'log'

2016-05-16 10:58:33 0027 SET firstReload = 0

2016-05-16 10:58:33 0030 SET TimeFormat = 'hh:mm:ss'

2016-05-16 10:58:33 0031 SET DateFormat = 'YYYY-MM-DD'

2016-05-16 10:58:33 0032 SET TimestampFormat = 'YYYY-MM-DD hh:mm:ss'

2016-05-16 10:58:33 0035 SUB logList

2016-05-16 10:58:33 0036

2016-05-16 10:58:33 0062 SUB defineFields

2016-05-16 10:58:33 0063

2016-05-16 10:58:33 0147 SUB loadBaseTable (nombre, archivo)

2016-05-16 10:58:33 0148

2016-05-16 10:58:33 0191 SUB multiNodeConfig

2016-05-16 10:58:33 0192

2016-05-16 10:58:33 0218 SUB logFolderList

2016-05-16 10:58:33 0219

2016-05-16 10:58:33 0239 SUB loadFiles (fdr,iter)

2016-05-16 10:58:33 0240

2016-05-16 10:58:33 0301 SUB serviceLog

2016-05-16 10:58:33 0302

2016-05-16 10:58:33 0344 SUB concatTables (concatToTable, incrementalTable, concatField)

2016-05-16 10:58:33 0345

2016-05-16 10:58:33 0379 SUB storeFiles (nombre, archivo)

2016-05-16 10:58:33 0380

2016-05-16 10:58:33 0396 SUB calendarization

2016-05-16 10:58:33 0397

2016-05-16 10:58:33 0488 SUB supportingLogic

2016-05-16 10:58:33 0489

2016-05-16 10:58:33 0576 SUB finalize

2016-05-16 10:58:33 0577

2016-05-16 10:58:33 0603 CALL logList

2016-05-16 10:58:33 0604

2016-05-16 10:58:33 0037 logList:

2016-05-16 10:58:33 0038 LOAD * INLINE [

2016-05-16 10:58:33 0039 logService, logArea, logType, logStart, logAddlFields

2016-05-16 10:58:33 0040 Engine, Audit, Activity,Timestamp,fieldsAuditActivity

2016-05-16 10:58:33 0041 Engine, Audit, Security,Timestamp,fieldsAuditSecurity

2016-05-16 10:58:33 0042 Repository, Audit, Activity,Timestamp,fieldsAuditActivity

2016-05-16 10:58:33 0043 Repository, Audit, Security,Timestamp,fieldsAuditSecurity

2016-05-16 10:58:33 0044 Proxy, Audit, Activity,Timestamp,fieldsAuditActivity

2016-05-16 10:58:33 0045 Proxy, Audit, Security,Timestamp,fieldsAuditSecurity

2016-05-16 10:58:33 0046

2016-05-16 10:58:33 0047 Scheduler, System, Service,Timestamp,fieldsSystemService

2016-05-16 10:58:33 0048 Proxy, System, Service,Timestamp,fieldsSystemService

2016-05-16 10:58:33 0049 Repository, System, Service,Timestamp,fieldsSystemService

2016-05-16 10:58:33 0050 Engine, System, Service,Timestamp,fieldsSystemService

2016-05-16 10:58:33 0051

2016-05-16 10:58:33 0052 Engine, Trace, Performance, Timestamp, fieldsEnginePerformance

2016-05-16 10:58:33 0053 Engine, Trace, Session, "Session Start", fieldsEngineSession

2016-05-16 10:58:33 0054 Repository, Trace, Audit, Timestamp, fieldsRepositoryAudit

2016-05-16 10:58:33 0055 Scheduler, Trace, TaskExecution, StartTime, fieldsSchedulerTaskExecution

2016-05-16 10:58:33 0056

2016-05-16 10:58:33 0057 ]

2016-05-16 10:58:33 5 fields found: logService, logArea, logType, logStart, logAddlFields,

2016-05-16 10:58:33 14 lines fetched

2016-05-16 10:58:33 0059 ENDSUB

2016-05-16 10:58:33 0060

2016-05-16 10:58:33 0604 CALL defineFields

2016-05-16 10:58:33 0605

2016-05-16 10:58:33 0066 LET commonFields = ' UserId,

2016-05-16 10:58:33 0067 ObjectId,ObjectName,

2016-05-16 10:58:33 0068 lower(Hostname) as Hostname,

2016-05-16 10:58:33 0069 Service,

2016-05-16 10:58:33 0070 ProxySessionId,ProxyPackageId,RequestSequenceId,

2016-05-16 10:58:33 0071 Context,Command,Result,Description,

2016-05-16 10:58:33 0072 if(index(Context,'&chr(39)&chr(42)&'app'&chr(47)&chr(42)&chr(39)&')>0,ObjectName) as [App Name],

2016-05-16 10:58:33 0073 ProductVersion'

2016-05-16 10:58:33 0075 LET fieldsAuditActivity = 'ProxySessionId&ProxyPackageId as _proxySessionPackage,'

2016-05-16 10:58:33 0076 & commonFields

2016-05-16 10:58:33 0078 LET fieldsAuditSecurity = 'ProxySessionId&ProxyPackageId as _proxySessionPackage,SecurityClass, ClientHostAddress,'

2016-05-16 10:58:33 0079 & commonFields

2016-05-16 10:58:33 0081 LET fieldsSystemService = 'Severity,If(ProxyPackageId=0 AND ProxySessionId=0, Id, ProxySessionId&ProxyPackageId) as _proxySessionPackage,'

2016-05-16 10:58:33 0082 & commonFields

2016-05-16 10:58:33 0086 LET fieldsSchedulerTaskExecution = 'AppId as ObjectId,

2016-05-16 10:58:33 0087 AppName as ObjectName,

2016-05-16 10:58:33 0088 AppName as [App Name],

2016-05-16 10:58:33 0089 If(Status='&chr(39)&'Aborting'&chr(39)&' OR Status='&chr(39)&'AbortInitiated'&chr(39)&',0,1) as TaskExecution,

2016-05-16 10:58:33 0090 TaskName as [Task Name],

2016-05-16 10:58:33 0091 Status as [Task Status],

2016-05-16 10:58:33 0092 ceil(Duration/1000/60,0.02) as [Task Duration],

2016-05-16 10:58:33 0093 FailureReason as [Task Failure Reason],

2016-05-16 10:58:33 0094 If(len(ProxySessionId)<=1, Id, ProxySessionId) as _proxySessionPackage,

2016-05-16 10:58:33 0095 '& chr(39) & 'Scheduler' & chr(39) & ' as Service,

2016-05-16 10:58:33 0096 Level as Severity,

2016-05-16 10:58:33 0097 lower(Hostname) as Hostname

2016-05-16 10:58:33 0098 '

2016-05-16 10:58:33 0100 LET fieldsEnginePerformance = 'ActiveDocSessions,ActiveDocs,ActiveUsers,CPULoad/100 as CPULoad,LoadedDocs,Selections,

2016-05-16 10:58:33 0101 Round("VMCommitted(MB)"/1024,0.01) as VMCommitted,

2016-05-16 10:58:33 0102 Round("VMAllocated(MB)"/1024,0.01) as VMAllocated,

2016-05-16 10:58:33 0103 Round("VMFree(MB)"/1024,0.01) as VMFree,

2016-05-16 10:58:33 0104 round("VMCommitted(MB)"/("VMFree(MB)"+"VMCommitted(MB)"),0.01) as VMPctCommitted,

2016-05-16 10:58:33 0105 Id as _proxySessionPackage,

2016-05-16 10:58:33 0106 '& chr(39) & 'Engine' & chr(39) & ' as Service,

2016-05-16 10:58:33 0107 Level as Severity,

2016-05-16 10:58:33 0108 lower(Hostname) as Hostname

2016-05-16 10:58:33 0109 '

2016-05-16 10:58:33 0111 LET fieldsEngineSession =

2016-05-16 10:58:33 0112 'AppId as ObjectId,

2016-05-16 10:58:33 0113 "App Title" as [App Name],

2016-05-16 10:58:33 0114 "Client Type",

2016-05-16 10:58:33 0115 "Exe Version",

2016-05-16 10:58:33 0116 Selections as [Session Selections],

2016-05-16 10:58:33 0117 "Exit Reason",

2016-05-16 10:58:33 0118 ceil("Session Duration"*24*60,1) as [Session Duration],

2016-05-16 10:58:33 0119 "App Title" as ObjectName,

2016-05-16 10:58:33 0120 mid([Authenticated User],index([Authenticated User],'&chr(39)&'UserId='&chr(39)&')+7) as "UserId",

2016-05-16 10:58:33 0121 if([Authenticated User] like '&chr(39)&'*INTERNAL*'&chr(39)&',0,1) as [Session Count],

2016-05-16 10:58:33 0122 If(ProxySessionId=0, Id, ProxySessionId) as _proxySessionPackage,

2016-05-16 10:58:33 0123 '& chr(39) & 'Engine' & chr(39) & ' as Service,

2016-05-16 10:58:33 0124 Level as Severity,

2016-05-16 10:58:33 0125 lower(Hostname) as Hostname

2016-05-16 10:58:33 0126 '

2016-05-16 10:58:33 0128 LET fieldsRepositoryAudit =

2016-05-16 10:58:33 0129 'if(len(ActiveUserId)>0,ActiveUserId,'& chr(39) & 'System' & chr(39) &') as UserId,subfield(Message,'&chr(39) & ' ' & chr(39) & ',1) as [QMC Resource Type],

2016-05-16 10:58:33 0130 TextBetween(Message,'& chr(39) & ' ' & chr(39) & '&chr(39),chr(39)&' & chr(39) & ' ' & chr(39) & ') as [QMC Resource],

2016-05-16 10:58:33 0131 if(len(Action)>1,Action,

2016-05-16 10:58:33 0132 if(subfield(Message,' & chr(39) & ' ' & chr(39) & ',1)=' & chr(39) & 'App' & chr(39) & ',' & chr(39) & 'Publish' & chr(39) & ','

2016-05-16 10:58:33 0133 & chr(39) & 'Other' & chr(39) &')) as [QMC Action],

2016-05-16 10:58:33 0134 if(subfield(Message,' & chr(39) & ' ' & chr(39) & ',1) <> '&chr(39)&'Temporary'&chr(39)&'

2016-05-16 10:58:33 0135 and subfield(Message,'&chr(39)&' '&chr(39)&',1) <> ' &chr(39) & 'Seeding'&chr(39)&',1) as qmc_change,

2016-05-16 10:58:33 0136 If(len(ProxySessionId)<=1, Id, ProxySessionId) as _proxySessionPackage,

2016-05-16 10:58:33 0137 '& chr(39) & 'Repository' & chr(39) & ' as Service,

2016-05-16 10:58:33 0138 Level as Severity,

2016-05-16 10:58:33 0139 lower(Hostname) as Hostname

2016-05-16 10:58:33 0140 '

2016-05-16 10:58:33 0143 ENDSUB

2016-05-16 10:58:33 0144

2016-05-16 10:58:33 0606 CALL loadBaseTable ('LogContent', 'lib://ServerLogFolder/governanceLogContent_2.0')

2016-05-16 10:58:33 0607

2016-05-16 10:58:33 0149 Let baseFileSize = FileSize('lib://ServerLogFolder/governanceLogContent_2.0.qvd')

2016-05-16 10:58:33 0151 IF baseFileSize > 0 THEN

2016-05-16 10:58:33 0152

2016-05-16 10:58:33 0169 trace Initial Load

2016-05-16 10:58:33 0169 Initial Load

2016-05-16 10:58:33 0170

2016-05-16 10:58:33 0170 Let firstReload = 1

2016-05-16 10:58:33 0171 LET lastReloadCompare = num('2014-01-01')

2016-05-16 10:58:33 0173 IF nombre = 'LogContent' THEN

2016-05-16 10:58:33 0174

2016-05-16 10:58:33 0174 LogContent:

2016-05-16 10:58:33 0175 NoConcatenate

2016-05-16 10:58:33 0176 Load * Inline [Id, LogEntryPeriodStart, LogTimeStamp,Service,Hostname,Message, Session Duration]

2016-05-16 10:58:33 7 fields found: Id, LogEntryPeriodStart, LogTimeStamp, Service, Hostname, Message, Session Duration,

2016-05-16 10:58:33 0 lines fetched

2016-05-16 10:58:33 0178 ELSE

2016-05-16 10:58:33 0179

2016-05-16 10:58:33 0185 END IF

2016-05-16 10:58:33 0186

2016-05-16 10:58:33 0187 LET NoOfRowsLogContentBASE = NoOfRows('LogContent')

2016-05-16 10:58:33 0189 ENDSUB

2016-05-16 10:58:33 0190

2016-05-16 10:58:33 0607 CALL multiNodeConfig

2016-05-16 10:58:33 0608

2016-05-16 10:58:33 0194 FOR each folder in DirList(archivedLogsFolder & '*')

2016-05-16 10:58:33 0195

2016-05-16 10:58:33 0195 node_list:

2016-05-16 10:58:33 0196 Load

2016-05-16 10:58:33 0197 'lib://ArchivedLogsFolder/win-cs6kr6sd3ts'&'\' as folder,

2016-05-16 10:58:33 0198 mid('lib://ArchivedLogsFolder/win-cs6kr6sd3ts',26) as [Node Name],

2016-05-16 10:58:33 0199 FileTime( 'lib://ArchivedLogsFolder/win-cs6kr6sd3ts' ) as folder_Time

2016-05-16 10:58:33 0200 AutoGenerate 1

2016-05-16 10:58:33 3 fields found: folder, Node Name, folder_Time,

2016-05-16 10:58:33 1 lines fetched

2016-05-16 10:58:33 0202 NEXT folder

2016-05-16 10:58:33 0203

2016-05-16 10:58:33 0204 LET count_of_nodes = NoOfRows('node_list')

2016-05-16 10:58:33 0207 IF count_of_nodes > 1 then

2016-05-16 10:58:33 0208

2016-05-16 10:58:33 0211 LET multiNode = 'Single-Node'

2016-05-16 10:58:33 0212 TRACE Single-Node environment detected

2016-05-16 10:58:33 0212 Single-Node environment detected

2016-05-16 10:58:33 0213

2016-05-16 10:58:33 0213 let count_of_nodes = If(isnull(count_of_nodes),0,1)

2016-05-16 10:58:33 0214 ENDIF

2016-05-16 10:58:33 0215

2016-05-16 10:58:33 0216 EndSub

2016-05-16 10:58:33 0217

2016-05-16 10:58:33 0610 working:

2016-05-16 10:58:33 0611 Load * inline [ProxyPackageId,RequestSequenceId]

2016-05-16 10:58:33 2 fields found: ProxyPackageId, RequestSequenceId,

2016-05-16 10:58:33 0 lines fetched

2016-05-16 10:58:33 0613 CALL logFolderList

2016-05-16 10:58:33 0614

2016-05-16 10:58:33 0221 logFolderList:

2016-05-16 10:58:33 0222 LOAD

2016-05-16 10:58:33 0223 'lib://ServerLogFolder/' as mainLogFolder,

2016-05-16 10:58:33 0224 'txt' as file_extension

2016-05-16 10:58:33 0225 AutoGenerate(1)

2016-05-16 10:58:33 2 fields found: mainLogFolder, file_extension,

2016-05-16 10:58:33 1 lines fetched

2016-05-16 10:58:33 0227 for each fldr in DirList('lib://ArchivedLogsFolder/'&'*')

2016-05-16 10:58:33 0228

2016-05-16 10:58:33 0228 Concatenate (logFolderList)

2016-05-16 10:58:33 0229 Load

2016-05-16 10:58:33 0230 'lib://ArchivedLogsFolder/win-cs6kr6sd3ts/' as mainLogFolder,

2016-05-16 10:58:33 0231 'log' as file_extension

2016-05-16 10:58:33 0232 AutoGenerate(1)

2016-05-16 10:58:33 2 fields found: mainLogFolder, file_extension,

2016-05-16 10:58:33 2 lines fetched

2016-05-16 10:58:33 0234 next fldr

2016-05-16 10:58:33 0235

2016-05-16 10:58:33 0237 ENDSUB

2016-05-16 10:58:33 0238

2016-05-16 10:58:33 0616 for i = 0 to noofrows('logFolderList')-1

2016-05-16 10:58:33 0617

2016-05-16 10:58:33 0619 FOR j = 0 to noofrows('logList')-1

2016-05-16 10:58:33 0620

2016-05-16 10:58:33 0620 CALL loadFiles (i,j)

2016-05-16 10:58:33 0621

2016-05-16 10:58:33 0241 Let carpeta = peek('mainLogFolder',0,'logFolderList')

2016-05-16 10:58:33 0242 Let extension = peek('file_extension',0,'logFolderList')

2016-05-16 10:58:33 0243 Let logService = peek('logService',0,'logList')

2016-05-16 10:58:33 0244 Let logArea = peek('logArea',0,'logList')

2016-05-16 10:58:33 0245 Let logType = peek('logType',0,'logList')

2016-05-16 10:58:33 0246 Let logAddlFields = peek('logAddlFields',0,'logList')

2016-05-16 10:58:33 0247 LET logType = if(logType='Performance','_performance',logType)

2016-05-16 10:58:33 0249 LET logName = 'lib://ServerLogFolder/Engine\Audit\*Activity'

2016-05-16 10:58:33 0252 LET fields2Load = fieldsAuditActivity

2016-05-16 10:58:33 0255 LET logStartTS = 'timestamp(Timestamp(Timestamp#(Replace(Left("' & peek('logStart',0,'logList') & '",15),' & CHR(39)&'T'&CHR(39)& ',' &CHR(39)&' '& CHR(39)& '), '& chr(39)

2016-05-16 10:58:33 0256 & 'YYYYMMDD hhmmss' & chr(39) & ')),' & CHR(39) &'YYYY-MM-DD hh:mm:ss[.fff]'& CHR(39)&')'

2016-05-16 10:58:33 0258 for each textFile in FileList(logName & '*.' & extension)

2016-05-16 10:58:33 0259

2016-05-16 10:58:33 0260 file_List:

2016-05-16 10:58:33 0261 Load

2016-05-16 10:58:33 0262 'lib://ServerLogFolder/Engine\Audit\WIN-CS6KR6SD3TS_AuditActivity_Engine.txt' as txtName,

2016-05-16 10:58:33 0263 FileTime( 'lib://ServerLogFolder/Engine\Audit\WIN-CS6KR6SD3TS_AuditActivity_Engine.txt' ) as fTime

2016-05-16 10:58:33 0264 AutoGenerate 1

2016-05-16 10:58:33 2 fields found: txtName, fTime,

2016-05-16 10:58:33 1 lines fetched

2016-05-16 10:58:33 0266 Let file_time = num(peek('fTime'))

2016-05-16 10:58:33 0269 If 42506.415537521 >= 41640 then

2016-05-16 10:58:33 0270

2016-05-16 10:58:33 0272 CONCATENATE (working)

2016-05-16 10:58:33 0273 Load

2016-05-16 10:58:33 0274 timestamp(Timestamp(Timestamp#(Replace(Left("Timestamp",15),'T',' '), 'YYYYMMDD hhmmss')),'YYYY-MM-DD hh:mm:ss[.fff]') AS LogEntryPeriodStart,

2016-05-16 10:58:33 0275 timestamp(Timestamp(Timestamp#(Replace(Left(Timestamp,15),'T',' '), 'YYYYMMDD hhmmss')),'YYYY-MM-DD hh:mm:ss[.fff]') AS LogTimeStamp,

2016-05-16 10:58:33 0276

2016-05-16 10:58:33 0277 Message,

2016-05-16 10:58:33 0278 ProxySessionId&ProxyPackageId as _proxySessionPackage, UserId,

2016-05-16 10:58:33 0279 ObjectId,ObjectName,

2016-05-16 10:58:33 0280 lower(Hostname) as Hostname,

2016-05-16 10:58:33 0281 Service,

2016-05-16 10:58:33 0282 ProxySessionId,ProxyPackageId,RequestSequenceId,

2016-05-16 10:58:33 0283 Context,Command,Result,Description,

2016-05-16 10:58:33 0284 if(index(Context,'*app/*')>0,ObjectName) as [App Name],

2016-05-16 10:58:33 0285 ProductVersion,

2016-05-16 10:58:33 0286 Id as Id_temp

2016-05-16 10:58:33 0287

2016-05-16 10:58:33 0288 FROM 'lib://ServerLogFolder/Engine\Audit\WIN-CS6KR6SD3TS_AuditActivity_Engine.txt'

2016-05-16 10:58:33 0289 (txt, utf8, embedded labels, delimiter is '\t', msq)

2016-05-16 10:58:33 0290 WHERE isnum(Sequence#)

2016-05-16 10:58:33 Error: Field not found - <ProxySessionId>

2016-05-16 10:58:33 General Script Error

2016-05-16 10:58:33 Execution Failed

2016-05-16 10:58:33 Execution finished.

kevincase · ‎2016-05-16

David,

This log is for the reload of the Operations Monitor application. This job is an automatically triggered task that usually runs every hour by default. It also seems to be failing but one issue at a time.

Since you are not getting any logs when you try to import, you could try to reboot the server. This will reinitialize all the Qlik services that are running on the server.

You really need to restart the services, not the QMC.

Levi_Turner · ‎2016-05-16

I'd bookmark this page: https://help.qlik.com/en-US/sense/2.2/pdf/Troubleshoot%20Qlik%20Sense%20using%20logs.pdf

In general app migration issues are logged in:

C:\ProgramData\Qlik\Sense\Log\AppMigration

C:\ProgramData\Qlik\Sense\Log\Repository\Trace <-- The System log

C:\ProgramData\Qlik\Sense\Log\Engine\Trace <-- The System log

Report Inappropriate Content · ‎2016-05-16

Thank you for the help... I will review the log guide. I will keep you posted.

Report Inappropriate Content · ‎2016-05-16

Thank you for the quick response... I will let you know if I am able to resolve the issue by shutting everything down and restarting services.

dionverbeke · ‎2016-05-16

I remember that sometimes the logs get corrupted.

Delete the logs and try again...

Should not happen in an ideal world...

Dion