Issue with export after upgrade to v2020.3.1

Octopus Server
, , ,
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”

3

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
5

@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

6

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
7

Hi Octopus Team

I get the same error when running the migrator with octopus 2020.3.2

I’ve downgraded to version 2020.2.17 and run the migrator with this version.
But then i get database compatibiliy errors.

The Octopus Server database is compatible with version 2020.3.0 or later.

The --skipDatabaseCompatibilityCheck switch does not work.

C:\Program Files\Octopus Deploy\Octopus>Octopus.Migrator.exe export --directory c:\temp\octopus --password xxx --skipDatabaseCompatibilityCheck
Unrecognized command line arguments: --skipDatabaseCompatibilityCheck

Are there any known workarrounds for this issue?

Thanks,
Marcel

8

Hi @marcel1,

Unfortunately, there is no known workaround at present.

Regards,
Paul

9

Hi @marcel1

Just letting you know we have developed a fix for this issue - it will be available in the 2020.5.0 release of Octopus Server, which should be released for download on Octopus.com in roughly 2 months time.

Cheers,

Andrew.

10

Hi Andrew

Perfect! Thanks for the fix.

Cheers,
Marcel

1 Like
11

Hi @marcel1,

I’ve got a quick update regarding this fix:

With the amount of ongoing customer interest regarding this particular fix, we have decided to back-port it to the 2020.4.0 release of Octopus, which will be available for download on Octopus.com in around 2 weeks.

Cheers,

Andrew.

12

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