Move project between 2 instances of Octopus

Hi !

We do have multiple instance of Octopus running. We do have one project within instance X which needs to be copied to instance Y. What is the most efficient way for us to do that please?

Tried import/export (Deprecated) it ended up with below error even after --dryRun said “No validation errors found. Project is ready to import.”

DispatchRequest: POST https://*****/api/Spaces-1/projects
Octopus Server returned an error: Sequence contains no elements
Error from Octopus Server (HTTP 500 InternalServerError)
Exit code: -7

Export ends un with below error using data migration

“Error: ===============================================================================
Error: The class ‘DeploymentRelatedMachine’ has a document map with JSON storage set to TextOnly, but the query does not include the ‘JSON’ column. Queries against this type must include the JSON in the select clause. If you just want a few columns, use Nevermores’ ‘plain class’ or tuple support.
Error: System.InvalidOperationException
Error: at Nevermore.Advanced.ReaderStrategies.Documents.DocumentReaderExpressionBuilder.AssertValidColumnOrdering()
Error: at Nevermore.Advanced.ReaderStrategies.Documents.DocumentReaderExpressionBuilder.Build()
Error: at Nevermore.Advanced.ReaderStrategies.Documents.DocumentReaderStrategy.Compile(DocumentMap map, IDataReader firstRow)
Error: at Nevermore.Advanced.ReaderStrategies.Documents.DocumentReaderStrategy.<>c__DisplayClass5_0.b__0(String _)
Error: at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory)
Error: at Nevermore.Advanced.ReaderStrategies.Documents.DocumentReaderStrategy.<>c__DisplayClass4_11.<CreateReader>b__1(DbDataReader dbDataReader) Error: at Nevermore.Advanced.ReadTransaction.ProcessReader[TRecord](DbDataReader reader, PreparedCommand command)+MoveNext() Error: at Nevermore.Advanced.ReadTransaction.Stream[TRecord](PreparedCommand command)+MoveNext() Error: at Octopus.Migrator.Core.ExportProcess.ExportController.WriteDocuments(String singularNoun, IEnumerable1 documents, ExportFileNameOption fileNameOption)+MoveNext() in ExportController.cs:line 797
Error: at Octopus.Migrator.Core.ExportProcess.ExportController.Write(String singularNoun, IEnumerable1 documents, ExportFileNameOption fileNameOption) in ExportController.cs:line 576 Error: at Octopus.Migrator.Core.ExportProcess.ExportController.Export() in ExportController.cs:line 103 Error: at Octopus.Migrator.Cli.Commands.ExportCommand.Start() in ExportCommand.cs:line 89 Error: at Octopus.Shared.Startup.AbstractCommand.Start(String[] commandLineArguments, ICommandRuntime commandRuntime, OptionSet commonOptions) Error: at Octopus.Shared.Startup.OctopusProgram.Start(ICommandRuntime commandRuntime) Error: at Octopus.Shared.Startup.ConsoleHost.Run(Action1 start, Action shutdown)
Error: at Octopus.Shared.Startup.OctopusProgram.RunHost(ICommandHost host)
Error: at Octopus.Shared.Startup.OctopusProgram.Run()
Error: -------------------------------------------------------------------------------
Error: Terminating process with exit code 100”

I think this thread has answer. Probably upgrading and trying with DataIntegration tool is only option for now. But if someone can confirm really appreciate that.

Hi @nipam2000,

Thanks for reaching out.

Yes, you’re correct this was a bug and has been fixed in 2020.4.0 as well as 2020.5.0. 2020.4.0 is currently available so you could upgrade and attempt to use the Octopus Migrator and partial-export to fit your use case. The partial-export documentation is here:

Would you be able to look into that and see if it would fit your use case? Please let me know.


Thanks @jeremy.miller ! Unfortunately due to time sensitivity and dependency can’t upgrade soon. Do we have any other quick fix/option please?


I’m sorry I don’t have better news for you but there’s no known workaround.

Please let me know if you have any other questions or concerns.


This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.