Are System Analyst Work Fails the Norm?

In the work of a systems analyst, they often face complex organizational and technical problems, tasks for which there is no obvious solution. In conditions of uncertainty and contradictions - how not to make a mistake and not to choose the wrong solution? Let's try to figure out using the example of a real case.