­

This page is work in progress with FAQ about the JTB FlexReport license reporting solution.

How to keep the database from growing too quick? 

How can I compact an MS Access based database that is very large? 

What is JTBFlexReport.NET-temp.mdb or the table UserDetailedLogTemp and why is it growing so fast?

How do I start with a new database?

How to improve performance using SQL Server? 

What needs to be taken backup on?

How do I move the JTB FlexReport Core installation from one server to another?

How do I move the JTB FlexReport Service installation from one server to another?

How do I move the JTB FlexReport Client installation from one server to another?

How do I move the JTB Process Monitor Service installation from one server to another?

How can I update the database from an older version of JTB FlexReport?

File location on other servers, usage of UNC paths

Package licenses and prior version support for Autodesk Collections / Suites


Q. What is JTB FlexReport?

A. A software that logs application and license usage in a database and that provides a lot of reports of the data.

Q. What licensing systems does JTB FlexReport support?

A. JTB FlexReport is a report tool for applications using network license systems like FlexNet / FLEXlm (flexlm license manager), IBM LUM (IBM License Use Management), DSLS (Dassault Systèmes License Server), SPLM (Intergraph SmartPlant License Manager), SLM/Sentinel LM/Sentinel RMS/Sentinel Protection Server/SafeNet Sentinel (SafeNet / Gemalto), LM-X, Solidworks SNL License Manager, T-Systems license manager product LICMAN, Vertex Systems, MathLM (Wolfram Mathematica license manager), RLM (Reprise License Manager), Ranorex, Venturis (TRICAD), Altium, Primavera from Oracle, GHSlm (Green Hills Software License Manager), LSTC-Dyna (LS-DYNA / Ansa / mETA / Livermore Software Technology Corporation), BETA LM (BETA CAE Systems), PKit license manager (PersonalQM / Method Park / Stages), ELM (EPLAN License Manager), Sentinel HASP (aka Aladdin HASP SRM) by SafeNet, DP Technology (DPT/ESPRIT), Tebis or 12D software licensing. With JTB Process Monitor any Windows application like Acrobat, Visio, Bentley MicroStation, single licensed AutoCAD or AutoCAD LT can be reported usage of.

Q. Is Dassault Systemes License Server (DSLS) license usage reporting supported?

A. Yes. 

Q. Is PKit License Manager supported?

A. Yes.

Q. Is Altium licenses supported?

A. Yes.

Q. Is Ranorex licenses supported?

A. Yes.

Q. Is Tebis licenses supported?

A. Yes.

Q. Is DP Technology (DPT/ESPRIT) licenses supported?

A. Yes.

Q. Is Sentinel HASP license usage reporting supported (previously known as Aladdin HASP)?

A. Yes

Q. Is Aladdin Hardlock Server license usage reporting supported?

A. No, as there seems to be no usage log or way to query the usage.

Q. Is Aspentech Software License Manager (SLM) supported?

A. Yes, because it is based on Sentinel RMS License Manager (SLM).

Q. Is AVEVA Licensing System (ALS) supported?

A. Yes, because it is based on Sentinel RMS License Manager (SLM).

Q. Is CodeMeter network licensing reporting used by Archicad and others, supported?

A. Yes

Q. Is progeCAD license usage reporting supported? Also known as progeSOFT Network License Manager (NLM).

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Felics license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Beta LM (betalm) license usage reporting supported?

A. Yes

Q. Is Bentley licensing and SELECTserver license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need. To some extent JTB Process Monitor. 

Q. Is VenturisIT / Venturis licensing and TRICAD MS for MicroStation license usage reporting supported?

A. Yes.

Q. Is LS-Dyna license usage reporting supported?

A. Yes.

Q. Is LSTC-Dyna license usage reporting supported?

A. Yes.

Q. Is GHSlm (Green Hills Software License Manager) supported?

A. Yes.

Q. Is MathLM Mathematica license usage reporting supported?

A. Yes.

Q. Is  ZWSOFT Network License Manager supported?

A. Yes, it is FlexNet based so usage on ZWCAD, ZW3D, ZWSim-WV can be monitored. 

Q. Is RSoft license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is GNS License Manager license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Orcaflex license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Sparx license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is TASKING license management usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Transoft license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Vertex Systems license usage reporting supported?

A. Support for Vertex Systems licensed products was added with JTB FlexReport 7.0.
Software from the Finish company Vertex Systems:
Homebuilding Industry:
Vertex BD Building Design Software
Vertex DS Homebuilders Data Management Software
Machinery Industry:
Vertex G4 Mechanical Engineering Software
Vertex G4Plant Plant & Piping Design Software
Vertex WG Design Workgroup Software
Vertex PDM Product Data Management Software

Q. Is ANSA's Beta_LM license usage reporting supported?

A. Yes.

Q. Is ANSYS License Manager license usage reporting supported?

A. Yes it is FlexNet based so it can be reported on. ANSYS License Interconnect with FLEXlm sits in between ANSYS vendor deamon & the client side applications.

Q. Is Bitlock license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is BricsCAD license usage reporting supported?

A. Yes. From BricsCAD version 14 Reprise License Manager will be used and thus also supported by JTB FlexReport. JTB Process Monitor can also be used to monitor usage of BricsCAD.

Q. Is Elprocad license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Rhino3d zoo license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Nalpeiron Licensing Service (NLS) license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is IBM Rational ClearCase Atria license usage reporting supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is Siemens PLM Software Common Licensing (formerly UGS) supported including monitoring of its vendor daemon ugslmd?

A. Yes it is, because it is based on FlexNet. FLEXnet licensing for NX software applications is known as Siemens PLM Software Licensing or SPLM Licensing.

Q. Is the license system for VEO by M-SIX supported?

A. Not yet but it might be added. Contact us if you have this need.

Q. Is CSC license manager supported? There are CSC products called FastTrack and Tedds.

A. Yes, because Sentinel RMS License Manager is used for this it is supported. The license manage creates logs files in the root of C:\windows\system32\.

Q. Is Intergraph Smart Licensing (ISL) supported? 

A. Not yet but it might be added. Contact us if you have this need.

Q. How can I get Vault Pro license usage showing what user is using the license?

A. At this point it is not supported but contact us if you have the need for this.

Q. Do you offer support for JTB FlexReport?

A. Support is included the first year and after that maintenance will include support and upgrades.

Q. Why do I need JTB FlexReport?

A. Several reasons. It can help cut license costs. It can help to determine when there is need of more or less licenses. It can help to split costs of licenses on different cost centers.

Q. How can I get a trial of JTB FlexReport?

A. Contact us for a free trial.

Q. How does the licensing work?

A. The server or servers that have JTB FlexReport Core, JTB FlexReport Service and/or JTB Process Monitor Service needs to be activated with a key. A license file in the installation folder for versions older than 11.

Q. How is JTB FlexReport priced?

A. See price information here.

Q. What if I have more licenses than users?

A. You may be entitled to a discount.

Q. How does it work with bundled or free licenses?

A. See here.

Q. How can I purchase JTB FlexReport?

A. See here.

Q. What is included with the maintenance?

A. Support and upgrades.

Q. What happens if I decide to not pay maintenance?

A. There is no penalty other than you are not entitled to get support and upgrades. I you decide to not pay maintenance you can still use your installation of JTB FlexReport. When you decide to pay maintenance again there is no extra fee for that or for the time you did not pay maintenance.

Q. How do I know what version of JTB FlexReport I have installed?

A. Via Windows add/remove programs where you typically uninstall programs you will see the version. In some of the products there is a readme.txt in the installation folder. In JTB FlexReport Chart Client the version can be seen in the about dialog box.

Q. What operating systems are JTB FlexReport compatible with?

A. See the system requirements.

Q. Do I have to install JTB FlexReport on a server?

A. It is recommended but you can use any Windows computer or supported Windows version. The reports can be installed and run from another machine like a PC.

Q. In what order should I install?

A. Start with the JTB FlexReport Core. After that optionally JTB FlexReport Report Service, JTB FlexReport Report Client, JTB Process Monitor Service, JTB Process Monitor Client as well as other add-ons. Where there is a service and client, install the service first.

Q. What version of Microsoft Outlook is needed?

A. Outlook is not a requirement at all.

Q. What are the minimal requirements?

A. See the system requirements.

Q. What requirements is it for Microsoft .NET Framework?

A. See the system requirements.

Q. How can I determine what version of Microsoft .NET Framework I have installed?

A. In the Windows Control Panel>Add/remove or uninstall programs. For trouble shooting see also .NET Framework Setup Verification Tool.

Q. Can I install JTB FlexReport on multiple servers or clients?

A. Yes.

Q. How many servers can be reported on?

A. There is no limitation in JTB FlexReport. But with many servers the snapshot might take several minutes and can limit the snapshot interval to be used.

Q. How many features can be reported on?

A. There is no limitation in JTB FlexReport. But with many servers the snapshot might take several minutes and can limit the snapshot interval to be used.

Q. How many users can be reported on?

A. There is no limitation in JTB FlexReport. But with many servers the snapshot might take several minutes and can limit the snapshot interval to be used.

Q. Are distributed servers supported?

A. Yes.

Q. Are redundant servers supported?

A. Yes.

Q. How should redundant servers be set up?

A. Separate the FlexNet license servers with commas like port@server1,port@server2,port@server3

Q. I have lost my license file. How can I get a new one?

A. Contact JTB World.

Q. How to I upgrade JTB FlexReport?

A. See here how to upgrade JTB FlexReport.

Q. When I install I get the message "Error 1001. The specified service has been marked for deletion". What should I do?

A. Sometimes it can help to close services.msc if it is open. But in most cases you need to restart Windows. One reason can also be that you have Process Explorer running. Close it and try again.

Q. How can I solve this? Error 1001 The specified service does not exist as an installed service or Error 1001. An exception occurred while uninstalling. This exception will be ignored and the uninstall will continue. However the application might not be fully uninstalled after the uninstall is complete. --> The specified service does not exist as an installed service or Error 1001. The specified service already exists

A. See this link: Error 1001 The specified service does not exist as an installed service

To manually stop and delete a service follow these steps. In this example it is "JTB FlexReport Core Service".
Stop the service in Windows Services.
Using the registry:
1. Run REGEDIT.EXE.
2. Find "HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services" and locate the service and delete the key.
Using command line (as administrator):
NET STOP "JTB FlexReport Core Service"
SC DELETE "JTB FlexReport Core Service"
Delete the installation folder.
Locate JTB FlexReport in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
or
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\
   Microsoft\Windows\CurrentVersion\Uninstall
You can do a Find and then delete that key.
It might be named like this: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\
   Microsoft\Windows\CurrentVersion\
   Uninstall\{1015F883-967B-4E57-B6C3-6923A1186A24}
Now try to install.
Restart if needed.

Q. In what order should I uninstall?

A. It does not matter in what order the uninstall is done.

Q. How can I do a complete uninstall?

A. Normally it is enough using the Windows uninstall functionality. But not everything is removed so you may want to locate the following locations:

Installation folders:
%ProgramFiles%\JTB World\JTB FlexReport
%ProgramFiles%\JTB World\JTB FlexReport Service
%ProgramFiles%\JTB World\JTB FlexReport Client
%ProgramFiles%\JTB World\JTB Process Service
%ProgramFiles%\JTB World\JTB Process Client

Other folders:
%ProgramData%\JTB World\JTB FlexReport
%ProgramData%\JTB World\JTB Process Service
%ProgramData%\JTB World\JTB Process Monitor Service
%AppData%\JTB_FlexReport 
%AppData%\JTB World\JTB Process Client
%LOCALAPPDATA%\JTB World\JTB FlexReport Client
%LOCALAPPDATA%\JTB World\JTB Process Monitor Client

Registry locations:
HKEY_LOCAL_MACHINE\SOFTWARE\JTB World\FlexReport
HKEY_LOCAL_MACHINE\SOFTWARE\JTB World\JTB FlexReport
HKEY_LOCAL_MACHINE\SOFTWARE\JTB World\JTB FlexReport Core
HKEY_CURRENT_USER\Software\JTB World\FlexReport
HKEY_CURRENT_USER\Software\JTB World\JTB FlexReport
HKEY_CURRENT_USER\Software\JTB World\ProcessMonitoring
HKEY_CURRENT_USER\Software\JTB World\ProcessMonitorService
On 64-bit systems the location can include Wow6432Node as seen below:
...\SOFTWARE\Wow6432Node\JTB World\...

Q. In what languages are JTB FlexReport available?

A. English only but if justified other languages can be supported. JTB FlexReport can run on Windows with other languages than English. 

Q. What applications do JTB FlexReport support?

A. The list would be very extensive but here are some:

Autodesk software, AutoCAD, AutoCAD Architecture,AutoCAD for Mac, AutoCAD Civil, AutoCAD Civil 3D, AutoCAD Electrical , AutoCAD Inventor Suites, AutoCAD Land Desktop, AutoCAD Map 3D, AutoCAD Mechanical, AutoCAD MEP, AutoCAD P&ID, AutoCAD Plant 3D, AutoCAD Raster Design, AutoCAD Revit Architecture Suite, AutoCAD Revit Architecture Visualization Suite, AutoCAD Revit MEP Suite, AutoCAD Revit Structure Suite, AutoCAD Structural Detailing, AutoCAD Visualization Suite, Autodesk 3ds Max, Autodesk 3ds Max Design, Autodesk Algor Simulation, Autodesk Alias Design, Autodesk Alias Surface, Autodesk AliasStudio, Autodesk Ecotect Analysis, Autodesk Entertainment Creation Suites, Autodesk Green Building Studio, Autodesk Inventor, Autodesk Inventor Automation Professional , Autodesk Inventor LT, Autodesk MapGuide, Autodesk MapGuide Enterprise, Autodesk MapGuide Studio, Autodesk Maya, Autodesk Moldflow Adviser, Autodesk Moldflow Insight, Autodesk MotionBuilder, Autodesk Mudbox, Autodesk Navisworks, Autodesk Revit Architecture, Autodesk Revit MEP, Autodesk Revit Structure, IBM Rational, DOORS, MSC Software: MSC SimManager, MSC SimXpert, MSC SimDesigner, MD Solutions, Engineering Analysis, Geomatic, ABAQUS, Altair, HyperWorks, Hypermesh, HyperGraph, Radioss, OptiStruct, Altium, AMESim, LMS Imagine.Lab, ANSYS, AVL, CD-Adapco, Dassault Systèmes’ DELMIA, DELCAM, DEM, ESRI, Fluent, Gamma Technologies, Inc., ICEM, ITI TranscenData, MathWorks, Mentor Graphics, PTC, E3.series from CAETEK, Intel(R) Compilers Intel(R) C++ and Fortran Compilers, T-Systems-Software, Volkswagen GII and CAA applications, SynaptiCAD (TestBencher, BugHunter, VeriLogger, WaveFormer, DataSheet, Timing Diagrammer, HDL Translators, GigaWave Viewer, TransactionTracker,EASE,HDL Companion,IO Checker), SimDE from IO Methodology, IMAGINiT Revit Utilities, Genesys contact center software (www.genesyslab.com), OrthoGen, iOrthoGen (Design Documentation Systems also known as 3DS Net, Inc. (3DS)).


Q. How do I setup Sentinel/SLM to create the required log file?

A. Google “sentinellm system administrators guide”. Open the PDF and go to “Appendix A – Using Environment Variables to Configure a License Server”, then see “Table A-3: LSERVOPTS Options Summary.

You have to go to into the registry HKEYLM\Software\Rainbow Technologies\Sentinel RMS (this can vary from version to version)\Current Version
Next you have to create a string key called CommandLineOpts
Set the value to -l “path\lserv.log” and restart the sentinel service. This will auto-generate a file in the path folder. 


Q. I don't get any usage logged and lmutil.exe lmstat -a -c port@server shows no features and users.

A. In some cases vendor daemons are sensitive to the lmutil.exe version. It might help to copy lmutil.exe from the license server to the JTB FlexReport folder. An indication of this problem is that nothing shows up after the "Feature usage info:" row when lmutil.exe is run.


Q. When setting up RLM and testing I get this connection error. 

Error connecting to 'rlm' server

Connection attempted to host: "MYSERVER" on port 5054

Read error from network (-105)

Timeout on read() (comm: - 13)

A. The problem might be that the port is wrong. We have seen cases where the port number is 5053.


Q. When I try to use the Microsoft Access based Detailed Report I get this error: The expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events. The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. There may have been an error evaluating the function, event, or macro.

A. Try to start MS Access directly from the Windows start menu. It might be that a secondary install needs to be run first. After that close MS Access and try the Detailed Report.


Q. Where can I find the FlexNet documentation?

A. FlexNet License Administration Guide documentation.pdf


Q. What is token-based licenses?

A. Introduction to Token-Based Licensing from IBM

Token based licensing is an option added to the existing floating, USER_BASED, node
locked, FLEXNet licensing of the Rational Portfolio. Historically, this mode of licensing came from the heritage Telelogic product licensing.
Technically, token licenses work the same way as a floating license. However, there
is a difference when it comes to the way the license checks out for consumption.
The Token based license model allows you to buy a certain number of Tokens (or
token-based licenses) for a group of entitled products in an organization. If you use a Rational tool that utilizes a token-based licensing model, then the
FEATURE/INCREMENT line in the license file will specify the number of Tokens for
check out in total. Tokens do not tie to a product. When the applications are closed, the tokens return to the pool for other end users with any token enabled application to use them.
A process permits and keeps track of the number of licenses used. Each application
that uses FLEXnet has its own vendor daemon. Rational License Server TL daemon is
telelogic, while the Rational License Server v8.1.1, which supports token licensing,
comes with the ibmratl daemon. The IBM Rational product and the Telelogic
daemon communicate in typical client-server architecture by making use of TCP/IP
protocol.
As described, token based licensing helps in re-using the same licenses for different
products as and when the need arises.
Note: Mixing tokens-based and non-token-based licenses is not a recommended
practice. However, you can mix tokens with traditional product floating licenses. The consuming occurs with floating licenses first, followed by the tokens. You can specify the floating licenses and tokens in the same license file for a single license server.
You can also separate into different license files or license servers. The floating
licenses must precede the token licenses in the license.dat file.
You cannot mix user-based, per-user, node locked licenses with token-based
licenses


Q. What does the FlexNet error codes mean?

A. Error codes below:

Error Message Format

FlexNet Publisher error messages presented by applications have the multiple components, which are described in the following table. An error message may also contain other optional supporting information.

FlexNet Publisher Error Message Components

Component Description Required
Error Number A positive or negative integer that identifies the error. X
Error Text Sentence that summarizes the issue. X
Error Explanation Paragraph that explains the problem and provides possible solutions or workarounds.  
Minor Error Number A positive integer. These numbers are unique error identifiers and are used by software publishers for more advanced support assistance.
Their meaning is not documented.
X
System Error Number Error code last set by the operating system.  
System Error
Explanation
Sentence that explains the system error.  

These error messages may occur in two formats available with FlexNet Publisher, or they may appear in a format customized by the application.

Format 1 (short)
FlexNet error text (lm_errno, minor_num[:sys_errno]) [sys_error_text]
The error information may be missing.
Example:
Can’t connect to license server machine (-15,12:61) Connection refused
Format 2 (long)
FlexNet error text
FlexNet error explanation
[Optional Supporting information]
FlexNet error: lm_errno, minor_num. [System Error: sys_errno] [“system_error_text”]
Example:
Cannot connect to license server system
The server (lmgrd) has not been started yet, or
the wrong port@host or license file is being used, or the
port or hostname in the license file has been changed.
Feature: f1
Server name: localhost
License path: @localhost:license.dat:./*.lic
FlexNet error: -15,12. System Error: 61 “Connection refused”

Error Code Descriptions

The following table lists the most common errors produced by FlexEnabled applications.

Error Code Description
21 lc_flexinit failed because there were insufficient rights to start the FlexNet Publisher Service.
Resolve this by setting the service to start automatically.
20 FlexNet Publisher Service is not installed.
13 Computed path to required file is too long for Mac OS X operating system.
12 Invalid bundle ID on Mac OS X operating system.
11 Framework specified by bundle ID was not loaded.
10 Error creating path from URL.
9 Error creating URL.
8 Path string not specified in UTF-8 format.
7 A call to lc_flexinit is not allowed after a call to lc_flexinit_cleanup.
6 Activation application has not been processed using the preptool, or the activation library for the activation application cannot be found.
5 Unable to allocate resources.
4 Initialization failed.
3 Unsupported version of the operating system.
2 Unable to load activation library.
1 Unable to find activation library.
-1 Cannot find license file.
-2 Invalid license file syntax.
-3 No license server system for this feature.
-4 Licensed number of users already reached.
-5 No such feature exists.
-6 No TCP/IP port number in license file and FlexNet Licensing Service does not exist. (pre-v6 only)
-7 No socket connection to license server manager service.
-8 Invalid (inconsistent) license key or signature.
The license key/signature and data for the feature do not match. This usually happens when a license file has been altered.
-9 Invalid host.
The hostid of this system does not match the hostid specified in the license file.
-10 Feature has expired.
-11 Invalid date format in license file.
-12 Invalid returned data from license server system.
-13 No SERVER lines in license file.
-14 Cannot find SERVER host name in network database.
The lookup for the host name on the SERVER line in the license file failed. This often happens when NIS or DNS or the hosts file is incorrect. Work around: Use IP address (for example, 123.456.789.123) instead of host name.
-15 Cannot connect to license server system.
The server (lmadmin or lmgrd) has not been started yet, or the wrong port@host or license file is being used, or the TCP/IP port or host name in the license file has been changed.
Windows XP SP2 platforms have a limit on the number of TCP/IP connection attempts per second that can be made, which your application may have exceeded. Refer to the manufacturer’s documentation on how to change this limit.
-16 Cannot read data from license server system.
-17 Cannot write data to license server system.
-18 License server system does not support this feature.
-19 Error in select system call.
-20 License server system busy (no majority).
-21 License file does not support this version.
-22 Feature checkin failure detected at license server system.
-23 License server system temporarily busy (new server connecting).
-24 Users are queued for this feature.
-25 License server system does not support this version of this feature.
-26 Request for more licenses than this feature supports.
-29 Cannot find ethernet device.
-30 Cannot read license file.
-31 Feature start date is in the future.
-32 No such attribute.
-33 Bad encryption handshake with vendor daemon.
-34 Clock difference too large between client and license server system.
-35 In the queue for this feature.
-36 Feature database corrupted in vendor daemon.
-37 Duplicate selection mismatch for this feature. Obsolete with version 8.0 or later vendor daemon.
-38 User/host on EXCLUDE list for feature.
-39 User/host not on INCLUDE list for feature.
-40 Cannot allocate dynamic memory.
-41 Feature was never checked out.
-42 Invalid parameter.
-47 Clock setting check not available in vendor daemon.
-52 Vendor daemon did not respond within timeout interval.
-53 Checkout request rejected by vendor-defined checkout filter.
-54 No FEATURESET line in license file.
-55 Incorrect FEATURESET line in license file.
-56 Cannot compute FEATURESET data from license file.
-57 socket call failed.
-59 Message checksum failure.
-60 License server system message checksum failure.
-61 Cannot read license file data from license server system.
-62 Network software (TCP/IP) not available.
-63 You are not a license administrator.
-64 lmremove request before the minimum lmremove interval.
-67 No licenses available to borrow.
-68 License BORROW support not enabled.
-69 FLOAT_OK can’t run standalone on license server system.
-71 Invalid TZ environment variable.
-73 Local checkout filter rejected request.
-74 Attempt to read beyond end of license file path.
-75 SYS$SETIMR call failed (VMS). Indicates and error due to an operating system failure.
-76 Internal FlexNet Licensing error. Please report error to Flexera Software.
-77 Bad version number must be floating-point number with no letters.
-82 Invalid PACKAGE line in license file.
-83 FlexNet Licensing version of client newer than server.
-84 USER_BASED license has no specified users; see license server system log.
-85 License server system doesn’t support this request.
-87 Checkout exceeds MAX specified in options file.
-88 System clock has been set back.
-89 This platform not authorized by license.
-90 Future license file format or misspelling in license file.
The file was issued for a later version of FlexNet Licensing than this program understands.
-91 Encryption seeds are non-unique.
-92 Feature removed during lmreread, or wrong SERVER line hostid.
-93 This feature is available in a different license pool.
This is a warning condition. The server has pooled one or more INCREMENT lines into a single pool, and the request was made on an INCREMENT line that has been pooled.
-94 Attempt to generate license with incompatible attributes.
-95 Network connect to THIS_HOST failed.
Change this_host on the SERVER line in the license file to the actual host name.
-96 License server machine is down or not responding.
See the system administrator about starting the server, or make sure that you’re referring to the right host (see LM_LICENSE_FILE environment variable).
-97 The desired vendor daemon is down.
1) Check the lmadmin or lmgrd log file, or 2) Try lmreread.
-98 This FEATURE line can’t be converted to decimal format.
-99 The decimal format license is typed incorrectly.
-100 Cannot remove a linger license.
-101 All licenses are reserved for others.
The system administrator has reserved all the licenses for others. Reservations are made in the options file. The server must be restarted for options file changes to take effect.
-102 A FLEXid borrow error occurred.
-103 Terminal Server remote client not allowed.
-104 Cannot borrow that long.
-105 Feature already returned to license server.
-106 License server system out of network connections.
The vendor daemon can't handle any more users. See the debug log for further information.
-110 Cannot read dongle: check dongle or driver.
Either the dongle is unattached, or the necessary software driver for this dongle type is not installed.
-112 Missing dongle driver.
In order to read the FLEXid hostid, the correct driver must be installed. These drivers are available from your software publisher.
-114 SIGN= keyword required, but missing from license certificate.
You need to obtain a SIGN= version of this license from your publisher.
-115 Error in Public Key package.
-116 TRL not supported for this platform.
-117 BORROW failed.
-118 BORROW period expired.
-119 lmdown and lmreread must be run on license server.
-120 Cannot lmdown the server when licenses are borrowed.
-121 FLOAT_OK requires exactly one FLEXid hostid.
-122 Unable to delete local borrow info.
-123 Returning a borrowed license early is not supported.
Contact the publisher for further details.
-124 Error returning borrowed license.
-125 A PACKAGE component must be specified.
-126 Composite hostid not initialized.
-127 A item needed for the composite hostid is missing or invalid.
-128 Error, borrowed license doesn't match any known server license.
-135 Error enabling the event log.
-136 Event logging is disabled.
-137 Error writing to the event log.
-139 Communications timeout.
-140 Bad message command.
-141 Error writing to socket. Peer has closed socket.
-142 Error, cannot generate version specific license tied to a single hostid, which is composite.
-143 Version-specific signatures are not supported for uncounted licenses.
-144 License template contains redundant signature specifiers.
-145 Bad V71_LK signature.
-146 Bad V71_SIGN signature.
-147 Bad V80_LK signature.
-148 Bad V80_SIGN signature.
-149 Bad V81_LK signature.
-150 Bad V81_SIGN signature.
-151 Bad V81_SIGN2 signature.
-152 Bad V84_LK signature.
-153 Bad V84_SIGN signature.
-154 Bad V84_SIGN2 signature.
-155 License key required but missing from the license certificate. The application requires a key in the license certificate. You need to obtain a license key version of this certificate from publisher.
-156 Invalid signature specified with the AUTH= keyword.
-157 Trusted storage has been compromised; repair needed. Contact your publisher for repair instructions.
-158 Trusted storage open failure. Contact your publisher for further information.
-159 Invalid fulfillment record. Contact your publisher for further information.
-160 Invalid activation request received. Contact your publisher for further information.
-161 No fulfillment exists in trusted storage which matches the request. Contact your publisher for further information.
-162 Invalid activation response received. Contact your publisher for further information.
-163 Cannot return the specified activation. Contact your publisher for further information.
-164 Return count(s) would exceed the maximum for the fulfillment. Contact your publisher for further information.
-165 No repair count left. Contact your publisher for further repair authorization.
-166 Specified operation not allowed. Contact your publisher for further information.
-167 The requested activation has been denied because the user or host is excluded from activating this entitlement by a specification in the options file.
-168 The options file contains include specifications for the entitlement, and this user or host is not included in these specifications.
-169 Activation error. Contact your publisher for further information.
-170 Invalid date format in trusted storage. Can be caused by setting your system clock to an earlier date. Check that your system clock is set to the current date and time.
-171 Message encryption failed. Internal error. Please report to Flexera Software Inc.
-172 Message decryption failed. Internal error. Please report to Flexera Software Inc.
-173 Bad filter context. Internal error. Please report to Flexera Software Inc.
-174 SUPERSEDE feature conflict. Contact your publisher for further information.
-175 Invalid SUPERSEDE_SIGN syntax. Contact your publisher for further information.
-176 SUPERSEDE_SIGN does not contain a feature name and license signature. Contact your publisher for further information.
-177 ONE_TS_OK is not supported in this Windows Platform.
-178 Internal error. Please report to Flexera Software Inc.
-179 Only one terminal server remote client checkout is allowed for this feature.
-180 Internal error. Please report to Flexera Software Inc.
-181 Internal error. Please report to Flexera Software Inc.
-182 Internal error. Please report to Flexera Software Inc.
-183 More than one ethernet hostid not supported in composite hostid definition. Contact your publisher for further information.
-184 The number of characters in the license file paths exceeds the permissible limit.
There is a limit on the number of license files that can be used by a license server manager. This limit is on the number of characters in the combined license file paths to the license files:
• Unix—40,960 characters
• Windows—20,400 characters
Reduce the number of license files, or relocate them so that the paths are shorter.
-187 The time zone information could not be obtained.
A license that is time zone limited could not be checked out because time zone information could not be obtained for the machine on which the license is required. Contact your publisher for further information.
-188 License client time zone not authorized for license rights.
A license that is time zone limited could not be checked out because the time zone of the machine on which the license is required does not match the time zone specified in the license.
-190 Feature can be checked out from Physical machine only.
The license specifies that it cannot be used on a virtual machine: The FlexEnabled application is installed on a virtual machine so checkout has been denied. Install the FlexEnabled application on a physical machine.
-191 FEATURE can be checked out from Virtual machine only.
The license specifies that it cannot be used on a physical machine. The FlexEnabled application is installed on a physical machine so checkout has been denied. Install the FlexEnabled application on a virtual machine.
-192 VM platform not authorized by license.
-193 FNP vendor keys do not support Virtualization feature.
-194 Checkout request denied as it exceeds the MAX limit specified in the options file.
-195 Binding agent API - Internal error.
-196 Binding agent communication error
-197 Invalid Binding agent version.

Debug Log Messages

FlexNet Publisher processes generate debug log files in the following format:
hh:mm:ss (daemon) message

Message Description
hh:mm:ss Time that the message was logged.
daemon Either lmadmin, lmgrd or the vendor daemon name. In the case where a single copy of the daemon cannot handle all of the requested licenses, an optional “_” followed by a number indicates that this message comes from a forked daemon.
message The text of the message.

The debug log files can be used to:
• Diagnose configuration problems
• Diagnose daemon software errors

Informational Messages

This lists the various informational messages used within FlexNet Publisher.

Message Description
Connected to host This daemon is connected to its peer on host.
CONNECTED, master is host The license daemons log this message when a quorum is up and everyone has selected a master.
DENIED: num_lic feature to user user was denied access to num_lic licenses of feature.
EXITING DUE TO SIGNAL nnn
EXITING with code nnn
All daemons list the reason that the daemon has exited.
EXPIRED: feature feature has passed its expiration date.
IN: “feature” user (num_lic licenses) user has checked in num_lic licenses of feature.
Lost connection to host A daemon can no longer communicate with its peer on node host, which can cause the clients to have to reconnect, or cause the number of daemons to go below the minimum number, in which case clients may start exiting. If the license daemons lose the connection to the master, they kill all the vendor daemons; vendor daemons shut themselves down.
Lost quorum The daemon lost quorum, so it processes only connection requests from other daemons.
MULTIPLE vendor servers running.
Kill and restart license daemon.
The license server manager has detected that multiple vendor daemons with the same vendor name are running. Shutdown lmadmin or lmgrd and all vendor daemons and then restart lmadmin or lmgrd.
OUT: feature user (num_lic licenses) user has checked out num_lic licenses of feature.
RESERVE feature for USER user
RESERVE feature for HOST host
A license of feature is reserved for either user or host.
REStarted vendor (internet port
nnn)
Vendor daemon vendor was restarted at TCP/IP port nnn.
Retrying socket bind (address in
use)
The license servers try to bind their sockets for approximately six minutes if they detect “address in use” errors.
Selected (EXISTING) master host. This license daemon has selected an existing master host as the master.
SERVER shutdown requested. A daemon was requested to shut down via a user-generated kill command.
Server started on host for:
feature_list
A (possibly new) server was started for the features listed.
Shutting down vendor The license server manager is shutting down the vendor daemon vendor.
SIGCHLD received. Killing child servers. A vendor daemon logs this message when a shutdown was requested by the license daemon.
Started vendor The license server manager logs this message whenever it starts a new vendor daemon.
TIMESTAMP A vendor daemon logs this message at regular intervals. The default interval between vendor daemon timestamps is 6 hours 5 minutes.
A license server manager (lmadmin or lmgrd) logs this message at regular intervals. The default interval between license server manager timestamps is 6 hours.
Trying to connect to host The daemon is attempting a connection to host.

Configuration Problem Messages

This lists configuration problem messages found in FlexNet Publisher.

Message Description
host: Not a valid server host,
exiting
This daemon was run on an invalid host name.
host: Wrong hostid, exiting The hostid is wrong for host.
BAD CODE for feature The specified feature name has a bad license key or signature. It was probably typed in wrong, or modified by the end user.
CANNOT OPEN options file The options file specified in the license file could not be opened.
Couldn’t find a master The daemons could not agree on a master.
License daemon: lost all connections This message is logged when all the connections to a server are lost, which often indicates a network problem.
Lost lock, exiting
Error closing lock file
Unable to re-open lock file
The vendor daemon has a problem with its lock file, usually because of an attempt to run more than one copy of the daemon on a single node.
Locate the other daemon that is running via a ps command, and kill it with kill -9.
No DAEMON line for vendor The license file does not contain a DAEMON or VENDOR line for vendor.
No DAEMON lines, exiting The license daemon logs this message if there are no DAEMON or VENDOR lines in the license file. Because there are no vendor daemons to start, there is nothing for the license daemon to do.
No features to serve! A vendor daemon found no features to serve. This could be caused by a corrupted or incorrectly entered license file.
UNSUPPORTED FEATURE
request: feature by user
The user has requested a feature that this vendor daemon does not support. This can happen for a number of reasons: the license file is bad, the feature has expired, or the daemon is accessing the wrong license file.
Unknown host: host The host name specified on a SERVER line in the license file does not exist in the network database (probably /etc/hosts).

Daemon Software Error Messages

This lists various daemon software error messages:

Message Description
accept: message An error was detected in the accept system call.
Can’t allocate server table space A malloc error. Check swap space.
Connection to host TIMED OUT The daemon could not connect to host.
Illegal connection request to
vendor
A connection request was made to vendor, but this vendor daemon is not vendor.
read: error message An error in a “read” system call was detected.
select: message An error in a “select” system call was detected. This is usually a sign of a system networking failure.
Server exiting The server is exiting. This is normally due to an error.

Question

I think the SQL Server database is inconsistent. Either some tables are missing or some columns are missing or not correct. How can I send that information to JTB World for confirmation?

Answer

Within Microsoft SQL Server Management Studio Open up the database and create a new query like below. Just change JTBFlexReport to whatever the JTB FlexReport database is named.

SELECT * FROM [JTBFlexReport].[INFORMATION_SCHEMA].[COLUMNS]

Then save the result using File>Save Result As a CSV file.

For constraint information run also this query:

SELECT * FROM [JTBFlexReport].[INFORMATION_SCHEMA].[CONSTRAINT_COLUMN_USAGE]

For information on indexes:

USE [JTBFlexReport]

SELECT
schema_name(schema_id) as SchemaName, OBJECT_NAME(si.object_id) as TableName, si.name as IndexName,
(CASE is_primary_key WHEN 1 THEN 'PK' ELSE '' END) as PK,
(CASE is_unique WHEN 1 THEN '1' ELSE '0' END)+' '+
(CASE si.type WHEN 1 THEN 'C' WHEN 3 THEN 'X' ELSE 'B' END)+' '+ -- B=basic, C=Clustered, X=XML
(CASE INDEXKEY_PROPERTY(si.object_id,index_id,1,'IsDescending') WHEN 0 THEN 'A' WHEN 1 THEN 'D' ELSE '' END)+
(CASE INDEXKEY_PROPERTY(si.object_id,index_id,2,'IsDescending') WHEN 0 THEN 'A' WHEN 1 THEN 'D' ELSE '' END)+
(CASE INDEXKEY_PROPERTY(si.object_id,index_id,3,'IsDescending') WHEN 0 THEN 'A' WHEN 1 THEN 'D' ELSE '' END)+
(CASE INDEXKEY_PROPERTY(si.object_id,index_id,4,'IsDescending') WHEN 0 THEN 'A' WHEN 1 THEN 'D' ELSE '' END)+
(CASE INDEXKEY_PROPERTY(si.object_id,index_id,5,'IsDescending') WHEN 0 THEN 'A' WHEN 1 THEN 'D' ELSE '' END)+
(CASE INDEXKEY_PROPERTY(si.object_id,index_id,6,'IsDescending') WHEN 0 THEN 'A' WHEN 1 THEN 'D' ELSE '' END)+
'' as 'Type',
INDEX_COL(schema_name(schema_id)+'.'+OBJECT_NAME(si.object_id),index_id,1) as Key1,
INDEX_COL(schema_name(schema_id)+'.'+OBJECT_NAME(si.object_id),index_id,2) as Key2,
INDEX_COL(schema_name(schema_id)+'.'+OBJECT_NAME(si.object_id),index_id,3) as Key3,
INDEX_COL(schema_name(schema_id)+'.'+OBJECT_NAME(si.object_id),index_id,4) as Key4,
INDEX_COL(schema_name(schema_id)+'.'+OBJECT_NAME(si.object_id),index_id,5) as Key5,
INDEX_COL(schema_name(schema_id)+'.'+OBJECT_NAME(si.object_id),index_id,6) as Key6
FROM sys.indexes as si
LEFT JOIN sys.objects as so on so.object_id=si.object_id
WHERE index_id>0 -- omit the default heap
and OBJECTPROPERTY(si.object_id,'IsMsShipped')=0 -- omit system tables
and not (schema_name(schema_id)='dbo' and OBJECT_NAME(si.object_id)='sysdiagrams') -- omit sysdiagrams
ORDER BY SchemaName,TableName,IndexName

Finally send the files to JTB World.


Question

How can I find the size of each table in SQL Server?

Answer

Run SQL Server Management Studio (SSMS).
Right click on the database
Navigate to Reports > Standard Reports > Disk Usage By Table

Or within Microsoft SQL Server Management Studio create a new query like below. Just change JTBFlexReport to whatever the JTB FlexReport database is named.

USE JTBFlexReport
GO
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
GO

To find the size of the database:

USE JTBFlexReport
GO
EXEC sp_spaceused
GO


Question: How can I compress the SQL Server database?

Answer: Before doing this you might want to take a backup of the database.

1. Shrink a Database, shrinking data files recovers space by moving pages of data from the end of the file to unoccupied space closer to the front of the file. When enough free space is created at the end of the file, data pages at end of the file can deallocated and returned to the file system. For details see http://msdn.microsoft.com/en-us/library/ms189035.aspx.

 2. You can also delete rows with 0 usage from the log file. It can get the size down a bit. Change JTB below to the name of the database.
DELETE FROM [JTB].[dbo].[log]
Where [UsedLic]=0

3. See also if there are features you have no need to log and set nolog in JTB FlexReport Config>Features. This will not delete old data but limit new data from be added for these features.


Question

How does the "TIMEOUT" feature in a FLEXlm options file affect IBM Rational PurifyPlus tools and its usage during inactivity?

Answer

The TIMEOUT feature ideally puts a license back into the pool for reuse after a certain period of inactivity is reached at the client. The period of inactivity can be specified in milliseconds against the TIMEOUT feature in the options file.

For PurifyPlus suite of tools, the TIMEOUT does not affect the functionality of the tool in any way even if there had been a period of inactivity longer than what is specified in the options file.

For example, if the TIMEOUT is set for 1800 ms (which is half an hour), the PurifyPlus license is checked back in automatically and made available in the pool for other users to use. If the inactive user tries using the tools (Rational Purify, Rational Quantify or Rational PureCoverage) even after the timeout has happened, the user will be able to use the tool without any licensing issues.

In other words, the usage of the tool after the timeout does not send a license request again to the license server.


I've got a question about the detailed report "Denied per day". In the report there is a column "License found". What exactly means this column? Some users have No and some have Yes ... I can't find anything about it. Maybe you can tell me what is the difference?

If it is Yes it means that within a just a few minutes the user was able to check out a license. If it is No it means that either the user did not try to check out a license again or was not able to check out a licenses within a few minutes.


Error in the Access based Detailed Reports pressing the reload button: Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down.
The solution was to relink the database once.


Here are some tips to determine if JTB FlexReport is installed and running as expected or to identify why it's not working.

Check that there is a service in Windows Service. Typically named "JTB FlexReport Service" or "JTB FlexReport Core Service", "JTB FlexReport Process Service", "JTB FlexReport Chart Service", "JTB FlexReport Sampling Service", "JTB FlexReport Auto Chart Service", "JTB FlexReport SPLM Service". If it does not exists a reinstallation is probably needed.

Check if the service is running in Windows Services.

Check the Windows Event Viewer for any Application or System errors being logged that are related to JTB FlexReport.

If Test Service Engine gives this error: “The Remote Name Could Not Be Resolved: ‘localHost’” and if the Event Viewer has this event (Event ID: 15005 Source: HTTP)you can try to change the port number to next number. Typically try port numbers from 2000 and up. This is also a message that might come up: "Unable to bind to the underlying transport for 0.0.0.0:2000. The IP Listen-Only list may contain a reference to an interface which may not exist on this machine. The data field contains the error number."

Try to use IP number instead of host name for the JTB Chart Service or Process Service.

Make sure that there is no firewall blocking any of the JTB FlexReport exe files or ports used. It might be needed to add exceptions for the exe files and the port used.

Make also sure the license file is copied to the folder installation folder for the chart service: C:\Program Files\JTB World\JTB FlexReport Service

Make sure the license file is copied to the folder installation folder for the Process Monitor service:
\JTB World\JTB Process Service

Make sure the license file is valid. Can be confirmed by sending it to JTB World.

Make sure that the service address is the same in all the config files in the installation folders for the Service and Client: "JTB FlexReportClient.exe.config", "JTB FlexReport Sampling Service.exe.config" and "JTB FlexReport Service Configurator.exe.config". The address can be for example: http://MyServer:2000/Service

To test from the client if it has contact with the server service you can locate JTB FlexReportClient.exe.config and locate near the end of the file this row: <endpoint address="http://MyServer:2000/Service". Now try to enter the address in a web browser and see if there are any problems to access the service or not. You can also try to ping the actual server.

Using netstat -o or netstat -on in command prompt window or using TCPView will help to identify ports that are used on the machine. Sometimes the port configured is already used and to solve the conflict you need to change the port in the configuration on the server and the client. Note that you cannot find what specific Windows Service that is using a port as all services shows under the System process.

If test of service engine gives this error "Please start the Service before testing. The remote name could not be resolved: 'localhost'" and/or if the Windows Event Viewer with Event Source: JTBFlexReportWCFService has this error it is an indication that an older .NET Framework version is installed or that it needs reinstall. 3.0 or newer is needed.

Event error description: Service cannot be started. System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: Unrecognized configuration section system.serviceModel.

Sometimes a reinstall can help for unknown errors.


lmgrd is not running: Cannot read data from license server system. (-16,287)

The above error can happen in some cases when a timeout is used to run lmutil.exe lmstat. If possible remove the use of timeout or try to adjust the timeout value up or down until it works.


I get this error: lmgrd is not running: License server machine is down or not responding. (-96,7:11001 "WinSock: Host not found (HOST_NOT_FOUND)")

The error could also be: lmgrd is not running: License server machine is down or not responding. (-96,7:11001 "Comm. error")

Here is a strange feature in lmutil.exe that also affects JTB FlexReport.
If the client PC is far a way from FLEXlm server, like the PC is in South America and server is in Europe. PC and server have a machine account in company wide Active Directory Each continent has separate domain name like European computers are in domain eu.net and American am.net.

Try to list all licenses from server (change the port and server name to yours)
Format is:
lmutil.exe lmstat -c <port number>@<Server Name>.<Domain Name>.<Domain>.<Extension> -a
Example:
lmutil.exe lmstat -c 27000@server.eu.net -a

Result:
lmgrd is not running: License server machine is down or not responding. (-96,7:11001 "WinSock: Host not found (HOST_NOT_FOUND)")

Add IP address and host name of the server to the host file found at: C:\WINDOWS\system32\drivers\etc\hosts

123.123.123.123 server server.eu.net

alternatively add only like this:
123.123.123.123 server

Now run the same command without domain name
lmutil.exe lmstat -c 27000@server -a

Now it works! Autodesk products get the license without hosts modification but lmutil.exe fails badly. Some error in DNS configuration? I don't know but if the PC is in Europe both commands will work because the both computers are in the same domain.


Usage of -t for timeout with lmutil.exe lmstat can be done through JTB FlexReport Config>Properties>Advanced.

If data is missing or license servers cannot be reached you can try to set the timeout to something. It’s not documented by the company behind FlexNet if this is in microseconds or milliseconds so you have to try. It is probably microseconds so a value of 1,000,000 would be a second. Try increase with a second until it works.


Q. How to keep the database from growing too quick?

A. Here are some steps:

  1. In JTB FlexReport Config click on Features and use the checkbox NoLog for features you don’t need or want to log usage for.
  2. In JTB FlexReport Config the Snapshot Interval can be increased.
    This is the interval between snapshots taken on the license usage and saved to the database. Default is 10 minutes. If you have many features and licenses and users don’t set the time too low because one snapshot can take several minutes and the database will also grow more. If you set the interval too high it decreases the accuracy in the resulting data.
    If the interval is changed after the service has been running for a time take a fresh copy of the database JTBFlexReport.NET.mdb and start using that one instead or manually empty the table “log”. Stop the service. Rename “JTBFlexReport.NET.mdb”. Copy “JTBFlexReport.NET (extra empty copy).mdb” and name it “JTBFlexReport.NET.mdb”. Start the service. Or if SQL Server is used the table “Log” needs to be emptied.
  3. In JTB FlexReport Service Configurator the Precision Value can be increased.
    The lower Precision Value the more correct result but the longer the sampling will take and the larger the cache temp table will be. Say the Previous Value is 30 minutes the usage will be less correct than with a value of 10 minutes. A time stamp of 8:50 will be rounded to 9:00 with 30 minute Precision Value.  
    “Sampling All Records” can be used if you want to change “Precision Value”. You don’t have to keep the Service Configurator open during sampling as it can take quite a while if there is lots of data to process. But if it is kept open a dialog box will tell when the sampling is ready.
  4. How can I compact an MS Access based database that is very large? 
  5. You can install JTB FlexReport on two or more servers and split the logging on separate databases.
  6. If using MS Access there is a limit of 2gb on the mdb database file. Other options are SQL Server Express (10gb limit) or SQL Server (only limited to your hard drive space).

Q. How can I compact an MS Access based database that is very large?

A. Stop all JTB services during this process.
It might help to run JTB FlexReport Config>General>Update DB.
Or try Compact & Repair using MS Access.

If the database is too large (typically 2GB) it cannot be compacted the normal way. The easiest thing is to start with a new empty database after taking backup of the original database. "JTBFlexReport.NET (extra empty copy).mdb" is an empty database that is available in the installation folder and can be used for this purpose. Stop the JTB services. If your main database is named "JTBFlexReport.NET.mdb", rename it or delete it, then copy "JTBFlexReport.NET (extra empty copy).mdb" and name it "JTBFlexReport.NET.mdb". Now start the JTB services again. After that delete JTBFlexReport.NET-temp.mdb and then use "Sampling All Records" in JTB FlexReport Service Configurator.


Sometimes it can work to import tables in a large or corrupted database into an empty database.
If the temp database (Default name is JTBFlexReport.NET-temp.mdb) is too large or close to 2GB you can try to compact it using the method above. You can also delete it and it will be recreated when configuring the main database in the Configurator. Otherwise try Compact & Repair using MS Access. Note that JTBFlexReport.NET-temp.mdb is create and updated by the JTB FlexReport Sampling Service and its size is partly depending on the sampling value interval as set in JTB FlexReport Service Configurator. If you have a lot of features, users and/or data for a large date period it can also grow quick and you might need to use "JTB FlexReport Database Administration" and move or delete data alternatively migrate the MS Access database to SQL Server.
You can also use "JTB FlexReport Database Administration" and move or delete data. It will make the main database smaller and after that you can "Sampling All Records" in JTB FlexReport Service Configurator.


For versions older than version 11: Run the Detailed Report MDB from JTB FlexReport Config>General and then make sure the path to the main database (default named JTBFlexReport.NET.mdb) is correct. If not, use Relink database button. Then click on "Compact linked and current database".


Q. What is JTBFlexReport.NET-temp.mdb or the table UserDetailedLogTemp and why is it growing so fast?

A. If MS Access is used as back end database the cache will be saved in a separate database with the suffix “-temp.mdb”. If SQL Server is used there is a table named UserDetailedLogTemp that holds this cache data.
UserDetailedLogTemp is created by the Sampling service that is configured in JTB FlexReport Service Configurator and is affected by the precision value where a smaller value makes the table UserDetailedLogTemp grow quicker but on the other hand a larger value makes the reports created based on UserDetailedLogTemp to be less accurate.
UserDetailedLogTemp is created based on data in tblUserDetailedLog and tblUserDetailedLogPrev. If one row in tblUserDetailedLog contains usage between 8:00 and 9:00 and the precision value is 10 minutes there will be created 6 rows of data for the times 8:00, 8:10, 8:20, 8:30, 8:40 and 8:50. So if there are usage of licenses that runs for days, weeks or months a lot of rows will be created.

The “-temp.mdb” database can be compressed with MS Access or the database/table can be recreated using “Sampling All Records” in JTB FlexReport Service Configurator. The mdb file is limited to 2GB in size.

The Database Administrator can be used to move or delete old data in a mdb file and there are scripts available to download on the product website for usage with SQL Server. After that you can "Sampling All Records" in JTB FlexReport Service Configurator.

Another method is to take backup of the main database JTBFlexReport.NET.mdb and start with a new from scratch. "JTBFlexReport.NET (extra empty copy).mdb" is an empty database that is available in the installation folder and can be used for this purpose. After that delete JTBFlexReport.NET-temp.mdb and then use "Sampling All Records" in JTB FlexReport Service Configurator.

You can also delete it and it will be recreated when configuring the main database in the Configurator.


Q. What needs to be taken backup on?

A. What you typically need to backup is the database (verify where it is and the name in JTB FlexReport Config > Configure Database) as it holds the most important usage data. If you have made any adjustments to other files in the installation folders you can include them as well. 

The following services might need to automatically be stopped to allow backup depending on how the backup is done:
“JTB FlexReport Core Service” is the service that is populating the database.
“JTB FlexReport Sampling Service” used by the chart service is also populating the database with sampled data and can also lock it.
“JTB FlexReport Report Service” and “JTB FlexReport Auto Service” might also be needed to stop as they read from the database.
If you use JTB Process Monitor there is the "JTB Process Monitor Service" and for SPLM monitoring there is the "JTB FlexReport SPLM Service". 

If you want to backup the settings in JTB FlexReport Config they are saved in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\JTB World\JTB FlexReport Core registry key. On 64-bit OS the location is HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB FlexReport Core.

All .config files in installation folders can be backed up as they hold various settings.

If you have created auto reports backup the .xml files from this folder: C:\ProgramData\JTB World\JTB FlexReport Service

For JTB Process Monitor settings are saved in C:\ProgramData\JTB World\JTB Process Monitor Service


Q. How do I move the JTB FlexReport Core installation from one server to another?

A. First install JTB FlexReport on the new location. Optionally copy the database. If you have made other customizations of INI, VBS files or the like you can copy them as well. You can optionally copy all .config files in the JTB FlexReport old folder to the new location as this will keep your database configurations.

If you want to bring with you the settings in JTB FlexReport Config you can export and import HKEY_LOCAL_MACHINE\SOFTWARE\JTB World\JTB FlexReport Core registry key. On 64-bit OS the location is HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB FlexReport Core.

Run JTB FlexReport Config and check all settings. Configure the database, click on General tab and on Configure Database button.

Press License Activation in Config and follow instructions.

If it was some versions between the old and the new JTB FlexReport it is a good idea to click on the Update DB button on the General tab in JTB FlexReport Config. If SQL Server database is used you might need to use the update script “JTB FlexReport SQL create and copy db version <version>.txt” found under https://jtbworld.com/jtb-flexreport#download.

Start the service from the General tab.

Make sure to test that the new server includes everything you need and that it works before deleting it from the old server.

Verify that the HTML file(s) are updated as expected and eventually that new data shows up in reports after a while.


Q. How do I move the JTB FlexReport Service installation from one server to another?

A. If you want to avoid re-configuring, first create the folders like you already have it on the existing server.

Default locations are:

For the folder below copy JTBFlexReportLicense.txt and all .config files. For newer versions the license file is not used. 

C:\Program Files (x86)\JTB World\JTB FlexReport Service

If you have created auto reports copy the .xml files from this folder.

C:\ProgramData\JTB World\JTB FlexReport Service

Run Regedit and export and import this registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB FlexReport Service

If you want a clean install you can after the installation just copy JTBFlexReportLicense.txt to the installation folder. For newer versions the license file is not used. In Configurator click License Activation and follow the instructions. 

Now run the JTB FlexReport Service installer and in the Configurator check that the settings are correct, press Configure and Start Service and do the tests.


Q. How do I move the JTB FlexReport Client installation from one server to another?

A. If you want to avoid re-configuring, first create the folders like you already have it on the existing server.

Default location is:

For the folder below copy all .config files.

C:\Program Files (x86)\JTB World\JTB FlexReport Client

Run Regedit and export and import these registry keys:
HKEY_CURRENT_USER\Software\JTB World\JTB FlexReport Client

HKEY_LOCAL_MACHINE\SOFTWARE\JTB World\JTB FlexReport Client
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB FlexReport Client

Now run the JTB FlexReport Client installer.

Favorites data is saved in this folder on the client:
%LOCALAPPDATA%\JTB World\JTB FlexReport Client\Gallery
For example: C:\Users\jtb\AppData\Local\JTB World\JTB FlexReport Client\Gallery
These can be made backup of or be copied to another computer if need be.


Q. How do I move the JTB Process Monitor Service installation from one server to another?

A. If you want to avoid re-configuring, first create the folders like you already have it on the existing server.

Default locations are:

For the folder below copy JTBFlexReportLicense.txt and all .config files. For newer versions the license file is not used. In Configurator click License Activation and file instructions. 

C:\Program Files (x86)\JTB World\JTB Process Monitor Service

Copy the below folder and all files in it to the new server:

C:\ProgramData\JTB World\JTB Process Monitor Service

Run Regedit and export and import this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB Process Monitor Service

Now run the JTB Process Monitor Service installer.


Q. How can I update the database from an older version of JTB FlexReport

A. If it was some versions between the old and the new JTB FlexReport it is a good idea to stop all JTB services, delete the -temp mdb if MS Access is used for database, click on the Update DB button on the General tab in JTB FlexReport Config, start the JTB services. If SQL Server database is used you might need to use the update script “JTB FlexReport SQL create and copy db version <version>.txt” found under https://jtbworld.com/jtb-flexreport#download 

Sometimes this update is not able to solve all problems on MS Access databases. A more thorough method for MS Access databases is using JTB FlexReport Merge DBs <version number>.zip found in the JTB FlexReport folder, extract JTBFlexReportMergeDBs - manual start.mdb and follow the instructions in the .txt file. This can solve bloating databases due to missing or incorrect indexes.


Q. How do I start with a new database?

A. Stop allJTB services that are running.

Then find out what the current main database you have is. Run “JTB FlexReport Config” and click on “Launch Service Configurator” button.

MS Access:

If the name is “JTBFlexReport.NET.mdb”, locate the corresponding temp database that is having the -temp extension. In this case “JTBFlexReport.NET-temp.mdb”. This -temp database can safely be deleted as it is recreated by the sampling service based on the main database.
If you have created groups in the Group Administrator or have added feature or server descriptions or other things in JTB FlexReport Config>Features or Server you run JTB FlexReport Config>Database Administrator and move or delete data (log data and Detailed Log data). Use a larger date range that what exists in the database. End by using the Compact the Main Database button.
Otherwise you need an empty database to start with. In the “JTB FlexReport” folder there is a file named “JTBFlexReport.NET (extra empty copy).mdb” that is an empty copy of the database. On https://jtbworld.com/jtb-flexreport#download below other downloads there is “JTBFlexReport.NET.mdb <version>.zip” that can be downloaded. If you want make a backup of the main database, rename it or delete it. Either take a copy of “JTBFlexReport.NET (extra empty copy).mdb” and rename it to “JTBFlexReport.NET.mdb” or use the downloaded empty database and put in the same folder as the old one was.

SQL Server:

To keep groups and descriptions use a script. Use the delete old data script here: https://jtbworld.com/jtb-flexreport#download

To start completely from scratch, backup and delete the database. Then follow the steps in the JTB FlexReport Core documentation PDF on how to create a new database.

Start all stopped JTB services. After a little while click on either Features or Servers and verify that these are populated. You can also check the HTML reports or any other reports later on.


Q. How to improve performance using SQL Server? 

A. Regarding performance. Set up the maintenance plan and add the reorganization tool. 

1 – add a maintenance plan under management/maintenance plans. It’s a good idea to create a backup sub plan, and whatever others make sense. Add a reorganize subplan
2 – from the toolbox on the left add the reorganize index task to the subplan by dragging it over
3 – edit the properties – set it to reorganize the system dbs (msdb) and JTB database and possibly master. 

Run the job from the SQL server agent and/or schedule it

After that you could script job as…to a new query window and see how it works – here is the sql
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Reorganize index',
@step_id=1,
@cmdexec_success_code=0,
@on_success_action=1,
@on_success_step_id=0,
@on_fail_action=2,
@on_fail_step_id=0,
@retry_attempts=0,
@retry_interval=0,
@os_run_priority=0, @subsystem=N'SSIS',
@command=N'/Server "$(ESCAPE_NONE(SRVR))" /SQL "Maintenance Plans\Flexreport_MaintenancePlan" /set "\Package\Reorganize index.Disable;false"',
@flags=0

To avoid the transaction log (.ldf) growing too large you can set the recovery mode to 'Bulk-Logged', where it will directly commit into data file (.mdf) while making transactions and hence the transactions will not be recorded into .ldf files, thus resulting in a reduced file growth. But one thing to consider in this method is that the point in time recovery will not be available if we make recovery mode to 'Bulk-Logged' .

See also: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server

Use the following command to set bulk-logged recovery model :

ALTER DATABASE your_database SET RECOVERY BULK_LOGGED


 Q. Why is there duplication showed in the reports?

A. It was due to the license file having two VENDOR lines in it. The version of lmstat on the server returns a report for each VENDOR, hence we were getting two sets of results. If the results were exactly the same then this did not seem to be an issue. If there was a difference in the license usage then both totals were added together. Removing one of the Vendor lines from the license file has fixed the problem.


File location on other servers, usage of UNC paths

Normally a Windows service like the JTB FlexReport Core Service cannot access files on other servers. Mapped drives to other servers cannot be used by the service. UNC path or a local drive must be used. One option is to install JTB FlexReport on the server where the log file is located or make a scheduled task that copies the log file to the server where JTB FlexReport is located.

To access log files on other servers than where JTB FlexReport’s service is running changing the account the service is running on can be needed in combination with UNC path.

Open Windows Services and look for the JTB FlexReport Core Service and if you have "Log On As" set to "Local System" you can try to change Log On As to the local administrator account instead as the SYSTEM or Local System account does not have network access. You'll need to switch the service to use either NETWORK SERVICE or a network user account or a unique domain user account such that you can access the network drive. After that stop and start the service.

Note that if you use a non-working account JTB FlexReport will stop working. A quick way to see if it works after restarting the JTB service is to first activate the JTB debug log on the Advanced tab and then see if JTB is writing to the log. Another is to check if the JTBFlexReport2.htm is updated at the next snapshot.

You can sometimes use a local user account and add specific required privileges or change system access control list (SACL) entries.

Unique user account. You can assign additional administrative privileges to the unique account for which the service is configured, but only if necessary. You should also limit the unique account's group membership to those groups that are required. Unique user accounts should conform to an organizational policy for secure password use. If multiple computers use the same service or related services, the passwords across each unique user account should also be required to be unique.

The Network Service account is a special built-in account that has reduced privileges similar to an authenticated user account. This limited access helps safeguard the computer if an attacker compromises individual services or processes. A service that runs as the Network Service account accesses network resources using the credentials of the computer account in the same manner as a Local System service does. The actual name of the account is NT AUTHORITY\NetworkService, and it does not have a password that an administrator needs to manage.

Domain Administrator accounts includes the built-in domain Administrator account that you create and use when you first install Active Directory. Try to avoid using this account as it can be a security issue. It includes any other user accounts that you subsequently create and add to the built-in local Administrators group or to the Domain Admins or Enterprise Admins groups. Members of these groups have complete and unrestricted access to the domain and, in the case of the Enterprise Admins group, to the entire forest. You might need to change location to the Corporate Domain, to get the ability to choose the Domain Administrator.

For more details see the Windows Services and Service Accounts Security Planning Guide http://technet.microsoft.com/en-us/library/cc170953.aspx and about User Rights http://technet.microsoft.com/en-us/library/bb457125.aspx


Q. Why is the FlexNet license manager returning this error? License server status: 27000@server Error getting status: Cannot connect to license server system. (-15,10:10061 "WinSock: Connection refused")

A. The most common reason is that the port number is wrong. It might happen because it was changed on the license server or not correct in the first place. How to specify the port to be used by FlexNet license manager and How to find the port used by a FlexNet license service

Other more advanced reasons for this error can be:

Lmgrd.exe might have restricted file or folder permissions.

A solution could be that 2 services are running in the license manager with conflicting portnumbers.

The following command was run on the server where FlexNet license manager is installed. The server is a virtualized Windows 2008 std server.

lmutil.exe lmstat -a -c 27000@server

[Detecting lmgrd processes…]
Error getting status: Cannot connect to license server system. (-15,10:10061 “Winsock: Connection refused”)

The FlexNet debug log also had this information.

16:27:23 (lmgrd) adskflex exited with status 58 ()
16:27:23 (lmgrd) Since this is an unknown status, license server
16:27:23 (lmgrd) manager (lmgrd) will attempt to re-start the vendor daemon.
16:27:23 (lmgrd) EXITING DUE TO SIGNAL 1

There were no problems with the ports and firewalls as they were opened. LMTOOLS.EXE did not show any problem on the status.

Using IP instead of server name resulted in this message:

lmutil - Copyright (c) 1989-2007 Macrovision Europe Ltd. and/or Macrovision Corporation. All Rights Reserved.
Flexible License Manager status on Tue 10/20/2009 15:49

[Detecting lmgrd processes...]
Error getting status: Cannot find license file. (-1,359:2 "No such file or directory")

Other errors that also might show up are some or all of these:

The TCP port number in the license, [portnumber], is already in use.
(adskflex) Unable to initialize access to trusted storage: 1
(adskflex) Failed to open socket to lmgrd, Exiting
(adskflex) EXITING DUE TO SIGNAL 28 Exit reason 5
(lmgrd) Can't send reread to adskflex: Cannot read data from license server system. (-16,10009:10054 "WinSock: Connection reset by peer")
(lmgrd) adskflex exited with status 28 (Communications error)
(lmgrd) Since this is an unknown status, license server 
(lmgrd) manager (lmgrd) will attempt to re-start the vendor daemon.

Eventually the solution found. The problem was caused because of Windows DEP (Data Execution Prevention) on the server. DEP simply killed lmgrd from doing its job.

The solution is:

  • Stop the license service using LMTOOLS.EXE or in Windows Services.
  • Stop any process in Task Manager like lmgrd.exe and adskflex.exe (or whatever the vendor daemon is named).
  • Start the DEP program from Control Panel > System > Advanced > Performance Settings > Data Execution Prevention.
  • Add an exception for LMGRD.exe and possibly also LMUTIL.EXE, LMTOOLS.EXE and the vendor EXE where the license manager is installed.
  • Restart the service and it should work.

DEP might also have the effect that LMTOOLS.EXE crashes or that you just notice that the license service is stopped after a while and you cannot check out any licenses. The problem is no only on Windows 2008 server but have been seen also on Windows 2003 server


Q. I get this Error getting status: Cannot connect to license server system. (-15,10:10060 "WinSock: Connection timed out")

A. Solution is usually to open any of the ports being used.


Q. When I try to run the client at a Windows (XP or 7) workstation, I get the error message “Could not connect to http://192.168.1.1:2000/Service. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.1.1:2000.” Then it says “Please start JTB FlexReport Service before running JTB FlexReportClient.” I’ve verified that the Windows Firewall is off on the server, so there shouldn’t be anything in the way of connecting.

A. Make sure first that the service is running. Check in Windows Services. Try otherwise to use another port for the chart service and the client. Try a port number in the range 2000-2050.


Q. When I try to run the client I get the error message “Could not connect to http://192.168.1.1:2000/Service. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.”
The port is listed as an exception in Windows Firewall.

A. To get this working you needed to explicitly open the port in the firewall on the client and the server.


Q. Why is Esri ArcGIS showing too many licenses?

A. A couple of customers of JTB FlexReport reported about an issue with the the usage monitoring of Esri ArcGIS licenses (like ARC/INFO, Grid, Tin, Viewer). The number of issued licenses and the number of licenses in use were 2-5 times higher than what the ArcGIS License Server Administrator showed. We found that it was the FlexNet tool lmutil.exe that caused this problem. lmutil.exe v11.12.1.4 and v11.12.1.2 did not work but v11.11.1.2 and v11.11.1.0 did work. Thus the solution was to take an older version of lmutil.exe and put in the JTB FlexReport folder. This will only correct data logged after changing the version. 


Q. When I try to create a report in the Chart Client I get the message "Cannot find table 0." and in the FlexReportService.log it says System.Data.OleDb.OleDbException (0x80004005): Not a valid bookmark. 

A. Open JTBFlexReport.NET.mdb (or whatever the main database is named) in MS Access (you can do it on any machine with MS Access installed) and run Compact & Repair it will solve the problem. During the process it might be needed to stop all JTB services. Start them again when ready.


Q. When I try to run the chart client the program hangs and just shows the splash screen. There is no error in the log files and no dialog box behind using Alt+Tab. The server with the SQL Server also starts to run slowly taking a lot of CPU.

During testing the following simple query timed out on the SQL Server.

SELECT COUNT(DateTime) FROM log
Msg -2, Level 11, State 0, Line 0
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

A. We found out eventually that the hard disk was almost full on the server.


We have now setup the FlexLM options file (.OPT) to control access to licenses based on host groups (HOST_GROUP) and the IP address of the PC. Can we report usage in JTB FlexReport based on these groups?

Unfortunately not at this point as there is no direct way to match the know information user or host with an IP number. There are ways to work around this though so it might be supported in a future version.

The Group Administrator makes it possible to create groups based on IP.


Q. Trying to start the service gives the following error and can apply to any of the JTB services. "Cannot start service JTB FlexReport Sampling Service on computer '.'. : Please try again"

A. The solution is to open Windows Services and open properties for the service in question and set the startup type to Disabled and press Apply and then set the startup type to automatic and press Apply followed by pressing Start.


Q. I get this error running the client: There was no endpoint listening at http://server/JTBFlexReportService/Service.svc that could accept the message. This is often cause by an incorrect address or SOAP action. See InnerException, if present, for more details.

A. Make sure that the port settings are correct and done in the configurators for both the service and the client.

Make sure the port is opened through firewall on both client and server.

Try to run the URL in a web browser and see what it says. A message like "The server at 192.111.10.10 is taking too long to respond." indicates that the port is not open all the way between client and server.

Try to use IP instead of server name.


Q. Is Vault supported?

A. Autodesk Vault Collaboration, Autodesk Vault Professional and Autodesk Vault Workgroup can be reported usage of but it is not possible to see what users are using the licenses as FlexNet only reports information like this where AutodeskVault is the fixed user name:
OUT: "85753VLTM_2012_0F" AutodeskVault@server


Q. Recently one of our software vendors (IBM) has switched to using a Common Vendor Daemon that supports their previous secondary daemons, even though the secondary daemon names appear in the feature lines. It seems that any feature with a secondary daemon in the feature line is not reported.

A. The lmutil included (11.9.1) only returns the Common Vendor Daemon name with no products under Feature usage info:(lmutil lmstat -a -c port@server) Replacing the 11.9.1 version with the 11.3 version of lmutil works and the feature lines appear along with the Common Vendor Daemon name. My test licence file contains only features using the secondary daemons. I suspect if I had feature lines using the Common Vendor Daemon explicitly then these would be reported but I cannot yet test this assertion yet but will be able to soon.


Q. I have Autodesk suite licenses but I don't know what actual product was being launched on the client computer because what is reported is only the feature the product use at any point in time and that can be any of the features included in the suit's package.

A. Unfortunately neither lmutil lmstat nor the FlexNet debug log provide this information. So this information cannot be retrieved on the license server. The workaround would be to use the JTB Process Monitor module for JTB FlexReport.


Q. How often is the SPLM client taking a snapshot of usage?

A. Client interval is by default every 10th minute but can be changed by editing the this registry location
HKEY_LOCAL_MACHINE\SOFTWARE\JTB World\JTB FlexReport SPLM Client
and set Interval_SPLM to another value (in minutes). On 64-bit OS the location is HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JTB World\JTB FlexReport SPLM Client.


Q. I have problem accessing usage from some LUM servers.

A. Following is a solution from a customer. February 2012. I finally got that LUM issue fixed. We installed the Hotfix 15 on the license server and with this fix, i4blt works without i4ls.ini in place.
Therefor it obviously also doesn't matter anymore, what is defined in i4ls.ini.

I defined all servers, grouped as clusters in JTB FlexReport and I get correct output for each cluster now.

Regarding the delay for unavailable servers, this is still the case, but there is a system variable available, called TIMEOUT_FACTOR, which defines the time, LUM is waiting for an unavailable server.
I defined the variable now, which reduces the waiting time from 160s to 16s, which is acceptable for me.

So up to now, LUM logging looks good to me.


If you get the error “Cannot open database"<database name” requested by the login. The login failed. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGIN'.” The JTB services are by default running using the “Local System” account. Change them to run with an account that has access to the SQL database. Another solution is to use SQL authentication connection.


Q. How can I update the database after moving a license file to another server.

A. Here are the update queries to change specified feature from being on one server to be on another server. Modify as needed.

PLIST is the name of the feature so you need to change PLIST to what you have and also the names of the servers. 'SERVER A' is the old server name and 'SERVER B' is the new server name.

If you want to be on safe side take backup of the database first.

UPDATE log SET log.ServerName = 'SERVER B'
WHERE (((log.ServerName)='SERVER A') AND ((log.AppName)= 'PLIST'))

UPDATE tblUserDetailedLog SET tblUserDetailedLog.ServerName = 'SERVER B'
WHERE (((tblUserDetailedLog.ServerName)= 'SERVER A') AND ((tblUserDetailedLog.AppName)= 'PLIST'))

UPDATE tblUserDetailedLogPrev SET tblUserDetailedLogPrev.ServerName = 'SERVER B'
WHERE (((tblUserDetailedLogPrev.ServerName)= 'SERVER A') AND ((tblUserDetailedLogPrev.AppName)= 'PLIST'))

After this run JTB FlexReport Service Configurator and click on "Sampling All Records" button. The Configurator can be closed while this is working in the background.


Q. When using Test Service Engines I get the error: Please start the Services before testing. The remote name could not be resolved: 'localHost'. But I had started the services right before pressing the test buttons in the JTB FlexReport Service Configurator. The client configurator also shows error when testing service engines.

Another error showing in a dialog box and also in Windows Event Logs: Could not load type 'System.Runtime.Diagnostics.ITraceSourceStringProvider' from assembly 'System.ServiceModel.Internals. Version=4.0.0.0. Culture=neutral. PublicKeyToken=31bf3856ad364e35'.

When manually checking if the JTB FlexReport Auto Chart Service and JTB FlexReport Chart Service are running I find that they are not running and after starting them they stops directly.

.NET Framework 4.5 is installed.

A. This issue can be resolved by installing .NET Framework 4.5.2 or newer (http://www.microsoft.com/en-us/download/details.aspx?id=42642)
After that you will need to restart the server and the issue should be fixed.


Q. AVEVA monitoring is not working as expected.

lsmon.exe gives this error:

Sentinel RMS Development Kit: Error[5]: Cannot talk to the license server on host "hostname123". Server not running??

A. lsmon.exe version 9.2.1 (AVEVA RMS 9.2.1.0011) does not work like old 8.5.3 version.

Copying old version of lsmon.exe to C:\Program Files (x86)\JTB World\JTB FlexReport\lsmon.exe solved the issue.


Q. How to move an SQL Server database to another server?

A. Take a backup of the database and restore it on the new server and make sure the account settings to access it are the same.

Then change the database settings in JTB FlexReport Config, JTB FlexReport Service Configurator and optionally JTB Process Monitor Service Configurator and JTB SPLM Service Configurator.

Then restart all JTB services.

Verify that reports are still working and new data is logged. This can be done a few hours or a day after.


Contact us if you have a question that is not answered here.

­