K12 user migration error

[petrji]

Brief bug description

Migrating Kentico 12 MVC to Xperience getting the error below.

Microsoft.EntityFrameworkCore.Database.Command[20102] Failed executing DbCommand (265ms) [Parameters=[@__PrivilegeLevelsMigratedAsAdminUser_0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30'] SELECT [c].[UserID], [c].[Email], [c].[FirstName], [c].[FullName], [c].[LastLogon], [c].[LastName], [c].[MiddleName], [c].[PreferredCultureCode], [c].[PreferredUICultureCode], [c].[UserCreated], [c].[UserEnabled], [c].[UserGUID], [c].[UserHasAllowedCultures], [c].[UserIsDomain], [c].[UserIsExternal], [c].[UserIsHidden], [c].[UserLastLogonInfo], [c].[UserLastModified], [c].[UserMFRequired], [c].[UserMFSecret], [c].[UserMFTimestep], [c].[UserName], [c].[UserPassword], [c].[UserPasswordFormat], [c].[UserPrivilegeLevel], [c].[UserSecurityStamp], [c].[UserStartingAliasPath], [c].[UserVisibility] FROM [CMS_User] AS [c] WHERE [c].[UserPrivilegeLevel] IN ( SELECT [p].[value] FROM OPENJSON(@__PrivilegeLevelsMigratedAsAdminUser_0) WITH ([value] int '$') AS [p] )
04:12:22.154

Repro steps

running Migration.Toolkit.CLI.exe migrate --sites --custom-modules --users

[liparova]

Hi! Thanks for sharing your problem and a solution! We'll take a look at it soon and consider adding it to the original integration.

[tkrch]

Hi @petrji, what is exact version of Kentico 12 (hotfix included)? Is it latest version?

Can You post here or send me log output (or console output) to [email protected]?

There should be exception details, they may point me in right direction. Currently i can't simulate issue

[MilanLund]

@tkrch Getting the same error on K11 site. Hotfix v11.0.43. Here is the output:

...

EDIT: Just hotfixed to the latest version 11.0.49 and reduced users to just these two guys. The error still persists.

[MilanLund]

@tkrch Following up on my previous comment, the issue is also present on the KX13 site I attempted to migrate. Logs are available here:

...

[tkrch]

@petrji @MilanLund this issue might be related to SQL Server version, I am currently running tests on all supported versions to ensure Migration Tool is working correctly. I will be back with results / fix if required.

Please send me version of MSSQL (so i can direct test to exactly same version), output of query Select @@version would be sufficient.

[MilanLund]

@tkrch Thanks for looking into this.

[tkrch]

Thanks for info, issue confirmed, i will work on fix.

[tkrch]

Fix published into branch fix/213_sql_server_compatibility (#229) if you want to check before all reviews and tests in compatibility matrix are done.

[MilanLund]

@tkrch
I attempted to migrate the K13 site. While the initial issue has been resolved, I encountered a new problem with Media Libraries and Attachments, which will require further investigation on my end.

As for the K11 site, I'm experiencing a similar issue, but with a different query. Here are logs:

...

[tkrch]

fix published for the issue in K11 db query.

[MilanLund]

@tkrch The issue is gone. Thank you. I came across another issue related to files missing in Media library but I guess that is something wrong on my end 😅.

[tkrch]

@MilanLund feel free to post any complications you encountered, maybe I can help

[MilanLund]

@tkrch I'm missing these files on my end - I need to get the latest project files and database from the server. However, since I'm currently testing the migration tool to see if it's suitable for future projects, I am giving this a low priority for now.

[petrji]

Hi @tkrch,
I was on leave last week. Glad this has been resolved. BTW we are also experiencing issues with media libraries. Other dev may log new issue as I moved to other project. We are using Azure blob storage.
You can close this one now. Thanks