Migration Assessment Scan: Long OneDrive URLs
Learn how to fix issues with long OneDrive URLs during migration.
Overview
When you're moving a OneDrive site from your source to the target environment, the OneDrive URL changes formats. On the source platform, the OneDrive sites are in the format of https://onedrive.contoso.com/personal/domain_user. On the target platform, the Domain_User portion of the URL changes to use the UPN for the user. This looks similar to https://onedrive.contoso.com/personal/user_contoso_com.
Example:
If you used this file:
https://OneDrive.contoto.com/personal/contoso_bobsmith/Documents/Folder1/Folder2/ProjectA.docx
The directory name of the file would be:
Personal/contoso_bobsmith/Documents/Folder1/Folder2
Note
There is a 400-character limit on the directory path to a file in SharePoint.
After the migration, the file path will look like the following.
Personal/bobsmith_contoso_com/Documents/Folder1/Folder2
Notice the URL is now four characters longer than it was before. Depending on how the UPNs are formed at your company, the change in length may be larger.
If the previous file in the source environment was 255 characters, the length after migration would be 259 characters.
We have identified four different locations in which failures are likely to occur due to long URLs. As a result, we have four different reports concerning long URLs. The Scan Result Reports section covers each report along with the remediation that needs to occur.
Data Migration
The migration of the source content resulting in the long URLs fail. This causes migration jobs to fail, which will prolong the migration project unnecessarily.
Important
Any site that is configured as "No Access" (locked), in SharePoint will be skipped. To see a list of locked site collections see the Locked Sites scan output.
Preparing for Migration
Review the reports and follow the remediation recommended for each report. In general, the remediation involves moving the content closer to the root of the site collection.
Post Migration
Validate that your content has been migrated.
Scan Result Reports
This scan results in four output files. Each file is for a specific long URL issue that will result in migration failures. LongODBUrl-AllDocs-detail.csv There are two limitations related to the length of the path to a given file:
The server relative path to the folder containing the file has a maximum of 400 characters. Using the following example file:
https://OneDrive.contoto.com/Personal/contoso_bobsmith/Documents/Folder1/Folder2/ProjectA.docxThe directory name would be the following:
Personal/contoso_bobsmith/Documents/Folder1/Folder2.After the migration, the file path will look like the following. Notice the URL is now longer than it was before:
Personal/bobsmith_contoso_com/Documents/Folder1/Folder2.The server relative path to a file or folder has a total maximum of 400 characters. Using the following example file:
https://OneDrive.contoto.com/Personal/contoso_bobsmith/Documents/Folder1/Folder2/ProjectA.docxThe server relative path to the file looks similar to the following: Personal/contoso_bobsmith/Documents/Folder1/Folder2/ProjectA.docx
If there are files listed in this report, the owners need to move the files to shorter paths or delete the files. For example, they could move ProjectA.docx up to a folder directly under Documents, or they could delete the file if it's no longer needed.
| Column | Description |
|---|---|
| SiteId | Unique identifier of the impacted site collection. |
| SiteURL | URL to the impacted site collection. |
| SiteOwner | Owner of the site collection. |
| SiteAdmins | List of people listed as site collection administrators. |
| SiteSizeInMB | Size of the size collection in megabytes [MB] |
| NumOfWebs | Number of webs that exist in the site collection. |
| ContentDBName | Name of the content database hosting the site collection. |
| ContentDBServerName | SQL Server hosting the content database. |
| ContentDBSizeInMB | Size of the content database hosting the site collection. |
| LastContentModifiedDate | Date/Time the site collection had content modified. |
| TotalItemCount | Total number of items found in the site collection. |
| Hits | Number of requests logged for the site collection. Relies on data from the usage logging service. If the usage logging service is disabled this row shows N/A. |
| DistinctUsers | Number of distinct users that have accessed the site collection. Relies on data from the usage logging service. If the usage logging service is disabled this row shows N/A. |
| DaysOfUsageData | Number of days the usage logging service retains data. This provides context for Hits and DistinctUsers. For example, if this is 14 days, the Hits and DistinctUsers data is for the last 14 days. |
| UPN | UPN that was used to determine the difference in the URL length. If the UPN is "****" that indicates the owner didn't have a UserPrincipalName set in their SharePoint profile. As a result, the average length of the UserPrincipalName values in the SharePoint profile store was used. |
| URLLengthDifference | Amount the URL grows when the site is renamed. |
| File | File that needs to be remediated. |
| ScanID | Unique identifier assigned to a specific execution of the SharePoint Migration Assessment Tool. |
LongODBUrl-NavNodes-detail.csv Navigation nodes have a URL length limitation of 260 characters. This can lead to the URL field exceeding the maximum length.
For example, you have a OneDrive site at https://OneDrive.contoso.com/personal/contoso_bobsmith. That site has a link in the Quick launch named Reports and the URL of the link points to https://onedrive.contoso.com/personal/contoso_bobsmith/documents/folder1/...folderN/Reports. During the migration, SharePoint updates the URL to point to /bobsmith_contoso_com/. The extra length added to the URL may result in the length being over 260 characters, which will cause the migration to fail.
To remediate this issue, you would move the reports folder close to the root of the /documents/ library and then update the quick launch link. Another option would be to remove the quick launch link.
| Column | Description |
|---|---|
| SiteId | Unique identifier of the impacted site collection. |
| SiteURL | URL to the impacted site collection. |
| SiteOwner | Owner of the site collection. |
| SiteAdmins | List of people listed as site collection administrators. |
| SiteSizeInMB | Size of the size collection in megabytes [MB] |
| NumOfWebs | Number of webs that exist in the site collection. |
| ContentDBName | Name of the content database hosting the site collection. |
| ContentDBServerName | SQL Server hosting the content database. |
| ContentDBSizeInMB | Size of the content database hosting the site collection. |
| UPN | UPN that was used to determine the difference in the URL length. If the UPN is "****" that indicates the owner didn't have a UserPrincipalName set in their SharePoint profile. As a result, the average length of the UserPrincipalName in the SharePoint profile store was used. |
| URLLengthDifference | URLLengthDifference Amount the URL grows when the site is renamed. |
| WebURL | URL to the web that has the navigation node. |
| NavigationNodeLocation | Navigation Node titles showing where the navigation node lives. You can have multiple levels of navigation nodes, and this will help locate the offending node. |
| NavigationNodeTitle | Title of the impacted navigation node. |
| NavigationNodeURL | URL that will be too long after the site rename. |
| ScanID | Unique identifier assigned to a specific execution of the SharePoint Migration Assessment Tool. |
LongODBUrl-Perms-detail.csv Permissions that are set on an object in SharePoint are tracked by the URL of that object. If you set permissions on a folder, SharePoint stores the relative path to the folder. If you set permissions on an item, SharePoint stores the server relative path to the item.
As a result, during a site migration, the URLs associated with permissions will be updated. This may lead to failures if the new URL is too long.
The remediation for this is to move the affected object closer to the root of the site collection. Another option is to remove the distinct permissions from the items in the report.
| Column | Description |
|---|---|
| SiteId | Unique identifier of the impacted site collection. |
| SiteURL | URL to the impacted site collection. |
| SiteOwner | Owner of the site collection. |
| SiteAdmins | List of people listed as site collection administrators. |
| SiteSizeInMB | Size of the size collection in megabytes [MB] |
| NumOfWebs | Number of webs that exist in the site collection. |
| ContentDBName | Name of the content database hosting the site collection. |
| ContentDBServerName | SQL Server hosting the content database. |
| ContentDBSizeInMB | Size of the content database hosting the site collection. |
| UPN | UPN UserPrincipalName that was used to determine the difference in the URL length. If the UPN is "****" that indicates the owner didn't have a UserPrincipalName set in their SharePoint profile. As a result, the average length of the UserPrincipalName in the SharePoint profile store was used. |
| URLLengthDifference | Amount the URL will grow when the site is renamed. |
| WebURL | URL to the web hosting the secured object. |
| SecuredObject | This is the URL to the secured object that will be too long after the site rename. If you add permissions to a file, this is the server relative path to the file. If you set permissions on a folder, this is the server relative path to the folder. |
| ScanID | Unique identifier assigned to a specific execution of the SharePoint Migration Assessment Tool. |
LongODBUrl-Deps-detail.csv Certain files can have other dependencies. Those dependencies are tracked by the URL. During the migration if the dependency information is too long, the migration fails.
There are two limitations in this report to be aware of:
FullURL has a limit of 260 characters. This is the file with the dependencies. To remediate if the FullURL is too long, either remove the file or move the file to a location closer to the root of the site collection.
DependencyDescription has a limit of 270 characters. This is the dependency associated with the FullURL. To remediate the DependencyDescription, either remove the dependency or move the dependency closer to the root of the site collection.
| Column | Description |
|---|---|
| SiteId | Unique identifier of the impacted site collection. |
| SiteURL | URL to the impacted site collection. |
| SiteOwner | Owner of the site collection. |
| SiteAdmins | List of people listed as site collection administrators. |
| SiteSizeInMB | Size of the size collection in megabytes [MB] |
| NumOfWebs | Number of webs that exist in the site collection. |
| ContentDBName | Name of the content database hosting the site collection. |
| ContentDBServerName | SQL Server hosting the content database. |
| ContentDBSizeInMB | Size of the content database hosting the site collection. |
| UPN | UPN that was used to determine the difference in the URL length. If the UPN is "****", that indicates the owner did not have a UserPrincipalName set in their SharePoint profile. As a result, the average length of the UserPrincipalName in the SharePoint profile store was used. |
| URLLengthDifference | Amount the URL will grow when the site is renamed. |
| FullURL | URL to the file that has the dependencies |
| DependencyDescription | DependencyDescription Description associated with the dependency. This may be a URL that is getting renamed. |
| ScanID | Unique identifier assigned to a specific execution of the SharePoint Migration Assessment Tool. |