During the installation of the Ideation module, Jive tries to update the database schema by creating and deleting an index. This does not work as the index already exists.
Jive Interactive Intranet-Jive Core
Skip this step of the upgrade if the index already exists. The installation should continue without issue.