Known Issue: Oracle GLAS (LMS) audit archive may fail to download or be out of date if inventory import log shows an ArgumentOutOfRangeException error associated with the ArchiveOracleLMSAuditEvidence import step (IOK-707920)

[#1]

Symptoms

The Oracle GLAS (previously LMS) audit evidence archive may not be available for download from the Oracle Instances page in the UI, or the contents of the archive may not reflect the latest inventory that has been gathered.

A key symptom of the cause of this specific issue is that logging from the latest inventory import process will show an error occurring while the ArchiveOracleLMSAuditEvidence import step ran, but the inventory import process continued on after that error.

This issue only occurs if the System Settings > Inventory > Include Oracle Fusion Middleware setting is enabled.

Details

The log from the most recent inventory import process includes error details like the following when this issue occurs:

2021-09-27 02:40:07,097 [INFO ]     ArchiveOracleLMSAuditEvidence
2021-09-27 02:45:57,051 [ERROR]       Exception in Archive:System.AggregateException: One or more errors occurred.
    Pipeline.Name        LMS-Masking

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
    Stage.Name           Stage0_ReadDB

System.AggregateException: One or more errors occurred. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.CollectionBase.System.Collections.IList.get_Item(Int32 index)
   at ManageSoft.Database.API.DatabaseObjectCollection.get_Item(Int32 p_Index)
   at ManageSoft.Compliance.Logic.Core.Impl.OracleLMS.UnpackFMWResultsPipeline.Stage0_ReadDB.DoStage()
   at Spider.Pipelining.PStage`1.Start()
   at System.Threading.Tasks.Task.Execute()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.WaitAll(Task[] tasks, Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.WaitAll(Task[] tasks, Int32 millisecondsTimeout)
   at Spider.Pipelining.Pipeline.Start()
   at ManageSoft.Compliance.Logic.Core.Impl.OracleLMS.UnpackFMWResultsPipeline.UnpackFMWResults(String tempExportFolder, OracleLMSQueryHelper qryHelper, Boolean maskContent, Boolean skipMasking)
   at ManageSoft.Compliance.Logic.Core.Impl.OracleLMS.OracleLMSAuditEvidence.Archive()
---> (Inner Exception #0) System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.CollectionBase.System.Collections.IList.get_Item(Int32 index)
   at ManageSoft.Database.API.DatabaseObjectCollection.get_Item(Int32 p_Index)
   at ManageSoft.Compliance.Logic.Core.Impl.OracleLMS.UnpackFMWResultsPipeline.Stage0_ReadDB.DoStage()
   at Spider.Pipelining.PStage`1.Start()
   at System.Threading.Tasks.Task.Execute()<---

2021-09-27 02:45:57,866 [INFO ]       Successfully processed in 5 minutes, 50 seconds

Despite the details appearing in the logging, this error is not fatal to the import process. The import continues with further processing after the error details are logged.

This issue is likely to only occur intermittently, as it is dependent on precise conditions that are only sometimes satisfied. In particular, the issue only occurs when the number returned by following query is a multiple of 50:

SELECT COUNT(*)
FROM dbo.ImportedComputerScriptResult icsr
	INNER JOIN dbo.ImportedComputer ic ON icsr.ExternalComputerID = ic.ExternalID AND icsr.ComplianceConnectionID = ic.ComplianceConnectionID
	LEFT JOIN dbo.ImportedComputerScriptResult icsr2 ON icsr2.ExternalComputerID = ic.ExternalID AND icsr2.ComplianceConnectionID = ic.ComplianceConnectionID AND icsr2.RecognitionRule = 'OracleCPURule'
	LEFT JOIN dbo.ComplianceComputer cc ON ic.ComplianceComputerID = cc.ComplianceComputerID
WHERE icsr.RecognitionRule = 'OracleFMWRule'
	AND (cc.ComplianceComputerID IS NULL OR cc.ComplianceComputerStatusID = 1)

Affected versions

FlexNet Manager Suite 2021 R1

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2021 R1.4 / Mar 2022 (Cloud), 2022 R1 (On Premises)

Other information

Affected components: Inventory import (read/write/export), SAM for Oracle

Master issue ID: IOK-707920

Also known as: FNML-76150