Feb 09, 2023
12:47 PM
1 Kudo
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
Feb 09, 2023
12:45 PM
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
Jan 19, 2023
03:19 PM
3 Kudos
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
Dec 28, 2022
12:06 PM
3 Kudos
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
Jul 01, 2021
03:03 PM
3 Kudos
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
Jun 28, 2021
12:06 PM
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
Dec 23, 2020
02:06 PM
2 Kudos
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
Dec 23, 2020
02:03 PM
2 Kudos
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
Jul 13, 2020
03:26 PM
Hi @captkras ,
Put the files back in C:\ProgramData\Flexera Software\Incoming\ActiveDirectory. Trigger the "Import Active Directory" Windows Scheduler task. Look in the last entries in the log below should tell you what is the issue preventing the import.
C:\ProgramData\Flexera Software\Compliance\Logging\WebResolvers\Dispatcher.log
... View more
Jul 09, 2020
09:09 AM
Hi @captkras,
Can you run the query below on the compliance database and see if there are any users there? If there are, check if the ComplianceUserID column is populated or if the isBlacklisted column has a value of 1.
select * from ImportedUser
If there are no users, can you check if the directory below on the application and beacon server has any files? C:\ProgramData\Flexera Software\Incoming\ActiveDirectory
... View more
Jul 07, 2020
11:11 AM
Hi Captkras,
The status might not be showing correctly when another process is running. There is a delay between the task being executed and the file being transferred to the application server.
If the users are still not showing up, can you check the log below and see if there are any errors? C:\ProgramData\Flexera Software\Compliance\Logging\ActiveDirectoryImport\ADImport.log
The publishers not showing up might be due to ARL not being downloaded yet if the environment is new.
... View more
Jun 25, 2020
11:53 AM
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
Jun 19, 2020
03:23 PM
2 Kudos
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
Labels:
Jun 19, 2020
03:03 PM
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
Labels:
Mar 31, 2020
02:27 PM
1 Kudo
Hi,
Unfortunately, there is no best practice guide specifically for SCCM connections. Some of the swid files are used for recognition in the library, so if that can be collected, it will help. Asset Intelligence installed with Logon Auditing enabled is required to track users who are logging on to computers. This will be needed for user licenses.
The KB below will help if usage is not being imported. It has some common issues listed as well. https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Troubleshooting-SCCM-last-used-date-reporting/ta-p/2252
SCCM data imported should merge with existing records if there are any. Some of the matching criteria are SamAccountNames, domains, and device serial numbers.
You can find some known issue in the link below: https://docs.flexera.com/FlexNetManagerSuite2019R2/EN/FlexNet%20Manager%20Suite%20Known%20Issues%20-%20On%20Premises%20Edition.pdf
... View more
Latest posts by NameTooShort
Subject | Views | Posted |
---|---|---|
332 | Feb 09, 2023 12:47 PM | |
131 | Feb 09, 2023 12:45 PM | |
434 | Jan 19, 2023 03:19 PM | |
409 | Dec 28, 2022 12:06 PM | |
485 | Jul 01, 2021 03:03 PM | |
445 | Jun 28, 2021 12:06 PM | |
616 | Dec 23, 2020 02:06 PM | |
586 | Dec 23, 2020 02:03 PM | |
1509 | Jul 13, 2020 03:26 PM | |
1766 | Jul 09, 2020 09:09 AM |
Activity Feed
- Posted Unlink assets from inventory using a business adapter on FlexNet Manager Knowledge Base. Feb 09, 2023 12:47 PM
- Posted Identifier displayed instead of property name for business adapter trace message on FlexNet Manager Knowledge Base. Feb 09, 2023 12:45 PM
- Posted Clear property values using a business adapter on FlexNet Manager Knowledge Base. Jan 19, 2023 03:19 PM
- Posted Business adapter imports large numbers as scientific notation on FlexNet Manager Knowledge Base. Dec 28, 2022 12:06 PM
- Posted All Licenses view not retaining column order or grouping of custom fields on FlexNet Manager Knowledge Base. Jul 01, 2021 03:03 PM
- Posted The "hosted in" field of Oracle instances is showing "On-premises" instead of following what the host has on FlexNet Manager Knowledge Base. Jun 28, 2021 12:06 PM
- Posted Unable to delete disabled beacon on FlexNet Manager Knowledge Base. Dec 23, 2020 02:06 PM
- Posted No license consumption on devices with custom roles on FlexNet Manager Knowledge Base. Dec 23, 2020 02:03 PM
- Posted Re: Initial Reconcile for AD User Sync shows "Never Commenced" on FlexNet Manager Forum. Jul 13, 2020 03:26 PM
- Posted Re: Initial Reconcile for AD User Sync shows "Never Commenced" on FlexNet Manager Forum. Jul 09, 2020 09:09 AM
- Posted Re: Initial Reconcile for AD User Sync shows "Never Commenced" on FlexNet Manager Forum. Jul 07, 2020 11:11 AM
- Posted Inventory Evidence Blank for Agent Inventoried Devices on FlexNet Manager Knowledge Base. Jun 25, 2020 11:53 AM
- Posted Business Adapter Studio shows "The MicrosoftAce.OLEDB.12.0 provider is not registered on the local machine" on FlexNet Manager Knowledge Base. Jun 19, 2020 03:23 PM
- Posted Reconcile failure on step 'GetUniversalApplicationInstalledInstallerEvidence-CreateIndexes' due to maximum length exceeded on FlexNet Manager Knowledge Base. Jun 19, 2020 03:03 PM
- Got a Kudo for Re: SCCM integration best practices. Apr 23, 2020 11:38 AM
- Posted Re: SCCM integration best practices on FlexNet Manager Forum. Mar 31, 2020 02:27 PM
- Posted Re: IBM Bundling with Device of license's supporting programs only and different license type on FlexNet Manager Forum. Feb 04, 2020 11:28 AM
- Posted Assign Users to Workflow using the AdminStudio Process Assistant on AdminStudio Knowledge Base. Feb 05, 2019 07:35 PM
- Posted Installshield Error 7354 When Building MSI with MoveFile Table Entry on InstallShield Knowledge Base. Nov 15, 2018 05:00 PM
- Posted Error 7354 When Building MSI on InstallShield Knowledge Base. Nov 14, 2018 10:05 PM