article License or Operations Monitor apps fail to reload with error: Error: Field 'Sequence#' not found in Official Support Articles

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

Andre_Sostizzo — Fri, 13 Jun 2025 13:22:38 GMT

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.

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.

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))
Go to the Hub to the My Work section and open the application
Click on Open to go to the Data Load Editor
Go to the Run Logic section
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.

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:

Save the file
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
Ensure that it has reloaded successfully
Delete the original License or Operations Monitor app
Rename the new copy, i.e. License Monitor (New) will be renamed to License Monitor
Publish the new app to the Monitoring Apps stream
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.

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

KTyler — Fri, 13 Jun 2025 12:53:49 GMT

There's an error on the statement:

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

The question mark shouldn't be there.

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

KTyler — Fri, 13 Jun 2025 13:03:13 GMT

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

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

Sonja_Bauernfeind — Fri, 13 Jun 2025 13:25:43 GMT

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

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

KTyler — Fri, 13 Jun 2025 15:03:32 GMT

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,