Product Registration Error Message
7 January 2012
When a product's registration keys appear to 'stop working' suddenly, and the keys are still valid, you could be experiencing orphaned user records in your Accountable Software User Activity table.
If this is the case, you would usually get the registration error message erratically, when your user limit is exceeded.
To rectify the issue, you need to remove any old records from the Accountable Software User Activity table (ASI00998), located in the DYNAMICS database in your SQL Server. The old records would be ones with old date and time values in the LOGINDAT and LOGINTIM columns in the table.
The first thing to check is the Accountable User Activity window in Great Plains. The ASI User Activity window can be added to the shortcut bar in Great Plains. It is located in the Company Series of the Forms Printer product folder in the Shortcut bar's window list. If the ASI User Activity window shows that there are more Accountable product users in the system than there should be for a particular product, then you will need to remove the orphaned records from the Accountable Software User Activity table. It may be easiest to do this at the end of the day when there are few users in the system.
You should be able to compare the users listed in this table, with the users logged in to Dynamics (Setup->System->User Activity.)
To remove the orphaned records from the Accountable Software User Activity table:
1. Open up SQL Enterprise Manager and navigate to the DYNAMICS database tables.
2. Find the ASI00998 table, click on it to highlight it.
3. From the menu at the top of the window, select 'Action', then select 'Open table', then select 'Return All Rows'.
4. Select each row that contains a user id that was not in the Great Plains User Activity table and hit the 'Delete' key on your keyboard. You will be prompted to verify you really want to delete that row.
There are two ways in which users who crashed out of Great Plains could be removed from the Great Plains User Activity table (ACTIVITY) and not be removed from the Accountable Software User Activity table (ASI00998), leaving orphan records in the Accountable Software table. Either they were removed manually from the ACTIVITY table, but not from the ASI00998 table, or they were removed from the User Activity window in Great Plains on a machine that does not have Accountable's products installed.
In the future, if anyone crashes out of Great Plains, you should remove them from a User Activity window on a machine that has an Accountable product (ex: AnyView Creator or Forms Printer) installed, or else remove them from both the ACTIVITY table and the ASI00998 table in SQL Enterprise Manager.