Mac mini, OS X Mountain Lion (10.8.3), Server
cragiboy,
Please try this to see if it restores proper Profile Manager functionality:
sudo psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "UPDATE devices SET last_update_info_time = dm_current_timestamp() + '1 month'"
Copy the above and paste it into Terminal (or remote ssh shell) on the server as an admin user. You'll almost certainly be prompted to enter your admin password.
Please let me know if this seems to fix the problem for you. (It might not be immediate, but it should show signs of working within a few minutes.)
I would also recommend that you run this command, to keep newly-enrolled devices from causing the same problem after a couple of days:
sudo psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "ALTER TABLE devices ALTER COLUMN last_update_info_time SET DEFAULT dm_current_timestamp() + '1 month'"
sorry mscott_mdm, but this did not solve the problem. it only works when i reenroll the devices. but i can not do this for 550 devices.
cragiboy,
Do you happen to have the output of the first command (the one with "UPDATE devices", not "ALTER TABLE devices")? If so, can you paste it hee? (It's OK to run that command again and paste that output if you don't have the original.)
Thanks.
Please note, if you applied the "ALTER TABLE" workaround I mentioned in this thread, you will need to apply the workaround I posted in Server 4.1 Profile Manager Migration Failed before you can successfully upgrade to Server 4.1. I would recommend doing this before you install Server 4.1 if you haven't already.
sudo psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "ALTER TABLE mdm_targets ALTER COLUMN last_update_info_time SET DEFAULT 'epoch'"
Push in Profile Manager 3.1 doesn't work
