Dundee University ‘cannot be allowed to fail’ in face of £30m deficit, MSP warns