Server 3.2.1 update fail
Hello Everybody,
like nearly everytime upgrading OS X Server it brings new issue's with it.
Updated to OS X 10.9.5 and OS X Server 3.2.1 today at ~15:10. I cant login to ProfileManager now. Following screen appears:
I like to share following Logs with you:
migration_tool.log
hydra:ProfileManager root# cat migration_tool.log
[4014] [2014/09/18 15:11:13.553] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4014] [2014/09/18 15:11:13.555]
################################################################################
migration_tool-875.25 (PID:4014, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
LA: migration_tool
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4014] [2014/09/18 15:11:13.620] Waiting for postgres to startup....
0:: [4014] [2014/09/18 15:11:14.276] +[PGConnection reloadPreferences]: DBDebug = NO, DBLogNotices = NO, DBLogSQL = NO, DBMonitor = NO
0:: [4014] [2014/09/18 15:11:14.885] Finsihed migrating YAML -> JSON for 'system_applications.subApps'. Rows converted: 145, rows not converted: 0
0:: [4014] [2014/09/18 15:11:14.894] Finsihed migrating YAML -> JSON for 'settings.dynamic_attributes'. Rows converted: 1, rows not converted: 0
0:: [4014] [2014/09/18 15:11:14.897] Finsihed migrating YAML -> JSON for 'settings.written_settings'. Rows converted: 1, rows not converted: 0
0:: [4014] [2014/09/18 15:11:14.898] Finsihed migrating YAML -> JSON for 'settings.knob_sets_enabled'. Rows converted: 1, rows not converted: 0
0:: [4014] [2014/09/18 15:11:14.904] Finsihed migrating YAML -> JSON for 'settings.trust_payloads'. Rows converted: 1, rows not converted: 0
0:: [4014] [2014/09/18 15:11:23.593] Finsihed migrating YAML -> JSON for 'library_item_metadata.dynamic_attributes'. Rows converted: 164, rows not converted: 0
0:: [4014] [2014/09/18 15:11:23.708] Finsihed migrating YAML -> JSON for 'knob_sets.dynamic_attributes'. Rows converted: 48, rows not converted: 0
0:: [4014] [2014/09/18 15:11:23.719] Finsihed migrating YAML -> JSON for 'dynamic_attributes_defaults.defaults'. Rows converted: 7, rows not converted: 0
0:: [4014] [2014/09/18 15:11:23.726] Finsihed migrating YAML -> JSON for 'dm_schema_information.dynamic_attributes'. Rows converted: 1, rows not converted: 0
0:: [4014] [2014/09/18 15:11:23.944] Finsihed migrating YAML -> JSON for 'completed_tasks.yaml'. Rows converted: 129, rows not converted: 0
0:: [4014] [2014/09/18 15:11:23.953] Finsihed migrating YAML -> JSON for 'certificates.dynamic_attributes'. Rows converted: 1, rows not converted: 0
0:: [4014] [2014/09/18 15:11:24.209] Finsihed migrating YAML -> JSON for 'auto_join_profiles.usage_log'. Rows converted: 1, rows not converted: 0
0:: [4014] [2014/09/18 15:11:25.849] Dropping views...
0:: [4014] [2014/09/18 15:11:26.048] Dropping trigger functions...
0:: [4014] [2014/09/18 15:11:26.765] Dropping remaining non-dependent functions...
0:: [4014] [2014/09/18 15:11:45.419] MIGRATE_00870.004 completed successfully
0:: [4014] [2014/09/18 15:11:45.429] MIGRATE_00870.005 completed successfully
0:: [4014] [2014/09/18 15:11:45.458] MIGRATE_00870.009 completed successfully
0:: [4014] [2014/09/18 15:11:45.747] MIGRATE_00870.010 completed successfully
0:: [4014] [2014/09/18 15:11:45.866] MIGRATE_00870.011 completed successfully
0:: [4014] [2014/09/18 15:11:45.880] MIGRATE_00870.015 completed successfully
0:: [4014] [2014/09/18 15:11:45.903] MIGRATE_00870.016 completed successfully
0:: [4014] [2014/09/18 15:11:45.966] MIGRATE_00870.017 completed successfully
0:: [4014] [2014/09/18 15:11:45.979] MIGRATE_00871.007 completed successfully
0:: [4014] [2014/09/18 15:11:46.034] MIGRATE_00871.008 completed successfully
0:: [4014] [2014/09/18 15:11:46.049] MIGRATE_00871.010 completed successfully
0:: [4014] [2014/09/18 15:11:46.064] MIGRATE_00872.002 completed successfully
0:: [4014] [2014/09/18 15:11:46.079] MIGRATE_00872.003 completed successfully
0:: [4014] [2014/09/18 15:11:46.133] Migration failed at statement:
--------------------------------------------------------------------------------------
INSERT INTO auto_join_profile_usage (created_at, auto_join_profile_id, device_id, device_tombstone_id)
SELECT "OUR_OWN_TIMESTAMP", auto_join_profile_id, device_id, tombstone_id FROM __temp_usage;
--------------------------------------------------------------------------------------
-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 23514 (ERROR: new row for relation "auto_join_profile_usage" violates check constraint "auto_join_profile_usage_check"
DETAIL: Failing row contains (20, 2014-05-16 13:22:51, 1, 2930, 2932).
)"
0:: [4014] [2014/09/18 15:11:46.133] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 23514 (ERROR: new row for relation "auto_join_profile_usage" violates check constraint "auto_join_profile_usage_check"
DETAIL: Failing row contains (20, 2014-05-16 13:22:51, 1, 2930, 2932).
)"
0:: [4014] [2014/09/18 15:11:46.133] Migration failed at MIGRATE_00873.001 (final step is MIGRATE_00875.026)
1:: [4014] [2014/09/18 15:11:46.133] Parsing enterprise apps with missing icons...
1:: [4014] [2014/09/18 15:11:48.667] Completed parsing enterprise apps with missing icons!
0:: [4014] [2014/09/18 15:11:48.676] ShutdownMigrator: 2014-09-18 13:11:48 +0000
0:: [4014] [2014/09/18 15:11:48.676] BYEprofilemanager.log:
[332] [2014/09/18 14:44:06.483] I: Logging preferences updated: level = 1, debugOutput = 0
[339] [2014/09/18 14:44:06.493] I: Logging preferences updated: level = 1, debugOutput = 0
[336] [2014/09/18 14:44:06.535] I: Logging preferences updated: level = 1, debugOutput = 0
[4054] [2014/09/18 15:11:22.146] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4054] [2014/09/18 15:11:22.152]
################################################################################
profilemanager-875.25 (PID:4054, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4054] [2014/09/18 15:11:22.152] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4056] [2014/09/18 15:11:22.151] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4056] [2014/09/18 15:11:22.163]
################################################################################
profilemanager-875.25 (PID:4056, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4056] [2014/09/18 15:11:22.163] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4051] [2014/09/18 15:11:22.180] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4051] [2014/09/18 15:11:22.189]
################################################################################
profilemanager-875.25 (PID:4051, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4051] [2014/09/18 15:11:22.189] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4055] [2014/09/18 15:11:22.181] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4055] [2014/09/18 15:11:22.197]
################################################################################
profilemanager-875.25 (PID:4055, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4055] [2014/09/18 15:11:22.197] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4053] [2014/09/18 15:11:22.193] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4053] [2014/09/18 15:11:22.200]
################################################################################
profilemanager-875.25 (PID:4053, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4053] [2014/09/18 15:11:22.202] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4060] [2014/09/18 15:11:22.236] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4060] [2014/09/18 15:11:22.251]
################################################################################
profilemanager-875.25 (PID:4060, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4060] [2014/09/18 15:11:22.251] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4059] [2014/09/18 15:11:22.258] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4059] [2014/09/18 15:11:22.283]
################################################################################
profilemanager-875.25 (PID:4059, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4059] [2014/09/18 15:11:22.283] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4052] [2014/09/18 15:11:22.270] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4052] [2014/09/18 15:11:22.296]
################################################################################
profilemanager-875.25 (PID:4052, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4052] [2014/09/18 15:11:22.297] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4058] [2014/09/18 15:11:22.269] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4058] [2014/09/18 15:11:22.312]
################################################################################
profilemanager-875.25 (PID:4058, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4058] [2014/09/18 15:11:22.313] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4057] [2014/09/18 15:11:22.300] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4057] [2014/09/18 15:11:22.313]
################################################################################
profilemanager-875.25 (PID:4057, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4057] [2014/09/18 15:11:22.313] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4055] [2014/09/18 15:11:24.101] I: Logging preferences updated: level = 1, debugOutput = 0
[4051] [2014/09/18 15:11:24.124] I: Logging preferences updated: level = 1, debugOutput = 0
[4056] [2014/09/18 15:11:24.138] I: Logging preferences updated: level = 1, debugOutput = 0
[4054] [2014/09/18 15:11:24.153] I: Logging preferences updated: level = 1, debugOutput = 0
[4059] [2014/09/18 15:11:24.158] I: Logging preferences updated: level = 1, debugOutput = 0
[4058] [2014/09/18 15:11:24.165] I: Logging preferences updated: level = 1, debugOutput = 0
[4060] [2014/09/18 15:11:24.171] I: Logging preferences updated: level = 1, debugOutput = 0
[4052] [2014/09/18 15:11:24.172] I: Logging preferences updated: level = 1, debugOutput = 0
[4053] [2014/09/18 15:11:24.173] I: Logging preferences updated: level = 1, debugOutput = 0
[4057] [2014/09/18 15:11:24.178] I: Logging preferences updated: level = 1, debugOutput = 0
[4102] [2014/09/18 15:11:46.713] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4102] [2014/09/18 15:11:46.717]
################################################################################
profilemanager-875.25 (PID:4102, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
Log verbosity level = 1
UID = 220, EUID = 220
################################################################################
0:: [4102] [2014/09/18 15:11:46.717] -[SULogFileCollection setGlobalLogLevelPrefix:]: NO
[4102] [2014/09/18 15:11:47.174] I: Logging preferences updated: level = 1, debugOutput = 0
[4102] [2014/09/18 15:11:48.585] I: EappIconParser.run: []
[4051] [2014/09/18 15:16:22.759] I: Processing MagicController#admin_will_load (for 62.96.187.1 at 2014-09-18 15:16:22) [POST]
[4051] [2014/09/18 15:16:22.760] I: auth_token doesn't exist
[4051] [2014/09/18 15:16:22.760] I: Filter chain halted as [:verify_auth_token] rendered_or_redirected.
[4051] [2014/09/18 15:16:22.761] I: Completed in 2ms (View: 0, DB: 15) | 403 Forbidden [https://hydra.s-f.com/magic/admin_will_load]
[4052] [2014/09/18 15:16:23.380] I: Processing MagicController#do_magic (for 62.96.187.1 at 2014-09-18 15:16:23) [POST]
[4052] [2014/09/18 15:16:23.381] I: auth_token doesn't exist
[4052] [2014/09/18 15:16:23.382] I: Filter chain halted as [:verify_auth_token] rendered_or_redirected.
[4052] [2014/09/18 15:16:23.382] I: Completed in 2ms (View: 0, DB: 9) | 403 Forbidden [https://hydra.s-f.com/magic/do_magic]
[4053] [2014/09/18 15:16:45.162] I: Processing MagicController#admin_will_load (for 62.96.187.1 at 2014-09-18 15:16:45) [POST]
[4053] [2014/09/18 15:16:45.163] I: auth_token doesn't exist
[4053] [2014/09/18 15:16:45.163] I: Filter chain halted as [:verify_auth_token] rendered_or_redirected.
[4053] [2014/09/18 15:16:45.164] I: Completed in 2ms (View: 0, DB: 23) | 403 Forbidden [https://hydra.s-f.com/magic/admin_will_load]
[4054] [2014/09/18 15:16:45.168] I: Processing MagicController#do_magic (for 62.96.187.1 at 2014-09-18 15:16:45) [POST]
[4054] [2014/09/18 15:16:45.170] I: auth_token doesn't exist
[4054] [2014/09/18 15:16:45.170] I: Filter chain halted as [:verify_auth_token] rendered_or_redirected.
[4054] [2014/09/18 15:16:45.170] I: Completed in 2ms (View: 0, DB: 41) | 403 Forbidden [https://hydra.s-f.com/magic/do_magic]
[4055] [2014/09/18 15:17:00.345] I: Processing AuthenticationController#callback (for 62.96.187.1 at 2014-09-18 15:17:00) [GET]
[4055] [2014/09/18 15:17:00.477] F: ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "view_all_user_groups_users_flat" does not exist
LINE 2: FROM view_all_user_groups_users_flat AS j
^
: SELECT COUNT(j.*)
FROM view_all_user_groups_users_flat AS j
WHERE j.user_id = 257
AND j.user_group_id = 1712
LIMIT 1
):
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `rescue in log'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract_adapter.rb:204:in `log'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:520:in `execute'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:1002:in `select_raw'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:989:in `select'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `block in select_all_with_query_cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all_with_query_cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/base.rb:920:in `count_by_sql'
app/models/user_group.rb:371:in `user_is_member_of_group'
app/models/user.rb:293:in `user_is_admin?'
app/controllers/application_controller.rb:258:in `verify_admin_logged_in'
vendor/ruby/1.9.1/gems/activesupport-2.3.18/lib/active_support/callbacks.rb:178:in `evaluate_method'
vendor/ruby/1.9.1/gems/activesupport-2.3.18/lib/active_support/callbacks.rb:166:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:225:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:629:in `run_before_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:615:in `call_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:610:in `perform_action_with_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/benchmarking.rb:68:in `block in perform_action_with_benchmark'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/benchmarking.rb:68:in `perform_action_with_benchmark'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/rescue.rb:160:in `perform_action_with_rescue'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/flash.rb:151:in `perform_action_with_flash'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/base.rb:532:in `process'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:606:in `process_with_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/base.rb:391:in `process'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/base.rb:386:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/routing/route_set.rb:438:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:87:in `dispatch'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:121:in `_call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:130:in `block in build_middleware_stack'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/string_coercion.rb:25:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/string_coercion.rb:25:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/params_parser.rb:15:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/session/abstract_store.rb:177:in `call'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/query_cache.rb:29:in `block in call'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/query_cache.rb:9:in `cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/query_cache.rb:28:in `call'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/failsafe.rb:26:in `call'
<internal:prelude>:10:in `synchronize'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:106:in `call'
vendor/ruby/1.9.1/gems/rails-2.3.18/lib/rails/rack/static.rb:31:in `call'
vendor/ruby/1.9.1/gems/rails-2.3.18/lib/rails/rack/log_tailer.rb:17:in `call'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:81:in `block in pre_process'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:79:in `catch'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:79:in `pre_process'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:54:in `process'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:39:in `receive_data'
vendor/ruby/1.9.1/gems/eventmachine-1.0.3/lib/eventmachine.rb:187:in `run_machine'
vendor/ruby/1.9.1/gems/eventmachine-1.0.3/lib/eventmachine.rb:187:in `run'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/backends/base.rb:63:in `start'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/server.rb:159:in `start'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/controllers/controller.rb:86:in `start'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/runner.rb:187:in `run_command'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/runner.rb:152:in `run!'
thin:11:in `<main>'
[4055] [2014/09/18 15:17:00.503] I: Rendering /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/public/500.html (500 Internal Server Error)PostgreSQL-2014-09-18.log
2014-09-18 15:09:07 CESTLOG: database system is shut down
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000700000062' === '/Library/Server/ProfileManager/Data/backup/000000010000000700000062'
2014-09-18 15:11:12 CESTLOG: database system was shut down at 2014-09-18 15:11:08 CEST
2014-09-18 15:11:12 CESTLOG: autovacuum launcher started
2014-09-18 15:11:12 CESTLOG: database system is ready to accept connections
2014-09-18 15:11:12 CESTLOG: connection received: host=[local]
2014-09-18 15:11:12 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:11:12 CESTLOG: connection received: host=[local]
2014-09-18 15:11:12 CESTLOG: connection authorized: user=_devicemgr database=postgres
2014-09-18 15:11:12 CESTLOG: received smart shutdown request
2014-09-18 15:11:12 CESTLOG: autovacuum launcher shutting down
2014-09-18 15:11:12 CESTLOG: shutting down
2014-09-18 15:11:12 CESTLOG: database system is shut down
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000002' ... '/Library/Server/ProfileManager/Data/backup/000000010000000000000002'
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000002' --> '/Library/Server/ProfileManager/Data/backup/000000010000000000000002'
2014-09-18 15:11:13 CESTLOG: connection received: host=[local]
2014-09-18 15:11:13 CESTFATAL: the database system is shutting down
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000001' ... '/Library/Server/ProfileManager/Data/backup/000000010000000000000001'
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000001' --> '/Library/Server/ProfileManager/Data/backup/000000010000000000000001'
2014-09-18 15:11:13 CESTLOG: database system was shut down at 2014-09-18 15:11:12 CEST
2014-09-18 15:11:13 CESTLOG: autovacuum launcher started
2014-09-18 15:11:13 CESTLOG: database system is ready to accept connections
2014-09-18 15:11:13 CESTLOG: connection received: host=[local]
2014-09-18 15:11:13 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:11:13 CESTLOG: connection received: host=[local]
2014-09-18 15:11:13 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:11:14 CESTLOG: connection received: host=[local]
2014-09-18 15:11:14 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:11:14 CESTLOG: connection received: host=[local]
2014-09-18 15:11:14 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:11:14 CESTLOG: connection received: host=[local]
2014-09-18 15:11:14 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:11:14 CESTLOG: connection received: host=[local]
2014-09-18 15:11:14 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:11:14 CESTLOG: connection received: host=[local]
2014-09-18 15:11:14 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "widgets" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "vpp_products" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "system_applications" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: connection received: host=[local]
2014-09-18 15:11:14 CESTLOG: replication connection authorized: user=_devicemgr
2014-09-18 15:11:14 CESTLOG: connection received: host=[local]
2014-09-18 15:11:14 CESTLOG: replication connection authorized: user=_devicemgr
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "system_applications" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "system_applications" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "sessions" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "sessions" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "preference_panes" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "preference_panes" DISABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-09-18 15:11:14 CESTLOG: statement: ALTER TABLE "library_item_metadata" DISABLE TRIGGER USER
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000003' ... '/Library/Server/ProfileManager/Data/backup/000000010000000000000003'
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000003' --> '/Library/Server/ProfileManager/Data/backup/000000010000000000000003'
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "knob_sets" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "its_accounts" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "dm_schema_information" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "device_groups" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "device_enrollment_settings" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "device_enrollment_settings" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "completed_tasks" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "certificates" DISABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "certificates" ENABLE TRIGGER USER
2014-09-18 15:11:23 CESTLOG: statement: ALTER TABLE "auto_join_profiles" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "asset_metadata" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "profile_substitution_caches" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "profiles" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "enterprise_apps" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "user_tasks" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "mdm_tasks" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "work_tasks" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "media" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "devices" DISABLE TRIGGER USER
2014-09-18 15:11:24 CESTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_active_user_vpp_email_invitation_tasks" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_device_groups_flat" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_active_mdm_targets_by_device_ids" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_user_groups_flat" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_user_groups_users_complete" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_active_mdm_targets_by_user_ids" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_all_user_groups_flat" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_all_user_groups_users_complete" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_all_valid_user_groups" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_all_valid_users" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_valid_devices" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_inactive_push_targets_with_names" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_library_items_unified_applications" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_mdm_tasks_as_target_tasks" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_valid_owner_lab_sessions" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_user_tasks_as_target_tasks" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_unified_applications" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_unused_its_accounts" CASCADE
2014-09-18 15:11:25 CESTLOG: statement: DROP VIEW "view_valid_lab_sessions" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_valid_logged_in_lab_sessions" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_valid_user_groups" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_valid_users" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_vpp_apps" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_vpp_apps_ios" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_vpp_apps_osx" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_vpp_assignment_order" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_vpp_books" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_vpp_enabled_devices" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP VIEW "view_vpp_its_accounts_users" CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_completed_tasks_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_data_files_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_db_notification_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_group_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_group_memberships_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_group_memberships_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_group_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_groups_devices_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_groups_devices_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_device_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_eapp_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_eapp_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_group_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_group_memberships_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_group_memberships_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_group_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_groups_users_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_groups_users_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_user_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_users_deleted() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_inactive_users_inserted() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_installed_app_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_internal_task_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_internal_tasks_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_internal_tasks_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_its_accounts_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_knob_set_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_knob_sets_attachment_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_lab_session_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_lab_session_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_lab_session_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_library_item_tasks_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_library_items_asset_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_library_items_assets_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_mdm_tasks_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_mdm_tasks_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_printer_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_profile_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_profile_substitution_cache_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_profile_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_system_application_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_group_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_group_memberships_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_group_memberships_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_group_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_groups_users_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_groups_users_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_tasks_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_user_tasks_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_users_deleted() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_users_inserted() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_vpp_licenses_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_vpp_product_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_vpp_product_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_widget_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_after_work_task_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_asset_metadata_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_asset_metadata_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_completed_task_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_data_file_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_device_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_device_group_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_device_group_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_user_group_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_device_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_eapp_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_eapp_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_inactive_user_group_memberships_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_inactive_user_group_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_inactive_user_groups_users_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_inactive_user_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_installed_app_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_internal_task_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_knob_set_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_lab_session_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_lab_session_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_lab_session_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_library_item_metadata_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_library_item_metadata_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_library_item_tasks_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_library_items_asset_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_mdm_tasks_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_profile_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_profile_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_profile_substitution_cache_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_user_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_user_group_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_user_modify() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_user_tasks_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_vpp_app_delete() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_before_vpp_product_insert() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_inactive_user_group_memberships_active_group_check() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_inactive_user_group_uniqueness_checks() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_inactive_user_groups_users_active_group_check() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_inactive_user_uniqueness_checks() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_operation_not_allowed() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION dm_deleted_mdm_row() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_trigger_after_delete_knob_set() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_trigger_after_settings_update() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_user_group_membership_checks() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_user_group_uniqueness_checks() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION _dm_user_uniqueness_checks() CASCADE
2014-09-18 15:11:26 CESTLOG: statement: DROP FUNCTION dm_trigger_objc_send() CASCADE
2014-09-18 15:11:28 CESTLOG: statement: DROP FUNCTION _dm_adjust_tasks_for_app_delete(varchar,varchar) CASCADE
2014-09-18 15:11:28 CESTLOG: connection received: host=[local]
2014-09-18 15:11:28 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:28 CESTLOG: connection received: host=[local]
2014-09-18 15:11:28 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:28 CESTLOG: connection received: host=[local]
2014-09-18 15:11:28 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: connection received: host=[local]
2014-09-18 15:11:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: connection received: host=[local]
2014-09-18 15:11:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: connection received: host=[local]
2014-09-18 15:11:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: connection received: host=[local]
2014-09-18 15:11:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: connection received: host=[local]
2014-09-18 15:11:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: connection received: host=[local]
2014-09-18 15:11:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: connection received: host=[local]
2014-09-18 15:11:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:29 CESTLOG: statement: DROP FUNCTION _dm_adjust_tasks_for_library_item_delete(varchar,int4,varchar,varchar,varchar) CASCADE
2014-09-18 15:11:30 CESTLOG: statement: DROP FUNCTION _dm_adjust_tasks_for_profile_delete(int4,varchar,varchar) CASCADE
2014-09-18 15:11:30 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_deleted(abstract_users) CASCADE
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000004' === '/Library/Server/ProfileManager/Data/backup/000000010000000000000004'
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000004.00002118.backup' ... '/Library/Server/ProfileManager/Data/backup/000000010000000000000004.00002118.backup'
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000004.00002118.backup' --> '/Library/Server/ProfileManager/Data/backup/000000010000000000000004.00002118.backup'
2014-09-18 15:11:31 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_group_deleted(abstract_user_groups) CASCADE
2014-09-18 15:11:31 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_group_inserted(abstract_user_groups) CASCADE
2014-09-18 15:11:31 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_group_memberships_deleted(abstract_user_group_memberships) CASCADE
2014-09-18 15:11:32 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_group_memberships_inserted(abstract_user_group_memberships) CASCADE
2014-09-18 15:11:32 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_group_modified(abstract_user_groups,abstract_user_groups) CASCADE
2014-09-18 15:11:32 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_groups_users_deleted(abstract_user_groups_users) CASCADE
2014-09-18 15:11:33 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_groups_users_inserted(abstract_user_groups_users) CASCADE
2014-09-18 15:11:33 CESTLOG: connection received: host=[local]
2014-09-18 15:11:33 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:11:33 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_inserted(abstract_users) CASCADE
2014-09-18 15:11:33 CESTLOG: statement: DROP FUNCTION _dm_after_abstract_user_modified(abstract_users,abstract_users) CASCADE
2014-09-18 15:11:34 CESTLOG: statement: DROP FUNCTION _dm_after_asset_deleted(assets) CASCADE
2014-09-18 15:11:34 CESTLOG: statement: DROP FUNCTION _dm_after_asset_inserted(assets) CASCADE
2014-09-18 15:11:34 CESTLOG: statement: DROP FUNCTION _dm_after_library_item_deleted(library_items) CASCADE
2014-09-18 15:11:35 CESTLOG: statement: DROP FUNCTION _dm_after_library_item_inserted(library_items) CASCADE
2014-09-18 15:11:35 CESTLOG: statement: DROP FUNCTION _dm_after_library_item_task_created(library_item_tasks) CASCADE
2014-09-18 15:11:35 CESTLOG: statement: DROP FUNCTION _dm_after_mdm_target_deleted(mdm_targets) CASCADE
2014-09-18 15:11:36 CESTLOG: statement: DROP FUNCTION _dm_after_mdm_target_inserted(mdm_targets) CASCADE
2014-09-18 15:11:36 CESTLOG: statement: DROP FUNCTION _dm_after_media_deleted(media) CASCADE
2014-09-18 15:11:36 CESTLOG: statement: DROP FUNCTION _dm_after_media_inserted(media) CASCADE
2014-09-18 15:11:36 CESTLOG: statement: DROP FUNCTION _dm_after_od_library_item_deleted(od_library_items) CASCADE
2014-09-18 15:11:37 CESTLOG: statement: DROP FUNCTION _dm_after_od_library_item_inserted(od_library_items) CASCADE
2014-09-18 15:11:37 CESTLOG: statement: DROP FUNCTION _dm_after_od_library_item_modified(od_library_items,od_library_items) CASCADE
2014-09-18 15:11:37 CESTLOG: statement: DROP FUNCTION _dm_asset_update_related_target(library_items_assets) CASCADE
2014-09-18 15:11:38 CESTLOG: statement: DROP FUNCTION _dm_auto_invite_vpp() CASCADE
2014-09-18 15:11:38 CESTLOG: statement: DROP FUNCTION _dm_auto_push_eapps() CASCADE
2014-09-18 15:11:38 CESTLOG: statement: DROP FUNCTION _dm_before_work_tasks_update_common(work_tasks,work_tasks) CASCADE
2014-09-18 15:11:38 CESTLOG: statement: DROP FUNCTION _dm_can_auto_sync_media(timestamp) CASCADE
2014-09-18 15:11:39 CESTLOG: statement: DROP FUNCTION _dm_can_auto_sync_profiles(timestamp) CASCADE
2014-09-18 15:11:39 CESTLOG: statement: DROP FUNCTION _dm_check_and_merge_duplicate_device_rows(devices,devices) CASCADE
2014-09-18 15:11:39 CESTLOG: statement: DROP FUNCTION _dm_clear_vpp_invitation_data(int4) CASCADE
2014-09-18 15:11:40 CESTLOG: statement: DROP FUNCTION _dm_convert_mdm_task_to_completed_task(mdm_tasks) CASCADE
2014-09-18 15:11:40 CESTLOG: statement: DROP FUNCTION _dm_convert_user_task_to_completed_task(user_tasks) CASCADE
2014-09-18 15:11:40 CESTLOG: statement: DROP FUNCTION _dm_create_app_tasks_from_temp_table(int4,varchar,asset_type,int4) CASCADE
2014-09-18 15:11:40 CESTLOG: statement: DROP FUNCTION _dm_create_profile_tasks_from_temp_table(int4,varchar,int4) CASCADE
2014-09-18 15:11:41 CESTLOG: statement: DROP FUNCTION _dm_deferred_device_membership_changed(int4) CASCADE
2014-09-18 15:11:41 CESTLOG: statement: DROP FUNCTION _dm_dep_is_ready() CASCADE
2014-09-18 15:11:41 CESTLOG: statement: DROP FUNCTION _dm_dev_norm_set_once(devices,devices,text,text,bool) CASCADE
2014-09-18 15:11:41 CESTLOG: statement: DROP FUNCTION _dm_device_owner_did_change(devices,devices) CASCADE
2014-09-18 15:11:42 CESTLOG: statement: DROP FUNCTION _dm_device_owner_will_change(devices,devices) CASCADE
2014-09-18 15:11:42 CESTLOG: statement: DROP FUNCTION _dm_device_remove_activation_lock_task(int4,uuid) CASCADE
2014-09-18 15:11:42 CESTLOG: statement: DROP FUNCTION _dm_device_was_enrolled(devices,devices) CASCADE
2014-09-18 15:11:42 CESTLOG: statement: DROP FUNCTION _dm_device_was_unenrolled(devices,devices) CASCADE
2014-09-18 15:11:43 CESTLOG: statement: DROP FUNCTION _dm_device_will_be_enrolled(devices,devices) CASCADE
2014-09-18 15:11:43 CESTLOG: statement: DROP FUNCTION _dm_device_will_be_unenrolled(devices,devices) CASCADE
2014-09-18 15:11:43 CESTLOG: statement: DROP FUNCTION _dm_eapp_will_update(enterprise_apps) CASCADE
2014-09-18 15:11:43 CESTLOG: statement: DROP FUNCTION _dm_get_lab_session_name(lab_sessions,devices,users) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_get_required_group_ids() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_get_required_user_ids() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_get_user_display_name(users) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_internal_profile_generation_task(profiles,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_internal_profile_generation_task(int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_internal_psc_generation_task(profile_substitution_caches,int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_internal_task_for_basic_task(varchar,mdm_targets,uuid) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_is_vpp_task(work_tasks) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_log(text,text) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_log_devicemgrd(varchar) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_managed_app_list_singletons() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_mdm_target_needs_repush(timestamp,timestamp,timestamp,bool) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_mdm_task_completed(mdm_tasks) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_mdm_task_status(mdm_tasks,bool) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_merge_placeholder_device_rows(devices,devices) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_normalize_device_columns(devices,devices,bool) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_notify(varchar,varchar) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_objc_send(varchar) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_profile_became_ready(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_profile_change_will_push(profiles,profiles) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_profile_device_substitution_bit_for_field(text) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_profile_list_singletons() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_profile_update_related_target(profiles) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_profile_user_substitution_bit_for_field(text) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_profile_will_update(profiles) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_device_eapp_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_device_group_eapp_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_device_group_profile_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_device_profile_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_user_eapp_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_user_group_eapp_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_user_group_profile_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_queue_user_profile_updates(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_reconnect_tasks_to_library_item(library_item_type,int4,varchar) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_score_device_row(devices,devices) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_singletons_for_task_type(varchar) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_task_type_for_singleton(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_user_vpp_enrolled_task(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_user_vpp_invitation_task(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_user_vpp_licensed_task(int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_user_vpp_registration_task(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_vpp_became_ready() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_vpp_is_ready() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_vpp_ready_task() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_vpp_user_became_enrolled(users) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_vpp_user_became_registered(users) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_vpp_user_became_retired(users) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_vpp_user_was_invited(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION _dm_work_task_status(work_tasks) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_allow_adhoc_profiles_access_for_user_id(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_allow_portal_access_for_user_id(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_allow_portal_enroll_unenrollment_for_user_id(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_app_info_for_device(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_app_info_for_device_group(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_app_info_for_user(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_app_info_for_user_group(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_begin_dep_sync() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_cancel_all_tasks_for_mdm_target(mdm_targets,bool) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_cancel_all_vpp_tasks() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_cancel_library_item_task(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_cancel_non_remove_tasks_for_library_item(varchar,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_check_set_once(anyelement,anyelement) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_cleanup_completed_tasks(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_complete_internal_task(int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_complete_mdm_tasks_for_mdm_target(int4,int4,bool,bool,text) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_create_basic_task_for_device_group_item(int4,varchar,int4,text,uuid,_int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_create_basic_task_for_device_item(int4,varchar,int4,text,uuid) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_create_basic_task_for_library_item(varchar,int4,varchar,text,uuid,_int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_create_basic_task_for_user_group_item(int4,varchar,int4,text,uuid,_int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_create_basic_task_for_user_item(int4,varchar,int4,text,uuid,_int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deactivate_user_groups(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deactivate_users(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deferred_device_group_membership_changed(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deferred_remove_profile_from_all_targets(profiles) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deferred_update_profiles_by_device_substitutions(devices,devices) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deferred_update_profiles_by_user_substitutions(users,users) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deferred_user_group_membership_changed(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deferred_user_membership_changed(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_deleted_mdm_row(text,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_dep_clear_service_data() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_device_application_lists_updated(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_device_certificate_list_updated(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_device_enrollment_settings_for_user(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_device_enrollment_settings_for_user_group(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_dropped_connection_timestamp() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_effective_privileges_for_od_library_item_id(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_effective_privileges_for_user_id(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_enterprise_apps_info_for_device_and_app(int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_enterprise_apps_info_for_device_group_and_app(int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_enterprise_apps_info_for_user_and_app(int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_enterprise_apps_info_for_user_group_and_app(int4,int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_eq(anyelement,anyelement) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_expanded_privileges_for_user_id(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_garbage_collect(bool) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_get_admin_group_id() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_get_device_push_statistics(int4) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_get_everyone_group_id() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_get_nobody_group_id() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_get_nobody_user_id() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_get_sacl_group_id() CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_inherited_privileges_for_od_library_item_id(int4,library_item_type) CASCADE
2014-09-18 15:11:44 CESTLOG: statement: DROP FUNCTION dm_inherited_privileges_for_user_id(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_is_active_mdm_target(mdm_targets) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_is_active_target_for_task(mdm_targets,varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_is_active_user_mdm_target(mdm_targets) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_lab_session_logged_in(lab_sessions) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_make_all_child_users_active(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_make_library_item_active(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_make_user_active(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_make_user_group_active(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_make_user_group_row_active(abstract_user_groups,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_make_user_row_active(abstract_users) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_may_retry_failed(timestamp) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_mdm_target_blocked_tasks_count(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_normalize_imei(varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_normalize_mac(varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_normalize_meid(varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_normalize_serial_number(varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_normalize_set_once(varchar,varchar,text,text,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_normalize_udid(varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_oldest_lab_session_login_time() CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_prepare_next_internal_task() CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_prepare_updated_target_tasks(int8,_int8) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_process_user_tasks() CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_profile_identifier_for_profile_uuid_alacarte(uuid,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_profile_needs_update(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_all() CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_eapp_to_device_group_item(int4,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_eapp_to_device_item(int4,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_eapp_to_library_item(int4,varchar,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_eapp_to_user_group_item(int4,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_eapp_to_user_item(int4,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_vpp_app_to_library_item(int4,varchar,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_vpp_app_to_user_group_item(int4,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_vpp_app_to_user_item(int4,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_vpp_apps_to_library_item(_int4,varchar,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_push_vpp_apps_to_user_item(int4,_int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_remove_profile_from_all_targets(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_send_push_notifications() CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_send_update_info_for_devices_with_limit(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_suppress_related_updates(bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_task_privileges_for_user_id(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_eapps_for_device(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_eapps_for_device_group(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_eapps_for_mdm_target(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_eapps_for_user(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_eapps_for_user_group(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_profiles_for_device(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_profiles_for_device_group(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_profiles_for_lab_session(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_profiles_for_mdm_target(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_profiles_for_user(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_all_profiles_for_user_group(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_device_eapps(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_device_enrollment_settings(int4,allow_al_enum) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_device_profile(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_eapp_targets(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_profile_targets(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_user_group_member_counts(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_update_user_group_member_counts(varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_asset_type_for_product_type_id(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_book_license_info_for_user(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_book_license_info_for_user_group(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_clear_service_data() CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_create_device_invite_tasks_for_user(int4,int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_create_device_invite_tasks_for_user_group(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_create_email_invite_tasks_for_user(int4,varchar) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_create_email_invite_tasks_for_user_group(int4,bool) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_get_enrollment_data_for_user_group(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_get_one_its_account_id_product_id_to_assign() CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_license_info_for_product(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_license_info_for_user_and_product(int4,int4,text) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_license_info_for_user_group_and_product(int4,int4,text) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_product_type_id_is_app(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_product_type_id_is_book(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_revoke_invitations_for_user_group(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_update_ext_license_counts(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_update_licenses_assigned(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: DROP FUNCTION dm_vpp_update_licenses_assigned_by_user_group_change(int4) CASCADE
2014-09-18 15:11:45 CESTLOG: statement: ALTER TYPE asset_type ADD VALUE 'Xsan' AFTER 'VPPBook';
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE knob_sets_assets DROP CONSTRAINT knob_sets_assets_asset_id_key;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE knob_sets_assets DROP CONSTRAINT knob_sets_assets_knob_set_id_key;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE work_tasks RENAME COLUMN yaml TO params;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN "DeviceName" SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN "ProductName" SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN "OSVersion" SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN "SerialNumber" SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN udid SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN identifier SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN "IMEI" SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN "MEID" SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN airplay_password SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ALTER COLUMN color SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE installed_applications ALTER COLUMN version SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE installed_applications ALTER COLUMN short_version SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE installed_applications ALTER COLUMN name SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE installed_applications ALTER COLUMN bundle_identifier SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE assets ALTER COLUMN name SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TYPE asset_type ADD VALUE 'EBook' AFTER 'Xsan';
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE media ALTER COLUMN unique_identifier SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE media ALTER COLUMN category SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE media ALTER COLUMN version SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE media ALTER COLUMN alt_version SET DATA TYPE varchar;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE settings RENAME COLUMN auto_push_eapps TO auto_push_media;
2014-09-18 15:11:45 CESTLOG: statement: CREATE TABLE _temp_media_tasks (
mdm_target_id integer,
mdm_target_type mdm_target_type,
device_id integer,
mm_id integer,
internal_task_id integer,
unique_identifier varchar NOT NULL,
task_type varchar NOT NULL,
args varchar
);
2014-09-18 15:11:45 CESTLOG: statement: CREATE TABLE ebooks (
CHECK(asset_type = 'EBook')
) INHERITS (media);
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE ebooks ADD PRIMARY KEY (id);
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE ebooks ALTER COLUMN asset_type SET DEFAULT 'EBook';
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE ebooks ALTER COLUMN category SET DEFAULT 'PDF';
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE ebooks ALTER COLUMN supported_devices SET DEFAULT 7;
2014-09-18 15:11:45 CESTLOG: statement: CREATE UNIQUE INDEX books_unique_uuid ON ebooks USING btree (uuid);
2014-09-18 15:11:45 CESTLOG: statement: CREATE UNIQUE INDEX books_unique_ident ON ebooks USING btree (unique_identifier);
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE completed_tasks RENAME COLUMN vpp_app_id TO vpp_product_id;
2014-09-18 15:11:45 CESTLOG: statement: CREATE TYPE im_status AS ENUM ('pending','managed');
2014-09-18 15:11:45 CESTLOG: statement: CREATE TABLE managed_media (
id SERIAL PRIMARY KEY,
mdm_target_type mdm_target_type NOT NULL,
device_id integer DEFAULT NULL,
mdm_task_id integer DEFAULT NULL REFERENCES mdm_tasks (id) ON DELETE SET NULL UNIQUE,
install_failed_at timestamp DEFAULT NULL,
unique_identifier varchar DEFAULT NULL NOT NULL,
version varchar DEFAULT NULL,
media_type asset_type,
status im_status DEFAULT 'managed'
);
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE network_lab_sessions DROP CONSTRAINT network_lab_sessions_user_id_fkey;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE network_lab_sessions ADD FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE RESTRICT;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE settings ADD COLUMN vpp_county_code varchar(3);
2014-09-18 15:11:45 CESTLOG: statement: CREATE OR REPLACE FUNCTION dm_profile_identifier_for_profile_uuid_alacarte(uuid uuid, alacarte boolean) RETURNS varchar
LANGUAGE plpgsql IMMUTABLE AS $$
<<fn>>
DECLARE
type text;
host varchar;
BEGIN
SELECT server_hostname INTO fn.host FROM settings;
IF fn.host IS NULL OR LENGTH(fn.host) = 0 THEN
RAISE EXCEPTION 'settings.server_hostname is not set';
END IF;
IF alacarte IS TRUE THEN
type := 'alacarte';
ELSE
type := 'pushed';
END IF;
RETURN format('com.apple.mdm.%s.%s.%s', fn.host, uuid::text, fn.type);
END
$$;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_library_items ON library_items;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_asset ON assets;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_modify_work_tasks ON work_tasks;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_abstract_user_group_memberships ON abstract_user_group_memberships;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_abstract_user_groups_users ON abstract_user_groups_users;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_mdm_targets ON mdm_targets;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_od_library_items ON od_library_items;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_media ON media;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_abstract_users ON abstract_users;
2014-09-18 15:11:45 CESTLOG: statement: DROP TRIGGER IF EXISTS dm_trigger_before_delete_insert_abstract_user_groups ON abstract_user_groups;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE devices ADD CHECK(mdm_target_type <> 'tv' OR (hp_singleton_tasks | lp_singleton_tasks | nn_singleton_tasks) & ~(x'2000E880'::integer) = 0);
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE profiles DROP COLUMN signing_certificate_id;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE internal_tasks DROP COLUMN profile_substitution_cache_id;
2014-09-18 15:11:45 CESTLOG: statement: ALTER TABLE internal_tasks ADD CONSTRAINT internal_tasks_check
CHECK( (profile_id IS NOT NULL AND user_id IS NULL AND device_id IS NULL)
OR (profile_id IS NULL AND user_id IS NOT NULL AND device_id IS NULL)
OR (profile_id IS NULL AND user_id IS NULL AND device_id IS NOT NULL)
);
2014-09-18 15:11:45 CESTLOG: statement: DROP TABLE profile_substitution_caches CASCADE;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE managed_media ADD FOREIGN KEY (device_id) REFERENCES devices (id) ON DELETE RESTRICT;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE installed_profiles DROP COLUMN signing_certificate_id;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE settings DROP COLUMN ssl_chain_path;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE settings DROP COLUMN signing_chain_path;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE settings DROP CONSTRAINT settings_check1;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE internal_tasks RENAME COLUMN user_action TO action;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE internal_tasks DROP CONSTRAINT internal_tasks_user_id_fkey;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE internal_tasks RENAME COLUMN user_id TO library_item_id;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE internal_tasks ADD FOREIGN KEY (library_item_id) REFERENCES library_item_metadata (id) ON DELETE CASCADE;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE internal_tasks DROP COLUMN device_id;
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE internal_tasks ADD CONSTRAINT internal_tasks_check
CHECK( (profile_id IS NOT NULL AND library_item_id IS NULL)
OR (profile_id IS NULL AND library_item_id IS NOT NULL)
);
2014-09-18 15:11:46 CESTLOG: statement: ALTER TABLE settings RENAME COLUMN vpp_county_code TO vpp_country_code;
2014-09-18 15:11:46 CESTLOG: statement: CREATE TABLE auto_join_profile_usage (
id SERIAL PRIMARY KEY,
created_at timestamp NOT NULL DEFAULT dm_current_timestamp(),
auto_join_profile_id integer NOT NULL REFERENCES auto_join_profiles (id) ON DELETE CASCADE,
device_id integer REFERENCES devices (id) ON DELETE RESTRICT,
device_tombstone_id integer REFERENCES target_tombstones (id) ON DELETE RESTRICT,
CHECK( (device_id IS NOT NULL AND device_tombstone_id IS NULL)
OR (device_id IS NULL AND device_tombstone_id IS NOT NULL))
);
2014-09-18 15:11:46 CESTLOG: statement: CREATE TEMPORARY TABLE __temp_usage (
auto_join_profile_id integer,
device_id integer,
tombstone_id integer,
"OUR_OWN_TIMESTAMP" timestamp,
"DEVICE_NAME" varchar,
"IMEI" varchar,
"MEID" varchar,
"PRODUCT" varchar,
"SERIAL" varchar,
"UDID" varchar
);
2014-09-18 15:11:46 CESTLOG: statement: CREATE OR REPLACE FUNCTION dm_normalize_imei(value varchar) RETURNS varchar
LANGUAGE plpgsql IMMUTABLE STRICT AS $$
<<fn>>
DECLARE
norm varchar;
BEGIN
fn.norm := regexp_replace(value, '[^0-9]+', '', 'g');
fn.norm := regexp_replace(fn.norm, '([0-9]{2})([0-9]{6})([0-9]{6})([0-9]*)', '\1 \2 \3 \4');
IF fn.norm !~ '^([0-9]{2}) ([0-9]{6}) ([0-9]{6}) ([0-9]*)$' THEN
RAISE NOTICE 'dm_normalize_imei: cannot normalize "%"', value;
fn.norm := NULL;
END IF;
RETURN fn.norm;
END
$$;
2014-09-18 15:11:46 CESTLOG: statement: CREATE OR REPLACE FUNCTION dm_normalize_meid(value varchar) RETURNS varchar
LANGUAGE plpgsql IMMUTABLE STRICT AS $$
<<fn>>
DECLARE
norm varchar;
BEGIN
fn.norm := regexp_replace(upper(value), '[^0-9A-F]+', '', 'g');
RETURN fn.norm;
END
$$;
2014-09-18 15:11:46 CESTLOG: statement: CREATE OR REPLACE FUNCTION dm_normalize_serial_number(value varchar) RETURNS varchar
LANGUAGE plpgsql IMMUTABLE STRICT AS $$
<<fn>>
DECLARE
norm varchar;
BEGIN
fn.norm := regexp_replace(upper(value), '[^0-9A-Z]+', '', 'g');
RETURN fn.norm;
END
$$;
2014-09-18 15:11:46 CESTLOG: statement: CREATE OR REPLACE FUNCTION dm_normalize_udid(value varchar) RETURNS varchar
LANGUAGE plpgsql IMMUTABLE STRICT AS $$
<<fn>>
DECLARE
norm varchar;
BEGIN
fn.norm := regexp_replace(lower(value), '[^0-9a-f]+', '', 'g');
RETURN fn.norm;
END
$$;
2014-09-18 15:11:46 CESTLOG: statement: CREATE OR REPLACE FUNCTION __temp_migrate_ajp(ajp auto_join_profiles) RETURNS void
LANGUAGE plpgsql AS $$
<<fn>>
DECLARE
BEGIN
INSERT INTO __temp_usage
SELECT *
FROM json_populate_recordset(NULL::__temp_usage, ajp.usage_log::json);
UPDATE __temp_usage
SET auto_join_profile_id = ajp.id,
"IMEI" = dm_normalize_imei(NULLIF("IMEI", '')),
"MEID" = dm_normalize_imei(NULLIF("MEID", '')),
"SERIAL" = dm_normalize_serial_number(NULLIF("SERIAL", '')),
"UDID" = dm_normalize_udid(NULLIF("UDID", ''))
WHERE auto_join_profile_id IS NULL;
UPDATE __temp_usage AS u
SET device_id = d.id
FROM devices AS d
WHERE d."IMEI" = u."IMEI"
OR d."MEID" = u."MEID"
OR d."SerialNumber" = u."SERIAL"
OR d.udid = u."UDID";
UPDATE __temp_usage AS u
SET tombstone_id = t.id
FROM target_tombstones AS t
WHERE target_class = 'Device'
AND target_ident = u."UDID";
WITH tt AS (
INSERT INTO target_tombstones (target_name, target_extra, target_class, target_ident)
SELECT FIRST(u."DEVICE_NAME" ORDER BY "OUR_OWN_TIMESTAMP" DESC), FIRST(u."PRODUCT" ORDER BY "OUR_OWN_TIMESTAMP" DESC), 'Device', u."UDID"
FROM __temp_usage AS u
WHERE u.device_id IS NULL AND u.tombstone_id IS NULL
GROUP BY u."UDID"
RETURNING *
)
UPDATE __temp_usage AS u
SET tombstone_id = tt.id
FROM tt
WHERE tombstone_id IS NULL
AND target_class = 'Device'
AND target_ident = tt.target_ident;
END
$$;
2014-09-18 15:11:46 CESTERROR: new row for relation "auto_join_profile_usage" violates check constraint "auto_join_profile_usage_check"
2014-09-18 15:11:46 CESTDETAIL: Failing row contains (20, 2014-05-16 13:22:51, 1, 2930, 2932).
2014-09-18 15:11:46 CESTSTATEMENT: INSERT INTO auto_join_profile_usage (created_at, auto_join_profile_id, device_id, device_tombstone_id)
SELECT "OUR_OWN_TIMESTAMP", auto_join_profile_id, device_id, tombstone_id FROM __temp_usage;
2014-09-18 15:11:48 CESTLOG: connection received: host=[local]
2014-09-18 15:11:48 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:27 CESTLOG: connection received: host=[local]
2014-09-18 15:12:27 CESTLOG: connection authorized: user=_devicemgr database=template1
2014-09-18 15:12:27 CESTLOG: connection received: host=[local]
2014-09-18 15:12:27 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "ebooks" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "device_enrollment_settings" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "certificates" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "managed_media" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "abstract_user_groups" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "target_tombstones" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "od_searches" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "inactive_user_groups" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "abstract_users" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: statement: ALTER TABLE "inactive_users" ENABLE TRIGGER USER
2014-09-18 15:12:27 CESTLOG: connection received: host=[local]
2014-09-18 15:12:27 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:27 CESTLOG: connection received: host=[local]
2014-09-18 15:12:27 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:27 CESTLOG: connection received: host=[local]
2014-09-18 15:12:27 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:28 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3016-3" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:28 CESTERROR: function dm_prepare_next_internal_task() does not exist at character 15
2014-09-18 15:12:28 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:28 CESTSTATEMENT: SELECT * FROM dm_prepare_next_internal_task()
2014-09-18 15:12:28 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3017-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:28 CESTERROR: relation "view_active_user_vpp_email_invitation_tasks" does not exist at character 18
2014-09-18 15:12:28 CESTSTATEMENT: SELECT t0.* FROM "view_active_user_vpp_email_invitation_tasks" AS t0 LIMIT 1
2014-09-18 15:12:28 CESTLOG: connection received: host=[local]
2014-09-18 15:12:28 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:28 CESTERROR: relation "view_pending_push_notifications" does not exist at character 18
2014-09-18 15:12:28 CESTSTATEMENT: SELECT t0.* FROM "view_pending_push_notifications" AS t0 ORDER BY "last_push_time" ASC LIMIT 100
2014-09-18 15:12:28 CESTERROR: function dm_prepare_next_internal_task() does not exist at character 15
2014-09-18 15:12:28 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:28 CESTSTATEMENT: SELECT * FROM dm_prepare_next_internal_task()
2014-09-18 15:12:28 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3021-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:28 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3026-4" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:28 CESTERROR: function dm_make_user_active(integer) does not exist at character 72
2014-09-18 15:12:28 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:28 CESTSTATEMENT: INSERT INTO "user_groups_users" (user_group_id, user_id) (SELECT 1712, dm_make_user_active(u.id) FROM "abstract_users" AS u WHERE u.guid IN ('FFFFEEEE-DDDD-CCCC-BBBB-AAAA00000000','6C0B586C-39CA-4BED-AC49-4E61595B14AF','AF65D4DE-11F3-4996-BCE4-936ECB3CF922','57973286-6E91-45F9-8537-E8A2A50CDA7C') AND NOT EXISTS (SELECT 1 FROM "user_groups_users" WHERE user_group_id = 1712 AND user_id = u.id))
2014-09-18 15:12:28 CESTLOG: connection received: host=[local]
2014-09-18 15:12:28 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:28 CESTERROR: could not serialize access due to concurrent update
2014-09-18 15:12:28 CESTSTATEMENT: SELECT t0.* FROM "settings" AS t0 LIMIT 1 FOR UPDATE
2014-09-18 15:12:28 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3036-4" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:28 CESTERROR: function dm_make_user_active(integer) does not exist at character 72
2014-09-18 15:12:28 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:28 CESTSTATEMENT: INSERT INTO "user_groups_users" (user_group_id, user_id) (SELECT 1877, dm_make_user_active(u.id) FROM "abstract_users" AS u WHERE u.guid IN ('57973286-6E91-45F9-8537-E8A2A50CDA7C') AND NOT EXISTS (SELECT 1 FROM "user_groups_users" WHERE user_group_id = 1877 AND user_id = u.id))
2014-09-18 15:12:29 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3041-4" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:29 CESTERROR: function dm_make_user_active(integer) does not exist at character 72
2014-09-18 15:12:29 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:29 CESTSTATEMENT: INSERT INTO "user_groups_users" (user_group_id, user_id) (SELECT 1712, dm_make_user_active(u.id) FROM "abstract_users" AS u WHERE u.guid IN ('FFFFEEEE-DDDD-CCCC-BBBB-AAAA00000000','6C0B586C-39CA-4BED-AC49-4E61595B14AF','AF65D4DE-11F3-4996-BCE4-936ECB3CF922','57973286-6E91-45F9-8537-E8A2A50CDA7C') AND NOT EXISTS (SELECT 1 FROM "user_groups_users" WHERE user_group_id = 1712 AND user_id = u.id))
2014-09-18 15:12:29 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3042-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:29 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3043-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:29 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3045-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:29 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3046-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:29 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3169-2" ("value" varchar UNIQUE)
2014-09-18 15:12:29 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3169-2"
2014-09-18 15:12:29 CESTERROR: relation "view_vpp_users_to_register" does not exist at character 18
2014-09-18 15:12:29 CESTSTATEMENT: SELECT t0.* FROM "view_vpp_users_to_register" AS t0 LIMIT 1
2014-09-18 15:12:30 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3414-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:30 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3415-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:30 CESTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3434-2" ("value" uuid UNIQUE NOT NULL)
2014-09-18 15:12:30 CESTLOG: connection received: host=[local]
2014-09-18 15:12:30 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:12:30 CESTERROR: function dm_make_user_active(integer) does not exist at character 72
2014-09-18 15:12:30 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:30 CESTSTATEMENT: INSERT INTO "user_groups_users" (user_group_id, user_id) (SELECT 1877, dm_make_user_active(u.id) FROM "abstract_users" AS u WHERE u.guid IN ('57973286-6E91-45F9-8537-E8A2A50CDA7C') AND NOT EXISTS (SELECT 1 FROM "user_groups_users" WHERE user_group_id = 1877 AND user_id = u.id))
2014-09-18 15:12:30 CESTERROR: function dm_make_user_active(integer) does not exist at character 72
2014-09-18 15:12:30 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:30 CESTSTATEMENT: INSERT INTO "user_groups_users" (user_group_id, user_id) (SELECT 1712, dm_make_user_active(u.id) FROM "abstract_users" AS u WHERE u.guid IN ('FFFFEEEE-DDDD-CCCC-BBBB-AAAA00000000','6C0B586C-39CA-4BED-AC49-4E61595B14AF','AF65D4DE-11F3-4996-BCE4-936ECB3CF922','57973286-6E91-45F9-8537-E8A2A50CDA7C') AND NOT EXISTS (SELECT 1 FROM "user_groups_users" WHERE user_group_id = 1712 AND user_id = u.id))
2014-09-18 15:12:31 CESTERROR: function dm_make_user_active(integer) does not exist at character 72
2014-09-18 15:12:31 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:31 CESTSTATEMENT: INSERT INTO "user_groups_users" (user_group_id, user_id) (SELECT 3841, dm_make_user_active(u.id) FROM "abstract_users" AS u WHERE u.guid IN ('6C0B586C-39CA-4BED-AC49-4E61595B14AF','8AE2C586-10F5-4F5F-BDAC-D8D9E35E1F21','89D92814-D628-4E08-96C6-02261A6A058C') AND NOT EXISTS (SELECT 1 FROM "user_groups_users" WHERE user_group_id = 3841 AND user_id = u.id))
2014-09-18 15:12:31 CESTERROR: function dm_update_user_group_member_counts(integer) does not exist at character 8
2014-09-18 15:12:31 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:31 CESTSTATEMENT: SELECT dm_update_user_group_member_counts(id) FROM "user_groups"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3016-3"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3414-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3415-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3434-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3045-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3042-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3046-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3043-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3021-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3017-2"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3041-4"
2014-09-18 15:12:31 CESTERROR: table "__runtime_temp_devicemgrd-3041-4" does not exist
2014-09-18 15:12:31 CESTSTATEMENT: DROP TABLE "__runtime_temp_devicemgrd-3041-4"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3036-4"
2014-09-18 15:12:31 CESTERROR: table "__runtime_temp_devicemgrd-3036-4" does not exist
2014-09-18 15:12:31 CESTSTATEMENT: DROP TABLE "__runtime_temp_devicemgrd-3036-4"
2014-09-18 15:12:31 CESTLOG: statement: DROP TABLE "__runtime_temp_devicemgrd-3026-4"
2014-09-18 15:12:31 CESTERROR: table "__runtime_temp_devicemgrd-3026-4" does not exist
2014-09-18 15:12:31 CESTSTATEMENT: DROP TABLE "__runtime_temp_devicemgrd-3026-4"
2014-09-18 15:12:32 CESTERROR: function dm_send_update_info_for_devices_with_limit(integer) does not exist at character 8
2014-09-18 15:12:32 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:12:32 CESTSTATEMENT: SELECT dm_send_update_info_for_devices_with_limit(10)
2014-09-18 15:13:29 CESTLOG: connection received: host=[local]
2014-09-18 15:13:29 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:03 CESTLOG: connection received: host=[local]
2014-09-18 15:14:03 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTLOG: connection received: host=[local]
2014-09-18 15:14:22 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTLOG: connection received: host=[local]
2014-09-18 15:14:22 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTLOG: connection received: host=[local]
2014-09-18 15:14:22 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTLOG: connection received: host=[local]
2014-09-18 15:14:22 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTLOG: connection received: host=[local]
2014-09-18 15:14:22 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTLOG: connection received: host=[local]
2014-09-18 15:14:22 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTLOG: connection received: host=[local]
2014-09-18 15:14:22 CESTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-09-18 15:14:22 CESTERROR: function dm_device_application_lists_updated(unknown) does not exist at character 8
2014-09-18 15:14:22 CESTHINT: No function matches the given name and argument types. You might need to add explicit type casts.
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_device_application_lists_updated($1)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction block
2014-09-18 15:14:22 CESTSTATEMENT: SELECT dm_complete_mdm_tasks_for_mdm_target($1,$2,$3,$4,$5)
2014-09-18 15:14:22 CESTERROR: current transaction is aborted, commands ignored until end of transaction blocklast lines repeated really often!
devicemgrd.log
0:: [172] [2014/09/18 15:09:06.796] BYE
[4447] [2014/09/18 15:12:26.996] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [4447] [2014/09/18 15:12:26.997]
############################################################################
devicemgrd-875.25 (PID:4447, OS:13F34, SERVER:13S5179, ARCH:x86_64) starting
LA: devicemgrd
Log verbosity level = 1
UID = 220, EUID = 220
############################################################################
1:: [4447] [2014/09/18 15:12:27.006] Incoming request: informWebAppState
0:: [4447] [2014/09/18 15:12:27.139] +[PGConnection reloadPreferences]: DBDebug = NO, DBLogNotices = NO, DBLogSQL = NO, DBMonitor = NO
0:: [4447] [2014/09/18 15:12:27.659] Profile Manager service RUNNING
0:: [4447] [2014/09/18 15:12:27.760] Loaded strings for locale 'de'.
0:: [4447] [2014/09/18 15:12:27.786] -[NSString(devicemgr_Additions) dateFromOpenSSLString]: 'Aug 7 06:31:58 2015 GMT'
1:: [4447] [2014/09/18 15:12:27.964] Wrote trust profile to /Library/Server/ProfileManager/Config/ServiceData/Data/FileStore/Trust-Profil_für_Scholz_&_Friends_Hamburg_GmbH.mobileconfig
1:: [4447] [2014/09/18 15:12:27.977] Registering for network reachability notifications to "gateway.push.apple.com".
0:: [4447] [2014/09/18 15:12:27.982] APNS topic = com.apple.mgmt.XServer.ffb8ced7-ea43-4041-8fd0-4be89ae33177
1:: [4447] [2014/09/18 15:12:27.996] Allowing OD full sync even though it might not have been long enough since the last full sync.
1:: [4447] [2014/09/18 15:12:28.006] Preparing to sync required users and groups
0:: [4447] [2014/09/18 15:12:28.050] Caught unhandled exception -[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:425): "Postgres error 42883 (ERROR: function dm_prepare_next_internal_task() does not exist
LINE 1: SELECT * FROM dm_prepare_next_internal_task()
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:28.053] Requesting incremental App Distribution sync in response to device token update
0:: [4447] [2014/09/18 15:12:28.056] Caught unhandled exception -[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:425): "Postgres error 42P01 (ERROR: relation "view_active_user_vpp_email_invitation_tasks" does not exist
LINE 1: SELECT t0.* FROM "view_active_user_vpp_email_invitation_task...
^
)"
1:: [4447] [2014/09/18 15:12:28.057] >>> networkSettingsChanged: "gateway.push.apple.com" is apparently reachable (flags = 0x2)
0:: [4447] [2014/09/18 15:12:28.063] Caught exception attempting to send push notifications: -[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:425): "Postgres error 42P01 (ERROR: relation "view_pending_push_notifications" does not exist
LINE 1: SELECT t0.* FROM "view_pending_push_notifications" AS t0 O...
^
)"
0:: [4447] [2014/09/18 15:12:28.064] Caught unhandled exception -[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:425): "Postgres error 42883 (ERROR: function dm_prepare_next_internal_task() does not exist
LINE 1: SELECT * FROM dm_prepare_next_internal_task()
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:28.065] -[DMODSyncRunner _syncGroupODRecords:syncMode:createActive:state:]: Processed 1 group records (synced 1)
1:: [4447] [2014/09/18 15:12:28.117] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Querying OD for 2 new users and groups
0:: [4447] [2014/09/18 15:12:28.195] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1712, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:28.196] Unable to sync group record with '<ODRecord 0x7ff75ae266e0 [attributes {'dsAttrTypeStandard:GeneratedUID': 'ABCDEFAB-CDEF-ABCD-EFAB-CDEF00000050', 'dsAttrTypeStandard:RecordName': ['admin', 'BUILTIN\Administrators'], 'dsAttrTypeStandard:AppleMetaNodeLocation': '/Local/Default', 'dsAttrTypeStandard:RealName': 'Administrators', 'dsAttrTypeStandard:RecordType': 'dsRecTypeStandard:Groups', 'dsAttrTypeStandard:PrimaryGroupID': '80', 'dsAttrTypeStandard:GroupMembers': ['FFFFEEEE-DDDD-CCCC-BBBB-AAAA00000000', '57973286-6E91-45F9-8537-E8A2A50CDA7C', 'AF65D4DE-11F3-4996-BCE4-936ECB3CF922', '6C0B586C-39CA-4BED-AC49-4E61595B14AF'], 'dsAttrTypeStandard:GroupMembership': ['root', 'admin', 'diradmin'], 'dsAttrTypeStandard:NestedGroups': '1EC73A3F-EBF6-4BD4-8DB5-B4062BB572BF'}]>': -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1712, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:28.196] -[DMODSyncRunner _syncGroupODRecords:syncMode:createActive:state:]: Processed 2 group records (synced 1)
1:: [4447] [2014/09/18 15:12:28.199] Preparing to sync OD subset
0:: [4447] [2014/09/18 15:12:28.271] -[NSString(devicemgr_Additions) dateFromOpenSSLString]: 'Nov 16 19:33:13 2015 GMT'
1:: [4447] [2014/09/18 15:12:28.274] __31+[Settings updateSigningState:]_block_invoke115: Signing organization or common name = hydra.s-f.com Signierungszertifikate f\xC3\xBCr Code
1:: [4447] [2014/09/18 15:12:28.277] Entering STM (this TXN retry count = 1, accumulated retry count = 30)
1:: [4447] [2014/09/18 15:12:28.281] Exiting STM
0:: [4447] [2014/09/18 15:12:28.281] RAW JSON !=, key:dynamic_attributes
PRIOR:
{"sacl_migration_done":true,"._vpp_last_incremental_sync":"TIMESTAMP","vpp_last_incremental_sync":1411043556.331841,"vpp_server_apple_id":"ham-it-vpp-apple@s-f.com","vpp_last_full_sync":1411044621.609943,"VPPUsersSinceModifiedToken":"H4sIAAAAAAAAAKtWMFCwVdBQMDQ0t7S0UNC0VlAoyS9JzHFKLEnOSC12yy\/NS3EGEiVAVYZAycw03\/yUzLTM1JTgzLzkVN\/MnJzMYpCciaGhgYmJmZGBuYkZiiEw3QYg0cqCVCBTqRisF2qQEsjYvOSc0pTUoNSSzKLUFIhdtQDVQKVinAAAAA==","vpp_server_last_enabled_apple_id":"ham-it-vpp-apple@s-f.com","vpp_stoken":"eyJ0b2tlbiI6IlFxczh1bndLdHY1ZGdrcjNRUEE4TGZiSXlDVTZqSm9kM0xXNHNIVEZsSFhrNmRoRmU1ajUyKzhaQzhtSVVBK0ptYWF6L0M4SHVkRHlocWEvalJ0SHZ3PT0iLCJleHBEYXRlIjoiMjAxNC0xMi0wM1QwODo0NDoyMy0wODAwIiwib3JnTmFtZSI6IlNjaG9seiAmIEZyaWVuZHMgSGFtYnVyZyBHbWJIIn0=","VPPLicensesSinceModifiedToken":"H4sIAAAAAAAAAKtWMFCwVdBQMDYxMLW0VNC0VlAoyS9JzHFKLEnOSC12yy\/NS3EGEiVAVYYgycqCVCBTqTgzLznVNz8lMy0zNUUJRRdMuQFQNDMNpiYYrCEzJyezGGSUiaGhgYmJmZGhkamZtUItALo59BWHAAAA","._vpp_last_full_sync":"TIMESTAMP","trust_profile_filename":"Trust-Profil_für_Scholz_&_Friends_Hamburg_GmbH.mobileconfig"}
CURRENT
{"vpp_server_apple_id":"ham-it-vpp-apple@s-f.com","vpp_last_full_sync":1411044621.609943,"vpp_stoken":"eyJ0b2tlbiI6IlFxczh1bndLdHY1ZGdrcjNRUEE4TGZiSXlDVTZqSm9kM0xXNHNIVEZsSFhrNmRoRmU1ajUyKzhaQzhtSVVBK0ptYWF6L0M4SHVkRHlocWEvalJ0SHZ3PT0iLCJleHBEYXRlIjoiMjAxNC0xMi0wM1QwODo0NDoyMy0wODAwIiwib3JnTmFtZSI6IlNjaG9seiAmIEZyaWVuZHMgSGFtYnVyZyBHbWJIIn0=","VPPUsersSinceModifiedToken":"H4sIAAAAAAAAAKtWMFCwVdBQMDQ0t7S0UNC0VlAoyS9JzHFKLEnOSC12yy\/NS3EGEiVAVYZAycw03\/yUzLTM1JTgzLzkVN\/MnJzMYpCciaGhgYmJmZGBuYkZiiEw3QYg0cqCVCBTqRisF2qQEsjYvOSc0pTUoNSSzKLUFIhdtQDVQKVinAAAAA==","._vpp_last_incremental_sync":"TIMESTAMP","vpp_last_incremental_sync":1411043556.331841,"VPPLicensesSinceModifiedToken":"H4sIAAAAAAAAAKtWMFCwVdBQMDYxMLW0VNC0VlAoyS9JzHFKLEnOSC12yy\/NS3EGEiVAVYYgycqCVCBTqTgzLznVNz8lMy0zNUUJRRdMuQFQNDMNpiYYrCEzJyezGGSUiaGhgYmJmZGhkamZtUItALo59BWHAAAA","vpp_server_last_enabled_apple_id":"ham-it-vpp-apple@s-f.com","sacl_migration_done":true,"._vpp_last_full_sync":"TIMESTAMP","trust_profile_filename":"Trust-Profil_für_Scholz_&_Friends_Hamburg_GmbH.mobileconfig","vpp_config_settings":{"expDate":"2014-12-03T08:44:23-0800","orgName":"Scholz & Friends Hamburg GmbH"}}
1:: [4447] [2014/09/18 15:12:28.413] Wrote trust profile to /Library/Server/ProfileManager/Config/ServiceData/Data/FileStore/Trust-Profil_für_Scholz_&_Friends_Hamburg_GmbH.mobileconfig
1:: [4447] [2014/09/18 15:12:28.510] -[DMODSyncRunner _syncODUserSubset]: Processed 130 users from OD subset
0:: [4447] [2014/09/18 15:12:28.994] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1877, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:28.994] Unable to sync group record with '<ODRecord 0x7ff75ac76f10 [attributes {'dsAttrTypeStandard:GeneratedUID': '45226B90-00DC-4504-A2B9-7420ABA005DE', 'dsAttrTypeStandard:RecordName': 'deprecated_pm_access_61e93cd7', 'dsAttrTypeStandard:AppleMetaNodeLocation': '/Local/Default', 'dsAttrTypeStandard:RealName': 'Deprecated Profile Manager Access Group', 'dsAttrTypeStandard:RecordType': 'dsRecTypeStandard:Groups', 'dsAttrTypeStandard:PrimaryGroupID': '1000', 'dsAttrTypeStandard:GroupMembers': '57973286-6E91-45F9-8537-E8A2A50CDA7C', 'dsAttrTypeStandard:GroupMembership': 'admin'}]>': -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1877, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:28.996] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Art-Buying_KST-0181_MA
1:: [4447] [2014/09/18 15:12:29.015] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Querying OD for 2 new users and groups
0:: [4447] [2014/09/18 15:12:29.051] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1712, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:29.052] Unable to sync group record with '<ODRecord 0x7ff75ae91a40 [attributes {'dsAttrTypeStandard:GeneratedUID': 'ABCDEFAB-CDEF-ABCD-EFAB-CDEF00000050', 'dsAttrTypeStandard:RecordName': ['admin', 'BUILTIN\Administrators'], 'dsAttrTypeStandard:AppleMetaNodeLocation': '/Local/Default', 'dsAttrTypeStandard:RealName': 'Administrators', 'dsAttrTypeStandard:RecordType': 'dsRecTypeStandard:Groups', 'dsAttrTypeStandard:PrimaryGroupID': '80', 'dsAttrTypeStandard:GroupMembers': ['FFFFEEEE-DDDD-CCCC-BBBB-AAAA00000000', '57973286-6E91-45F9-8537-E8A2A50CDA7C', 'AF65D4DE-11F3-4996-BCE4-936ECB3CF922', '6C0B586C-39CA-4BED-AC49-4E61595B14AF'], 'dsAttrTypeStandard:GroupMembership': ['root', 'admin', 'diradmin'], 'dsAttrTypeStandard:NestedGroups': '1EC73A3F-EBF6-4BD4-8DB5-B4062BB572BF'}]>': -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1712, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:29.052] -[DMODSyncRunner _syncGroupODRecords:syncMode:createActive:state:]: Processed 4 group records (synced 1)
1:: [4447] [2014/09/18 15:12:29.082] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group dd3580d8-94de-4597-b0bc-3b8560076422 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.107] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 66288b6b-6c30-4c6e-b622-85ffc213e462 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.120] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 12c52a37-5e24-4002-a461-4456bc3547e1 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.126] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group fc1dbb88-7fe9-452a-b324-a157ee1c9940 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.132] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group d244e563-ebf5-44fa-a127-06bb8a9896c0 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.152] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group b50d0f97-04f8-4295-8867-f833664fa934 direct member count has changed (was: 3895, is: 0)
1:: [4447] [2014/09/18 15:12:29.166] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group ca6c360d-6e0d-4014-9378-be1f69ac11db direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.177] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 81d771fb-c5e2-4244-88e2-469d59d10a7b direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.184] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 5d071e04-0f6d-45b4-95a7-90d0e9052788 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.191] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group e25632ec-e9e9-4e5f-a0dd-3d88b76fd3b9 direct member count has changed (was: 2103, is: 0)
1:: [4447] [2014/09/18 15:12:29.197] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 76a2fc87-d56e-43d5-a176-ce8cadececb5 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.205] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 9d3ec4a2-2152-48b6-a563-0335d28700ab direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.225] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 4a3d04ed-b081-47f7-ada3-31f9d233b93c direct member count has changed (was: 2103, is: 0)
1:: [4447] [2014/09/18 15:12:29.262] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 70593e40-172a-4a5c-8fb3-4312bb34674e direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.287] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group bd01e166-52f0-4ef2-8746-fde3a8d3db6a direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.298] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 4698fa53-be7f-4f82-a106-d61b3b30bcaa direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.303] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 2752ef58-8326-4b6d-8d0a-a858bc6cf3ef direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.309] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 8f27ec77-346e-4989-ad48-c0bf59d4a57e direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.314] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 93ed87e7-4cb8-4352-aae4-4381139fdd15 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.319] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group ccfdc179-c2f6-4b86-a91f-dc98cdbc49a0 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.330] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group fdc1d17f-6651-484b-aac2-84e03fcb085f direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.338] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 6d06a696-a96b-4967-b417-6afc9e23a98d direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.346] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group e5abc9b3-e94b-49d5-9825-050596fd4e4a direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.354] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 84344185-a866-4a0e-bd1e-416090f5f14c direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.362] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group c0c32697-7127-44cb-8bfa-af9390fa349f direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.374] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group b13266c0-e177-4eb3-915e-935669744fe2 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.382] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group b8246fca-ac15-4fb5-8bd2-aa06593f446a direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.388] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group d89aac62-358c-4e3a-9b2f-f40a97dcbbe8 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.395] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group ab48f7c0-6b7f-4a6f-97bb-005574eb15ef direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.401] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group dd823437-7ded-4a43-9327-953ddb385988 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.416] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 0bc5e2bf-84be-47e5-933a-d6c83dad8f24 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.421] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group ee7c1e4d-1ba5-47e2-99ea-980f9835d46f direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.428] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group c892171b-9eb7-46b4-825c-dd228208433a direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.439] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 6f24ceac-a8e0-496f-aa7b-043c93420bc7 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.451] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 4c2445a7-970e-465f-b9a8-cf0f37ebd86c direct member count has changed (was: 1079, is: 0)
1:: [4447] [2014/09/18 15:12:29.460] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 7122db0c-06a8-4930-bf28-300c4a1f1b24 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.468] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group c891e97c-dec2-4405-b22e-648947887cd1 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.484] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group bbc124a1-2a69-443e-8c18-da2f07df33f3 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.503] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 7ceaae00-1b55-4b3f-bcd1-f47475aa04b6 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.511] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 34975d7d-90d2-4f10-92e7-2c4991a695e2 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.524] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 84caa500-c204-443a-a1d1-76f650f5f4ff direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.550] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 0dd7e65d-1e54-4022-87ff-c0508abbd651 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.561] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group d10b64d5-a1e3-457b-be18-f128e627d3fd direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.577] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 68046779-3aee-44ee-9641-4463183738ee direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.589] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 11692352-acaf-4c3b-a37b-378a6ecce588 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.596] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group aecc2f9e-699e-4294-9871-ba1b665bcdc5 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.605] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 66a3ba9a-d585-4e58-850b-10f33fd8e502 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.634] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 8e3f665f-2f9a-43da-893c-3f2226d7eee1 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.654] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 61111749-d4c6-4227-89ec-7b1a9ac24465 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.671] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 3032f1e5-f860-4d74-b70b-12d3631628f9 direct member count has changed (was: 1847, is: 0)
1:: [4447] [2014/09/18 15:12:29.696] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 4c206e93-587d-4738-9a51-8f3cbad50041 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.704] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 7fd12bc2-067b-4f5d-abc8-501689fec45d direct member count has changed (was: 2103, is: 0)
1:: [4447] [2014/09/18 15:12:29.721] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group b23d228b-1765-47cb-852a-692a6622df40 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.730] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 9ffa13a4-4dc8-4ec4-8a0e-687b4d5f0b29 direct member count has changed (was: 1335, is: 0)
1:: [4447] [2014/09/18 15:12:29.737] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group a032cb32-d02b-4327-b643-6ce71b946924 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.747] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 942ece59-cf75-4249-bef5-b23a84a78d72 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.776] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 023d8464-f156-4b15-8888-dc718053da20 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.785] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group c305a3ef-037f-4769-a0f4-d213065ee673 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.795] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 22a8aa65-2466-4d14-8a44-50ceae644ea0 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.811] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 758458c3-726c-4caf-a4ca-a267fc8acddc direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.818] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 0bdd8a4c-a5cf-4351-9ddd-8efd024a4d56 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:29.874] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 5b6f159a-dcfb-4692-b261-fe59e197d935 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:29.915] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 259b99f4-4ff5-4790-b779-f1e3ab850fea direct member count has changed (was: 2615, is: 0)
0:: [4447] [2014/09/18 15:12:29.994] Caught unhandled exception running DMVPPSyncRunner. Aborting.
-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:425): "Postgres error 42P01 (ERROR: relation "view_vpp_users_to_register" does not exist
LINE 1: SELECT t0.* FROM "view_vpp_users_to_register" AS t0 LIMIT ...
^
)"
0:: [4447] [2014/09/18 15:12:29.994] -[StateMachine setException:]: -[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:425): "Postgres error 42P01 (ERROR: relation "view_vpp_users_to_register" does not exist
LINE 1: SELECT t0.* FROM "view_vpp_users_to_register" AS t0 LIMIT ...
^
)"
0:: [4447] [2014/09/18 15:12:29.994] Sync of VPP data failed: -[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:425): "Postgres error 42P01 (ERROR: relation "view_vpp_users_to_register" does not exist
LINE 1: SELECT t0.* FROM "view_vpp_users_to_register" AS t0 LIMIT ...
^
)"
1:: [4447] [2014/09/18 15:12:29.995] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 4fb78185-50c5-46b1-ba12-c0040396a5fe direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.007] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group cbbe388c-6f09-438b-ab6c-9114ebbee8c1 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.014] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 52bc20c2-feff-4f36-9f62-49e28ad946ea direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.021] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 96d76a4f-a7f7-4874-bc23-3ce64dc1ec82 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.042] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group cc01b90c-0543-4056-9a18-c805a423da9b direct member count has changed (was: 823, is: 0)
1:: [4447] [2014/09/18 15:12:30.050] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group dca13261-cacf-462e-8118-ff31dea4d0d9 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.057] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group c43251b6-7904-4a96-b1c8-0b25e0baee46 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.065] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group d5c0f063-d986-42a0-b56a-fbb5c832044b direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.071] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 8fd8bac3-81d5-43a7-a1f1-c489024b8943 direct member count has changed (was: 3127, is: 0)
1:: [4447] [2014/09/18 15:12:30.107] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 818bb54d-6cc8-4203-ba27-470bdeb1d6c4 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.124] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 219aabe4-c907-4f5e-a282-d61dea8e88c7 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.134] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group f9195e52-5983-4990-8ced-de0fb29c9c7f direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.140] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 57a6ea0d-2d53-4527-8ba8-bbab59f51c10 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.151] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 31654bfc-5f23-4eab-a0f6-5852cd9f3d1d direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.161] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 2c0318c2-0ff2-4a29-99c2-af590923913f direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.166] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 0233ed7e-80e2-4fcd-8abd-892fbd7edb55 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.174] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 299ec28b-caff-4234-bc2a-eb305b72f8c4 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.186] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group f6fd94dc-9b84-4aeb-82a6-b0fd32dd5629 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.197] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group ac33e932-e49f-4f88-9c7e-c658bad936c3 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.203] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group a2b775a1-a2e1-4d4a-9d8a-4890d61251fa direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.209] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 66ec81a2-8623-4825-aee2-089b14931122 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.275] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group e0728622-1cb0-4634-af1b-7c84ee6e9861 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.281] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 5b994258-7aff-41ff-9b1b-a6aadf686842 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.286] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 20094034-3971-4bcd-bf4a-f41a0e2bae67 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.290] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group a1ab7ae7-acdc-4385-8512-f059a9561fea direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.297] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 38ab154c-da1f-4bf6-afb2-ee7a3aa2d5fa direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.302] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group ff810077-f69f-41df-a809-ed213a2b5337 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.309] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group b62e9f4b-4b18-4c50-bcf1-670dde00f1e5 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.313] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 27cf0084-7b3d-44a0-8cee-9781d84cc6b5 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.322] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 74007a8b-502f-419d-99e4-e8128e6311ac direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.327] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 8fa13455-1b3b-42b3-8e80-ce5f5ddd9012 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.331] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 18103ca7-e5d3-481f-975b-53187716650d direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.352] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group e280a40e-cba5-446c-a1bd-a33b50dc2b60 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.370] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 34349adb-87d1-4b2b-be1e-18f8810b6246 direct member count has changed (was: 823, is: 0)
1:: [4447] [2014/09/18 15:12:30.391] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group f1d24f3d-4e34-4005-8281-62b45d586b97 direct member count has changed (was: 823, is: 0)
1:: [4447] [2014/09/18 15:12:30.399] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 0d299490-a54b-48dc-bb7d-3287150d5c13 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.408] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group e86ab337-13fd-4daf-ac49-fabd2f413811 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.414] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 51e08794-21ea-47d3-80bc-a6a1356c6015 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.420] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 85b03747-455a-437a-8f5d-658b8c5e1cac direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.440] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 57f165df-c818-4b5f-b2a6-d56f466d5dc0 direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.446] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 9285cd1f-c519-4b7f-940b-94682788ff2b direct member count has changed (was: 567, is: 0)
1:: [4447] [2014/09/18 15:12:30.453] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 77c9880b-7f5b-4405-a5a8-154e30c36420 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.460] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 8cd9398a-f380-435d-8f8a-4dda01aacd88 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.471] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group e13ca75c-2479-46e8-b799-69280c76967f direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.476] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group f8269bd4-ab84-4e2a-a506-31291d3fba66 direct member count has changed (was: 2615, is: 0)
1:: [4447] [2014/09/18 15:12:30.482] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 8a9c850e-a406-4a66-99a9-5044b7b1e635 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.493] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 649abfd2-e734-4b71-b1c1-a6a9cc05c979 direct member count has changed (was: 311, is: 0)
1:: [4447] [2014/09/18 15:12:30.496] -[DMODSyncRunner _syncGroupODRecords:syncMode:createActive:state:]: Processed 294 group records (synced 181)
1:: [4447] [2014/09/18 15:12:30.496] -[DMODSyncRunner _syncODGroupSubset]: Processed 6 already active groups from OD subset
1:: [4447] [2014/09/18 15:12:30.496] -[DMODSyncRunner _syncODGroupSubset]: Processed 294 non-active groups from OD subset
1:: [4447] [2014/09/18 15:12:30.496] Preparing to sync active users and groups
1:: [4447] [2014/09/18 15:12:30.577] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_One-Zero_KST-6054_MA
1:: [4447] [2014/09/18 15:12:30.594] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_OPC-FRA_KST-5059_MA
1:: [4447] [2014/09/18 15:12:30.610] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_OPC-Lit-Creation_KST-5057_MA
1:: [4447] [2014/09/18 15:12:30.625] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_OPC-Int-Creation_KST-5056_MA
1:: [4447] [2014/09/18 15:12:30.642] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Service_KST-5200_MA
1:: [4447] [2014/09/18 15:12:30.657] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Beratung-2-FT_KST-4152_MA
1:: [4447] [2014/09/18 15:12:30.672] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Kreation-1-LS_KST-4151_MA
1:: [4447] [2014/09/18 15:12:30.691] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group 4c77e98c-662c-43d6-8534-544979c3272d direct member count has changed (was: 7223, is: 0)
1:: [4447] [2014/09/18 15:12:30.691] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_ALLE_MA
1:: [4447] [2014/09/18 15:12:30.717] Removed 28 total groups from membership for group 4C77E98C-662C-43D6-8534-544979C3272D
1:: [4447] [2014/09/18 15:12:30.730] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Human-Resources_KST-0903_MA
1:: [4447] [2014/09/18 15:12:30.747] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_FFF_KST-0182_MA
0:: [4447] [2014/09/18 15:12:30.793] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1877, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:30.794] Unable to sync group record with '<ODRecord 0x7ff75ac4bf70 [attributes {'dsAttrTypeStandard:GeneratedUID': '45226B90-00DC-4504-A2B9-7420ABA005DE', 'dsAttrTypeStandard:RecordName': 'deprecated_pm_access_61e93cd7', 'dsAttrTypeStandard:AppleMetaNodeLocation': '/Local/Default', 'dsAttrTypeStandard:GroupMembers': '57973286-6E91-45F9-8537-E8A2A50CDA7C', 'dsAttrTypeStandard:RecordType': 'dsRecTypeStandard:Groups', 'dsAttrTypeStandard:PrimaryGroupID': '1000', 'dsAttrTypeStandard:RealName': 'Deprecated Profile Manager Access Group', 'dsAttrTypeStandard:GroupMembership': 'admin'}]>': -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1877, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:30.798] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_OPC-Nat-Acc_KST-5058_MA
1:: [4447] [2014/09/18 15:12:30.819] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_OPC-Lit-Acc_KST-5057_MA
1:: [4447] [2014/09/18 15:12:30.835] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\GRO_NB_KST-5200_MA
1:: [4447] [2014/09/18 15:12:30.850] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Produktion_KST-0902_MA
1:: [4447] [2014/09/18 15:12:30.866] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Lektorat_KST-0184_MA
1:: [4447] [2014/09/18 15:12:30.882] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Kreation-2-FT_KST-4152_MA
1:: [4447] [2014/09/18 15:12:30.897] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\GRO_MIC_KST-5200_MA
1:: [4447] [2014/09/18 15:12:30.912] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_LohnBuHa_KST-0901_MA
1:: [4447] [2014/09/18 15:12:30.928] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Beratung-3-MA_KST-4153_MA
1:: [4447] [2014/09/18 15:12:30.944] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Querying OD for 2 new users and groups
0:: [4447] [2014/09/18 15:12:30.966] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1712, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:30.966] Unable to sync group record with '<ODRecord 0x7ff75d41e390 [attributes {'dsAttrTypeStandard:GeneratedUID': 'ABCDEFAB-CDEF-ABCD-EFAB-CDEF00000050', 'dsAttrTypeStandard:RecordName': ['admin', 'BUILTIN\Administrators'], 'dsAttrTypeStandard:AppleMetaNodeLocation': '/Local/Default', 'dsAttrTypeStandard:GroupMembers': ['FFFFEEEE-DDDD-CCCC-BBBB-AAAA00000000', '57973286-6E91-45F9-8537-E8A2A50CDA7C', 'AF65D4DE-11F3-4996-BCE4-936ECB3CF922', '6C0B586C-39CA-4BED-AC49-4E61595B14AF'], 'dsAttrTypeStandard:RecordType': 'dsRecTypeStandard:Groups', 'dsAttrTypeStandard:PrimaryGroupID': '80', 'dsAttrTypeStandard:NestedGroups': '1EC73A3F-EBF6-4BD4-8DB5-B4062BB572BF', 'dsAttrTypeStandard:RealName': 'Administrators', 'dsAttrTypeStandard:GroupMembership': ['root', 'admin', 'diradmin']}]>': -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 1712, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:30.970] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Kurierstelle_KST-0906_MA
1:: [4447] [2014/09/18 15:12:30.986] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_FinanzBuHa_KST-0901_MA
1:: [4447] [2014/09/18 15:12:31.002] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_GF_KST-0102_MA
1:: [4447] [2014/09/18 15:12:31.018] __69-[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]_block_invoke: Group c43b6276-1c90-43cd-b4bc-8a975481c1e9 direct member count has changed (was: 823, is: 0)
1:: [4447] [2014/09/18 15:12:31.018] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_IT_KST-0904_MA
0:: [4447] [2014/09/18 15:12:31.034] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 3841, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:31.034] Unable to sync group record with '<ODRecord 0x7ff75d320bf0 [attributes {'dsAttrTypeStandard:GeneratedUID': 'C43B6276-1C90-43CD-B4BC-8A975481C1E9', 'dsAttrTypeNative:groupType': '-2147483646', 'dsAttrTypeStandard:RecordName': 'COMMARCO\HAM_IT_KST-0904_MA', 'dsAttrTypeStandard:AppleMetaNodeLocation': '/Active Directory/COMMARCO/commarco.com', 'dsAttrTypeStandard:RecordType': 'dsRecTypeStandard:Groups', 'dsAttrTypeStandard:PrimaryGroupID': '1144742518', 'dsAttrTypeStandard:AppleMetaRecordName': 'CN=HAM_IT_KST-0904_MA,OU=Groups,OU=HAM,DC=commarco,DC=com', 'dsAttrTypeStandard:RealName': 'HAM_IT_KST-0904_MA', 'dsAttrTypeStandard:GroupMembership': ['COMMARCO\Hans Kasper', 'COMMARCO\Patrick Faust', 'COMMARCO\Mike Fischer']}]>': -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_make_user_active(integer) does not exist
LINE 1: ...ups_users" (user_group_id, user_id) (SELECT 3841, dm_make_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:31.038] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Beratung-1-LS_KST-4151_MA
1:: [4447] [2014/09/18 15:12:31.053] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\GRO_PR_KST-5200_MA
1:: [4447] [2014/09/18 15:12:31.068] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_OPC-Int-Acc_KST-5056_MA
1:: [4447] [2014/09/18 15:12:31.085] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_Empfang_KST-0905_MA
1:: [4447] [2014/09/18 15:12:31.100] -[DMODSyncRunner _syncGroupODRecord:createActive:syncMode:syncState:]: Enumerating AD group: COMMARCO\HAM_OPC-Allgemein_KST-5055_MA
1:: [4447] [2014/09/18 15:12:31.112] -[DMODSyncRunner _syncGroupODRecords:syncMode:createActive:state:]: Processed 31 group records (synced 27)
0:: [4447] [2014/09/18 15:12:31.120] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_update_user_group_member_counts(integer) does not exist
LINE 1: SELECT dm_update_user_group_member_counts(id) FROM "user_gro...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:31.120] Caught unhandled exception running DMODSyncRunner. Aborting.
-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_update_user_group_member_counts(integer) does not exist
LINE 1: SELECT dm_update_user_group_member_counts(id) FROM "user_gro...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:31.120] -[StateMachine setException:]: -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_update_user_group_member_counts(integer) does not exist
LINE 1: SELECT dm_update_user_group_member_counts(id) FROM "user_gro...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:31.124] Sync aborted while in the following state:
———————— Sync/Query State —————————
Work Queues | user | 0
| ————————————————+——
| sparse group | 0
| immediate group | 0
| recursive group | 0
| ————————————————+——
| deletions | 0
| membership | 1
————————————+——————————————————————
Visit Lists | user | 135
| ————————————————+————
| sparse group | 181
| immediate group | 0
| recursive group | 30
————————————+——————————————————————
0:: [4447] [2014/09/18 15:12:31.125] Full sync of bound directory services failed: -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_update_user_group_member_counts(integer) does not exist
LINE 1: SELECT dm_update_user_group_member_counts(id) FROM "user_gro...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
0:: [4447] [2014/09/18 15:12:32.062] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-875.25/Compiled/Framework-Models/Postgres/PGConnection.m:330): "Postgres error 42883 (ERROR: function dm_send_update_info_for_devices_with_limit(integer) does not exist
LINE 1: SELECT dm_send_update_info_for_devices_with_limit(10)
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
)"
1:: [4447] [2014/09/18 15:12:41.299] Incoming request: informWebAppState
1:: [4447] [2014/09/18 15:12:46.847] Incoming request: readSettings
1:: [4447] [2014/09/18 15:12:46.887] Incoming request: readAppDistributionSettings
1:: [4447] [2014/09/18 15:12:46.920] Incoming request: readSimplifiedDeviceEnrollmentSettings
1:: [4447] [2014/09/18 15:13:04.961] Incoming request: readSettings
1:: [4447] [2014/09/18 15:13:05.034] Incoming request: readAppDistributionSettings
1:: [4447] [2014/09/18 15:13:05.101] Incoming request: readSimplifiedDeviceEnrollmentSettingsSo, got anybody a idea what went wrong?
best,
