20 Replies Latest reply: Sep 28, 2016 4:02 AM by clark m RSS

    Log Files - Qlik Sense Hub

    David Weiser

      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

        • Re: Log Files - Qlik Sense Hub
          Kevin Case

          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

            • Re: Log Files - Qlik Sense Hub
              David Weiser

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

                • Re: Log Files - Qlik Sense Hub
                  Kevin Case

                  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.

                    • Re: Log Files - Qlik Sense Hub
                      David Weiser

                      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.

                • Re: Log Files - Qlik Sense Hub
                  Kevin Case

                  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.

                   

                  • Re: Log Files - Qlik Sense Hub
                    Levi Turner

                    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

                      • Re: Log Files - Qlik Sense Hub
                        David Weiser

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

                          • Re: Log Files - Qlik Sense Hub
                            David Weiser

                            I shut down all the servers and tried to import .qvf file and got the following error. I am in programdata/qlik/sense/log/repository/trace/ <name>_system_repository:

                             

                             

                            Failed to request service alive response from 'https://win-cs6kr6sd3ts:5151/qss/' (Unable to connect to the remote server)                                      9c133784-ffb7-43df-abc7-cd7eed3c3c4d

                             

                            57       20160517T095715.865-0700       INFO   WIN-CS6KR6SD3TS            System.Repository.Repository.Core.Synchronization.TransactionLog.SnapshotCreator            31       5c09664b-80d1-4ccb-8a0f-ece771d6e6ad          NT AUTHORITY\SYSTEM     Snapshot creator: Idle                                              5c09664b-80d1-4ccb-8a0f-ece771d6e6ad

                             

                            58       20160517T112415.068-0700       WARN WIN-CS6KR6SD3TS            System.Repository.Repository.WebSocketServer.RepositoryWebSocketSession            58       852326b3-25ae-45ef-a9a8-d825e7f27dd9            NT AUTHORITY\SYSTEM     Exception received when sending over websocket          GeneralCommunicationException with communication error WebSocketSendOnClosed and http error code 500                                   852326b3-25ae-45ef-a9a8-d825e7f27dd9

                             

                             

                            Any help you could provide would be greatly appreciated...

                             

                            Thanks

                          • Re: Log Files - Qlik Sense Hub
                            clark m

                            HI Levi,

                             

                            Please help me on  System Engine log file..In that LEVEL is showing Error .. What is the reason for that ?/

                             

                            Please help me Levi

                             

                            Thanks In advance