The Pharos License Server status in the Pharos Administrator shows as "Unable to determin status"

Problem:

After an recent upgrade of the Uniprint software the Pharos License Server Service shows in the Pharos Administrator as below with the message "Unable to determine status"

The License Server Service, by design does not show in the Pharos Administrator application under System > Servers.

When Uniprint first started out the Pharos Administrator was an in-house developed application and the services were not listed in the Admin.

The last version to use the in-house created application was Uniprint 7.2. In Uniprint 8.0 and greater the Pharos Administrator was converted to using a MMC (Microsoft management Console) and has been that way since.

Root cause of why it is changed to show in the Pharos Administrator indicates something a database upgrade was did not go as planned.

This is not a widely occurring event and has only been seen once so far.

Resolution:

The root cause is the 'services' Table in the Pharos database has an entry in it for the License Service. There should not be an entry in the 'services' Table that corresponds to a service_type_id of 5.

Using SQL Management Studio open a new query window and run the below queries to determine the server-id associated to the LServer and remove it from the services table.

**Make a backup of the database before making any changes**

use pharos

select * from servers

*Locate the server_id that corresponds to the Principal Server.

use pharos

select * from services where service_type_id = 5

*The server_id should bt that of the server from the first query.

Next is to delete this entry in the 'services' Table.

use pharos

delete from services where service_type_id = 5

If you have any questions about the above steps please contact Pharos Support before making any database changes.

For Internal Support and Resellers:

The root cause is the 'services' Table in the Pharos database has an entry in it for the license Service. There should not be an entry in the 'services' Table that corresponds to a service_type_id of 5.

Using SQL Management Studio open a new query window and run the below queries to determine the server-id associated to the LServer and remove it from the services table.

**Make a backup of the database before making any changes**

use pharos

select * from servers

*Locate the server_id that corresponds to the Principal Server.

use pharos

select * from services where service_type_id = 5

*The server_id should bt that of the server from the first query.

Next is to delete this entry in the 'services' Table.

use pharos

delete from services where service_type_id = 5

If you have any questions about the above steps please contact Pharos Support before making any database changes.