Summary This article will explain why in the Application Recognition Library, SQL Server components such as SSRS, SSIS , SSAS are classified as 'Commercial' instead of 'Component'. Synopsis In the application recognition library, there are a list of SQL Components software such as: SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services SQL Server Master Data Services SQL Server Database Engine Services They are currently be assigned with classification as 'Commercial'. It will be questioned why they are not being assigned as 'Component' as classification naturally. Discussion The reason is based on Microsoft SQL Server licensing agreement: SQL Server software includes a range of licensed server components, including the SQL Server Database Engine (DB), Master Data Services (MDS), Analysis Services (AS), Integration Services (IS), Reporting Services (RS), and Data Quality Services (DQS). In addition, a number of management components are provided, such as client applications and tools used for creating or working with analytical data The software components of SQL Server 2012 cannot be separated for use in more than one OSE. If these components are running on a server other than the main database server, then an additional license is required for each additional OSE in which they are installed. For example, if the SQL Server DB is deployed in one OSE and SQL Server RS is deployed in another, both OSEs must be fully licensed for SQL Server 2012 accordingly. The attachment contains the Microsoft SQL Server licensing term with specification of licensing requirement for using above components. In summary, In ARL library we classified those components are 'Commercial'. This classification is an useful reminder for Enterprise SAM administrator to pay attention to make sure all those licenseable components have SQL license coverage. "Component" could be easily neglected. ... View more

Summary This article will describe a potential inconsistency may be seen when customer is viewing the inventory on field "Last Inventory Date" between the grid row value compared with the opening property dialog value where the Last Inventory Date view will be empty. Synopsis This article will describe a potential inconsistency may be seen when customer is viewing the inventory on field "Last Inventory Date" between the grid row value compared with the opening property dialog value where the Last Inventory Date view will be empty. The cause is due to the 'InventoryDate' field is NULL. The property dialog page will show 'empty when this field value is NULL, but 'All Inventory' page, the row grid view will using another SQL View '' ComputerBasicDisplayInfo" -- the details of this view statement can be found in the 'Additional Information' session. So when InventoryDate is Null, the view use ' ISNULL(cci.InventoryDate, GETDATE()) AS InventoryDate, ' Therefore such missing 'Inventory Date' device, they will also showing a current SQL Server date as 'Inventory Date' from grid view. Discussion Such missing 'Inventory Date' device will confuse end user by comparing the inventory date (customer report etc). However the fundermental issue we need determine is why the Inventory is created but missing Inventory date. So the current design of the view used by grid should only affect a very small portion of 'problematic Device', if the number is large we need check further on the source import process to find out why Inventory Date is Null. Workaround Make sure those device has inventory tool running to get the inventory information and returned to FlexNet Manager Platform, so eventually inventorydate field from ComplianceComputer table will be reset from Null. Additional Information CREATE VIEW dbo.ComputerBasicDisplayInfo AS SELECT cci.ComplianceComputerID, cci.ComputerName, cci.DomainName, cci.HostComputerName, cci.HostComplianceComputerID AS HostId, hst.AssetID AS HostAssetId, cci.AssetID, cci.OperatingSystem, cci.ServicePack, cci.NumberOfProcessors, cci.ProcessorType, cci.MaxClockSpeed, ROUND(CAST(cci.TotalMemory AS FLOAT)/(1073741824),2) AS RAM, -- convert into GB ChassisType, cci.NumberOfHardDrives, ROUND(CAST(cci.TotalDiskSpace AS FLOAT )/(1073741824),2) AS TotalDiskSpace, -- convert into GB cci.NumberOfNetworkCards, cci.NumberOfDisplayAdapters, cci.IPAddress, cci.MACAddress, cci.Manufacturer, cci.ModelNo, cci.SerialNo, cat.[Path] AS Category, ISNULL(cci.InventoryDate, GETDATE()) AS InventoryDate, cci.InventoryAgent, ISNULL(au.UserName, au.SAMAccountName) AS AssignedUser, ISNULL(cu.UserName, cu.SAMAccountName) AS CalculatedUser, cci.CreationDate, acs.StatusDefaultValue AS ComplianceStatus, cci.ComplianceComputerInventorySourceTypeID, cci.VirtualMachineID, ComputerType, ComputerInventorySource, cci.ComplianceComputerTypeID, VMType, cci.VMName, cci.NumberOfCores, cci.NumberOfSockets, cci.PartialNumberOfProcessors, cci.NumberOfLogicalProcessors, cci.HostIdentifyingNumber, vm.ServiceProvider, vm.VMPoolID AS Pool, cci.ComplianceComputerStatusID AS StatusID, ccsi.DefaultValue AS Status, cci.LocationID, loc.[Path] AS Location, cci.BusinessUnitID AS CorporateUnitID, dep.[Path] AS CorporateUnit, cci.CostCenterID, cctr.[Path] AS CostCenter, ccri.DefaultValue AS [Role], ISNULL(llu.UserName, llu.SAMAccountName) AS LastLoggedOnUser, cci.CalculatedUserID, cci.AssignedUserID, ast.ShortDescription AS AssetName, rec_ast.ShortDescription AS RecommendedAssetLink, rec_ast.AssetID AS RecommendedAssetID, ccci.ConnectionName AS InventoryConnectionName, CASE WHEN ISNULL(cci.AssetID,'') != '' THEN ( SELECT ( SELECT cci.AssetID AS ID, ast.ShortDescription AS [Value] FOR XML PATH('Item'), TYPE ) FOR XML PATH(''), ROOT('Items') ) END AS LinkedAssetDetails, CASE WHEN ( cci.ComplianceComputerTypeID = 3 AND cts.SettingValue = 1 ) OR (ISNULL(rec_ast.AssetID,'') = '') THEN NULL ELSE ( SELECT ( SELECT rec_ast.AssetID AS ID, rec_ast.ShortDescription AS [Value] FOR XML PATH('Item'), TYPE ) FOR XML PATH(''), ROOT('Items') ) END AS RecommendedAssetDetails, ni.NotificationCount, ni.Notification, ast.AssetStatusID, asts.StatusDefaultValue AS AssetStatus, CASE WHEN cts.SettingValue=1 AND (cci.AssetID) IS NULL AND hst.AssetID IS NOT NULL AND cci.ComplianceComputerTypeID = 3 THEN 1 ELSE 0 END AS IsVirtualMachineLinkedViaHost, -- The virtual machine is linked to an asset because the host is. DATEDIFF(DAY,ISNULL(cci.InventoryDate, GETDATE()),GETDATE()) as MissingComputersThreshold, cts.SettingValue AS VMsFollowHostToRegistered, -- The virtual machines status will be Registered if the host is linked to an asset, and this value is 1 CASE WHEN cci.NumberOfCoresDefault IS NOT NULL OR cci.NumberOfSocketsDefault IS NOT NULL OR cci.NumberOfProcessorsDefault IS NOT NULL OR cci.PartialNumberOfProcessorsDefault IS NOT NULL OR cci.MaxClockSpeedDefault IS NOT NULL OR cci.NumberOfLogicalProcessorsDefault IS NOT NULL OR cci.ModelNoDefault IS NOT NULL OR cci.ProcessorTypeDefault IS NOT NULL THEN 1 ELSE 0 END AS Overridden, vm.AffinityEnabled, vm.VMEnabledStateID, vm.FriendlyName , vm.CPUAffinity, vm.CoreAffinity FROM dbo.ComplianceComputerInfo cci LEFT OUTER JOIN ComplianceComputerStatusI18N ccsi ON ccsi.ComplianceComputerStatusID = cci.ComplianceComputerStatusID LEFT OUTER JOIN dbo.GroupEx_T loc ON loc.GroupExID = cci.LocationID LEFT OUTER JOIN dbo.GroupEx_T cctr ON cctr.GroupExID = cci.CostCenterID LEFT OUTER JOIN dbo.GroupEx_T dep ON dep.GroupExID = cci.BusinessUnitID LEFT OUTER JOIN dbo.Category AS cat ON cat.GroupExID = cci.CategoryID LEFT OUTER JOIN dbo.VirtualMachine vm ON vm.ComplianceComputerID = cci.ComplianceComputerID LEFT OUTER JOIN dbo.ComplianceUser cu ON cu.ComplianceUserID = cci.CalculatedUserID LEFT OUTER JOIN dbo.ComplianceUser au ON au.ComplianceUserID = cci.AssignedUserID LEFT OUTER JOIN dbo.AssetComplianceStatusI18N acs ON acs.AssetComplianceStatusID = ISNULL(cci.AssetComplianceStatusID, 1) -- New by default LEFT OUTER JOIN dbo.ComplianceComputerRoleI18N ccri ON ccri.ComplianceComputerRoleID = cci.ComplianceComputerRoleID LEFT OUTER JOIN dbo.ComplianceUser llu ON llu.ComplianceUserID = cci.ComplianceUserID LEFT OUTER JOIN dbo.Asset ast ON ast.AssetID = cci.AssetID LEFT OUTER JOIN AssetStatusI18N asts ON asts.AssetStatusID = ast.AssetStatusID LEFT OUTER JOIN dbo.ComplianceTenantSetting AS cts ON cts.SettingNameID = 40 -- VMsFollowHostToRegistered setting LEFT OUTER JOIN dbo.SerialNumberBlackList snbl ON snbl.SerialNo = cci.SerialNo OUTER APPLY ( SELECT a.* FROM ( SELECT CASE WHEN cci.SerialNo IS NULL OR cci.SerialNo = '' OR snbl.SerialNumberBlackListID IS NOT NULL OR cci.AssetID IS NOT NULL OR (cts.SettingValue = 1 AND cci.ComplianceComputerTypeID = 3) THEN NULL ELSE ( SELECT AssetID FROM dbo.Asset_LinkedToDummy() ald WHERE ald.SerialNumber = cci.SerialNo ) END AS AssetID ) ald JOIN dbo.Asset a ON a.AssetID = ald.AssetID ) rec_ast LEFT OUTER JOIN dbo.ComplianceComputerConnectionInfo ccci ON ccci.ComplianceComputerID = cci.ComplianceComputerID LEFT OUTER JOIN NotificationInfo AS ni ON ni.TargetID = cci.ComplianceComputerID AND ni.TargetTypeID = 14 -- Compliance computer -- Self join to retrive Host computer AssetId LEFT OUTER JOIN ComplianceComputer AS hst ON hst.ComplianceComputerID = cci.HostComplianceComputerID -- Exclude computers with awaiting inventory status, not using "ComplianceComputerNotDummy" view for performance reason WHERE cci.ComplianceComputerStatusID != 4 AND cci.ComplianceComputerTypeID != 6 -- VDI Templates ... View more

Summary This knowledge base article will describe an UI alert "There is a gap in maintenance coverage for this license" and how user can manage to fix this issue. Synopsis This knowledge base article will describe an UI alert "There is a gap in maintenance coverage for this license" and how user can manage to fix this issue. From FlexNet Manager Suite version 2015 R2, there is a new license alert will be shown as below: Typical locations: License Properties, and listings of licenses. Discussion Comments: There is a period between the "Expire date" of one purchase of maintenance and the "Effective date" of the next one for which some of the license entitlements are missing maintenance coverage. Remedy: Check the Purchases tab of the license properties. A similar alert appears on the purchase which ends the gap (let's call it "purchase B"). Check its Effective date; and for the purchase A immediately before this one (sorted in order of purchase date), check the Expiry date. if there are any days between, that cuase teh alert. Also check the maintenance quantity on purchase. A against the entitlements on the license. Are they all covered ? You may either: -- Find and insert any missing purchase records for additional maintenance -- Correct any errors in the Effective date and Expiry date, or purchase quantities, in the various purchases' properties -- With publisher's consent, set the Allow maintenance gap check box. ... View more

Summary This knowledge base article will describe a product behavior that a process task may appear as "in progress" with an abnormal period of waiting time. In fact it is caused by an incoming product migration process. Synopsis This knowledge base article will describe a product behavior for FNMS On Demand customer that a process task may appear as "in progress" status with an abnormal period of waiting time. This can be caused by a very close incoming product migration process. In general, On Demand customer will receive an product migration notification email as long as a product alert when they log in the FNMS WEB UI as shown below. However On Demand customer may also see certain task they triggered appearing as 'In Progress" for an extra length of waiting time compared with the time of running the same process in other days. This usually happens when a cloud product migration process is approaching very close. Discussion Flexera server team will pause the Batch Processor server 2-3 hours prior to the customer notified migration time frame. This is order to prepare for a health migration process instead of too many accumulated tasks under the batch processor queue. Therefore Flexera support advise customer should try the same process once the FNMS is migrated to the newer version instead of repeated trying the same process 2-3 hours prior to the product migration occurs. ... View more

Summary This knowledge base article will describe the information why SKU library version 377 start supporting multi-product licenses to model "bundle with a bundle" scenarios. Synopsis We are pleased to announce an update to the Bundle automation capabilities of FlexNet Manager Suite to support multi-product licenses. Multi-product licenses will now be able to automatically model the ?bundle within a bundle? scenario. No product upgrade is necessary. All multi-product license capable versions of FlexNet Manager Suite (version 2016 R1 and later) will be able to take advantage of this enhancement immediately after update to PURL version #377. Multi-product licenses in FlexNet Manager Suite are currently represented as a single layer of primary and supplementary products. At least one primary product must be installed to consume an entitlement and any number of supplementary products may be present on the same device. Sometimes bundles can be members of other bundles, creating layers of nested bundles. This enhancement collapses supporting applications from the various layers into a single list of primary and supplementary products, where they will be represented as a single set of primary and supplementary products. For example, consider the below example of IBM WebSphere Application Server v9 multi-product license: IBM WebSphere Application Server V9 ? IBM DB2 Enterprise Server Edition Version 9.5 o IBM Tivoli System Automation for Multiplatform Version 2.2.0.3 o IBM Tivoli Enterprise Monitoring Agent o IBM Tivoli Monitoring for Databases: DB2 Agent o IBM Data Server Client Version 9.5 o IBM Data Server Runtime Client Version 9.5 ? IBM Tivoli Directory Server V6.3 o IBM Tivoli Directory Integrator 7.1 IBM MQEveryplace 2.0.2.13 IBM Tivoli Directory Server 6.2 IBM Solid DB 6.5 IBM Lotus Expeditor 6.2.1 ? IBM Tivoli Access Manager for e-business 6.1 o IBM Tivoli Directory Server 6.3 o IBM Tivoli Directory Integrator 7.1 o IBM Tivoli Common Reporting 1.2 o IBM WebSphere Extreme Scale 7.0 ? Mozilla Firefox for AIX ? WebSphere Customization Toolbox Currently, only the following supporting programs will appear on a license: IBM WebSphere Application Server v9 ? IBM DB2 Enterprise Server Edition Version 9.5 ? IBM Tivoli Directory Server V6.3 ? IBM Tivoli Access Manager for e-business 6.1 ? Mozilla Firefox for AIX ? WebSphere Customization Toolbox After this update, the unique applications from the different nested levels of supporting programs will also be present: IBM WebSphere Application Server v9 ? IBM DB2 Enterprise Server Edition Version 9.5 ? IBM Tivoli System Automation for Multiplatform Version 2.2.0.3 ? IBM Tivoli Enterprise Monitoring Agent ? IBM Tivoli Monitoring for Databases: DB2 Agent ? IBM Data Server Client Version 9.5 ? IBM Tivoli Directory Server V6.3 ? IBM Tivoli Directory Integrator 7.1 ? IBM MQEveryplace 2.0.2.13 ? IBM Tivoli Directory Server 6.2 ? IBM Solid DB 6.5 ? IBM Lotus Expeditor 6.2.1 ? IBM Tivoli Access Manager for e-business 6.1 ? IBM Tivoli Directory Server 6.3 ? IBM Tivoli Directory Integrator 7.1 ? IBM Tivoli Common Reporting 1.2 ? IBM WebSphere Extreme Scale 7.0 Additional Information You can inspect the changed data in the SKU Library with the SKU Library Update Report. If you do not already have a copy of this report installed, you can obtain the latest version of the report (and installation instructions) from Flexera Software knowledge base article M 100955 available from the Flexera Software Knowledge Center at http://flexerasoftware.force.com/SupportKBList . ... View more

Summary This knowledge base article will describe a product defect that FlexNet inventory agent may incorrectly count Oracle Universal Installer (OUI) packages which are located in a backup directory. The article contains the details of the cause and workaround information. Symptoms We have detections of Oracle DB versions that we no longer use. Why is this? We are seeing Oracle DB components as in use when there is no Oracle DB on this server any more. Why are they in use?   Cause Oracle Universal Installer saves a backup of its inventory package before any changes like an uninstall, and our Agent is reading these backed-up OUI packages causing to report uninstalled Applications when they are no longer installed. Steps to Reproduce: Install a Oracle software with Oracle Universal Installer. Uninstall the Oracle software using the Oracle Universal Installer. You will find a backup folder under the Inventory directory, which is being collected by the Agent. The backup path should be easy to identify. You can open the agent tracker.log (by default located in C:\Windows\Temp\ManageSoft on Windows devices and /var/opt/managesoft/logs on Unix-like devices) and search for backup or oneoffs to identify the detected XML file. Examples for default installation: C:\Program Files (x86)\Oracle\Inventory\backup\2016-06-23_09-34-34AM\ContentsXML\inventory.xml C:\Program Files (x86)\Oracle\Inventory\backup\2016-06-23_09-34-34AM\ContentsXML\comps.xml Example for custom install location: C:\Oracle\product\11.2.0\OraHome112\inventory\backup\2016-06-23_12-06-41PM\ContentsXML\inventory.xml C:\Oracle\product\11.2.0\OraHome112\inventory\backup\2016-06-23_12-06-41PM\ContentsXML\comps.xml   Resolution It is reported as a product defect referenced FNMS-35281. It affects FlexNet Manager Suite agent from version 2015-2019 R1. This defect has been fixed in FNMS agent 2019 R2 (14.0) and XML files found in backup folders will be ignored.   Workaround This can be worked-around as follows: Open OUI and ensure all the components which are not needed are correctly marked as uninstalled. Open the tracker.log for the agent, and search for backup and oneoffs which will display a file path for an XML file located in a backup or oneoffs directory. Open this up and ensure the components do not appear as an XML element. Save the file and perform an inventory and reconcile. Alternatively, the backup or oneoffs directories can be excluded so that the agent knows not to collect inventory from these folders as follows: On Windows devices, open the following registry key [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ManageSoft Corp\ManageSoft\Tracker\CurrentVersion] and add the below keys as type string. On Unix-like devices, open the agent config.ini (or ndtrack.ini for the light agent) and add under the ini group [ManageSoft\Tracker\CurrentVersion] following the same format as the file. Name: ExcludeDirectory Value: */backup;*/oneoffs   Name: ExcludeEmbedFileContentDirectory Value: */backup;*/oneoffs Note: This would exclude parsing all file content from backup folders, not just OUI backups.   Additional Information https://docs.oracle.com/cd/E11882_01/em.112/e12255/b_oui_appendix.htm#OUICG37 Snippet from tracker.log to help identify where the Agent has found this false-positive xml file: [7/16/2016 8:06:44 AM (G, 0)] {4780} The file 'C:\Program Files (x86)\Oracle\Inventory\backup\2016-06-23_09-34-34AM\ContentsXML\comps.xml' has been detected as a possible package registry [7/16/2016 8:06:44 AM (G, 0)] {4780} The file 'C:\Program Files (x86)\Oracle\Inventory\backup\2016-06-23_09-34-34AM\ContentsXML\inventory.xml' has been detected as a possible package registry Snippet from trace: 627.9708, pid 7720 (Inventory/Packaging/OracleUniversalInstaller): Attempting to parse OUI inventory.xml file: 'C:\Program Files (x86)\Oracle\Inventory\backup\2016-06-23_09-34-34AM\ContentsXML\inventory.xml' 627.9717, pid 7720 (Inventory/Packaging/OracleUniversalInstaller): Not found OUI comps.xml file: 'C:\Oracle\11.2.0\product\11.2.0\client_1\inventory\ContentsXML\comps.xml' 627.9724, pid 7720 (Inventory/Packaging/OracleUniversalInstaller): Parsing OUI comps.xml file: 'C:\Program Files (x86)\Oracle\Inventory\ContentsXML\comps.xml' 627.9731, pid 7720 (Inventory/Packaging/OracleUniversalInstaller): Parsing OUI comps.xml file: 'C:\Program Files (x86)\Oracle\Inventory\backup\2016-06-23_09-34-34AM\ContentsXML\comps.xml' 627.9749, pid 7720 (Inventory/Packaging/OracleUniversalInstaller): Parsing OUI comps.xml file: 'C:\Oracle\product\11.2.0\OraHome112\inventory\backup\2016-06-23_12-06-41PM\ContentsXML\comps.xml' 627.9769, pid 7720 (Inventory/Packaging/OracleUniversalInstaller): Find OUI edition for comps.xml file: 'C:\Oracle\product\11.2.0\OraHome112\inventory\backup\2016-06-23_12-06-41PM\ContentsXML\comps.xml'   ... View more

Summary OnDemand Cloud Solution (v10.0.5 Aug 2014 or earlier version), License entitlement counts (License quantity) will be incorrectly increased by the number of PO quantity when a new 'Software Maintenance' Purchase Order was added via 'Process' Button under 'Unprocessed Purchase' page Symptoms OnDemand Cloud Solution (v10.0.5 Aug 2014 or earlier version), License entitlement counts (License quantity) will be incorrectly increased by the number of PO quantity when a new 'Software Maintenance' Purchase Order was added via 'Process' Button under 'Unprocessed Purchase' page. Software Maintenance shouldn't increase the entitlement number, however this wrong behaviour will update the existing license number + PO quantity of new Maintenance purchase order. (It's a severe error on licensing) eg: A License with counts = 10 , linked by a new Software Maintenance PO with quantity 20 through 'link license wizard'. after the process, the total license counts will be 30. Cause Defect in 'Process' button in Unprocessed Purchases page. Workaround As a workaround, the customer should be able to use the license property window to manually link licenses and maintenance purchases. Please see an attached document for manual workaround demo. ... View more

Summary This article will help to solve the 403 Unauthorized Login Issue when customer is logging from the website on Demand Solution Synopsis This article will help to solve the 403 Unauthorized Login Issue when customer is logging from the website on Demand Solution. User will hit this 403 Unauthorized issue mostly when his previous role is 'disabled' now in specific tenant while he is trying to access this tenant again. The web page looks like below screenshot Discussion Once customer hit the authentication issue, currently there is no easy or obvious way to get away from the 403 page and select another tenant. If the browser is closed and restarted, when you browse to https://www.flexnetmanager.com/Suite/ you are immediately redirected to the page to select a tenant. Even if a tenant that the user is configured in a role for is selected at this point, you are still taken back to the ?403: Unauthorized? page. This is because we user cookie to remember previous tenant login information. when the Tenant Role is disabled, User login will be lead to URL https://www.flexnetmanager.com/Suite/Login/Failure/NoAccess In that page, there is neither way back to main login page, nor clear the cookie. There are 3 workarounds available to quick come over this problem 1. Manually browse to the page at https://agw.flexnetoperations.com/agw/login and login again. After doing that and selecting a tenant with full access to, everything is OK. 2. Manually browse to the page at https://www.flexnetmanager.com/Suite/Login/Failure/NoRole There is a button ' Return to FlexNet Manager Suite' , click it will do the clear cookie and back to main login page 3. Clear Internet browser cookie manually then go to product page ... View more

Summary This Knowledge Base article describes a defect in Installer Evidence type locale string value with old product name 'BDNA' instead all other locales are called 'Data Platform' FlexNet Manager Suite 2018 R1 release. Symptoms In FlexNet Manager Suite 2018 R1 release, the naming conversion, eu-US locale for 'BDNA Normalize integration' features are called in the new term 'Data Platform'. However one place under Installer Evidence Type list , this value was incorrectly called 'BDNA' which is the old naming convention. Step to confirm whether your 2018 R1 system has been affected: 1. Under "License Compliance" -> "Evidence" -> "All Evidence" page 2. Make sure the grid view including the 'Type' column 3. Expand the list and check whether you have 'BDNA' or 'Data Platform' (as shown below) Note: if you see 'BDNA' which means your system is affected by this defect, please use the method described in 'Resolution' field. Cause In FNMS 2018 R1 , the default schema of InstallerEvidenceType should be "InstallerEvidenceType.BDNA en-US Data Platform" However, this value will be updated to the old naming value 'BDNA' by ARL released before 30th of March 2018. As the content value shipped via ARL still contains the old name which will overwrite the product default name. Resolution User can use the method to confirm followed by the screenshot in 'Symptom' session Or run below sql script in FNMSCompliance Database SELECT * FROM ResourceStringCultureType WHERE ResourceString = 'InstallerEvidenceType.BDNA' If the query result of 'en-US' is BDNA , then please run below update statement to apply the fix. UPDATE ResourceStringCultureType SET ResourceValue = 'Data Platform' WHERE ResourceString = 'InstallerEvidenceType.BDNA' ***Note*** please make sure the product system to import content library ARL released after 30th of March 2018. Otherwise, the value will be overwritten back to 'BDNA' ... View more

Summary This article will describe an error you will get in the FnmpXenAppAgent.exe with the message "An unhandled error occured while attempting to process the application 'SOME APP'. An item with the same key has already been added". The affected version is FNM On Premise 2014 R3 and FNM On Demand (before April 2015) Symptoms If you get an error in the FnmpXenAppAgent.exe with the message "An unhandled error occured while attempting to process the application 'SOME APP'. An item with the same key has already been added" The affected version is FNM On Premise 2014 R3 and FNM On Demand (before April 2015) Cause This is due to the application 'SOME APP' being published directly on a XenApp server, and a worker group that also contains the same XenApp server. May affect XenAppAgent 6 / XenAppAgent 65 / XenAppAgent75 Resolution You can either manually remove the XenApp server from the list of servers publishing the application and simply keep the XenApp server in the worker group, or use the patched FnmpXenAppAgent.exe attached to this KB article. Additional Information Sample error log: 2015-02-03 2:08:56.596 : Error : An unhandled error occured while attempting to process the application 'SOME APP'. 2015-02-03 2:08:56.596 : Error : System.ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at Flexera.Compliance.Importer.XenAppAgent.DataProviders.XaDataProviderBase.GetAclApplicationServers(String p_AppBrowserName) at Flexera.Compliance.Importer.XenAppAgent.DataProviders.XaDataProviderBase.GetAclApplications() 2015-02-03 2:08:56.596 : Error : An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at Flexera.Compliance.Importer.XenAppAgent.DataProviders.XaDataProviderBase.GetAclApplicationServers(String p_AppBrowserName) at Flexera.Compliance.Importer.XenAppAgent.DataProviders.XaDataProviderBase.GetAclApplications() at Flexera.Compliance.Importer.XenAppAgent.AclImporter.Import(String p_DatabaseConnectionString, Int32 p_DatabaseTimeout, String p_OutputFile) at Flexera.Compliance.Importer.XenAppAgent.Program.Main(String[] args) ... View more

Summary This Knowledge Base article will explain why the existing catalog items' deployment is not showing after the System Center Configuration Manager is migrated from SCCM 2007/2012 to the current System Center Configuration Manager. Synopsis Existing catalog items,deployments, and requests are no longer visible under the Deployment tab --> SCCM2012 Tab After an In-Place Upgrade to System Center Configuration Manager (Current Branch). Discussion If you are performing an in-place upgrade of your deployment technology from System Center 2012 Configuration Manager to System Center Configuration Manager (Current Branch), you will also need to run an SQL script to upgrade your App Portal database. This script will upgrade the existing catalog items, deployments, and requests in your App Portal database. To upgrade your App Portal database after an in-place upgrade to System Center Configuration Manager (Current Branch): 1. Perform the in-place upgrade of your deployment technology from System Center 2012 Configuration Manager to System Center Configuration Manager (Current Branch). 2. If you have not yet installed App Portal 2015 R2, run the App Portal 2015 R2 installer. 3. On your App Portal server, run the App Portal 2015 R2 SP4 Upgrader: AppPortalUpgrade_2015_R2_ServicePack_4.exe. 4. In App Portal, open the SCCM 2012 tab of the Site Management > Settings > Deployment view, remove the site server and database settings, and click Save. 5. Open the ConfigMgr tab and enter the same site server and database settings that you just deleted. 6. Click Test to test the connection, and then click Save. 7. On the App Portal database server, run the App Portal 2015 R2 SP4 Database Upgrade SQL Script onthe App Portal database Additional Information Please run the SQL statement in the attached App Portal 2015 R2 SP4 Release Note -- page 15. Please back up your current product database before run the script in case for roll back purpose. ... View more

Summary This article will provide with some help to configure cascading drop down list questions in App Portal Synopsis The scenario case is to set up: Question26 where the dropdown list is populated from a web service call WS1 Question27 where the dropdown list is populated from a web service call WS2 that takes the answer to Question26 as an input parameter The difficulty is by default the parameter is always passed through with the literal value ?##QuestionID:26##? rather than the answer to the question. How to let the system to pass the answer to Question26 through to the web service call to populate the Question27 dropdown list. Discussion To achieve above configuration, You would like to need to specify the ?Reload answers for questions? setting under web site->catalog behavior. The value should be ?26~27?. This indicates that the when the source question of 26 changes, then the target question 27 should reload.. This should cause the variable to be resolved. As screenshot shown below. ... View more

Summary This article will contains a SQL query to help to query the current response to a question in App Portal from version 8.0 and later. Synopsis In Release 7.5 and earlier, App Portal captured responses in the WD_Response table. In 8.0, a new table was intruduced named WD_ResponseQuestionAuditTrail. This table is where the responses are now stored. The SQL select statement in Discussion can be used to get most recent response to a question. Discussion SELECT TOP ( 1 ) WITH TIES r . RequestID_FK , r . Response AS SoftwareName FROM dbo . WD_ResponseQuestionAuditTrail r INNER JOIN dbo . WD_Question q ON q . QuestionID = r . QuestionID_FK AND q . QuestionTitle = 'Software Name' ORDER BY ROW_NUMBER () OVER ( PARTITION BY r . RequestID_FK ORDER BY r . QuestionVersion DESC ) ... View more

Summary This article will describe a product defect while App Portal product search the application title from FlexNet Manager Platform Application Recognition Library when application title contains blank version. Symptoms This article will describe a product defect while App Portal product search the application title from FlexNet Manager Platform Application Recognition Library when application title contains blank version. Affected version from App Portal v8.5 till the most recent 2015 R2. For instance, there is a blank version of application called 'IBM Network Installation Management' in the Application Recognition Library However when you do search in App Portal, there are only same product name with version value title will be returned, but not the blank version title Cause There is a problematic SQL code while App Portal calling FNMP ARL via -- Pre-calculate software titles that match filter. Resolution There is no permanent fix available yet at present when the KB is created on 9th Nov 2015. Workaround Please try to avoid choosing the ARL Application Title without version information at this stage. ... View more

Summary This knowledge base article will describe an issue created in App Portal 2016 service pack 3. ServiceNow workflow "Validate Request" will fail due to API call return 500 error. Symptoms This knowledge base article will describe an issue created in App Portal 2016 service pack 3. ServiceNow workflow "Validate Request" will fail due to API call return 500 error. You can verify the failure error either by IIS log file or login App Portal server directly and open an internet browser. Try to call the following API to confirm whether you have expected result return or return 500. API call: http://localhost/ESD/api/users?filter=email%3D%3D%22UserEmailAddress%22&machineName=UserAssociatedDeviceName (Please replace UserEmailAddress , UserAssociatedDeviceName to the real value in your case) Current behavior: Browser will return incorrect format of file to ask for saving , but eventually end with 500 error ( can be observed by iis log file) Cause The problem was at the code implementation. A constructor was not handling the method call gracefully, hence API call has broken. we have come to know that, constructor calling a public method can be an antipattern. Resolution The same fix would be available on SP4, the scheduled release for the same is end of August. Workaround 1. Please download attachement and unzip it. 2. Backup your existing folder from App Portal Server before replacement 3. Stop the ESD services and replace the dll in the patch attament. --- Please be aware when do the (copy and paste dll file), simply choose the replace the existing file option, Do Not rename old dll and paste the new file...it will break the COM dependency. 4. Restart ESD service account 5. Reset IIS 6. Try to call the API call again and we expect browser will ask you to save the file by json format, and eventually the API result will be shown on the browser. ... View more