This started yesterday afternoon on production database where printing and print preview is not working.
Doesn’t matter if it is standard canned reports or customized reports that don’t work.
Rebooted the server, stopped and started the appservers with no luck.
We also have Test database on the same server and the printing works on it.
I restored a backup of Live db onto our Pilot db and getting the same no printing or print preview.
Any suggestions as it seems to be related to the live database?
Also try going to system agent and looking at which user is set on the main screen .
Then with the user name go to user security and make sure they are set to active…not inactive.
This printing issue has been resolved. Not an easy fix as I haven’t seen anything like this in past 5 years. Tried all the above and even removing system agent and adding it back.
It was related to the SysTask table. This table contains history of print jobs/reports and somehow had records/jobs that didn’t complete or was corrupted which prevented all further printing from being released to system monitor.