Apple Event: May 7th at 7 am PT
Everytime I click on completed tasks in profile manager, I get the error message "A Server Error has Occurred" and am told to reload the page, but it keeps doing the same thing. I am not able to view my competed tasks. Is anyone seeing this same issue or have a solution?
Thank you.
Mac mini, OS X Server
We have the same problem and I'm looking for a solution. With os x server 2.2, I was able to delete completed tasks with this command:
sudo psql -h "/Library/Server/PostgreSQL For Server Services/Socket" -U _postgres -d device_management -c "TRUNCATE TABLE tasks;"
but this command does not work with os x server 3.0.1!
Same problem
There are foreign keys used now in the task list I think. I did a cascading truncate on the table 'library_item_tasks' and that seemed to do the trick.
On a second note, I would recommend pgadmin3 as a graphical database management utility for performing these sort of tasks and exploring the various profile manager tables.
Be very careful using TRUNCATE in the Server 3 Profile Manager database. Due to the rules for cascading truncation and foreign key references, you can very easily truncate tables you had no intention of truncating. (Learned that one the hard way myself. 😉)
This command will (safely) clear all the completed tasks:
sudo psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "DELETE FROM library_item_tasks WHERE completed_at IS NOT NULL"
Leave off the WHERE clause to delete all tasks safely.
This command solved the completed tasks error. Thanks!
OS X Server 3.0.1 Completed Tasks Error
