Devolutions ForumDevolutions Forum

DataMigration to SQL, JobOutput/JobParameter errors

DataMigration to SQL, JobOutput/JobParameter errors

avatar
(anonymous user) 
Product: PowerShell Universal
Version: 4.2.20


In preparation for the 5.0 upgrade not supporting LiteDB anymore I cloned my Universal server to test the LiteDB > SQL migration. Ran DataMigration as specified here

and ended up with a lot of errors for JobOutput and JobParameter. Most of the JobOutput migrations worked fine.

(I only got the JobParameter capture, but it was the same error)

Migrating JobParameter 584
System.InvalidOperationException: Sequence contains no elements
   at System.Linq.ThrowHelper.ThrowNoElementsException()
   at lambda_method1743(Closure, QueryContext)
   at DataMigration.Program.<>c.<Main>b__2_7(JobParameter item, PsuDbContext dbContext)
   at DataMigration.Program.TransferItems[T](String connectionString, String tableName, IEnumerable`1 items, Func`3 preProcess, Boolean setIdentity)


Is this an issue that will cause problems down the line?

All Comments (1)

avatar

Reverted the snapshot back to before migration to make sure things would work as expected and grabbed the JobOutput error

Migrating JobOutput 1581842
System.InvalidOperationException: Sequence contains no elements
   at System.Linq.ThrowHelper.ThrowNoElementsException()
   at lambda_method1743(Closure, QueryContext)
   at DataMigration.Program.<>c.<Main>b__2_6(JobOutput item, PsuDbContext dbContext)
   at DataMigration.Program.TransferItems[T](String connectionString, String tableName, IEnumerable`1 items, Func`3 preProcess, Boolean setIdentity)