Print and Print Preview not working

We are running 905.607a Progress 32Bit database.

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?

Thanks,
Mike

Does the System Monitor launch on the clients? Does it show anything on the Scheduled Tasks tab?

Check the System Agent. is it started? Set to Auto start?

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.

Thanks,
Michael

How did you clear the systask table?

Truncate/delete all the records in the SysTask table.

1 Like

could you give me the full sql syntax to do this?

I know had this issue in previous company because i didn’t start everything in the correct order. Do you only have one server to 2 APP servers?