Import Fails: 2019.12.1 LTS Importing Data with FrozenProjectVariableSetId

Octopus Server
1

Hi,
We are looking to build a new Octopus Server and migrate our old data/configuration.
The same version has been installed on the new environment and a backup made.
When importing the data it fails with the following error:

Error while executing SQL command in transaction ‘’: Cannot insert the value NULL into column ‘FrozenProjectVariableSetId’, table ‘ppmazoctopusdeploydb.dbo.RunbookSnapshot’; column does not allow nulls. INSERT fails.

Is there a way to resolve this?

Thanks for your help.

5

Hi Simon,

Thank you for reaching out. Sorry that you ran into this issue. We believe we found the cause, our migrator didn’t support the export of Runbook Snapshots as part of the partial-export functionality. We’re working on a fix for this and will be patching Octopus Server LTS 2019.12 and once that is available, I will let you know.

Thank you,
Ankith

6

Hi Ankith,
Thanks very much for the update. Do you have any idea of timescales?
Due to project timescales, just working out if we should rebuild from scratch.

Thanks
Simon

7

Hi Simon,

I have good news, the fix was made and is in the process of being released. Here is the issue you can follow https://github.com/OctopusDeploy/Issues/issues/6213 The fix will be available in version 2019.12.6

I will message you once the patch is available.

Regards,
Ankith

8

Hi Simon,

Good news, Octopus Server 2019.12.6 has been released, once you apply this patch, please run the partial export again on your project and import.

Regards,
Ankith