Issue with export after upgrade to v2020.3.1

Hi Guys

We are experimenting with Octopus deploy and have run into an issue after the upgrade from Octopus.2020.1.12-x64 to Octopus.2020.3.1-x64.

The upgrade did go well but when we tried to export the data(after upgrade) using the octopus manager, we have run into an issue.

Below is the error log from the Octopus manager export

Loading T…
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.GetCachedCompiledExpression(IDataReader dbDataReader, DocumentMap mapping)
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
Error: Full error details are available in the log files at:
Error: C:\Octopus\Logs
Error: C:\Users\stewari\AppData\Local\Octopus\Logs
Error: If you need help, please send these log files to https://octopus.com/support
Error: -------------------------------------------------------------------------------
Error:
Error: The previous command returned a non-zero exit code of: 100
Error: The command that failed was: “C:\Program Files\Octopus Deploy\Octopus\Octopus.Migrator.exe” export --instance “OctopusServer” --directory “C:\Backup” --password “XXX”

Hi @sourabh.tewari,

Thanks for getting in touch!

This looks like a bug within our export process, I’m hitting the same issue when testing this. I’ve raised it with our engineering team to investigate further.

Regards,
Paul

1 Like

@paul.calvert Would you be able to link us to any bug/issue tracker for this? We are keen to get this working soon.

Regards
Sourabh

Hi @sourabh.tewari,

Our engineers are looking into this and the following issue has been raised: https://github.com/OctopusDeploy/Issues/issues/6497

Regards,
Paul

2 Likes