You can use a business adapter to schedule an import that unlinks multiple inventories from their assets. In the Computer Object > Asset ID view: Set the Source to SQL Value. Set the Value field to NULL. Set the Update rule to Always update the property.   In the Computer object, enable Update existing object in the database in the Import Rules. Select File > Save to retain the changes. ... View more

When checking for trace rejection messages in a business adapter import, a message like the example below will appear if one of the mandatory fields for an object is not populated in the source data, even if the column isn’t used for matching. Example @param_105dd8c94487454398d3d74652d400c9 is a mandatory property - value was not provided; This message is a SQL parameter. It occurs for properties that are mandatory for the object. For the dynamic SQL to work, the generated parameter name must be unique for the SQL. Identify and populate the mandatory property Look for the object in Using FlexNet Business Adapters: The FlexNet Business Importer Data Model. Determine which properties in the object are mandatory. Check if the properties are empty in the source data for any entries. Populate any mandatory fields. ... View more

If a property value needs to be cleared for multiple items, you can use a business adapter to upload multiple objects with one import rather than clearing each entry out individually. To clear out property values for multiple items using a business adapter: The property you're clearing must have empty values on the source data but still retain the column to be mapped if you're importing with other data. The property that you want to clear out cannot be used for matching. If the property is linked with another object, the ID object used for the linking must have the Always update the property value for the Update rule. The object must allow updating by the import. Example If you want to clear the Cost Center from a purchase, you can use a business adapter to clear these fields. Go to Purchase Order Line > Cost Center ID. Set the Update rule in the Cost Center ID to Always update the property. In the Purchase Order Line object, the Import Rules must have Update existing object in the database selected. ... View more

When importing large numbers in Business Adapter Studio from an Excel spreadsheet, they may show in scientific notation (for example, 1.01578e+010) in the FlexNet Manager Suite UI. This commonly occurs for purchase order numbers or serial numbers that you may not want expressed in scientific notation. Large values become expressed as scientific notation due to the behavior of Microsoft's OLE DB driver, which reads the source data.  Change the cell data type To correct this, you can use a schema.ini file to specify the data type for any cells you don't want to show in scientific notation. 1. Change the cell category in the Excel spreadsheet cell to text. Right-click on the cell(s), choose Format cells, select Text, then select OK.             2. In the data source view, enable the Read "Intermixed" data columns as text option under the Excel File Properties section. 3. Use a schema.ini file to specify the data type when importing. The schema.ini file will be consumed in the process. NOTE: See Microsoft's documentation for help with Schema.ini Files (Text File Driver). ... View more

Description When viewing the All Licenses view at different times, the column order or the grouping filter is not retained. This affects custom fields rather than out-of-box columns. Replication Scenario Create more than one custom field in license property pages. In the All Licenses view, select a custom field to be grouping value. Navigate away from the page and return. Workaround Hotfix attached for FNMS 2020 R1 Please back up the file below before replacing it with the one attached. <Install location>\FlexNet Manager Platform\WebUI\bin\Flexera.Web.Logic.dll   Resolution Fixed in FNMS 2020 R2 for cloud and premise. ... View more

Description The "hosted in" field of Oracle instances is showing "On-premises" instead of following what the host has. This is just a UI display bug and does not impact the license calculation. Replication Scenario Instances are showing the default value for the "hosted in" field, which is "On-premises".  Any instances in the UI should show the same "Hosted in" as the host. There is a bug in the grid query where it is not getting the cloudserviceproviderID of the host computer of the instance, and if cloudserviceproviderID is null, it will default to "On-premises".  Workaround No workaround is available. Resolution The bug is reported under IOJ-2159924. Currently, there is no target date yet. ... View more

Description When attempting to delete a beacon in disabled status in the Beacons view, a red bar error occurs. The beacon remains undeleted.   Workaround Change the beacon status before attempting to delete. Or Run the query below on the compliance database with the name of the beacon that needs to be removed. DELETE FROM Beacon WHERE BeaconName = '<nameofbeacon>'     ... View more

Description If an inventory is updated with a nondefault role, the inventory does not consume any license. This is due to an incorrectly populated flag in the database. This can be confirmed with the query below: select * from ComplianceComputerRole where DefaultValue='<EnterRoleNameHere>' If ManageLicenses does not have value of 1, the device with this role will not consume licenses.   Workaround Run the query below to enable consumption on the the devices with the custom role. update ComplianceComputerRole Set ManageLicenses=1 where DefaultValue='<EnterRoleNameHere>' A reconcile is needed after to calculate consumption.   Resolution The issue will be fixed by Engineering with bug IOJ-2094595. ... View more

Symptoms: When navigating to Inventory Evidence tab of the discovered device record, there is no evidence showing. The source of the inventory was from agent. Diagnosis: There is an incorrect connection string to the Inventory Database. Solution: Confirm that the registry value below is correctly pointed to the Inventory Database on both the web and batch server: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ManageSoft corp\ManageSoft\Reporter\CurrentVersion\InventoryDatabaseConnectionString Confirm that the Server and DatabaseName column from the query result is correct. Please execute on the Compliance Database. SELECT * from ComplianceConnection where SourceType='ManageSoft' ... View more

Symptoms: When importing source data with Microsoft Office format data, the error message below appears: "The MicrosoftAce.OLEDB.12.0 provider is not registered on the local machine" Diagnosis: A prerequisite for the software is missing. Solution: Download and install the 32bit version of Microsoft Access Database Engine 2010 Redistributable. https://www.microsoft.com/en-us/download/details.aspx?id=13255 ... View more

Symptoms: With SCCM import, the reconcile fails with an error similar to the one below: Failed to execute Reader 'GetUniversalApplicationInstalledInstallerEvidence-CreateIndexes' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\sms\InstallerEvidence.xml, at step line 2 Error: Operation failed. The index entry of length 910 bytes for the index 'IX_InstallerEvidence' exceeds the maximum length of 900 bytes. Warning! The maximum key length is 900 bytes. The index 'IX_UniversalInstalledInstallerEvidence' has maximum length of 1056 bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length is 900 bytes. The index 'IX_InstallerEvidence' has maximum length of 1056 bytes. For some combination of large values, the insert/update operation will fail. The statement has been terminated. Diagnosis: This is due to the combined string of the installer evidence, version, and publisher being too long. This usually occurs if the any of the above values are modified or the installation was repackaged. Solution: This issue has bee resolved in FNMS 2019 R2.3. Workaround: The queries below can be used on the SCCM database to identify which entry and machine this evidence is coming from. If possible, please remove the evidence. If it is modified from the default value, there is a high chance this will not map to any existing entry in the library. SELECT DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0), c.name00, arpd.* FROM dbo.v_GS_ADD_REMOVE_PROGRAMS AS arpd LEFT OUTER JOIN Computer_System_data AS c ON c.MachineID = arpd.ResourceID WHERE DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0) > 900 SELECT DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0), c.name00, arpd.* FROM dbo.v_GS_ADD_REMOVE_PROGRAMS_64 AS arpd LEFT OUTER JOIN Computer_System_data AS c ON c.MachineID = arpd.ResourceID WHERE DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0) > 900 ... View more