- 12 Apr 2024
- 2 Minutes to read
- Print
- DarkLight
- PDF
When I open the Pharos Reports application I get a license error or license warning about unmanaged devices.
- Updated on 12 Apr 2024
- 2 Minutes to read
- Print
- DarkLight
- PDF
Environment:
Uniprint 8.3 and greater.
Problem:
When I run the Pharos Reports application it will either prompt me with a message about ex ceeding the number of unmanaged devices or will not run because I have exceeded the number of unmanaged copiers.
The two possible styles of errors are below.
Max Unmanaged Printers you are licensed for is 0, but there are 1 in the database. Pharos Reports will stop working if you exceed the number of licensed unmanaged printers or copiers by 20%, or 2 devices, whichever is the greater.
Max Unmanaged Copiers you are licensed for is 0, but there are 3 in the database. You have exceeded the number of licensed unmanaged printers or copiers by 3. Pharos Reports will stop working.
Cause:
The unmanaged Printer/Copier problem is the result of devices reporting transactions to the system but not having the particular function being managed.
Troubleshooting:
We first need to determine what devices are missing the expected functions, copy or print, and then we can correct the settings for those devices and delete any null devices that have been created. Here is a SQL query that should help use determine what devices we need to look at.
SELECT
d.device AS [DeviceName],
ps.pstn_name AS [ReleaseStation],
CASE
WHEN ps.pstn_types = 1 THEN 'Print Station'
WHEN ps.pstn_types = 3 THEN 'PrintCopy Station'
ELSE 'Other'
END AS 'StationFunctions'
FROM devices d
JOIN printers p ON d.device_id = p.printer_id
JOIN p_station_printers psp ON p.printer_id = psp.printer_id
JOIN edi_pharos_stations eps ON psp.pstn_id = eps.pstn_id
JOIN pharos_stations ps ON eps.pstn_id = ps.pstn_id
WHERE device_type = 1 and managed_device_type = 1
Run this query on the Pharos DB.
There can also be a problem when there are more than one device in the DB that have the same IP address assigned. When the Station/Terminal is set to Copy/Print then the Device should match those capabilities. If there are devices with duplicate IP addresses then the first active device we find will be used for that evaluation of settings.
The next step would be to delete the Null devices and get the Reports to working again. Then see if any null devices come back over time. They should not as long as all the devices and station functions are set correctly.