Exception when trying to create a table for a plugin
hymavathi May 19, 2014 11:55 AMHi,
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: