Please help, I get an error when trying to access a project and all I want to do is delete it.
I’m on version 2020.5.1 and the project in question is just a test project so it isn’t in use. This is the only project that I’m having problems with.
The project just had two process which were running child projects.
I’m not sure when this would of started and since the last time I access this project, I have changed license, upgraded Octopus server, migrated to a new Windows machine and made a bunch of changes to other projects so a backup restore isn’t an option.
If the easiest thing to do is hack the records out of the SQL database, I’m happy to do but I would like guidance on what tables I should be adjusting.
The error I get is:
Unhandled error on request: GET http://octopus.cx.local:80**/api/Spaces-1/projects/Projects-361/summary 8000003d-0001-fa00-b63f-84710c7967bb by C***** S : Error reading row 1, column 4. Unexpected token while deserializing object: PropertyName. Path ‘Steps.Actions.Packages.AcquisitionLocation’, line 1, position 605…
Compiled reader expression:
(DbDataReader reader, DocumentReaderContext context) =>
Type deserializeAsType = Octopus.Core.Model.Projects.DeploymentProcess
context.Column = 0
String temp0 = IIF(reader.IsDBNull(0), null, reader.GetString(0))
context.Column = 1
String temp1 = IIF(reader.IsDBNull(1), null, reader.GetString(1))
context.Column = 2
Boolean temp2 = IIF(reader.IsDBNull(2), default(Boolean), Convert(reader.GetValue(2), Boolean))
context.Column = 3
Int32 temp3 = reader.GetInt32(3)
context.Column = 4
DeploymentProcess deserializedFromJson = context.DeserializeText(reader, 4, deserializeAsType)
context.Column = 5
ReferenceCollection temp5 = Convert(value(Octopus.Core.RelationalStorage.TypeHandlers.UntypedReferenceCollectionTypeHandler).ReadDatabase(reader, 5), ReferenceCollection)
context.Column = 6
String temp6 = IIF(reader.IsDBNull(6), null, reader.GetString(6))
DeploymentProcess result = deserializedFromJson
if (result != null)
result.Id = temp0
result.OwnerId = temp1
result.IsFrozen = temp2
result.Version = temp3
result.SpaceId = temp6