Summary:
The TIBCO Scribe® Insight Adapter for Dynamics GP counts users that have access to a GP company by default.  When the GP registration information is available, the adapter will count concurrent users.  This article explains how the TIBCO Scribe® Insight counts GP users and provides a SQL script to assist in troubleshooting.

When the Dynamics GP user count is exceeded, Insight will provide alert messages during the 15 day grace period.  When the grace period expires, runs will fail with an error message.  If you exceed the user count with your first connection, there is no grace period and runs will fail with an error message.

Alert message:
There are too many ERP users for the current Scribe license. In [nn] days, DTS files and Integration Processes will not run unless you upgrade your Scribe license or reduce the number of ERP users. 

Error message:
Execution terminated - There are too many CRM/ERP users for the current Scribe license. The grace period has expired for one or more adapters. Insight will not run until you upgrade your license. Contact your Scribe Reseller or Scribe Sales Representative.

The TIBCO Scribe Insight Adapter for Dynamics GP counts users that have access to a GP company. This article explains how TIBCO Scribe Insight counts GP users and provides SQL scripts to assist in troubleshooting.

By default, the TIBCO Scribe® Insight for Dynamics GP adapter counts the total number of named users in Dynamics GP.  If the GP registration information is available, the adapter will replace the default user count with the GP concurrent user count.  To troubleshoot, compare the user count from the Workbench with results from the SQL script below.

1. Launch the Workbench and go to Help > Show User Counts.  Note the ERP total user count.  For more information, see article Counting Users In TIBCO Scribe® Insight.
2. In SQL Server Management Studio, run the following SQL script against the DYNAMICS database to count users with access to a GP company.

           SELECT COUNT(DISTINCT(U.USERID)) FROM DYNAMICS.dbo.SY01400 U JOIN DYNAMICS.dbo.SY60100 C ON C.USERID=U.USERID WHERE C.CMPANYID <> -1

3. If the Workbench “Show User Counts” indicates all named users (SQL script in Step 2),  install the GP client on the Scribe server to bring the Insight count down to the concurrent count per your GP license.  For more information, please see the TIBCO Scribe Insight Online Help.
4. If you are unable to install the GP client or the GPReg.dll on the Scribe server, you can remove some Named users to reduce the user count, or contact TIBCO Scribe® Sales to upgrade to the next product tier.
5. After GP users have been adjusted, unregister and re-register Insight to reset the ERP user count.