Trouble Shoot Form: Database Item 003 (Following data migration from SQL to FB, EasyAdmin doesn’t show any logging)

 

Title Following data migration from SQL to FB, EasyAdmin doesn’t show any logging
Category Database
Date Sep 25, 2011
Handled by Rachel
Relevant Links (link to mantis item, docs, customer correspondence etc.)
Applies to license managers FLEXlm, FLEXnet publisher, IBM LUM, HASP, RLM, Sentinel RMS, LM-X, DSLS
Applies to license model Floating licenses, Network licenses, Concurrent licenses
Symptoms Customer complained that EasyAdmin does not show any stats.
Observed during investigation
Trouble shoot process
Solution Found (Found/Pending/Known Issue)

Symptoms

A customer complains that: “I have successfully connected the new database, BUT nothings seems to be logging. I have no stats showing on the EasyAdmin screen.”

Trouble shoot process

1. Make sure the license servers list is defined at the “OpenLM Server Configuration Form”
2. All settings of OpenLM are saved in the database. When you migrate to a different database (e.g.: from SQL to FB), you need to re-enter the license servers list.

  1. Switch to Firebird.
  2. Open “OpenLM Configuration Form”, navigate to “Advanced” panel, click “Export…” button and save the settings to a file.
  3. Close “OpenLM Configuration Form”.
  4. Switch to SQLServer.
  5. Open “OpenLM Configuration Form” again and you will see that servers list is empty.
  6. Navigate to “Advanced” panel, click “Import…” and import the file you saved earlier.
  7. Click “Apply” and restart OpenLM server.
  8. Check EasyAdmin.

Trouble Shoot Form: Database Item 002 (Data migration from SQL to FB)

Trouble Shoot Form: Item 02.002

Title Data migration troubles, from SQL to FB.
Category Database
Date Sep 25, 2011
Handled by Rachel
Relevant Links (link to mantis item, docs, customer correspondence etc.)
Symptoms Customer reported failure to import the SQL database to FB At first.
Applies to license managers FLEXlm, FLEXnet publisher, IBM LUM, HASP, RLM, Sentinel RMS, LM-X, DSLS
Applies to license model Floating licenses, Network licenses, Concurrent licenses
Observed during investigation
Trouble shoot process
Solution Found (Found/Pending/Known Issue)

Symptoms

Customer reported failure to import the SQL database to FB.

Trouble shoot process

 

  1. Make sure the “Data Migration” tool version is compliant to the OpenLM version.
  2. A special version of the data migration tool is required for 64 bit computers.
  3. Migration of a database over to a new database that is not empty may result in failure to migrate certain tables. This is indicated by the following message: 

If this is the case, create a clean database again, and run the OpenLM_SQLServer.SQL” script to build the tables and try to migrate again.

Application Note 1003_a: OpenLM Groups License Activity Report tool

The OpenLM Groups License Activity Report tool provides the ability to present an historical account of groups’ license usage sessions.

More details:

OpenLM provides an easy interface for monitoring software license usage. It does so for a constantly expanding variety of concurrent license manager types, e.g. FlexLM / Flexnet, Sentinel RMS Reprise RLM, MathLM, DSLS, Sentinel HASP, LM-X, IBM-LUM etc.

OpenLM is capable of reporting usage according to Users, User groups, Hosts, Host groups, Organizational Units and Projects. OpenLM’s web application – EasyAdmin – presents users’ accumulated data in a variety of real-time windows (e.g. “Active Products” and “Feature Usage Status” windows), and historical usage tables (e.g. “License usage” and “License activity” windows). See the OpenLM screenshots document for more information.

At the time of writing this revision, the current OpenLM version (1.8.1.17) is not yet capable of presenting an historical account of groups’ license usage sessions (i.e. the groups’ equivalent of single users’ “License activity” window).

The OpenLM Groups License Activity Report tool provides this ability.

OpenLM License Activity

The EasyAdmin “License activity” window provides an account for all ended sessions on license managers that are monitored by OpenLM. This window contains columns for the user name, Feature name and Session start & end times. (Some items on the image below have been deleted for privacy considerations)

The users who populate this list are members of groups in the OpenLM database. These groups may be introduced either manually, or by means of LDAP (Active Directory) synchronization.

Please refer to these Application notes:

Application Note 2029_a: LDAP (Active Directory) Synchronization. Basic guide v1.8

Application Note 2029_b: LDAP (Active Directory) Synchronization. Comprehensive guide v1.8

And this video:

Synchronize Active Directory, and add users manually

for more information on OpenLM Groups.

In the image above, the ‘Engineering’ group has been selected for the time period from 22/10/2012 until now. In order to provide information for the Groups reporting tool, the information needs to be exported to a CSV file, using the green arrow icon (marked by a red rectangle).

OpenLM Groups reporting tool

Once the License Activity information was exported to CSV, the OpenLM Groups reporting tool may be employed:

  • Open the OpenLM Groups reporting tool.

  • Type in the exported file path.

  • Select the Date time format (in the example above it is dd/MM/yyyy)

  • Click the Start button.

After the tool is run, a CSV format file should be created and its directory presented on the desktop. This file’s default name is OpenLMGroups.csv, and it contains an historical account of OpenLM groups’ license usage

The default location for the output CSV, as well as for Log files is

For post-Vista Windows’ version:

C:\Users\<username>\AppData\Roaming\OpenLM\OpenLMGroupsReport_Log.txt

C:\Users\<username>\AppData\Roaming\OpenLM\OpenLMGroups.csv

For pre-Vista Windows’ version: this would be at:

C:\Documents and Settings\<username>\Application Data\OpenLM

Trouble Shoot Form: OpenLM Server Item 002 (Connection to FlexLM license server failed)

Title Unable to connect to FlexLM license server
Category OpenLM Configuration Form
Date Nov 03, 2011
Handled by
Relevant Links
Applies to license managers FLEXlm, FLEXnet publisher
Applies to license model Floating licenses, Network licenses, Concurrent licenses, Node Locked
Symptoms No activity reported on EasyAdmin for a specific FlexLM license server
Observed during investigation A License server’s  ‘LED’ on the EasyAdmin “License Servers” window is red.
Clicking the “Check” button for one of the license servers on the OpenLM Configuration Form resulted in an error.
Trouble shoot process Check License server connectivity configuration.
Solution Found (Found/Pending/Known Issue)

Symptom

The customer complained that there was no activity on the EasyAdmin web application regarding a specific license server.

Solution

1. Make sure the License server configuration is correct:

  • Open the LMtools utility on the “Server status” tab.
  • Click the “Perform status Enquiry”. Status text appears.
  • On the “License server status” line – extract the Server name and status (e.g.: olm_lm_acad and 27000)

2. Install the OpenLM Broker on each license server machine. Refer to the Application Note for reference.

What is FLEXlm? What is FlexNet?

General

FLEXlm software is a license management solution that allows software vendors to limit the number of software seats available to their users. FLEXlm supports different licensing policies such as Floating (aka Concurrent) and Node Locked licenses.
These type of software systems are also called DRM Solutions (Digital Rights Management). Other software with the same functionality are SafeNet HASP, SafeNet RMS and IBM LUM.
FLEXlm is used by a great variety of software vendors, such as ESRI, Autodesk, Mathworks, PTC, Ansys, Cadence and more.

History

FLEXlm was originally a joint development of GLOBEtrotter Software and Highland Software in 1988. GLOBEtrotter was then acquired by Macrovision in 2000, which renamed the product FlexNet.
In 2008 the company was sold to Acresso Software, and it’s name was changed to Flexera. The product was named Flexera FlexNet Publisher, but is still widely referred to as FlexLM. In 2011 the Canadian Teacher’s Private Capital fund acquired Flexera.

Flexnet License Manager operation

The general structure of the Flexnet license manager is shown below:

License server manager

lmadmin or lmgrd FlexLM daemons are supplied either by the licensed FLEXenabled application publisher or by Flexera Software. Its job is to communicate with the application, and receive the license request from it.It then passes the request to the vendor daemon.

Vendor daemon

Created by the publisher, and is unique to each FlexEnabled application installed on the network. It is the vendor daemon’s job to process the license request and to either grant it or deny it, depending on the number of available licenses, and predefined license usage constraints.

License file

Created by your software supplier, and holds detailed license information such as the quantity and time extent of the license

Trusted storage

Some publishers provide trusted storage as an encrypted alternative to using license files.

Debug log and Report log

FlexNet logs written by the license server manager (lmadmin or lmgrd), typically accounting the license check-outs and check-ins, and license denials.

Option Files

Files created by license administrators to restrict license usage to specific users or user groups.

OpenLM fully supports FLEXlm / FlexNet and 20 other license managers. It focuses on a wide array of CAD, GIS and PLM applications, such as AutoCAD, ArcGIS, SolidWorks, MATLAB, Mathcad, CATIA, progeCAD, Bentley, NX, Abaqus, NX IBM Rational, and many others.