Summary ComplianceUpload fails to check revocation for the certificate Symptoms ComplianceUpload fails in ComplianceUpload fails to check revocation for the certificate in FlexNet Manager Suite Cloud with the following error messages in ComplianceUpload.log. ---- System.Net Verbose: 0 : [4476] HttpWebRequest#16246551::Abort() System.Net.Sockets Verbose: 0 : [4476] Socket#52307948::Dispose() System.Net Verbose: 0 : [4476] Exiting HttpWebRequest#16246551::Abort() System.Net Information: 0 : [0924] SecureChannel#66629781 - Remote certificate has errors: System.Net Information: 0 : [0924] SecureChannel#66629781 - The revocation function was unable to check revocation for the certificate. System.Net Information: 0 : [0924] SecureChannel#66629781 - The revocation function was unable to check revocation because the revocation server was offline. System.Net Information: 0 : [0924] SecureChannel#66629781 - Remote certificate was verified as invalid by the user. System.Net Error: 0 : [0924] Exception in HttpWebRequest#16246551:: - The request was aborted: The request was canceled.. System.Net Verbose: 0 : [0924] HttpWebRequest#16246551::EndGetRequestStream() System.Net Error: 0 : [0924] Exception in HttpWebRequest#16246551::EndGetRequestStream - The request was aborted: The request was canceled.. System.Net.Http Error: 0 : [0924] Exception in BeaconHttpClientHandler#17625630::SendAsync - The request was aborted: The request was canceled.. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) System.Net.Http Error: 0 : [0924] HttpClient#61705107::SendAsync() - Request for HttpRequestMessage#46544415 was canceled. ----   Cause This issue occurs if Beacon is not able to download the certificate revocation list (CRL) for FlexNet Manager Suite Cloud Production/UAT certificate. Generally, this issue occurs if Beacon uses a proxy server and it blocks to download CRL. Resolution Please ensure the beacon is able to download the certificate revocation list (CRL). Note that the location of the CRL is "http://tj.symcb.com/tj.crl". Workaround Please create a String Value registry entry "CheckCertificateRevocation" under "HKLM\SOFTWARE\Wow6432Node\ManageSoft Corp\ManageSoft\Common" and set the value to "False". This registry setting enables to bypass a CRL checking. ... View more

Summary Is the Inventory Agent for IBM System i released? Synopsis Is the Inventory Agent for IBM System i released? Discussion IBM System i is not a supported platform of FlexNet Manager Suite. Therefore the Inventory Agent for IBM System i has not been released. ... View more

Summary License Manager Status / Vendor Daemon Status is "unknown" or "down" Question License server is running but License Manager Status / Vendor Daemon Status is unknown or down status. Environment FlexNet Manager for Engineering Applications 15.x FlexNet Agent 5.x   Answer There are some reasons of this problem. Agent is down Start FlexNet Agent and make sure it is "up" status on FlexNet Manager for Engineering Applications Web console. Agent cannot access the configured lmgrd Make sure "lmgrd Executable Location" is configured a correct lmgrd executable path. FlexNet Agent 5.3 or before does not work if "lmgrd Executable Location" value is a symbolic link path. Update the value to the physical path. Agent cannot access the configured lmutil Make sure "lmutil Executable Location" is configured a correct lmutil executable path. FlexNet Agent 5.3 or before does not work if "lmutil Executable Location" value is a symbolic link path. Update the value to the physical path. Agent cannot access the configured license file Make sure "License Files and Directories" is configured a correct license file path. FlexNet Agent 5.3 or before does not work if "License Files and Directories" value is a symbolic link path. Update the value to the physical path. The configured lmutil version is older than vendor daemon Compare the base FlexNet Publisher version of both lmutil and vendor daemon. UNIX % lmutil lmver <path>/lmutil % lmutil lmver <path>/<vendor_daemon> Windows > lmutil.exe lmver <path>\lmutil.exe > lmutil.exe lmver <path>\<vendor_daemon> The configured lmutil is corrupted Make sure lmstat returns a license server status. lmutil lmstat -c <license_file> The vendor daemon path in the license file is invalid Make sure the configured vendor daemon path in the license file is valid. For FlexNet Agent 5.3.1 or later, it is mandatory to specify the daemon executable name in the path ( IOJ-1728848) . ... View more

Summary The status of vender daemon shows "Unknown" Symptoms The status of vender daemon shows "Unknown". However, the VENDOR line of the vender daemon had been removed in the renewed current license file. Cause The existing vendor entry is not removed automatically even if the VENDOR line of the vender daemon was removed in the renewed license file. Therefore the status of the removed vendor daemon is not updated and it shows "Unknown" in FlexNet Manager for Engineering Applications Web console. Resolution To remove Vendor daemon entry, it requires remove the license server entry and reconfigure it on FlexNet Manager for Engineering Applications web console. ... View more

Summary "flexnet loaddb" command fails with "java.sql.SQLException: I/O exception: Connection reset". Symptoms Environment: Application: FlexNet Manager for Engineering Applications Operating System: Linux Database: Oracle (Remote) "flexnet loaddb" command fails with "java.sql.SQLException: Io exception: Connection reset" like the following. ERROR: Could not connect to database: Io exception: Connection reset Attempting to connect to config service database 14:47:57,319 DEBUG Could not access config service data: java.sql.SQLException: Io exception: Connection reset Cause The net.ipv4.tcp_keepalive_time OS level KeepAlive parameter is configured in /etc/sysctl.conf but ACK response for KeepAlive from the Oracle database server was not received, therefore OS closed the connection. Resolution Please work with your network administrator to resolve to receive the KeepAlive packets. Workaround Please remove net.ipv4.tcp_keepalive_time = xxx in /etc/sysctl.conf. ... View more

Summary Failed to execute Writer 'RemoteApplicationsByFileEvidenceTempTables' due to inserting duplicate key in object 'dbo.#RemoteServerFileEvidence' Symptoms Reconcile fails after XenApp Agent integration on Writer 'RemoteApplicationsByFileEvidenceTempTables' due to inserting duplicate key in object 'dbo.#RemoteServerFileEvidence'. 2016-07-20 00:16:18,953 [INFO ] Successfully processed in 3 seconds 2016-07-20 00:16:18,953 [INFO ] RemoteApplicationsByFileEvidenceTempTables 2016-07-20 00:16:19,500 [INFO ] Failed to execute Writer 'RemoteApplicationsByFileEvidenceTempTables' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\InstalledSoftware.xml Error: Violation of UNIQUE KEY constraint 'UQ__#RemoteS__E75FB5011B4D2163'. Cannot insert duplicate key in object 'dbo.#RemoteServerFileEvidence'. The duplicate key value is (101, <NULL>, 95, 3). Found 0 remote file usage records Found 0 remote file user access records 2016-07-20 00:16:19,500 [INFO ] All retries have been attempted for Writer 'RemoteApplicationsByFileEvidenceTempTables' 2016-07-20 00:16:19,500 [ERROR] System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ__#RemoteS__E75FB5011B4D2163'. Cannot insert duplicate key in object 'dbo.#RemoteServerFileEvidence'. The duplicate key value is (101, <NULL>, 95, 3). Found 0 remote file usage records Found 0 remote file user access records at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ManageSoft.Compliance.Importer.Logic.XML.Writer.Execute(IExecutionContext context) at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteWriters(ComplianceReader p_ComplianceReader, IExecutionContext context, String singleConnectionIdentifier) ClientConnectionId:574b4e16-5f4a-4063-835b-96e6fa892b53 Error Number:2627,State:2,Class:14 Cause This issue has been identified as Bug #FNMS-34747. This will arise when a customer has the following conditions met Using XenApp 7.0+ Still publishing file based applications instead of App-V packages Publishing the same file based application across multiple desktop groups Resolution Please add VDIGroupUUID column to the unique clustered index of #RemoteServerFileEvidence table, it is defined in "C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\InstalledSoftware.xml" line 567. <Writer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="RemoteApplicationsByFileEvidenceTempTables" Order="155" Retries="1"> <![CDATA[ IF OBJECT_ID('tempdb..#RemoteServerFileEvidence') IS NOT NULL DROP TABLE #RemoteServerFileEvidence CREATE TABLE #RemoteServerFileEvidence ( ComplianceConnectionID INT, ExternalServerID BIGINT, VDIGroupUUID UNIQUEIDENTIFIER, ExternalFileID BIGINT, AccessModeID INT, UNIQUE CLUSTERED(ComplianceConnectionID, ExternalServerID, VDIGroupUUID , ExternalFileID, AccessModeID) ) ... View more

Summary Location names being truncated at 64 characters if data is imported via one-off upload Symptoms Help page in FlexNet Manager Suite Help > System Menu > Data Inputs > Business Data Tab > Enterprise Group Upload describes template of import data as the below. Column Sample Values Notes Name Guangzhou The name of the location, cost center, or corporate unit. Maximum 256 alphanumeric characters . Spaces and simple punctuation are also supported, but the foward slash character 9/) must not be used in a group name. After import, visible in the Name column of the appropriate list, once the tree of corporate structure has been sufficiently expanded. However, imported data being truncated at 64 characters. It is possible to create location names longer than 64 characters directly in the web UI. Cause This issue has been identified a bug #FNMS-48611. Workaround Login to FNMSCompliance database via Microsoft SQL Server Management Studio. Backup dbo.GroupExImport and dbo.GroupExImport_MT stored procedures, right click on the stored procedure in the Object Explorer, and then select Script Stored Procedure as > CREATE to > File.... Alter stored procedures, right click on the stored procedure in the Object Explorer, and then select Script Stored Procedure as > ALTER to > New Query Editor Window, then change the following line. Before: @GroupName nvarchar(64), After: @GroupName nvarchar(256), Execute both ALTER PROCEDURE scripts ... View more

Summary OLE DB provider for Oracle is installed but "OLE DB provider for Oracle is not installed" message is logged in the action status. Symptoms Oracle database inventory requires 32 bit OLE DB Provider for Oracle on the beacon server. OLE DB Provider for Oracle is installed but the Oracle database inventory in the action status of the Discovery Device Properties page shows like the following messages in the Details of Last Failure. Error 0x0800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.connection". Error 0x0800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.connection". OLE DB provider for Oracle is not installed Cause OLE DB Provider for Oracle was installed after Inventory Beacon installation and Flexera Inventory Beacon Engine service has not restarted after OLE DB Provider for Oracle installation. Resolution Stop Flexera Inventory Beacon Engine service. Restart Flexera Inventory Beacon Engine service. Don't use the restart button or menu, it needs to stop the running Flexera Inventory Beacon Engine service and then restart it. Additional Information If the same error occurs after restarting Flexera Inventory Beacon Engine service, there is a possibility that Oracle installer failed to register OLE DB Provider for Oracle. Run like the following commands and then restart Flexera Inventory Beacon Engine service. Open a Command prompt in administrator mode cd %ORACLE_HOME%\bin Example: cd \oracle\product\11.2.0\client_1\BIN Register the dll of OLE DB Provider for Oracle Example: Oracle 11gR2 32 bit environment c:\Windows\system32\regsvr32.exe OraOLEDB11.dll 64 bit environment c:\Windows\SysWOW64\regsvr32.exe OraOLEDB11.dll Related KB Articles 000017831 ... View more

Summary This article discusses how to reset the Content Store database used by Flexera Analytics (Report Designer ), which is based on IBM Cognos technology. Discussion The following steps can recreate or reset an initial Content Store database. Invoke IBM Cognos Configuration by running the "<Report Designer installed directory>\c10\bin\fnhccfg.bat" Stop the IBM Cognos service Run SQL Server Management Studio Drop the ContentStore database Recreate the ContentStore database Grant the service account used by IBM Cognos db_owner rights to the ContentStore database Back in the IBM Cognos Configuration UI, start the IBM Cognos service ... View more