2 Replies Latest reply on May 20, 2014 6:34 PM by hymavathi

    Exception when trying to create a table for a plugin

    hymavathi

      Hi,

      I need to add a table to an existing Plugin's schema. I have followed all the steps required like changing databaseKey and cretaing a task java class and related xml file. But When I started cargo I see exception in the console and the table is not created in the back end.

      here is the stack trace . The plugin is not able to load the xml file specified in the path seems to be the problem. Any insight is appreciated.

       

      java.lang.IllegalArgumentException: Sql gen file com/jivesoftware/idea/plugin/AddJiveIdeaProductModuleMapTable.xml could not be loaded

      from location com/jivesoftware/idea/plugin/AddJiveIdeaProductModuleMapTable.xml

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.executeSQLGenFile(UpgradeUtils.java:1044)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.executeSQLGenFile(UpgradeUtils.java:984)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.executeSQLGenFile(UpgradeUtils.java:961)

      [INFO] [talledLocalContainer]   at com.jivesoftware.idea.plugin.AddJiveIdeaProductModuleMapTableTask.doTask(AddJiveIdeaProductModuleMapTableTask.java:41)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.executeUpgrade(UpgradeTaskExecutor.java:124)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.run(UpgradeTaskExecutor.java:88)

      [INFO] [talledLocalContainer]   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:48)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.PluginUpgradeManager.start(PluginUpgradeManager.java:59)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.upgradePluginSchema(PluginSchemaManager.java:129)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.checkSchema(PluginSchemaManager.java:110)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.checkPluginSchema(PluginSchemaManager.java:63)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.verifyPluginSchemaUpgraded(PluginManagerImpl.java:628)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.loadPlugin(PluginManagerImpl.java:575)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.loadDevPlugins(PluginManagerImpl.java:964)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.handle(PluginManagerImpl.java:1219)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.handle(PluginManagerImpl.java:1)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.EventDispatchHelper.dispatchEvent(EventDispatchHelper.java:163)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.NonBlockingEventDispatcherImpl$JiveEventWrapperFuture.complete(NonBlockingEventDispatcherImpl.java:

      367)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.NonBlockingEventDispatcherImpl$Dispatcher.call(NonBlockingEventDispatcherImpl.java:321)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.NonBlockingEventDispatcherImpl$Dispatcher.call(NonBlockingEventDispatcherImpl.java:1)

      [INFO] [talledLocalContainer]   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

      [INFO] [talledLocalContainer]   at java.util.concurrent.FutureTask.run(FutureTask.java:138)

      [INFO] [talledLocalContainer]   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

      [INFO] [talledLocalContainer]   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

      [INFO] [talledLocalContainer]   at java.lang.Thread.run(Thread.java:662)

      [INFO] [talledLocalContainer] 2014-05-19 14:26:00,908 [NonBlockingEventDispatcher-thread-2] [::] ERROR com.jivesoftware.community.upgrade.UpgradeTaskExecutor - Upgra

      de task 'Add a new TABLE_NAME for idea extended Field relation for Product and Module' failed.

      [INFO] [talledLocalContainer] java.lang.IllegalArgumentException: Sql gen file com/jivesoftware/idea/plugin/AddJiveIdeaProductModuleMapTable.xml could not be loaded

      from location com/jivesoftware/idea/plugin/AddJiveIdeaProductModuleMapTable.xml

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.executeSQLGenFile(UpgradeUtils.java:1044)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.executeSQLGenFile(UpgradeUtils.java:984)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.executeSQLGenFile(UpgradeUtils.java:961)

      [INFO] [talledLocalContainer]   at com.jivesoftware.idea.plugin.AddJiveIdeaProductModuleMapTableTask.doTask(AddJiveIdeaProductModuleMapTableTask.java:41)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.executeUpgrade(UpgradeTaskExecutor.java:124)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.run(UpgradeTaskExecutor.java:88)

      [INFO] [talledLocalContainer]   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:48)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.PluginUpgradeManager.start(PluginUpgradeManager.java:59)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.upgradePluginSchema(PluginSchemaManager.java:129)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.checkSchema(PluginSchemaManager.java:110)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.checkPluginSchema(PluginSchemaManager.java:63)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.verifyPluginSchemaUpgraded(PluginManagerImpl.java:628)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.loadPlugin(PluginManagerImpl.java:575)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.loadDevPlugins(PluginManagerImpl.java:964)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.handle(PluginManagerImpl.java:1219)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.handle(PluginManagerImpl.java:1)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.EventDispatchHelper.dispatchEvent(EventDispatchHelper.java:163)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.NonBlockingEventDispatcherImpl$JiveEventWrapperFuture.complete(NonBlockingEventDispatcherImpl.java:

      367)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.NonBlockingEventDispatcherImpl$Dispatcher.call(NonBlockingEventDispatcherImpl.java:321)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.NonBlockingEventDispatcherImpl$Dispatcher.call(NonBlockingEventDispatcherImpl.java:1)

      [INFO] [talledLocalContainer]   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

      [INFO] [talledLocalContainer]   at java.util.concurrent.FutureTask.run(FutureTask.java:138)

      [INFO] [talledLocalContainer]   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

      [INFO] [talledLocalContainer]   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

      [INFO] [talledLocalContainer]   at java.lang.Thread.run(Thread.java:662)

      [INFO] [talledLocalContainer] 2014-05-19 14:26:01,000 [NonBlockingEventDispatcher-thread-2] [::] ERROR com.jivesoftware.community.upgrade.UpgradeUtils - Could not ex

      ecute SQLGen xml file: com/jivesoftware/community/upgrade/scripts/AddJiveIdeaProductModuleMapTable.xml

      [INFO] [talledLocalContainer] org.dom4j.DocumentException: null Nested exception: null

      [INFO] [talledLocalContainer]   at org.dom4j.io.SAXReader.read(SAXReader.java:484)

      [INFO] [talledLocalContainer]   at org.dom4j.io.SAXReader.read(SAXReader.java:343)

      [INFO] [talledLocalContainer]   at org.jivesoftware.sqlgen.model.Model.build(Model.java:114)

      [INFO] [talledLocalContainer]   at org.jivesoftware.sqlgen.SQLGen.generateSQL(SQLGen.java:218)

      [INFO] [talledLocalContainer]   at org.jivesoftware.sqlgen.SQLGen.generateSQL(SQLGen.java:213)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.processSQLGenXml(UpgradeUtils.java:1152)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.doProcessSqlGenStream(UpgradeUtils.java:1140)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.doProcessSqlGenFile(UpgradeUtils.java:1125)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.processSQLGenFile(UpgradeUtils.java:1105)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeUtils.processSQLGenFile(UpgradeUtils.java:1089)

      [INFO] [talledLocalContainer]   at com.jivesoftware.idea.plugin.AddJiveIdeaProductModuleMapTableTask.getInstructions(AddJiveIdeaProductModuleMapTableTask.java:32)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.executeUpgrade(UpgradeTaskExecutor.java:133)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.UpgradeTaskExecutor.run(UpgradeTaskExecutor.java:88)

      [INFO] [talledLocalContainer]   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:48)

      [INFO] [talledLocalContainer]   at com.jivesoftware.community.upgrade.PluginUpgradeManager.start(PluginUpgradeManager.java:59)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.upgradePluginSchema(PluginSchemaManager.java:129)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.checkSchema(PluginSchemaManager.java:110)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginSchemaManager.checkPluginSchema(PluginSchemaManager.java:63)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.verifyPluginSchemaUpgraded(PluginManagerImpl.java:628)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.loadPlugin(PluginManagerImpl.java:575)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.loadDevPlugins(PluginManagerImpl.java:964)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.handle(PluginManagerImpl.java:1219)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.plugin.PluginManagerImpl.handle(PluginManagerImpl.java:1)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.EventDispatchHelper.dispatchEvent(EventDispatchHelper.java:163)

      [INFO] [talledLocalContainer]   at com.jivesoftware.base.event.v2.NonBlockingEventDispatcherImpl$JiveEventWrapperFuture.complete(NonBlockingEventDispatcherImpl.java: