The name for those is "wicked problem". They usually appear when your problem statement is itself incoherent.

The entire thing about users interacting with data through computers is one of them. There are several inconsistent goals, like consistency is at odds with flexibility, and accessibility is at odds with security.

We have those tools that push the incoherence around, but they are always prone to collide somewhere.