Hi,
I'm attempting to deploy my already existing Joget Workflow (developed on a local Tomcat server) on an external linux machine running tomcat6. I've deployed the .war file in the appropriate webapps folder on tomcat6, and have also migrated the database. However when I try to start the application, I get the following error:
Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'jwdb.SHKProcessStates' doesn't exist)
The table jwdb.shkprocessstates exists on my database, and all the other tables seem to be read and created appropriately on Joget startup. Any ideas on what might be causing this?
Thanks,
Nick
Tomcat6 Server Log:
WARN 05 Aug 2013 15:55:28 com.atomikos.icatch.config.UserTransactionServiceImp - No properties path set - looking for transactions.properties in classpath...
WARN 05 Aug 2013 15:55:28 com.atomikos.icatch.config.UserTransactionServiceImp - transactions.properties not found - looking for jta.properties in classpath...
WARN 05 Aug 2013 15:55:28 com.atomikos.icatch.config.UserTransactionServiceImp - Using init file: /var/lib/tomcat6/webapps/jw/WEB-INF/classes/jta.properties
INFO 05 Aug 2013 15:55:29 org.joget.commons.util.SetupManager - Using base directory: /usr/share/tomcat6/wflow/
INFO 05 Aug 2013 15:55:29 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3306/jwdb?characterEncoding=UTF-8, user=user
INFO 05 Aug 2013 15:55:33 org.joget.plugin.base.PluginManager - PluginManager initialized
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table jwdb.dir_user_group (userId varchar(255) not null, groupId varchar(255) not null, primary key (userId, groupId)) ENGINE=InnoDB
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'dir_user_group' already exists
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table jwdb.dir_user_role (userId varchar(255) not null, roleId varchar(255) not null, primary key (userId, roleId)) ENGINE=InnoDB
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'dir_user_role' already exists
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table onlineadvocate.users (id varchar(255) not null, username varchar(255), hash mediumblob, salt mediumblob, firstName varchar(255), lastName varchar(255), email varchar(255)ivated bit, primary key (id)) ENGINE=InnoDB
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'users' already exists
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table dir_employment_report_to add index FK53622945F4068416 (reportToId), add constraint FK53622945F4068416 foreign key (reportToId) references dir_employment (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't create table 'jwdb.#sql-6ea_3a' (errno: 150)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table dir_employment_report_to add index FK536229452787E613 (employmentId), add constraint FK536229452787E613 foreign key (employmentId) references dir_employment (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't create table 'jwdb.#sql-6ea_3a' (errno: 150)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_group add index FKB8FEBDC0159B6639 (groupId), add constraint FKB8FEBDC0159B6639 foreign key (groupId) references dir_group (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FKB8FEBDC0159B6639'
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_group add index FKB8FEBDC0CE539211 (userId), add constraint FKB8FEBDC0CE539211 foreign key (userId) references onlineadvocate.users (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FKB8FEBDC0CE539211'
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_role add index FK58914D15C8FE3CA7 (roleId), add constraint FK58914D15C8FE3CA7 foreign key (roleId) references dir_role (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FK58914D15C8FE3CA7'
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_role add index FK58914D15CE539211 (userId), add constraint FK58914D15CE539211 foreign key (userId) references onlineadvocate.users (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FK58914D15CE539211'
INFO 05 Aug 2013 15:55:39 org.joget.workflow.model.service.WorkflowManagerImpl - Datasource bound to jwdb
SharkEngineManager -> Shark engine is being initialized ...
2013-08-05 15:55:40,339: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API
2013-08-05 15:55:40,342: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactory' implementation of core SharkObjectFactory API
2013-08-05 15:55:40,342: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowToolActivityHandler' implementation of core ToolAgentManager API
2013-08-05 15:55:40,343: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API
2013-08-05 15:55:40,404: WorkflowAssignmentManager -> Working with 'org.joget.workflow.shark.WorkflowUserGroupManagerAdmin' implementation of UserGroup API
2013-08-05 15:55:40,408: WorkflowAssignmentManager. -> Working without ParticipantMapping API implementation - ParticipantMappingManager is not specified.
2013-08-05 15:55:40,409: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowAssignmentManager' implementation of Assignment API
2013-08-05 15:55:40,409: SharkEngineManager -> Working without Caching API implementation - CacheManager is not specified.
2013-08-05 15:55:40,490: DODSPersistentManager -> Adding shutdown hook for HSQL DB
2013-08-05 15:55:42,218: Starting synchronous cache load for class: org.enhydra.shark.instancepersistence.data.ProcessStateDO
2013-08-05 15:55:42,287: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'jwdb.SHKProcessStates' doesn't exist)
2013-08-05 15:55:42,291: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'jwdb.SHKProcessStates' doesn't exist)
com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'jwdb.SHKProcessStates' doesn't exist)
...
WARN 05 Aug 2013 15:55:28 com.atomikos.icatch.config.UserTransactionServiceImp - No properties path set - looking for transactions.properties in classpath...
WARN 05 Aug 2013 15:55:28 com.atomikos.icatch.config.UserTransactionServiceImp - transactions.properties not found - looking for jta.properties in classpath...
WARN 05 Aug 2013 15:55:28 com.atomikos.icatch.config.UserTransactionServiceImp - Using init file: /var/lib/tomcat6/webapps/jw/WEB-INF/classes/jta.properties
INFO 05 Aug 2013 15:55:29 org.joget.commons.util.SetupManager - Using base directory: /usr/share/tomcat6/wflow/
INFO 05 Aug 2013 15:55:29 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3306/jwdb?characterEncoding=UTF-8, user=advocate
INFO 05 Aug 2013 15:55:33 org.joget.plugin.base.PluginManager - PluginManager initialized
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table jwdb.dir_user_group (userId varchar(255) not null, groupId varchar(255) not null, primary key (userId, groupId)) ENGINE=InnoDB
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'dir_user_group' already exists
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table jwdb.dir_user_role (userId varchar(255) not null, roleId varchar(255) not null, primary key (userId, roleId)) ENGINE=InnoDB
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'dir_user_role' already exists
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table onlineadvocate.users (id varchar(255) not null, username varchar(255), hash mediumblob, salt mediumblob, firstName varchar(255), lastName varchar(255), email varchar(255)ivated bit, primary key (id)) ENGINE=InnoDB
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Table 'users' already exists
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table dir_employment_report_to add index FK53622945F4068416 (reportToId), add constraint FK53622945F4068416 foreign key (reportToId) references dir_employment (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't create table 'jwdb.#sql-6ea_3a' (errno: 150)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table dir_employment_report_to add index FK536229452787E613 (employmentId), add constraint FK536229452787E613 foreign key (employmentId) references dir_employment (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't create table 'jwdb.#sql-6ea_3a' (errno: 150)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_group add index FKB8FEBDC0159B6639 (groupId), add constraint FKB8FEBDC0159B6639 foreign key (groupId) references dir_group (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FKB8FEBDC0159B6639'
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_group add index FKB8FEBDC0CE539211 (userId), add constraint FKB8FEBDC0CE539211 foreign key (userId) references onlineadvocate.users (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FKB8FEBDC0CE539211'
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_role add index FK58914D15C8FE3CA7 (roleId), add constraint FK58914D15C8FE3CA7 foreign key (roleId) references dir_role (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FK58914D15C8FE3CA7'
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table jwdb.dir_user_role add index FK58914D15CE539211 (userId), add constraint FK58914D15CE539211 foreign key (userId) references onlineadvocate.users (id)
ERROR 05 Aug 2013 15:55:38 org.hibernate.tool.hbm2ddl.SchemaUpdate - Duplicate key name 'FK58914D15CE539211'
In HelpstepsDirectoryManagerImpl
INFO 05 Aug 2013 15:55:39 org.joget.workflow.model.service.WorkflowManagerImpl - Datasource bound to jwdb
SharkEngineManager -> Shark engine is being initialized ...
2013-08-05 15:55:40,339: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API
2013-08-05 15:55:40,342: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactory' implementation of core SharkObjectFactory API
2013-08-05 15:55:40,342: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowToolActivityHandler' implementation of core ToolAgentManager API
2013-08-05 15:55:40,343: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API
2013-08-05 15:55:40,404: WorkflowAssignmentManager -> Working with 'org.joget.workflow.shark.WorkflowUserGroupManagerAdmin' implementation of UserGroup API
2013-08-05 15:55:40,408: WorkflowAssignmentManager. -> Working without ParticipantMapping API implementation - ParticipantMappingManager is not specified.
2013-08-05 15:55:40,409: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowAssignmentManager' implementation of Assignment API
2013-08-05 15:55:40,409: SharkEngineManager -> Working without Caching API implementation - CacheManager is not specified.
2013-08-05 15:55:40,490: DODSPersistentManager -> Adding shutdown hook for HSQL DB
2013-08-05 15:55:42,218: Starting synchronous cache load for class: org.enhydra.shark.instancepersistence.data.ProcessStateDO
2013-08-05 15:55:42,287: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'jwdb.SHKProcessStates' doesn't exist)
2013-08-05 15:55:42,291: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'jwdb.SHKProcessStates' doesn't exist)
com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'jwdb.SHKProcessStates' doesn't exist)