Cannot resolve Orphaned channels

Casper Thygesen's Avatar

Casper Thygesen

11 Jan, 2018 09:01 PM

Hi.

Integrity report has the following:
The project Projects-1 for channel Default (Channels-684) does not exist. Lifecycle=<none>.
The project Projects-101 for channel Default (Channels-701) does not exist. Lifecycle=<none>.
etc...

However, using your API i can not delete the channels, as they report:
repo.Channels.Delete(channel);
"There was a problem with your request. - This channel has releases including: 1.1.3.1-https, 1.1.3.1-httpsforced, 1.1.4, 1.1.4-https, 1.1.5"

When I try to delete the orphaned channels releases, it reports:
repo.Releases.Delete(release);
"The resource 'Projects-145' was not found."

So how do i resolve this integrity issue?

  1. Support Staff 1 Posted by Robert Wagner on 12 Jan, 2018 12:13 AM

    Robert Wagner's Avatar

    Hi Casper,

    Thank you for getting in touch. The channels need to be deleted directly from the database using the following query:

    DELETE FROM Channel WHERE ProjectId not in (SELECT Id FROM Project)
    

    Alternatively, you can wait for me to implement this issue (sometime in the next week) and then upgrade.

    If the problem re-occurs, please let us know, along with which version you are running.

    Rob W

  2. 2 Posted by Casper Thygesen on 12 Jan, 2018 07:55 AM

    Casper Thygesen's Avatar

    Hi Rob. Thank you very much. It worked! The integrity report is now a success, however I can conclude that there is still rogue releases, belonging to no projects or channels - howver they seem like a much lesser issue

  3. Support Staff 3 Posted by Robert Wagner on 15 Jan, 2018 03:42 AM

    Robert Wagner's Avatar

    Hi Casper,

    Interesting. Did you upgrade from 2.6 in the past?

    Releases that don't belong to a project should be deleted.

    Rob W

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac