1 - check the size of your tempdb.

This is usual vilain.

2 - drop and recreate the view and maybe the envolved indexes.

No logic, ok, but works.