Overview

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

Environment

• Jive Interactive Intranet
• Jive Core 9.x On-Premise Idea Plugin
  
  

Root Cause

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.

Resolution 

1. Create a backup of the existing jiveplugin table.
2. Identify the idea-type pluginid in the jiveplugin table.
3. Delete the idea-type plugin record from the jiveplugin table.
4. Restart Jive.