Managed Settings missing in Profile Manager after upgrade to Server 3

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.

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.

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.

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.

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.

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

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).

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.

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

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.

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

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.

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?

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.

It is good to know the data is still there somewhere. I did try those commands and it set everything back to the way it was right after the upgrade. However, it is still failing in the same place as before and not importing devices. It seems like the database needs to be updated to allow for a certain fields character size to allow a correct import if I am reading the log correctly.