The PPM or Agile Admin tool may show you have X number of licenses available but when you try to add a user to a license it may say you don't have any left. The following sql statements can be run against the database to help troubleshoot where the discrepancy may be.
This statement may change without notice so always check the hardware and software requirements for the application you are using for the most up to date information, or contact Customer Support for further assistance. Here is the link to Microsoft’s article on support for SQL Server 2000
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PES_View_Action". The conflict occurred in database "Western", table "dbo.PES_View", column 'vw_UID'.
