Re: Import Inventory files going in to BadLogs

msutharh · ‎Aug 13, 2020

Some machines are not find in WebUI. When import manually then it gives error and NDI files goes into BadLogs\invalidformat.

We have on-prem 2019 R2. Below is the manually import result.

PS G:\ProgramFiles\Flexera Software\FlexNet Manager Platform\Importers\bin> .\mogsimport.exe -e -t inventories
Starting Importer...
No directory specified - using G:\ProgramFiles\Flexera Software\Incoming\Inventories
Processing 3 files
Processing file G:\ProgramFiles\Flexera Software\Incoming\Inventories\system on inmumflxtstapp.ndi:

EXCEPTION:
--------------------
System.NullReferenceException: Object reference not set to an instance of an object.
at ManageSoft.Directory.Impl.DirectoryBinder.BindToComputerAndUser(IManageSoftDatabaseLayer databaseLayer, String com
puterName, String computerDomain, String computerFlatDomain, String computerUID, DirectoryEntry computerObject, String u
serName, String userDomain, String userUID, Boolean useUniqueNames, Int32& computerID, Int32& computerOUID, Int32& userI
D, Int32& userOUID, String agentID, String agentVersion)
at ManageSoft.Inventory.Importer.DatabaseImport.Begin(InventoryImportSession session)
at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleElement()
at ManageSoft.Inventory.Importer.Implementation.BaseElementNodeProcessor.Process(InventoryImportSession session)
at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, S
tring sourceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stat
s, IDispatcherPreferences preferences)
----
Type: 'System.NullReferenceException'
Message: 'Object reference not set to an instance of an object.'
Source: 'ManageSoft.Directory.Logic'
--StackTrace:--
at ManageSoft.Directory.Impl.DirectoryBinder.BindToComputerAndUser(IManageSoftDatabaseLayer databaseLayer, String com
puterName, String computerDomain, String computerFlatDomain, String computerUID, DirectoryEntry computerObject, String u
serName, String userDomain, String userUID, Boolean useUniqueNames, Int32& computerID, Int32& computerOUID, Int32& userI
D, Int32& userOUID, String agentID, String agentVersion)
at ManageSoft.Inventory.Importer.DatabaseImport.Begin(InventoryImportSession session)
at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleElement()
at ManageSoft.Inventory.Importer.Implementation.BaseElementNodeProcessor.Process(InventoryImportSession session)
at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, S
tring sourceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stat
s, IDispatcherPreferences preferences)
--------------------

File G:\ProgramFiles\Flexera Software\Incoming\Inventories\system on inmumflxtstapp.ndi: File content was in invalid for
mat
File saved to G:\ProgramFiles\Flexera Software\Incoming\Inventories\BadLogs\invalidformat
Processing file G:\ProgramFiles\Flexera Software\Incoming\Inventories\system on inmumflxtstbcn.ndi:

EXCEPTION:
--------------------
System.NullReferenceException: Object reference not set to an instance of an object.
at ManageSoft.Directory.Impl.DirectoryBinder.BindToComputerAndUser(IManageSoftDatabaseLayer databaseLayer, String com
puterName, String computerDomain, String computerFlatDomain, String computerUID, DirectoryEntry computerObject, String u
serName, String userDomain, String userUID, Boolean useUniqueNames, Int32& computerID, Int32& computerOUID, Int32& userI
D, Int32& userOUID, String agentID, String agentVersion)
at ManageSoft.Inventory.Importer.DatabaseImport.Begin(InventoryImportSession session)
at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleElement()
at ManageSoft.Inventory.Importer.Implementation.BaseElementNodeProcessor.Process(InventoryImportSession session)
at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, S
tring sourceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stat
s, IDispatcherPreferences preferences)
----
Type: 'System.NullReferenceException'
Message: 'Object reference not set to an instance of an object.'
Source: 'ManageSoft.Directory.Logic'
--StackTrace:--
at ManageSoft.Directory.Impl.DirectoryBinder.BindToComputerAndUser(IManageSoftDatabaseLayer databaseLayer, String com
puterName, String computerDomain, String computerFlatDomain, String computerUID, DirectoryEntry computerObject, String u
serName, String userDomain, String userUID, Boolean useUniqueNames, Int32& computerID, Int32& computerOUID, Int32& userI
D, Int32& userOUID, String agentID, String agentVersion)
at ManageSoft.Inventory.Importer.DatabaseImport.Begin(InventoryImportSession session)
at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleElement()
at ManageSoft.Inventory.Importer.Implementation.BaseElementNodeProcessor.Process(InventoryImportSession session)
at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, S
tring sourceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stat
s, IDispatcherPreferences preferences)
--------------------

File G:\ProgramFiles\Flexera Software\Incoming\Inventories\system on inmumflxtstbcn.ndi: File content was in invalid for
mat
File saved to G:\ProgramFiles\Flexera Software\Incoming\Inventories\BadLogs\invalidformat
Processing file G:\ProgramFiles\Flexera Software\Incoming\Inventories\system on inmumflxtstbcn at 20200813T055802 (Full)
.ndi.gz:

EXCEPTION:
--------------------
System.NullReferenceException: Object reference not set to an instance of an object.
at ManageSoft.Directory.Impl.DirectoryBinder.BindToComputerAndUser(IManageSoftDatabaseLayer databaseLayer, String com
puterName, String computerDomain, String computerFlatDomain, String computerUID, DirectoryEntry computerObject, String u
serName, String userDomain, String userUID, Boolean useUniqueNames, Int32& computerID, Int32& computerOUID, Int32& userI
D, Int32& userOUID, String agentID, String agentVersion)
at ManageSoft.Inventory.Importer.DatabaseImport.Begin(InventoryImportSession session)
at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleElement()
at ManageSoft.Inventory.Importer.Implementation.BaseElementNodeProcessor.Process(InventoryImportSession session)
at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, S
tring sourceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stat
s, IDispatcherPreferences preferences)
----
Type: 'System.NullReferenceException'
Message: 'Object reference not set to an instance of an object.'
Source: 'ManageSoft.Directory.Logic'
--StackTrace:--
at ManageSoft.Directory.Impl.DirectoryBinder.BindToComputerAndUser(IManageSoftDatabaseLayer databaseLayer, String com
puterName, String computerDomain, String computerFlatDomain, String computerUID, DirectoryEntry computerObject, String u
serName, String userDomain, String userUID, Boolean useUniqueNames, Int32& computerID, Int32& computerOUID, Int32& userI
D, Int32& userOUID, String agentID, String agentVersion)
at ManageSoft.Inventory.Importer.DatabaseImport.Begin(InventoryImportSession session)
at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleElement()
at ManageSoft.Inventory.Importer.Implementation.BaseElementNodeProcessor.Process(InventoryImportSession session)
at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, S
tring sourceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stat
s, IDispatcherPreferences preferences)
--------------------

File G:\ProgramFiles\Flexera Software\Incoming\Inventories\system on inmumflxtstbcn at 20200813T055802 (Full).ndi.gz: File content was in invalid format
File saved to G:\ProgramFiles\Flexera Software\Incoming\Inventories\BadLogs\invalidformat
All tasks are complete
Finished importing 3 files in 3.3s
PS G:\ProgramFiles\Flexera Software\FlexNet Manager Platform\Importers\bin>

those machines are found ADComputer & Computer table in FNMSInventory DB but not imported in ImportedComputer and ComplianceComputer in FNMSCompliance DB.

Upload log showing successfully uploaded and No issue with FNMS license.

erwinlindemann · ‎Aug 13, 2020

Hi msutharh,

If the Inventories for these devices can be found in the [FNMSInventory].[Computer] table, you obviously have been able to import inventory data for the devices previously.

Are there any NDI file that can be imported using the mgsImport tool succesfully?
Which version (and command line options) of the Flexera Agent did you use for creating the latest NDI files where the import fails?
Would it be possible to share one of these NDI files for testing, please?

msutharh · ‎Aug 17, 2020

@erwinlindemann

Yes, both devices are found in Computer table in FNMSInventory DB.

Are there any NDI file that can be imported using the mgsImport tool successfully?
-> No, because this is Test instance and only 2 machines are reported and both fail to import.

Which version (and command line options) of the Flexera Agent did you use for creating the latest NDI files where the import fails?
-> FNMS agent version is 14.00.52 and both machines OS is Windows sever 2012 R2

Would it be possible to share one of these NDI files for testing, please?
-> Unable to share due to some compliance reason but I have tried to import same NDI files into Production instance and it imported successfully.

kclausen · ‎Aug 18, 2020

@msutharh - Are you trying to import into a multi-tenant instance of FNMS On-Premises? If yes, then the name of the file needs to have the TenantID of one of the tenants in the database.

msutharh · ‎Aug 19, 2020

No, we have single tenant only of on-prem and as mentioned previously it's a Test environment. But when I copy working inventory file from Production environment and paste it in Inventory folder in Test environment then it also showing failed while import.