Millions were spent on the failed scheme before it was scrapped in July 2024.