Configuration Profiles

[khurram]

iPad is enrolled into JSS using Apple Configurator but Configuration Profiles are not taking effect.
On iPads already being used, the Configuration Profiles won't take affect when we change them among different user groups.

Any clues? whats wrong here. why configuration profiles are not taking affect.

[davidacland]

Hi,

Can you send any push notifications to the device such as device lock, wipe etc? It sounds like the enrollment isn't happening correctly.

Does it all work if you do a web based manual enrollment on an iPad?

[khurram]

Hi @davidacland Thanks for the reply. I have checked the server logs and it mentions that one of the table mobile_device_management_commands is marked as crashed. Data Source status is: CONNECTION ALREADY CLOSED. Connection Handle status is: DB access problem. Killing off this connection and all remaining connections in the connection pool.
I restarted MySQL and Tomcat, MySQL started successfully but started and now it is stuck at screen showing "Checking for tables to rename".

I think I might have to replace this table from old JSS database backup.

[davidacland]

Hi, that sometimes happens after a JSS upgrade. It fails to rename one of the tables. If you look in the JAMF server log when you startup tomcat it should tell you which table it can't rename. It's usually a legacy copy of the table and you can delete it.

[RobertHammen]

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

would be my first shot at repairing the database, before trying any restores from backup...