Q: Managed Settings missing in Profile Manager after upgrade to Server 3

Question

brianw815

Level 1 (5 points)

Q: Managed Settings missing in Profile Manager after upgrade to Server 3

I have a semi-production rollout of Macs and iPads using Pofile Manager for managed settings. All had a Trust Profile and Enrollment profile installed from ML server. After upgrading to Mavericks and Server v3, all my managed preferences (and all enrolled devices!) are missing from Profile Manager. All the Device Groups I created in ML Server are still there, but the devices are no longer present. It's a small rollout, so I can re-enroll them if necessary, but it's still a hassle.

Any ideas?

OS X Server

Posted on Oct 22, 2013 6:09 PM

I have this question too

Q: Managed Settings missing in Profile Manager after upgrade to Server 3

All replies

Helpful answers

Page 1 of 3 last

by JJSagona,

JJSagona Oct 23, 2013 6:08 AM in response to brianw815
Level 1 (0 points)

Oct 23, 2013 6:08 AM in response to brianw815

I am having the same issue, only I show the devices still as present in the device list, but no longer assigned to their appropriate device groups. I am trying to piece that together, since we are only at 150 or so devices. But, we are also missing all of the configured policies which is really part of the nightmare.

I also have a series of frozen active tasks that cannot be canceled now either. I suppose my best advise to folks following in my mistaken footsteps would be to clear out all active tasks from PM before beginning the Mavericks upgrade.
Reply options

Link to this post

by sosnovsken,

sosnovsken Oct 23, 2013 4:23 PM in response to brianw815
Level 1 (0 points)

Oct 23, 2013 4:23 PM in response to brianw815
I am having similar issues.

My device groups still exist
They are empty
All the settings associated with said groups are gone
All of my enrolled devices are gone

I'm calling support right now and will update with more information when I get the word from Apple.
Reply options

Link to this post

by Rhodan_0x10,

Rhodan_0x10 Oct 23, 2013 10:31 PM in response to sosnovsken
Level 1 (10 points)

Oct 23, 2013 10:31 PM in response to sosnovsken

Morning guys,

let me ask a interposed question: I'm in trouble with profilemanager in some diffrent way, see thread , the profiles I downloaded over mydevices are not signed. May you check your profiles if they are signed and check your logfiles for any errors? Espacial the profilemanager.log, I get following error on loading or sending out profiles:

[7790] [2013/10/24 07:09:45.837] I: Processing ProfileController#get_ssl_cert_profile (for 192.168.232.10 at 2013-10-24 07:09:45) [GET]
[7790] [2013/10/24 07:09:46.006] [1;7;31mEXCEPTION: [0;31m Error <-[SCEPHelper getCMSSignedData:certPath:keyPath:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Base/Support/SCEPHelper.m:181): "'((SCEPHELPER_GetCMSSignedData(self.connection, data, dataCnt, certPath, certPathCnt, keyPath, keyPathCnt, &signedData, &signedDataCnt)))' error -50"> [0m [0m
[7790] [2013/10/24 07:09:46.007] [1;7;31mEXCEPTION: [0;31m Error <-[SCEPHelper getCMSSignedData:certPath:keyPath:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Base/Support/SCEPHelper.m:181): "'((SCEPHELPER_GetCMSSignedData(self.connection, data, dataCnt, certPath, certPathCnt, keyPath, keyPathCnt, &signedData, &signedDataCnt)))' error -50">
    USERINFO: {
        NSLocalizedDescription = "Carbon error -50";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4316599910
    ? | 4316193528
    ? | 4311791756
    ? | 4311736512
    ? | 4311770759
    ? | 4311768086
    ? | 4310937826
    ? | 4311791756
    ? | 4311736512
    ? | 4311770759
    ? | 4311783115
    ? | 4311764933
    ? | 4311766751
    ? | 4311791756
    ? | 4311736512
     [0m [0m
[7790] [2013/10/24 07:09:46.007] W: Signing failed, exporting a raw profile file instead.
[7790] [2013/10/24 07:09:46.025] I: Completed in 188ms (View: 17, DB: 5) | 200 OK [https://...server...et/profile/get_ssl_cert_profile]

It seems to be that the problem occours only with me and one other guy, didn't read anything on the net.

I would appreciate for any help, Rhodan.
Reply options

Link to this post

by Paul Scott`,

Paul Scott` Oct 24, 2013 5:19 PM in response to brianw815
Level 1 (4 points)

Oct 24, 2013 5:19 PM in response to brianw815

I have run into the same problem. My users came over from AD, my groups are still present but all my devices have disappeared and their settings are gone as well.
Reply options

Link to this post

by Pantein,

Pantein Oct 25, 2013 5:41 AM in response to brianw815
Level 1 (0 points)

Oct 25, 2013 5:41 AM in response to brianw815

Having exactly the same problem here! Really glad my time machine backup worked!!

Please Apple, fix this annoying problem. Honestly I have never had any joy with profile manager, and if this was my first experience with an Apple product, I would NOT be impressed at all.
Reply options

Link to this post

by Paul Scott`,

Paul Scott` Oct 25, 2013 10:22 AM in response to Pantein
Level 1 (4 points)

Oct 25, 2013 10:22 AM in response to Pantein

How did you get the database back out of Time Machine? That would be a great start for me at least.
Reply options

Link to this post

by JJSagona,

JJSagona Oct 25, 2013 10:56 AM in response to Paul Scott`
Level 1 (0 points)

Oct 25, 2013 10:56 AM in response to Paul Scott`

Server 3 has a different schema for the Profile Manager database so just exporting the 2.2 version using a solution like "sudo pg_dump -U _postgres -c device_management > $HOME/device_management.sql" won't be a great fix for Server 3 necessarily.

In my case, I just restored the entire server from Time Machine backup to OS X 10.8.5 since it is only utilized for Profile Manager. Once you are rolled back you can run the script from above, but again, I doubt it will do you much good in Server 3 without the modifications they are applying (quite poorly I might add since all the valuable data is getting lost in that transition).
Reply options

Link to this post

by mscott_mdm,

mscott_mdm Oct 25, 2013 11:22 AM in response to brianw815
Level 2 (225 points)

Oct 25, 2013 11:22 AM in response to brianw815

brianw815 (or anybody else with this issue), can you attach the last 100 lines or so from /Library/Logs/ProfileManager/migration_tool.log ?

Profile Manager keeps your old data in another database so it is possible to re-run only Profile Manager migration without starting over from scratch with everything. If we can figure out why the migration is failing, it MIGHT be possible to get your Profile Manager data back without all the work of restoring backups and reinstalling everything.
Reply options

Link to this post

by Paul Scott`,

Paul Scott` Oct 25, 2013 11:56 AM in response to mscott_mdm
Level 1 (4 points)

Oct 25, 2013 11:56 AM in response to mscott_mdm

Here is a chunk of my migration.log file. I think I see the problem. There is a large amount of records listed in the log that said failed to migrate.

0:: [3861] [2013/10/23 01:24:14.019] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"> [0m [0m
0:: [3861] [2013/10/23 01:24:14.019] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )">
    USERINFO: {
        SQLSTATE = 25P02;
        errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4442461637
    ? | 4442314300
    ? | 4442377826
    ? | 4442450292
    ? | 4442375919
    ? | 4440142933
    ? | 4440108595
    ? | 4440138300
    ? | 4440123099
    ? | 4440122369
    ? | 4442463750
    ? | 4442341271
    ? | 4440121705
    ? | 4440145717
    ? | 140735485654525
     [0m [0m
0:: [3861] [2013/10/23 01:24:14.020] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"> [0m [0m
0:: [3861] [2013/10/23 01:24:14.021] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )">
    USERINFO: {
        SQLSTATE = 25P02;
        errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4442461637
    ? | 4442314300
    ? | 4442377826
    ? | 4442450292
    ? | 4442375919
    ? | 4440142933
    ? | 4440108595
    ? | 4440138300
    ? | 4440123099
    ? | 4440122369
    ? | 4442463750
    ? | 4442341271
    ? | 4440121705
    ? | 4440145717
    ? | 140735485654525
     [0m [0m
0:: [3861] [2013/10/23 01:24:14.022] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"> [0m [0m
0:: [3861] [2013/10/23 01:24:14.023] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )">
    USERINFO: {
        SQLSTATE = 25P02;
        errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4442461637
    ? | 4442314300
    ? | 4442377826
    ? | 4442450292
    ? | 4442375919
    ? | 4440142933
    ? | 4440108595
    ? | 4440138300
    ? | 4440123099
    ? | 4440122369
    ? | 4442463750
    ? | 4442341271
    ? | 4440121705
    ? | 4440145717
    ? | 140735485654525
     [0m [0m
0:: [3861] [2013/10/23 01:24:14.024] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"> [0m [0m
0:: [3861] [2013/10/23 01:24:14.025] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )">
    USERINFO: {
        SQLSTATE = 25P02;
        errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4442461637
    ? | 4442314300
    ? | 4442377826
    ? | 4442450292
    ? | 4442375919
    ? | 4440142933
    ? | 4440108595
    ? | 4440138300
    ? | 4440123099
    ? | 4440122369
    ? | 4442463750
    ? | 4442341271
    ? | 4440121705
    ? | 4440145717
    ? | 140735485654525
     [0m [0m
0:: [3861] [2013/10/23 01:24:14.026] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"> [0m [0m
0:: [3861] [2013/10/23 01:24:14.028] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )">
    USERINFO: {
        SQLSTATE = 25P02;
        errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4442461637
    ? | 4442314300
    ? | 4442377826
    ? | 4442450292
    ? | 4442375919
    ? | 4440142933
    ? | 4440108595
    ? | 4440138300
    ? | 4440123099
    ? | 4440122369
    ? | 4442463750
    ? | 4442341271
    ? | 4440121705
    ? | 4440145717
    ? | 140735485654525
     [0m [0m
0:: [3861] [2013/10/23 01:24:19.888] ***** Failed to migrate the following rows

<<removed query result listing all items in the database >>

0:: [3861] [2013/10/23 01:24:21.329] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"> [0m [0m
0:: [3861] [2013/10/23 01:24:21.330] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )">
    USERINFO: {
        SQLSTATE = 25P02;
        errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4442457568
    ? | 4442340410
    ? | 4440129037
    ? | 4440123099
    ? | 4440122369
    ? | 4442463750
    ? | 4442341271
    ? | 4440121705
    ? | 4440145717
    ? | 140735485654525
    ? | 1
     [0m [0m
0:: [3861] [2013/10/23 01:24:21.331] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"
0:: [3861] [2013/10/23 01:24:21.331] *****************************************
0:: [3861] [2013/10/23 01:24:21.331] Migration from version 1 database failed!
    -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block
    )"
0:: [3861] [2013/10/23 01:24:21.331] *****************************************
4:: [3861] Total transaction time: 0.028936 seconds.
1:: [3861] [2013/10/23 01:24:21.360] Finalizing migration....
2:: [3861] [2013/10/23 01:24:46.126] main RESULT:
     [1;32m————————+———————————————————————————————————————————————————————————————— ———————————————————————————————————————————————————————————————————————————————— —————————— [0m
    COMMAND | /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/devicemgrd -finalizeMigration
    WD      | /
     [1;32m————————+———————————————————————————————————————————————————————————————— ———————————————————————————————————————————————————————————————————————————————— —————————— [0m
    STATUS | 0
     [1;32m————————+———————————————————————————————————————————————————————————————— ———————————————————————————————————————————————————————————————————————————————— —————————— [0m
    STDERR | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-5_value_key" for table "__runtime_temp_devicemgrd-1374-5"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-1092_value_key" for table "__runtime_temp_devicemgrd-1374-1092"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-4090_value_key" for table "__runtime_temp_devicemgrd-1374-4090"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-4093_value_key" for table "__runtime_temp_devicemgrd-1374-4093"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-4100_value_key" for table "__runtime_temp_devicemgrd-1374-4100"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-4103_value_key" for table "__runtime_temp_devicemgrd-1374-4103"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-4130_value_key" for table "__runtime_temp_devicemgrd-1374-4130"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-4998_value_key" for table "__runtime_temp_devicemgrd-1374-4998"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-7870_value_key" for table "__runtime_temp_devicemgrd-1374-7870"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-7873_value_key" for table "__runtime_temp_devicemgrd-1374-7873"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-7880_value_key" for table "__runtime_temp_devicemgrd-1374-7880"
            | NOTICE: CREATE TABLE / UNIQUE will create implicit index "__runtime_temp_devicemgrd-1374-7883_value_key" for table "__runtime_temp_devicemgrd-1374-7883"
            |
     [1;32m————————+———————————————————————————————————————————————————————————————— ———————————————————————————————————————————————————————————————————————————————— —————————— [0m
    STDOUT |
     [1;32m————————+———————————————————————————————————————————————————————————————— ———————————————————————————————————————————————————————————————————————————————— —————————— [0m
1:: [3861] [2013/10/23 01:24:46.126] Migration complete!
0:: [3861] [2013/10/23 01:24:46.127] ShutdownMigrator: 2013-10-23 08:24:46 +0000
2:: [3861] [2013/10/23 01:24:46.127] void ErasePIDFile(): pidFilePath = '/Library/Server/ProfileManager/Config/var/migration_tool'
0:: [3861] [2013/10/23 01:24:46.128] BYE
Reply options

Link to this post

by mscott_mdm,

mscott_mdm Oct 25, 2013 12:04 PM in response to Paul Scott`
Level 2 (225 points)

Oct 25, 2013 12:04 PM in response to Paul Scott`

Thanks Paul,

So the primary error happened much earlier in the log. Can you look for the last line that contains "EXCEPTION" that doesn't have the message "current transaction is aborted" (i.e., the EXCEPTION line immediately before the first "current transaction is aborted" error)? That will probably be the error that caused everything else to fail. You might have to work your way backwards through hundreds of EXCEPTION lines. If you open the file in a text editor, search for "current transaction is aborted" and then scroll up from the first one you find. Please copy the hundred or so lines immediately BEFORE the first "current transaction is aborted" error.

Thanks.
Reply options

Link to this post

by Paul Scott`,

Paul Scott` Oct 25, 2013 12:32 PM in response to mscott_mdm
Level 1 (4 points)

Oct 25, 2013 12:32 PM in response to mscott_mdm

3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————— [0m
    BundleSize :   6908554
    Identifier :   com.bitrock.installbuilder
    Name :         uninstall-apachephp
    ShortVersion : 3.0
    Version :      3.0
     [1;32m——————————————+—————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————— [0m
    BundleSize :   5908455
    Identifier :   com.bitrock.installbuilder
    Name :         uninstall-phppgadmin
    ShortVersion : 3.0
    Version :      3.0
     [1;32m——————————————+—————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————— [0m
    BundleSize :   5899639
    Identifier :   com.bitrock.installbuilder
    Name :         uninstall-psqlodbc
    ShortVersion : 3.0
    Version :      3.0
     [1;32m——————————————+—————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————————————————————————————— [0m
    BundleSize :   4735047
    Identifier :   com.brother.utility.BrStatusMonitor
    Name :         Brother Status Monitor
    ShortVersion : 3.9.1
    Version :      3.9.1
     [1;32m——————————————+——————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————————————————————— [0m
    BundleSize :   20302960
    Identifier :   jp.co.canon.bj.print.app.bjprinterutility2
    Name :         Canon IJ Printer Utility
    ShortVersion : 7.27.2
    Version :      7.27.2
     [1;32m——————————————+—————————————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————————————————— [0m
    BundleSize :   330989
    Identifier :   jp.co.canon.CUPSPS2.BackGrounder
    Name :         Canon PS BackGrounder v3
    ShortVersion : 3.31
    Version :      3.31
     [1;32m——————————————+———————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————————————— [0m
    BundleSize :   756364
    Identifier :   jp.co.canon.CUPS.PS2.Printmonitor
    Name :         Canon CUPS PS Printmonitor v3
    ShortVersion : 3.31
    Version :      3.31
     [1;32m——————————————+————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————————————————— [0m
    BundleSize :   335629
    Identifier :   com.epson.ijprinter.EPIJAutoSetupTool2
    Name :         EPIJAutoSetupTool2
    ShortVersion : 8.02
    Version :      8.02
     [1;32m——————————————+—————————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————————————— [0m
    BundleSize :   431783
    Identifier :   com.epson.ijprinter.commandtoescp
    Name :         commandtoescp
    ShortVersion : 8.02
    Version :      8.02
     [1;32m——————————————+————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————————— [0m
    BundleSize :   3710631
    Identifier :   com.epson.ijprinter.pdftopdf2
    Name :         pdftopdf2
    ShortVersion : 8.02
    Version :      8.02
     [1;32m——————————————+————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————————————— [0m
    BundleSize :   388989
    Identifier :   com.epson.ijprinter.rastertoescpII
    Name :         rastertoescpII
    ShortVersion : 8.02
    Version :      8.02
     [1;32m——————————————+—————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————————————————————————————————————— [0m
    BundleSize :   191265
    Identifier :   com.epson.ijprinter.EpsonPrinterUtilityLite
    Name :         Epson Printer Utility Lite
    ShortVersion : 8.02
    Version :      8.02
     [1;32m——————————————+——————————————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————————————————————— [0m
    BundleSize :   194357
    Identifier :   com.hp.print.cups.filter.commandtohp
    Name :         commandtohp.filter
    ShortVersion : 2.2.0
    Version :      2.2.0
     [1;32m——————————————+———————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————————————— [0m
    BundleSize :   1432982
    Identifier :   com.hp.print.cups.filter.pdftopdf
    Name :         pdftopdf.filter
    ShortVersion : 2.4.0
    Version :      2.4.0
     [1;32m——————————————+————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————— [0m
    BundleSize :   53313
    Identifier :   com.hp.print.autosetup
    Name :         autosetup.tool
    ShortVersion : 1.3.0
    Version :      1.3.0
     [1;32m——————————————+—————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————— [0m
    BundleSize :   13401013
    Identifier :   com.hp.fax
    Name :         fax.backend
    ShortVersion : 5.9.0
    Version :      5.9.0
     [1;32m——————————————+——————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————— [0m
    BundleSize :   379717
    Identifier :   com.hp.rastertofax
    Name :         rastertofax.filter
    ShortVersion : 5.9.0
    Version :      5.9.0
     [1;32m——————————————+—————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————————————————————————— [0m
    BundleSize :   1268309
    Identifier :   com.hp.print.cups.filter.hpPreProcessing
    Name :         hpPreProcessing.filter
    ShortVersion : 1.4.3
    Version :      1.4.3
     [1;32m——————————————+———————————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————————————— [0m
    BundleSize :   190845
    Identifier :   com.hp.dmf3.hpdot4d
    Name :         hpdot4d
    ShortVersion : 3.9.3
    Version :      3.9.3
     [1;32m——————————————+——————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————— [0m
    BundleSize :   196425
    Identifier :   com.hp.devicemodel.hpdot4d
    Name :         hpdot4d
    ShortVersion : 4.6.0
    Version :      4.6.0
     [1;32m——————————————+—————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————— [0m
    BundleSize :   2245184
    Identifier :   com.hp.devicemonitor
    Name :         HP Device Monitor
    ShortVersion : 2.3.0
    Version :      2.3.0
     [1;32m——————————————+———————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————— [0m
    BundleSize :   12083067
    Identifier :   com.hp.events.hpalerts
    Name :         HP Alerts
    ShortVersion : 1.3.0
    Version :      1.3.0
     [1;32m——————————————+—————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————— [0m
    BundleSize :   17252428
    Identifier :   com.hp.printerutility
    Name :         HP Utility
    ShortVersion : 5.15.0
    Version :      5.15.0
     [1;32m——————————————+————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————————— [0m
    BundleSize :   1809999
    Identifier :   com.lexmark.utility.2007
    Name :         Lexmark Printer Utility
    ShortVersion : 1.2.10
    Version :      1.2.10
     [1;32m——————————————+———————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————————— [0m
    BundleSize :   826366
    Identifier :   com.lexmark.LexmarkCUPSDriver
    Name :         LexmarkCUPSDriver
    ShortVersion : 1.1.26
    Version :      1.1.26
     [1;32m——————————————+————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————— [0m
    BundleSize :   113728
    Identifier :   com.lexmark.utilitylogger
    Name :         UtilityLogger
    ShortVersion : 1.0.02
    Version :      1.0.02
     [1;32m——————————————+————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————————————————————————— [0m
    BundleSize :   184299
    Identifier :   com.smilesoftware.print.pagesenderhelper
    Name :         PageSender Helper
    ShortVersion : 4.2
    Version :      4.2
     [1;32m——————————————+———————————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m————————————+———————————————————————— [0m
    BundleSize : 7722930
    Identifier : jp.buffalo.NasNavigator2
    Name :       NASNavigator2
    Version :    2.26
     [1;32m————————————+———————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m————————————+——————————————————————————————— [0m
    BundleSize : 54697
    Identifier : com.schubert-it.print-selection
    Name :       Print Selection.service
    Version :    2.0
     [1;32m————————————+——————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m————————————+————————————————————————————— [0m
    BundleSize : 2127822
    Identifier : com.yourcompany.vpndownloader
    Name :       vpndownloader
    Version :    3.0.5080
     [1;32m————————————+————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————————————————————————— [0m
    BundleSize :   615237
    Identifier :   com.apple.webobjects.JavaPlaybackManager
    Name :         JavaPlaybackManager.woa
    ShortVersion : 5.4
    Version :      5.4
     [1;32m——————————————+———————————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+———————————————————————————————————————— [0m
    BundleSize :   224141
    Identifier :   com.rogueamoeba.InstantHijackPreferences
    Name :         Instant On Preferences
    ShortVersion : 3.0.0
    Version :      3.0.0
     [1;32m——————————————+———————————————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————— [0m
    Identifier :   com.adobe.dreamweaver-9.0
    Name :         Dreamweaver
    ShortVersion : 9.0.0.3481
    Version :      9.0.0.3481
     [1;32m——————————————+————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————— [0m
    Identifier :   com.adobe.ExtensionManager
    Name :         Extension Manager
    ShortVersion : 1.8.169
    Version :      1.8.169
     [1;32m——————————————+—————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————— [0m
    Identifier :   com.adobe.flash-9.0-en_us
    Name :         Adobe Flash CS3
    ShortVersion : 9.0.0.494
    Version :      9.0.0.494
     [1;32m——————————————+————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————————————————————————— [0m
    Identifier :   com.macromedia.Flash Player.app
    Name :         Flash Player
    ShortVersion : 9.0.115.0
    Version :      9.0.115.0
     [1;32m——————————————+——————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————— [0m
    Identifier :   com.MindVision.VISEX
    Name :         Install Flash Player 9 UB
    ShortVersion : 3.0
    Version :      3.0
     [1;32m——————————————+————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————————————————————————— [0m
    Identifier :   com.macromedia.Flash Player.app
    Name :         Flash Player
    ShortVersion : 9.0.115.0
    Version :      9.0.115.0
     [1;32m——————————————+——————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————————————————————————— [0m
    Identifier :   com.macromedia.Flash Player.app
    Name :         Flash Player
    ShortVersion : 9.0.115.0
    Version :      9.0.115.0
     [1;32m——————————————+——————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————— [0m
    Identifier :   com.MindVision.VISEX
    Name :         Install Flash Player 9 UB
    ShortVersion : 3.0
    Version :      3.0
     [1;32m——————————————+————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+————————————————————————————— [0m
    Identifier :   com.macromedia.FLVEncoder
    Name :         Adobe Flash CS3 Video Encoder
    ShortVersion : Flash Video Encoder 2.0.0.494
    Version :      Flash Video Encoder 2.0.0.494
     [1;32m——————————————+————————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+——————————————————————————— [0m
    Identifier :   com.adobe.Adobe Help Viewer
    Name :         Adobe Help Viewer 1.1
    ShortVersion : 1.1
    Version :      1.1
     [1;32m——————————————+——————————————————————————— [0m
3:: [3861] IAL entry:
     [1;32m——————————————+—————————————————————————————————————————————————————————— ————————————————————— [0m
    Identifier :   com.adobe.Photoshop
    Name :         Adobe Photoshop CS3
    ShortVersion : 10.0.1 (10.0.1x20071012 [20071012.r.1644 2007/10/12:09:30:00 cutoff; r branch])
    Version :      10.0.1 (10.0.1x20071012 [20071012.r.1644 2007/10/12:09:30:00 cutoff; r branch])
     [1;32m——————————————+—————————————————————————————————————————————————————————— ————————————————————— [0m
0:: [3861] [2013/10/23 01:24:13.858] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 22001 (ERROR: value too long for type character varying(63)
    )"> [0m [0m
0:: [3861] [2013/10/23 01:24:13.859] [1;7;31mEXCEPTION: [0;31m Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 22001 (ERROR: value too long for type character varying(63)
    )">
    USERINFO: {
        SQLSTATE = 22001;
        errorMessage = "ERROR: value too long for type character varying(63)\n";
    }
     [4;31mBACKTRACE: [0m
     [0;31m? | 4442461637
    ? | 4442314300
    ? | 4442377826
    ? | 4442267783
    ? | 4440110587
    ? | 4440138300
    ? | 4440123099
    ? | 4440122369
    ? | 4442463750
    ? | 4442341271
    ? | 4440121705
    ? | 4440145717
    ? | 140735485654525
    ? | 1
     [0m [0m
Reply options

Link to this post

by mscott_mdm,

mscott_mdm Oct 25, 2013 3:02 PM in response to Paul Scott`
Level 2 (225 points)

Oct 25, 2013 3:02 PM in response to Paul Scott`

Thanks Paul. I know what the problem is now, but I don't yet have a good suggestion for how you can work around it. I'll post here if I come up with something.
Reply options

Link to this post

by Paul Scott`,

Paul Scott` Oct 25, 2013 3:19 PM in response to mscott_mdm
Level 1 (4 points)

Oct 25, 2013 3:19 PM in response to mscott_mdm

Thanks I appreciate it. I also have an open call with Apple Enterprise support. I don't mind recreating the policies, I just need to figure out how to get the devices back in. I am still working on it as well.

Any idea if the old database might still be on the system somewhere to remigrate?
Reply options

Link to this post

by mscott_mdm,

mscott_mdm Oct 25, 2013 4:37 PM in response to Paul Scott`
Level 2 (225 points)

Oct 25, 2013 4:37 PM in response to Paul Scott`

Yes, the old database is present and can be re-migrated. You can try this command to remove the data that's causing the problem from that copy of the old database. (The data being deleted comes from the device, so it can be recovered with an "Update Info" command once your migration is successful.)

sudo psql -U _devicemgr -d device_management -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "update devices set \"InstalledApplicationList\" = NULL where \"InstalledApplicationList\" LIKE '%CS3%';"

Then you can re-run the migration with this command:

sudo /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/config/wipeDB. sh

You do not need to re-install anything, you do all this on your Server 3 installation and Profile Manager will find the old database and attempt a migration again. Note that this command will erase all data from the new Profile Manager database, so if you've done any work in the new Profile Manager it will be lost.
Reply options

Link to this post

Page 1 of 3 last

Q: Managed Settings missing in Profile Manager after upgrade to Server 3

All replies Helpful answers

by JJSagona,

by sosnovsken,

by Rhodan_0x10,

by Paul Scott`,

by Pantein,

by Paul Scott`,

by JJSagona,

by mscott_mdm,

by Paul Scott`,

by mscott_mdm,

by Paul Scott`,

by mscott_mdm,

by Paul Scott`,

by mscott_mdm,

All replies

Helpful answers