Newsroom Update

Beginning in May, a special Today at Apple series titled “Made for Business” will offer small business owners and entrepreneurs free opportunities to learn how Apple products and services can support their growth and success. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Server 4.1 profile manager: Unable to register IOS device: SQL ERROR

I try to register several IOS 8.1 devices in profile manager. I'm able to download and install the trust profile. I can install the registration profile but the registration could not be finished. If I check the logs I could found an in a database query:

Jul 28 10:47:03.668 [49541] <192.168.200.3> {LogPDOException (common.php:276)} PDOException: 'SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for uuid: "308FLO-86142ED8-3CDE-4FA7-BDD0-769787967D9F"' (info: '[ 22P02,7,ERROR: invalid input syntax for uuid: "308FLO-86142ED8-3CDE-4FA7-BDD0-769787967D9F" ]', code:22P02)

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #0 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/db .php(689): PDOStatement->execute()

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #1 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/db .php(709): _execute_statement(Object(PDOStatement))

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #2 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/db .php(273): _execute_statement_and_fetch(Object(PDOStatement))

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #3 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/db .php(287): FindBySQL('profiles', 'WHERE "uuid" = ...', Array, '')

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #4 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/ta sk.php(885): FindInDatabase('profiles', 'uuid', '308FLO-86142ED8...')

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #5 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/ta sk.php(656): _parse_profile_list(Array, 15, false)

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #6 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/md m_connect.php(44): Task_handle_response(Array, Array)

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #7 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/db .php(396): _connect_transaction_1(Array)

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #8 /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/php/md m_connect.php(126): PerformInTransaction('_connect_transa...', Array)

0::Jul 28 10:47:03.668 [49541] <192.168.200.3> #9 {main}

1::Jul 28 10:47:03.669 [49541] <192.168.200.3> {SendFinalOutput (common.php:495)} Sent Final Output (25 bytes)

1::Jul 28 10:47:03.669 [49541] <192.168.200.3> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ - /devicemanagement/api/device/mdm_connect

0::Jul 28 10:47:03.669 [49541] <192.168.200.3> {SendFinalOutput (common.php:495)} Completed in 15ms | 500 Internal Server Error [https://myServer.my-domain.net/devicemanagement/api/device/mdm_connect]



Any ideas how to fix this?

I already have done a complete reset to defaults of profile manager.

OS X Yosemite (10.10.4)

Posted on Jul 28, 2015 2:15 AM

Reply

There are no replies.

Server 4.1 profile manager: Unable to register IOS device: SQL ERROR

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.