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, Func
2 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, IEnumerable
1 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(Action
1 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”