Rundeck 2.0.1 Integrating with Oracle Database

353 views

Skip to first unread message

Sunil Tantry

unread,

Feb 27, 2014, 11:13:02 PM2/27/14

to rundeck...@googlegroups.com

Hi,

I am unable to get rundeck running with the Oracle Database. Is there any other sql scripts or steps that I need to execute before this can happen.

Kindly assist.

Below is the error log.

2014-02-28 15:05:51.429:INFO:/:Initializing Spring root WebApplicationContext

2014-02-28 15:06:02,225 [Main Thread] ERROR hbm2ddl.SchemaUpdate - Unsuccessful: create table base_report (id number(19,0) not null, version number(19,0) not null, action_type varchar2(7 char) not null, author varchar2(255 char) not null, ctx_name varchar2(255 char), ctx_project varchar2(255 char) not null, ctx_type varchar2(255 char), date_completed timestamp not null, date_started timestamp not null, mapref_uri varchar2(255 char), message long not null, node varchar2(255 char), report_id varchar2(255 char), status varchar2(7 char) not null, tags varchar2(255 char), title long not null, class varchar2(255 char) not null, aborted_by_user varchar2(255 char), adhoc_execution number(1,0), adhoc_script long, ctx_command varchar2(255 char), ctx_controller varchar2(255 char), jc_exec_id varchar2(255 char), jc_job_id varchar2(255 char), primary key (id))

2014-02-28 15:06:02,232 [Main Thread] ERROR hbm2ddl.SchemaUpdate - ORA-01754: a table may contain only one column of type LONG

2014-02-28 15:06:02,233 [Main Thread] ERROR hbm2ddl.SchemaUpdate - Unsuccessful: create table execution (id number(19,0) not null, version number(19,0) not null, abortedby varchar2(255 char), arg_string long, cancelled number(1,0) not null, date_completed timestamp, date_started timestamp, do_nodedispatch number(1,0), failed_node_list long, filter varchar2(255 char), loglevel varchar2(255 char), node_exclude long, node_exclude_name long, node_exclude_os_arch long, node_exclude_os_family long, node_exclude_os_name long, node_exclude_os_version long, node_exclude_precedence number(1,0), node_exclude_tags long, node_include long, node_include_name long, node_include_os_arch long, node_include_os_family long, node_include_os_name long, node_include_os_version long, node_include_tags long, node_keepgoing number(1,0), node_rank_attribute varchar2(255 char), node_rank_order_ascending number(1,0), node_threadcount number(10,0), outputfilepath long, project varchar2(255 char) not null, scheduled_execution_id number(19,0), server_nodeuuid varchar2(36 char), status varchar2(255 char), succeeded_node_list long, rduser varchar2(255 char) not null, workflow_id number(19,0), primary key (id))

2014-02-28 15:06:02,233 [Main Thread] ERROR hbm2ddl.SchemaUpdate - ORA-01754: a table may contain only one column of type LONG

2014-02-28 15:06:02,261 [Main Thread] ERROR hbm2ddl.SchemaUpdate - Unsuccessful: create table node_filter (id number(19,0) not null, version number(19,0) not null, filter long, name varchar2(255 char) not null, node_exclude long, node_exclude_name long, node_exclude_os_arch long, node_exclude_os_family long, node_exclude_os_name long, node_exclude_os_version long, node_exclude_precedence number(1,0), node_exclude_tags long, node_include long, node_include_name long, node_include_os_arch long, node_include_os_family long, node_include_os_name long, node_include_os_version long, node_include_tags long, project varchar2(255 char), user_id number(19,0) not null, primary key (id))

2014-02-28 15:06:02,261 [Main Thread] ERROR hbm2ddl.SchemaUpdate - ORA-01754: a table may contain only one column of type LONG

2014-02-28 15:06:02,277 [Main Thread] ERROR hbm2ddl.SchemaUpdate - Unsuccessful: create table rdoption (id number(19,0) not null, version number(19,0) not null, default_value long, delimiter varchar2(255 char), description long, enforced number(1,0) not null, multivalued number(1,0), name varchar2(255 char) not null, regex long, required number(1,0), scheduled_execution_id number(19,0), secure_exposed number(1,0), secure_input number(1,0), sort_index number(10,0), values_url varchar2(255 char), values_url_long varchar2(3000 char), primary key (id))

2014-02-28 15:06:02,277 [Main Thread] ERROR hbm2ddl.SchemaUpdate - ORA-01754: a table may contain only one column of type LONG

2014-02-28 15:06:02,383 [Main Thread] ERROR hbm2ddl.SchemaUpdate - Unsuccessful: create table scheduled_execution (id number(19,0) not null, version number(19,0) not null, arg_string long, date_created timestamp not null, day_of_month varchar2(255 char) not null, day_of_week varchar2(255 char) not null, description long, do_nodedispatch number(1,0), exec_count number(19,0), filter long, group_path long, hour varchar2(255 char) not null, job_name long not null, last_updated timestamp not null, loglevel varchar2(255 char), minute varchar2(255 char) not null, month varchar2(255 char) not null, multiple_executions number(1,0), next_execution timestamp, node_exclude long, node_exclude_name long, node_exclude_os_arch long, node_exclude_os_family long, node_exclude_os_name long, node_exclude_os_version long, node_exclude_precedence number(1,0), node_exclude_tags long, node_include long, node_include_name long, node_include_os_arch long, node_include_os_family long, node_include_os_name long, node_include_os_version long, node_include_tags long, node_keepgoing number(1,0), node_rank_attribute varchar2(255 char), node_rank_order_ascending number(1,0), node_threadcount number(10,0), project varchar2(255 char) not null, scheduled number(1,0) not null, seconds varchar2(255 char), server_nodeuuid varchar2(36 char), total_time number(19,0), rduser varchar2(255 char), user_role_list long, uuid varchar2(255 char) unique, workflow_id number(19,0), year varchar2(255 char), primary key (id))

2014-02-28 15:06:02,384 [Main Thread] ERROR hbm2ddl.SchemaUpdate - ORA-01754: a table may contain only one column of type LONG

2014-02-28 15:06:02,428 [Main Thread] ERROR hbm2ddl.SchemaUpdate - Unsuccessful: create table workflow_step (id number(19,0) not null, version number(19,0) not null, description varchar2(1024 char), error_handler_id number(19,0), keepgoing_on_success number(1,0), class varchar2(255 char) not null, arg_string long, job_group long, job_name long, node_step number(1,0), json_data long, type varchar2(255 char), adhoc_execution number(1,0), adhoc_filepath long, adhoc_local_string long, adhoc_remote_string long, interpreter_args_quoted number(1,0), script_interpreter long, primary key (id))

2014-02-28 15:06:02,428 [Main Thread] ERROR hbm2ddl.SchemaUpdate - ORA-01754: a table may contain only one column of type LONG

2014-02-28 15:06:09,607 ERROR JDBCExceptionReporter - ORA-00942: table or view does not exist

2014-02-28 15:06:09,654 ERROR GrailsContextLoader - Error initializing the application: could not execute query; SQL [select this_.id as id1_0_, this_.version as version1_0_, this_.abortedby as abortedby1_0_, this_.arg_string as arg4_1_0_, this_.cancelled as cancelled1_0_, this_.date_completed as date6_1_0_, this_.date_started as date7_1_0_, this_.do_nodedispatch as do8_1_0_, this_.failed_node_list as failed9_1_0_, this_.filter as filter1_0_, this_.loglevel as loglevel1_0_, this_.node_exclude as node12_1_0_, this_.node_exclude_name as node13_1_0_, this_.node_exclude_os_arch as node14_1_0_, this_.node_exclude_os_family as node15_1_0_, this_.node_exclude_os_name as node16_1_0_, this_.node_exclude_os_version as node17_1_0_, this_.node_exclude_precedence as node18_1_0_, this_.node_exclude_tags as node19_1_0_, this_.node_include as node20_1_0_, this_.node_include_name as node21_1_0_, this_.node_include_os_arch as node22_1_0_, this_.node_include_os_family as node23_1_0_, this_.node_include_os_name as node24_1_0_, this_.node_include_os_version as node25_1_0_, this_.node_include_tags as node26_1_0_, this_.node_keepgoing as node27_1_0_, this_.node_rank_attribute as node28_1_0_, this_.node_rank_order_ascending as node29_1_0_, this_.node_threadcount as node30_1_0_, this_.outputfilepath as outputf31_1_0_, this_.project as project1_0_, this_.scheduled_execution_id as scheduled33_1_0_, this_.server_nodeuuid as server34_1_0_, this_.status as status1_0_, this_.succeeded_node_list as succeeded36_1_0_, this_.rduser as rduser1_0_, this_.workflow_id as workflow38_1_0_ from execution this_ where this_.date_completed is null and this_.server_nodeuuid is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id1_0_, this_.version as version1_0_, this_.abortedby as abortedby1_0_, this_.arg_string as arg4_1_0_, this_.cancelled as cancelled1_0_, this_.date_completed as date6_1_0_, this_.date_started as date7_1_0_, this_.do_nodedispatch as do8_1_0_, this_.failed_node_list as failed9_1_0_, this_.filter as filter1_0_, this_.loglevel as loglevel1_0_, this_.node_exclude as node12_1_0_, this_.node_exclude_name as node13_1_0_, this_.node_exclude_os_arch as node14_1_0_, this_.node_exclude_os_family as node15_1_0_, this_.node_exclude_os_name as node16_1_0_, this_.node_exclude_os_version as node17_1_0_, this_.node_exclude_precedence as node18_1_0_, this_.node_exclude_tags as node19_1_0_, this_.node_include as node20_1_0_, this_.node_include_name as node21_1_0_, this_.node_include_os_arch as node22_1_0_, this_.node_include_os_family as node23_1_0_, this_.node_include_os_name as node24_1_0_, this_.node_include_os_version as node25_1_0_, this_.node_include_tags as node26_1_0_, this_.node_keepgoing as node27_1_0_, this_.node_rank_attribute as node28_1_0_, this_.node_rank_order_ascending as node29_1_0_, this_.node_threadcount as node30_1_0_, this_.outputfilepath as outputf31_1_0_, this_.project as project1_0_, this_.scheduled_execution_id as scheduled33_1_0_, this_.server_nodeuuid as server34_1_0_, this_.status as status1_0_, this_.succeeded_node_list as succeeded36_1_0_, this_.rduser as rduser1_0_, this_.workflow_id as workflow38_1_0_ from execution this_ where this_.date_completed is null and this_.server_nodeuuid is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

at org.grails.datastore.gorm.GormStaticApi.methodMissing(GormStaticApi.groovy:111)

at rundeck.services.ExecutionService.cleanupRunningJobs(ExecutionService.groovy:502)

at BootStrap$_closure1.doCall(BootStrap.groovy:239)

at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:308)

at grails.util.Environment.executeForEnvironment(Environment.java:301)

at grails.util.Environment.executeForCurrentEnvironment(Environment.java:277)

at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:733)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:233)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1214)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:676)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:455)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)

at org.eclipse.jetty.server.Server.doStart(Server.java:261)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)

at com.dtolabs.rundeck.RunServer.run(RunServer.java:105)

at com.dtolabs.rundeck.RunServer.main(RunServer.java:66)

at com.dtolabs.rundeck.ExpandRunServer.invokeMain(ExpandRunServer.java:690)

at com.dtolabs.rundeck.ExpandRunServer.execute(ExpandRunServer.java:647)

at com.dtolabs.rundeck.ExpandRunServer.run(ExpandRunServer.java:304)

at com.dtolabs.rundeck.ExpandRunServer.main(ExpandRunServer.java:113)

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

... 21 more

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1041)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3331)

at org.grails.datastore.gorm.GormStaticApi.methodMissing(GormStaticApi.groovy:111)

at rundeck.services.ExecutionService.cleanupRunningJobs(ExecutionService.groovy:502)

at BootStrap$_closure1.doCall(BootStrap.groovy:239)

at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:308)

at grails.util.Environment.executeForEnvironment(Environment.java:302)

at grails.util.Environment.executeForCurrentEnvironment(Environment.java:277)

at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:733)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:236)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1215)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:676)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:455)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)

at org.eclipse.jetty.server.Server.doStart(Server.java:261)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)

at com.dtolabs.rundeck.RunServer.run(RunServer.java:105)

at com.dtolabs.rundeck.RunServer.main(RunServer.java:67)

at com.dtolabs.rundeck.ExpandRunServer.invokeMain(ExpandRunServer.java:691)

at com.dtolabs.rundeck.ExpandRunServer.execute(ExpandRunServer.java:649)

at com.dtolabs.rundeck.ExpandRunServer.run(ExpandRunServer.java:304)

at com.dtolabs.rundeck.ExpandRunServer.main(ExpandRunServer.java:114)

2014-02-28 15:06:09,656 ERROR GrailsContextLoader - Error initializing Grails: could not execute query; SQL [select this_.id as id1_0_, this_.version as version1_0_, this_.abortedby as abortedby1_0_, this_.arg_string as arg4_1_0_, this_.cancelled as cancelled1_0_, this_.date_completed as date6_1_0_, this_.date_started as date7_1_0_, this_.do_nodedispatch as do8_1_0_, this_.failed_node_list as failed9_1_0_, this_.filter as filter1_0_, this_.loglevel as loglevel1_0_, this_.node_exclude as node12_1_0_, this_.node_exclude_name as node13_1_0_, this_.node_exclude_os_arch as node14_1_0_, this_.node_exclude_os_family as node15_1_0_, this_.node_exclude_os_name as node16_1_0_, this_.node_exclude_os_version as node17_1_0_, this_.node_exclude_precedence as node18_1_0_, this_.node_exclude_tags as node19_1_0_, this_.node_include as node20_1_0_, this_.node_include_name as node21_1_0_, this_.node_include_os_arch as node22_1_0_, this_.node_include_os_family as node23_1_0_, this_.node_include_os_name as node24_1_0_, this_.node_include_os_version as node25_1_0_, this_.node_include_tags as node26_1_0_, this_.node_keepgoing as node27_1_0_, this_.node_rank_attribute as node28_1_0_, this_.node_rank_order_ascending as node29_1_0_, this_.node_threadcount as node30_1_0_, this_.outputfilepath as outputf31_1_0_, this_.project as project1_0_, this_.scheduled_execution_id as scheduled33_1_0_, this_.server_nodeuuid as server34_1_0_, this_.status as status1_0_, this_.succeeded_node_list as succeeded36_1_0_, this_.rduser as rduser1_0_, this_.workflow_id as workflow38_1_0_ from execution this_ where this_.date_completed is null and this_.server_nodeuuid is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query