-
Bug
-
Resolution: Done
-
Critical
-
EAP_EWP 5.1.1 ER2
-
None
-
NEW
It seems that table JBM_CLUSTER cannot be created when new failover mode is used and db2 97 db is used.
Could you please look at it?
Thank you,
Mirek
Log:
02:36:41,398 TRACE @RMI TCP Connection(2)-10.16.89.224 [JDBCSupport] Executing: CREATE TABLE JBM_CLUSTER (NODE_ID SMALLINT, PING_TIMESTAMP DATETIME, STATE SMALLINT, PRIMARY KEY(NODE_ID))
02:36:41,398 DEBUG @RMI TCP Connection(2)-10.16.89.224 [logger] TransactionImple.getStatus
02:36:41,398 DEBUG @RMI TCP Connection(2)-10.16.89.224 [logger] TransactionImple.getStatus
02:36:41,435 DEBUG @RMI TCP Connection(2)-10.16.89.224 [JDBCSupport] Failed to execute: CREATE TABLE JBM_CLUSTER (NODE_ID SMALLINT, PING_TIMESTAMP DATETIME, STATE SMALLINT, PRIMARY KEY(NODE_ID))
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DATETIME, DRIVER=4.11.77
at com.ibm.db2.jcc.am.gd.a(gd.java:676)
at com.ibm.db2.jcc.am.gd.a(gd.java:60)
at com.ibm.db2.jcc.am.gd.a(gd.java:127)
at com.ibm.db2.jcc.am.jn.c(jn.java:2561)
at com.ibm.db2.jcc.am.jn.d(jn.java:2549)
at com.ibm.db2.jcc.am.jn.b(jn.java:1965)
at com.ibm.db2.jcc.t4.cb.h(cb.java:224)
at com.ibm.db2.jcc.t4.cb.b(cb.java:47)
at com.ibm.db2.jcc.t4.q.b(q.java:38)
at com.ibm.db2.jcc.t4.rb.h(rb.java:114)
at com.ibm.db2.jcc.am.jn.hb(jn.java:1960)
at com.ibm.db2.jcc.am.jn.a(jn.java:3066)
at com.ibm.db2.jcc.am.jn.c(jn.java:719)
at com.ibm.db2.jcc.am.jn.executeUpdate(jn.java:703)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)
at org.jboss.messaging.core.impl.JDBCSupport.createSchema(JDBCSupport.java:340)
at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:207)
at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:413)
at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:516)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.test.messaging.tools.container.ServiceContainer.invoke(ServiceContainer.java:715)