Loading...

Type: Bug
Resolution: Done
Priority: Blocker
Fix Version/s: jboss-fuse-6.2.1
Affects Version/s: jboss-fuse-6.2.1
Component/s: RTGov
Labels:
None

Fuse Progress Bar:

% %
Steps to Reproduce:

Hide

java -jar fuse-eap installer

java -jar rtgov-server installed

install-overlord.sh

deploy ordermgmt app,ip,epn

cd ordermgmt/app; mvn exec:java -Dreq=order1

Show
java -jar fuse-eap installer java -jar rtgov-server installed install-overlord.sh deploy ordermgmt app,ip,epn cd ordermgmt/app; mvn exec:java -Dreq=order1

SFDC Cases Counter:
SFDC Cases Links:

In ER4 the default persistence is the relational DB as in FSW 6.1 (instead of elasticsearch that is used in the community). Currently the RTGov does not work out of the box, because the DB tables are not created in the h2 db (in FSW 6.1 it was done by the installer). After executing ordermgmt quickstart, I get:

09:04:37,061 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-107) Table "RTGOV_ACTIVITY_UNITS" not found; SQL statement:
insert into RTGOV_ACTIVITY_UNITS (host, node, principal, thread, id) values (?, ?, ?, ?, ?) [42102-168]
09:04:37,063 ERROR [stderr] (Thread-107) org.hibernate.exception.SQLGrammarException: could not prepare statement
09:04:37,064 ERROR [stderr] (Thread-107) 	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
09:04:37,064 ERROR [stderr] (Thread-107) 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
09:04:37,064 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
09:04:37,064 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:193)
09:04:37,064 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:89)
09:04:37,064 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.buildBatchStatement(AbstractBatchImpl.java:150)
09:04:37,065 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.getBatchStatement(AbstractBatchImpl.java:139)
09:04:37,065 ERROR [stderr] (Thread-107) 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3057)
09:04:37,065 ERROR [stderr] (Thread-107) 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)
09:04:37,065 ERROR [stderr] (Thread-107) 	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
09:04:37,065 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
09:04:37,065 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)
09:04:37,066 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)
09:04:37,066 ERROR [stderr] (Thread-107) 	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
09:04:37,066 ERROR [stderr] (Thread-107) 	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
09:04:37,066 ERROR [stderr] (Thread-107) 	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
09:04:37,066 ERROR [stderr] (Thread-107) 	at org.overlord.rtgov.common.jpa.JpaStore.withJpa(JpaStore.java:182)
09:04:37,066 ERROR [stderr] (Thread-107) 	at org.overlord.rtgov.activity.store.jpa.JPAActivityStore.store(JPAActivityStore.java:75)
09:04:37,067 ERROR [stderr] (Thread-107) 	at org.overlord.rtgov.internal.activity.server.jee.JEEActivityServer.store(JEEActivityServer.java:256)
09:04:37,067 ERROR [stderr] (Thread-107) 	at org.overlord.rtgov.activity.collector.activity.server.ActivityServerLogger$1.run(ActivityServerLogger.java:115)
09:04:37,067 ERROR [stderr] (Thread-107) 	at java.lang.Thread.run(Thread.java:745)
09:04:37,067 ERROR [stderr] (Thread-107) Caused by: org.h2.jdbc.JdbcSQLException: Table "RTGOV_ACTIVITY_UNITS" not found; SQL statement:
09:04:37,067 ERROR [stderr] (Thread-107) insert into RTGOV_ACTIVITY_UNITS (host, node, principal, thread, id) values (?, ?, ?, ?, ?) [42102-168]
09:04:37,067 ERROR [stderr] (Thread-107) 	at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
09:04:37,068 ERROR [stderr] (Thread-107) 	at org.h2.message.DbException.get(DbException.java:169)
09:04:37,068 ERROR [stderr] (Thread-107) 	at org.h2.message.DbException.get(DbException.java:146)
09:04:37,068 ERROR [stderr] (Thread-107) 	at org.h2.command.Parser.readTableOrView(Parser.java:4770)
09:04:37,068 ERROR [stderr] (Thread-107) 	at org.h2.command.Parser.readTableOrView(Parser.java:4748)
09:04:37,068 ERROR [stderr] (Thread-107) 	at org.h2.command.Parser.parseInsert(Parser.java:958)
09:04:37,068 ERROR [stderr] (Thread-107) 	at org.h2.command.Parser.parsePrepared(Parser.java:375)
09:04:37,068 ERROR [stderr] (Thread-107) 	at org.h2.command.Parser.parse(Parser.java:279)
09:04:37,069 ERROR [stderr] (Thread-107) 	at org.h2.command.Parser.parse(Parser.java:251)
09:04:37,069 ERROR [stderr] (Thread-107) 	at org.h2.command.Parser.prepareCommand(Parser.java:217)
09:04:37,069 ERROR [stderr] (Thread-107) 	at org.h2.engine.Session.prepareLocal(Session.java:415)
09:04:37,069 ERROR [stderr] (Thread-107) 	at org.h2.engine.Session.prepareCommand(Session.java:364)
09:04:37,069 ERROR [stderr] (Thread-107) 	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
09:04:37,069 ERROR [stderr] (Thread-107) 	at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
09:04:37,069 ERROR [stderr] (Thread-107) 	at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:626)
09:04:37,070 ERROR [stderr] (Thread-107) 	at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:748)
09:04:37,070 ERROR [stderr] (Thread-107) 	at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:734)
09:04:37,070 ERROR [stderr] (Thread-107) 	at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:405)
09:04:37,070 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:96)
09:04:37,070 ERROR [stderr] (Thread-107) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:183)
09:04:37,070 ERROR [stderr] (Thread-107) 	... 17 more

I was able to integrate it into the install-overlord.sh script:

#!/bin/sh

SCRIPT_HOME=`dirname $(readlink -f $0)`

EAP_HOME=`readlink -f ${SCRIPT_HOME}/../../..`

ANT_HOME=`readlink -f ${EAP_HOME}/lib`

H2_HOME=`readlink -f ${EAP_HOME}/modules/system/layers/base/com/h2database/h2/main`

H2_FILE=`ls ${H2_HOME} | grep .jar`

DATA_DIR=`readlink -f ${EAP_HOME}/standalone/data`

java -Dant.home=${ANT_HOME} -Dpath=${EAP_HOME} -Dappserver.id=jboss-eap-64 -cp ${ANT_HOME}/ant-launcher-1.8.3.jar org.apache.tools.ant.launch.Launcher -q -f ${SCRIPT_HOME}/platforms/jboss-eap-64/all/build.xml install

java -cp ${H2_HOME}/${H2_FILE} org.h2.tools.RunScript -url jdbc:h2:${DATA_DIR}/h2/rtgov -script ${EAP_HOME}/sql/rtgov/overlord-rtgov.DB2Dialect.sql

Maybe it can be tweaked (i'm not a bash expert), but it's working.

dcoleman@redhat.com what do you think? Or can this be executed via the fuse-patch tool?

relates to

ENTESB-4409 [ER4] Ordermgmt QS throwing exceptions

Closed

Details

Description

Attachments

Issue Links

Activity

People

Dates