Title

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)

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

Was this helpful?

Support Hub

Product

FlexNet Manager Suite

Deployment type

On-premises

Visibility

Guest

URL Name

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

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

Products	Region	Phone Numbers
FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield	North America *	+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America)
	Europe *	+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe)
	Japan *	+81 3-4540-5335 (select option 2)
	Australia *	+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics) Compliance Intelligence	Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.

Symptoms

Details

Affected versions

Fix status

Other information

Related Articles

Please wait...

Case id: 00001065