License or Operations Monitor apps fail to reload with error: Error: Field 'Sequence#' not found

[Andre_Sostizzo]

The reload task fails with a message like this in the document log:

Failed reload log shows errors when loading Archived Logs like:      FROM 'lib://ArchivedLogsFolder/servername\Engine\Audit\XXXX.log'
      (txt, utf8, embedded labels, delimiter is '\t', msq)
      WHERE isnum(Sequence#)
           AND CounterName <> 'Layout' and CounterName <> 'Properties'
Error: Field not found - <CounterName>
General Script Error
Execution Failed
Execution finished.

or

           2017-11-10 10:16:48 0454       WHERE isnum(Sequence#)
            2017-11-10 10:16:48      Error: Field 'Sequence#' not found
            2017-11-10 10:16:48      Execution Failed
            2017-11-10 10:16:48      Execution finished.

or
 

Sequence# field not found in 'lib://SHARE/Repository/Trace/SERVERNAME_Synchronization_Repository.txt' 

The steps below apply where it cannot find any field. The field that cannot be found includes but is not limited to CounterName, ProxySessionID.

Environment:

• Qlik Sense Enterprise on Windows and Qlik Sense Monitoring apps

Cause:

QLIK-35804: Occasionally when Qlik Sense services stop, they do not fully write to the logs in the expected format. 

Resolution:

Services need a restart

Restart the Qlik Sense services 

Last stop of services did not write logs in the expected format

Modify the License and Operations Monitor apps such that it will continue parsing logs even if it fails to fully parse a particular log.

1. When logged in to the server, import a new copy of the problematic app from C:\ProgramData\Qlik\Sense\Repository\DefaultApps (You will need to give it a new name, i.e. License Monitor (New))
2. Go to the Hub to the My Work section and open the application
3. Click on Open to go to the Data Load Editor
4. Go to the Run Logic section
5. It will initially look like below. For reference, the screenshots are from the Operations Monitor but the principle applies to the License Monitor as well even though the load script will look slightly different.
   
6. Wrap the section labelled working: with the following code:

   //begin ignoring errors parsing logs
   set errormode = 0;

   and 

   //end ignoring errors parsing logs
   set errormode = 1;

   This will look something like this:
   
   
7. Save the file
8. Reload from the Hub or QMC
   1. From the Hub: Click on the Load Data icon in the upper right hand corner
   2. From the QMC: Apps > Select the new License or Operations Monitor App > More Actions > Reload Now
9. Ensure that it has reloaded successfully
10. Delete the original License or Operations Monitor app
11. Rename the new copy, i.e. License Monitor (New) will be renamed to License Monitor
12. Publish the new app to the Monitoring Apps stream
13. Create a reload task to reload the new app. The default reload schedule for the default apps is to reload every hour, but you can set to this to be as frequent as your needs require.

[KTyler]

There's an error on the statement:

"//end ignoring errors parsing logs
set errormode = 1;?"

The question mark shouldn't be there. 

[KTyler]

But why is it not finding the Sequence # field? This works around the issue, it doesn't solve the problem, or even diagnose it.

[Sonja_Bauernfeind]

Hello @KTyler 

Thank you for alerting me to the typo. I've correct it.

As for your question:

From my understanding, this specifically addresses the issue QLIK-35804, whereas the Qlik Sense services do not fully write to the logs in the expected format at stop. 

If you receive the same error though maybe not specifically tied to this issue, I would recommend posting about it in detail (version, error behaviour, error message, etc) in the Qlik Sense Management and Governance forum, where your knowledgeable Qlik peers and our active Support agents can assist you.

All the best,
Sonja

[KTyler]

I believe it's the same error, but as time passes, it doesn't quite look the same:

The following error occurred:
Field 'Sequence#' not found
The error occurred here:
CONCATENATE (working)
Load
Round(TimeStamp(ConvertToLocalTime(Round("Timestamp",1/86400))),1/1440) &'|'
& Round(ConvertToLocalTime(Timestamp),1/1440) AS _date_time_link,
TimeStamp(ConvertToLocalTime(Round("Timestamp",1/86400))) AS LogEntryPeriodStart,
timestamp(ConvertToLocalTime(Round(Timestamp,1/86400))) AS LogTimeStamp,
Message,
Severity,If(ProxyPackageId=0 AND ProxySessionId=0, Id, ProxySessionId&ProxyPackageId) as _proxySessionPackage,UserDirectory & chr(92) & UserId as UserId,
ObjectId,ObjectName,
Lower(If(Left(Message, 12)='Sending task', Subfield(Subfield(Message, ' ', -4), chr(46),1), Hostname)) as Hostname,
Service,
ProxySessionId,ProxyPackageId,RequestSequenceId,
Context,Command,Result,Description,
if(ObjectName ='Not available',null(),
IF(Service='Scheduler',subfield(ObjectName,'|',2),
IF(Service='Printing' and Index(Command,'Export'),subfield(ObjectName,'|',-1),
IF(right(Command,3)='app' OR Context like '*/app/*',ObjectName,
IF(lower(Command)='get layout',Subfield(ObjectName,chr(124),1),Null())
)
)
)
) AS [App Name],
ProductVersion,
Id as Id_temp
FROM 'lib://ArchivedLogsFolder/qsense2.int.excelsior.edu/Repository/System/QSENSE2_Service_Repository_2025-06-10T14.48.22Z.log'
(txt, utf8, embedded labels, delimiter is '\t', msq)
WHERE isnum(Sequence#)

What I need to know is, can I remove the referenced log? Is that all that's happening here is that a log file is corrupted in some way?

Thanks,

KT