Data Migration Assitant Ignore Error Code: 46010 ?

Question

Data Migration Assitant Ignore Error Code: 46010 ?

Ximing Feng 1

I ran a Data Migration Assitant assessment on my SQL Server 2012 engine. The target version was set to 2019 running on Windows. After the assessment finished, I got a "Breaking Changes": Object [Entity] has syntax errors. Incorrect syntax near ].. Error number 46010. For more details, please see: Line 2, Column 23. The [Entity] is a table in my database
I did not find any issue with the creation script of the table. Also from this page , in the example, 46010 was ignored. So I followed the instruction and change the dma.exe.config:

<workflowSettings>  
<assessment parallelDatabases="8" ignoreErrorCodes="46010;71501" />  
</workflowSettings>

However, that did not change anything. The error message still showed up after I ran it again. What can I do to resolve the issue?

Thank you very much!

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2020-11-04T22:39:46.99+00:00

When you said that you found no issues in the creation script, did you script the table from the database, or did you look at a script in version control?

I think we would need to see the script generated from SSMS to say what might be wrong. It does sound a little bit like a scripting error.
Ximing Feng 1 Reputation point

2020-11-04T22:44:34.743+00:00

Thank you!
I scripted the table from the database. Here what I did
Right-click on the table -> Script Table as -> Create To -> New Query Editor Window
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2020-11-05T21:54:52.997+00:00

If you scripted it from SSMS, then smells a little buggy to me.

Unless Mia's advice helps, I think you need to share the script with us, to see if we can find a cllue. Go into options and check scripting sessons so that all table properties are included. By default indexes and triggers are not included when scripting in SSMS.
Chris Wood 21 Reputation points

2022-01-25T22:26:16.027+00:00

I am seeing similar 46010 messages when looking at stored procedures in SQL 2019 CU11 instances that show no problems when scripted out using SSMS 18.10 and then re-added with different names. The stored procs all seem to have BEGIN TRY/END TRY in them that get this message
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-01-25T22:31:57.937+00:00

I think it would be better to start a new thread, describing your problem from start to end, rather than to piggy back on an old one.
Chris Wood 21 Reputation points

2022-01-25T23:05:03.36+00:00

I just created Data Migration Assistant 5.5.5310.2 throwing Error Code: 46010 in stored procedures

2 answers

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2020-11-04T22:39:46.99+00:00

When you said that you found no issues in the creation script, did you script the table from the database, or did you look at a script in version control?

I think we would need to see the script generated from SSMS to say what might be wrong. It does sound a little bit like a scripting error.
Ximing Feng 1 Reputation point

2020-11-04T22:44:34.743+00:00

Thank you!
I scripted the table from the database. Here what I did
Right-click on the table -> Script Table as -> Create To -> New Query Editor Window
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2020-11-05T21:54:52.997+00:00

If you scripted it from SSMS, then smells a little buggy to me.

Unless Mia's advice helps, I think you need to share the script with us, to see if we can find a cllue. Go into options and check scripting sessons so that all table properties are included. By default indexes and triggers are not included when scripting in SSMS.
Chris Wood 21 Reputation points

2022-01-25T22:26:16.027+00:00

I am seeing similar 46010 messages when looking at stored procedures in SQL 2019 CU11 instances that show no problems when scripted out using SSMS 18.10 and then re-added with different names. The stored procs all seem to have BEGIN TRY/END TRY in them that get this message
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-01-25T22:31:57.937+00:00

I think it would be better to start a new thread, describing your problem from start to end, rather than to piggy back on an old one.
Chris Wood 21 Reputation points

2022-01-25T23:05:03.36+00:00

I just created Data Migration Assistant 5.5.5310.2 throwing Error Code: 46010 in stored procedures

Answer 1

m 4,276

Hi @Ximing Feng ,

...What can I do to resolve the issue?

Copy code as next to have a try,if you only encounter error 46010, you can just input the specific error code to test:

<workflowSettings>  
  
<assessment parallelDatabases="8" ignoreErrorCodes="46010" />  
  
</workflowSettings>

BR,
Mia

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

Answer 2

m 4,276

Hi @Ximing Feng ,

Is the reply helpful?

BR,
Mia

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

Share via

Data Migration Assitant Ignore Error Code: 46010 ?

2 answers

Your answer