Summary ARL import failed: Could not establish trust relationship for the SSL/TLS secure channel Symptoms ARL import failed. mgsImportRecognition.exe fails with the following error.   C:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\DotNet\bin>mgsImportRecognition.exe Downloading and importing software recognition data from 'http://www.managesoft.com/support/Compliance/RecognitionAfter82.cab'... Unexpected error occurred: ManageSoft.Compliance.Logic.Core.API.ImportRecognitionDownloadException: Failed to download the file 'http://www.managesoft.com/support/Compliance/RecognitionAfter82.cab' to 'C:\Users\flex-admin\AppData\Local\Temp\RecognitionAfter82.cab'. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Autentication.AuthenticationException: The remote certificate is invalid according to the validation procedure. at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception) at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result) at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size) at System.Net.ConnectStream.WriteHeaders(Boolean async) --- End of inner exception stack trace --- at System.Net.WebClient.DownloadFile(Uri address, String fileName) at ManageSoft.Compliance.Logic.Core.Impl.RecognitionImporter.Download(String p_ImportUrl, String p_DownloadPath) --- End of inner exception stack trace --- at ManageSoft.Compliance.Logic.Core.Impl.RecognitionImporter.Download(String p ImportUrl String p_DownloadPath) at ManageSoft.Compliance.Logic.Core.Impl.RecognitionImporter.Import(EARLImportMode p_ARLImportMode, String p_DownloadLocationOverride, String p_LocalFilePathOverrideARL, String p_GroupDatabaseName) at ManageSoft.Compliance.Console.RecognitionImportTool.ImportRecognition() Failed to download the file 'http://www.managesoft.com/support/Compliance/RecognitionAfter82.cab' to 'C:\Users\flex-admin\AppData\Local\Temp\RecognitionAfter82.cab'. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ARL import has failed. Please check the ARL log file for the detailed error message. ARL/SKU import has failed. Please check the ARL/SKU log files for the detailed error message.   Cause A certificate chain could not be built to a trusted root authority. The root or/and the intermediate certificates are not stored in the Cert Store of the computer.  ARL download requires Thawte Primary Root CA - G3 and Thawte SHA256 SSL CA. Resolution These certificates are available in the following Thawte's web pages. Please download the missing certificate(s), and import it/them to the Cert Store. Thawte Primary Root CA - G3: https://www.thawte.com/roots/ Thawte SHA256 SSL CA: https://knowledge.digicert.com/solution/SO26817.html ... View more

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 Beacon Policy Status shows "Awaiting update" Symptoms Beacon Policy Status shows "Awaiting update". Relaunching the inventory beacon application to force get a new policy does not resolve the issue. Resolution Verify that the Scheduled Tasks used by the beacon to upload inventory and beacon status files are both scheduled and running successfully. You can find these tasks in the Windows Task Scheduler. The scheduled task that handles uploading status files is "Upload FlexNet Beacon status." While the task that handles inventory uploads is "Upload Flexera logs and inventories." It may take a few minutes after enabling these tasks for the FNMS UI to show any changes to the Beacon Policy status.    Incrementing the version number of a beacon policy file and relaunching the inventory beacon via the following steps can also resolve the issue: Login to FlexNet Manager Suite Web UI. Go to Discovery & Inventory > Settings. Update any setting on the Inventory Settings page, and then click Save. It does not matter what setting is changed; this change is being made to force a policy revision to occur Revert the updated setting in step 3, and then Save again. Login to the Inventory Beacon server. Relaunch the Inventory Beacon.   If you have recently changed the service account password, then update the password for your service account by following the steps in the knowledge base article below:    How to Change Your Domain Service Account Password for FlexNet Manager Suite? https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/How-to-Change-Your-Domain-Service-Account-Password-for-FlexNet/ta-p/5525 ... View more

Summary An SCCM inventory connection schedule was completed but the Status of "Gathering inventory data" and "Uploading to Application Server" steps in the System Task shows "Skipped". The import.log of the SCCM inventory connection suggests it completed without any issues. Symptoms An SCCM inventory connection schedule was completed but the Status of "Gathering inventory data" and "Uploading to Application Server" steps in the System Task shows "Skipped". The import.log of the SCCM inventory connection suggests it completed without any issues. Cause The Upload Flexera logs and inventories and the Upload third party inveontry data windows tasks were Disabled in the inventory beacon server. Resolution Enabling the Upload Flexera logs and inventories and the Upload third party inveontry data windows tasks resolved the issue at the next SCCM invenotry connection schedule. ... 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

Summary Some computers are missing in the All Inventory after upgrading the system to FNMS 2017R2. The serial number of them are in the blacklist. Symptoms Some computers are missing in the All Inventory after upgrading the system to FlexNet Manager Suite 2017 R2. These computers were existing before the upgrade. They were removed after the Reconcile with "Update inventroy for reconciliation" option. The serial number of them is "To Be filled By O.E.M." which is in the default blacklist. Cause This issue has been identified as Bug #FNMS-52223. Workaround Remove the serial number from the blacklist. ... View more

Summary Agent status is not updated after downgrading FNMEA 2016 R1 to 15.5 Symptoms FlexNet Manager Engineering Applications environment was downgraded from 2016 R1 to 15.5. After that Agent 4.1.6 logs the following errors in flexnetagent.log. 2016-10-05 14:58:42,752 WARN [flexnet.agent] [main] Manager Agent module could not start, will try again in 30 secs. java.rmi.RemoteException: platform.exceptions.FLEXnetHibernateException AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.rmi.RemoteException: platform.exceptions.FLEXnetHibernateException faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}hostname: licensesvr java.rmi.RemoteException: platform.exceptions.FLEXnetHibernateException at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:260) at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:169) at org.apache.axis.encoding.DeserializationContextImpl.endElement(DeserializationContextImpl.java:1015) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(Unknown Source) at org.apache.axis.encoding.DeserializationContextImpl.parse(DeserializationContextImpl.java:242) at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:538) at org.apache.axis.Message.getSOAPEnvelope(Message.java:376) at org.apache.axis.client.Call.invokeEngine(Call.java:2583) at org.apache.axis.client.Call.invoke(Call.java:2553) at org.apache.axis.client.Call.invoke(Call.java:2248) at org.apache.axis.client.Call.invoke(Call.java:2171) at org.apache.axis.client.Call.invoke(Call.java:1691) at com.macrovision.flexnet.manager.transport.generated.AgentManagerSoapBindingStub.registerAgent(AgentManagerSoapBindingStub.java:352) at com.macrovision.flexnet.agent.LicenseDiscovery.registerAgent(LicenseDiscovery.java:287) at com.macrovision.flexnet.agent.LicenseDiscovery.populateManager(LicenseDiscovery.java:191) at com.macrovision.flexnet.agent.AgentInitServlet.init(AgentInitServlet.java:115) at javax.servlet.GenericServlet.init(GenericServlet.java:256) at org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:220) at org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandler.java:445) at org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebApplicationHandler.java:150) at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:458) at org.mortbay.jetty.plus.PlusWebAppContext.start(PlusWebAppContext.java:133) at org.mortbay.http.HttpServer.start(HttpServer.java:663) at org.mortbay.jetty.plus.Server.start(Server.java:135) at org.mortbay.jetty.plus.Server.main(Server.java:184) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.mortbay.start.Main.invokeMain(Main.java:153) at org.mortbay.start.Main.start(Main.java:483) at org.mortbay.start.Main.main(Main.java:91) Cause This problem occurs if FNMEA databases were not re-created after the downgrade. Table structure of some tables are different between 2016 R1 and 15.5. MGR_AGENT table is one of them. The following error is logged in admin server's flexnet.log file. 2016-10-05 14:58:41,599 INFO [manager.transport] [http-0.0.0.0-8888-3] Registering agent from server licensesvr with address 192.168.10.51 2016-10-05 14:58:41,614 ERROR [manager.transport] [http-0.0.0.0-8888-3] Failed to complete the operation. Hint: Look at the stack trace [Incident# 9013-401477] com.flexnet.platform.exceptions.FLEXnetHibernateException: Error has been returned by Hibernate. [Incident# 9013-401477] at com.flexnet.platform.services.persistence.PersistenceService.saveOrUpdate(PersistenceService.java:688) at com.flexnet.platform.entities.Entity.persist(Entity.java:72) at com.flexnet.manager.entities.Agent.setAdministrators(Agent.java:323) at com.flexnet.manager.webites.WebiteHelper.createAgent(WebiteHelper.java:1007) at com.flexnet.manager.transport.AgentManager.registerAgent(AgentManager.java:901) at com.flexnet.manager.webservices.AgentManagerSoapBindingImpl.registerAgent(AgentManagerSoapBindingImpl.java:23) at com.flexnet.manager.webservices.AgentManagerSoapBindingSkeleton.registerAgent(AgentManagerSoapBindingSkeleton.java:118) at sun.reflect.GeneratedMethodAccessor523.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.flexnet.web.platform.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:52) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:722) Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.flexnet.manager.entities.Agent] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643) at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507) at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499) at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495) at com.flexnet.platform.services.persistence.PersistenceService.saveOrUpdate(PersistenceService.java:678) ... 69 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'type', table 'flexnet.dbo.MGR_AGENT'; column does not allows nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:209) at org.hibernate.id.IdentityGenerator$InsertSelectDelegate.executeAndExtract(IdentityGenerator.java:117) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33) ... 84 more Resolution Both admin and reporting database must be re-created. Please rerun "flexnet loaddb" command on both admin and reporting servers. ... View more

Summary How to deselect "Application usage agent" feature in the Agent installer on the command line installation? Synopsis It is possible to deselect the "Application usage agent" feature on GUI installer of the Agent. How to do that on the command line installation? Discussion Using the updated setup.ini file can deselect the "Application usage agent" feature as default. Edit the setup.ini file (not mgssetup.ini). Append REMOVE=aua to CmdLine parameter in [Startup] section. ... View more