-
All replies
-
Helpful answers
-
Mar 19, 2014 9:49 AM in response to cragiboyby mscott_mdm,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.)
-
Mar 19, 2014 10:36 AM in response to mscott_mdmby mscott_mdm,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'"
-
Mar 20, 2014 12:52 AM in response to mscott_mdmby cragiboy,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.
-
Mar 20, 2014 7:39 AM in response to cragiboyby mscott_mdm,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.
-
Apr 21, 2015 12:50 PM in response to mscott_mdmby mscott_mdm,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'"