Prevent more than one issue tracker to be active for the same project

What does this MR do?

Prevent more than once issue tracker service to be active at the same.

Are there points in the code the reviewer needs to double check?

This is a new validation, there may be existing records in the database that fail this validation.

Screenshots (if relevant)

Does this MR meet the acceptance criteria?

• Changelog entry added
• [ ] Documentation created/updated
• [ ] API support added
• Tests
  • Added for this feature/bug
  • All builds are passing
• Conform by the merge request performance guides
• Conform by the style guides
• Branch has no merge conflicts with master (if it does - rebase it please)
• Squashed related commits together

What are the relevant issue numbers?

Closes #22797 (closed)