SCCM Migration - missing objects

Question

Hi,

I just started a new job. Now I have an outdated SCCM 2303 environment with a single primary site server on Server 2012R2 and SQL 2012 I have to deal with. Management wants me to create a new site with a remote SQL server. Updating the old systems is not allowed. Don't ask.

The plan is to use site-by-site migration to get apps, TSs, collections... to the new site and updating it to 2409 later. I did set up a test environment for that: a source site SCCM 2303 on 2012 and a target site 2303 on 2019 (2022 is not allowed) and a remote SQL server 2019. All works fine.

But starting the migration caused some trouble. The gathering works. But when I create a migration job, I only see collections, boundaries and boundary groups. No apps, or anything else. The migmctrl.log (attached) shows e.g.:

Start syncing #MIG_Entity. Query against Legacy Site...

migmctrl.logQuery completed, 5 record(s) merged to target table...

Query completed, 0 record(s) merged to target table...

Query completed, 5 record(s) merged to target table...

5/5 records copied for #MIG_Entity

Synced one batch. 5 records in #MIG_Entity Synced.

The target site's DB table "MIG_Entity" contains all objects from the source site. All objects that are NOT available in the migration job have a 1 in the column "IsDeleted". So, something makes the decision which data is relevant and which isn't.

The view "v_MIG_Entities" only contains data that was NOT marked as "IsDeleted".

Does anyone have an idea what's happening here?

Thanks, Alex

Answer 1

Hi Alex,

Hope everything is going well.

1,Does the account used to access the source site have permissions to read all of those applications? Maybe they are in different scopes, and the account doesn't have all of those scopes assigned? Kindly check the account permissions that you are using for migration.

Required configurations for migration

2, A similar thread for your reference:

SOLVED Migration to new hardware and version, objects missing

Note: This is non-Microsoft link, just for your reference.

Feel free to contact me if you have any concerns/queries.

Best regards,

Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

After the way you tag questions on Q&A is updated, for any "Microsoft Configuration Manager" related problem, you can tag it with "Microsoft Intune", and then "Microsoft Configuration Manager" as the child tag.

Answer 2

Hi,

the link handled a case where they first tried to use the same site code. I use different codes.

Since this is a simple test environment, I don't have any scopes. The computer account and my test user have full admin rights in SCCM and sysadmin rights on the DB.

It seems all data is collected. As I stated, I can see the data in the table "MIG_Entity" but it is flagged as "IsDeleted". The view "v_MIG_Entities" only contains data that was NOT marked as "IsDeleted". The view reflects what I see in the migration job.So, the problem is not missing access rights.

I would need to know why the "IsDeleted" row is set to 1 on most objects. Something that can be configured maybe?

Thanks,  Alex

Answer 3

Hi,

I have an update on this. To make sure the problem is not based on an outdated SCCM version, I snapshotted everything and installed 2409 on the target site. Now I have a different issue. The gather process doesn't work because of some database issue - column encryption.

The migmctrl.log says:

migmctrl.log[MigrationManager]: Set the schedule item 16777218 to Failed.ERROR: [MigrationManager]: System.InvalidOperationException: SQL Server instance in use does not support column encryption.     at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)     at System.Data.SqlClient.SqlCommand.ExecuteScalar()     at Microsoft.ConfigurationManagement.MigrationManager.V5SyncAgentJob..ctor(MigrationRepository current, LegacyRepository legacy, JobManagerBase1 jobManager, Int32 id)     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJobManager.CreateJob(MigrationRepository repository, MIG_SiteMapping scheduleItem)     at Microsoft.ConfigurationManagement.MigrationManager.JobManagerBase`1.GetNextJob(Int32& sleepMilliseconds)     at Microsoft.ConfigurationManagement.MigrationManager.JobManager.GetNextJob(Int32& sleepMilliseconds)ERROR: [MigMCtrl]: FAILED to GETNEXT job. error = Unknown error 0x80131509, 80131509

Google didn't help so far. I'm really not a database guy.Any help would be much appreciated.

Thanks, Alex

Answer 4

Hi,

Thanks for your reply.

For this issue, I will do more research, if there is any update, I will let you know.

Since this is a SQL server related issue, your best course here though is to open a support case with Microsoft:

Microsoft Support for business

Global Customer Service phone numbers

Thanks for your understanding.

Best regards,

Simon