We use Gitlab CE .
By default it is only possible to have on active integration as issue tracker. We used to have Redmine as issue tracker. Now we have Jira as issue tracker. Usually Gitlab allows only one active issue tracker. Somehow due to updates some projects are now in a state that we have two active issue trackers, Jira and Redmine. In each tracker the checkbox to disable the issue tracker is checked and disabled. And each integration shows a messages " Another issue tracker is already in use. Only one issue tracker integration can be active at a time. Please disable the active tracker first and try again."

So it seems that it is not possible to disable the old Redmine integation via GUI. Is there a way to disable the integration via cli?

I have tried with the hint given in this thread: Error: Another issue tracker is already in use and modified the script for rails console to search for redmine. But that did not work.

Any Idea how to delete the redmine integration in rails?

As a reference i share the rails script i have used:

Find all project IDs with more a Redmin service record

Service.where(type: “Redmine”).group(:project_id).count.select {|_, v| v > 0}.keys.each { |key|

For each Project

p=Project.find_by_id(key)

Skip if project is nil

next if p.nil?

Get all Readmin IDs for Project p

p.integrations.where(type: “Redmine”).each { |s|
#
# For each ID destroy
#
p.integrations.find_by_id(s).destroy
}
}

p = Project.find_by_sql(“SELECT p.id FROM projects p LEFT JOIN services s ON p.id = s.project_id WHERE s.type = ‘Redmine’ AND s.active = true”)

How did you run the script? I have exactly same problem and every time I try to run this script I get uninitialized constant Service (NameError):

irb(main):001:1* Service.where(type: “Redmine”).group(:project_id).count.select {|_, v| v > 0}.keys.each { |key|
irb(main):002:1* puts key
irb(main):003:0> }
(irb):1:in `': uninitialized constant Service (NameError)