It’s kinda part of the job. Several times in my career I’ve put in months of effort on projects that then get canned for various reasons. One of them was 100% complete. No real big deal, it’s still a good billet on my resume.