Installing plugins after upgrading an instance can, sometimes, cause the instance not to start. This article addresses an issue where users are unable to restart Jive after installing the Idea plugin.
In the sbs.logs file, you will find the below error message:
2018-08-03 16:25:09,979 [localhost-startStop-1] [::] ERROR org.jivesoftware.sqlgen.SQLWriter - ORA-01430: column being added already exists in table java.sql.SQLException: ORA-01430: column being added already exists in table
- Jive Interactive Intranet
- Jive Core 9.x On-Premise Idea Plugin
The error message is due to duplicate entries in the
jiveideavote table. The plugin tries to add a unique constraint key to
jiveideavote, and it fails because of a duplicate record.
- Create a backup of the existing
- Identify the idea-type
- Delete the idea-type plugin record from the
- Restart Jive.