Sting's Broadway musical The Last Ship is due to close later this month.
Producers confirmed that the Grammy Award-winning singer-songwriter's musical will shut down when he leaves the show on January 24, despite his hopes that it might be saved.
Sting, who wrote the songs, jumped into the show in December playing a shipyard foreman, previously played by Jimmy Nail. But while that improved sales, they didn't skyrocket.
The Last Ship is a semi-autobiographical story about a prodigal son who returns to his northern England shipbuilding town to reclaim the girl he abandoned when he fled years before. He finds the workers are now unemployed and entertaining the idea of building one last boat to show off their skill and pride.
The show has struggled at the box office because of its challenging topic and mixed reviews, aside from the bump in ticket sales that most shows see over the Christmas and New Year period.
Sting drew on his childhood growing up in Newcastle, an area with a history of shipbuilding, and was last on stage on Broadway in 1989's revival of The Threepenny Opera.
He said recently: "This was never going to be easy. I didn't anticipate a shoo-in at all. I expected a battle because I want to succeed against the odds."
Other rock stars have joined shows they helped create, including Green Day's frontman Billie Joe Armstrong, who made several onstage visits to his show American Idiot.