L

5 Messages

 • 

160 Points

Tue, Dec 8, 2020 9:33 PM

Closed

Lightroom Desktop: Migration was not successful

I'm attempting to migrate my Lightroom Classic catalog to Lightroom.  During the migration I am receiving an ambiguous "Migration was not successful".  After some digging I found a log 'IncompleteMigrationReport_Lightroom Catalog-v10_2020-12-08T13-02-31.txt' with the following Error:

***************************
( ErrorCode: PROCESSING_ERROR )
***************************
PROCESSING_ERROR
Error occurred during [ 
 Stacks_stage_folder_asset_pass : Msg:Database "/Volumes/Mac/Users/leftride/Pictures/Lightroom Library.lrlibrary/migration/lrcat/lightroom catalog-v10/5F805239-8437-40D7-A133-BB015CBE2D9C/Lightroom Catalog-v10.manifest": UNIQUE constraint failed: stack_asset.stack, stack_asset.asset
  sql: INSERT INTO stack_asset( local_id, stack, asset ) values( ?, ?, ? ) (error code 2067) Data:{
 665,
 1011918,
 144133,
}  ].  Error Info : ^2

I assume this is some how related to Stacks in the catalog, but not sure how to narrow it down to the offender.

Here are some of the details of the catalog:

********** SOURCE FILE PROCESSING DETAILS ***********
storeProviderID : LrCat_22B90702-DEDC-42A8-A8B4-58121AC39127
Source DBVersion  : 1000000
Number of absolute folder paths : 3
Number of relative paths : 1319
Number of Valid folders : 119
Number of invalid folders : 0
Size of Valid Assets : 956245624133
Number of assets : 86294
Number of assets owned by sources. : 86294
Number of missing assets due to missing files : 0
Number of missing assets due to missing folders : 0
Number of missing assets  : 0
Number of unsupported assets  : 0
Number of virtual copies : 3349
Number of skipped virtual copies : 0
Number of Assets with conflicting metadata : 97
Number of migratable assets with conflicting metadata : 97
Number of total stacks ( Folder Stack ) : 7776
Number of valid stacks ( Folder Stack ) : 7776
Number of total stack assets ( Folder Stack ) : 28751
Number of valid stack assets ( Folder Stack ) : 28751
Number of total stacks ( Collection Stack ) : 3936
Number of valid stacks ( Collection Stack ) : 3936
Number of total stack assets ( Collection Stack ) : 14563
Number of valid stack assets ( Collection Stack ) : 14563
Number of videos  : 878
Number of assets with with gps location data : 10761
Number of valid assets with with gps location data : 10761
Number of synonyms : 26
Number of keyword entries : 439
Number of person keywords : 62
Number of image keyword associations : 97539
Number of keywords referenced by valid assets : 405
Number of assets with caption : 5361
Number of assets with copymargin: 0;">

Accepted Solution

5 Messages

 • 

160 Points

1 y ago

I was able to make some progress...I realized Lightroom Catalog-v10.manifest is a sqllite DB so I was able to query it to identify the actual asset (144133) that was causing the issue.  When I opened the catalog in Lightroom it looked like the image was in a stack, but when I clicked on it the stack seemed to go away, not sure exactly the issue (it was an image from 2010).  I'm rerunning the migration again.

(edited)

5 Messages

 • 

160 Points

I was able to progress further in the migration.  I had created Collections based on of my Lightroom Classic folders e.g. 'YYYY-MM-DD Shoot Name' by dragging the folders into the Collection area and for whatever reason those collections were created with Stacks that were causing this.  I recreated a a group of those Collections where it started failing by right-click and creating the collections (instead of dragging) and the migration has now progressed to 'Adding Photos and Videos'.  That has been running for ~10 hours, not sure if that's expected but I have a 80k/900GB library.

5 Messages

 • 

160 Points

after recreating the Collections, which seems to have resolved the issues with the Stacks the migration completed.

Adobe Administrator

 • 

10.9K Messages

 • 

143.5K Points

1 y ago

I spoke to the QE for this feature and he asked me to collect all of the Migration logs Is it possible for you to gather those and send to me?

5 Messages

 • 

160 Points

Yes, I can send the logs.  How/where do I send them?

Adobe Administrator

 • 

10.9K Messages

 • 

143.5K Points

I've emailed you with instructions

Adobe Photography Products

Quality Engineering - Customer Advocacy