1 Reply Latest reply: Aug 12, 2012 1:22 PM by anjhawar - oracle RSS

    Failed to execute heartbeat update java.sql.SQLSyntaxErrorException.

    952786
      Hi

      I am using sqlserver2008 database with Oracle SOA suite/weblogic clustered environment. When I start my managed servers in a cluster, I get the following warning in my server stdout. Does anyone had a similar exception, or any helpful suggestions.




      <Jul 31, 2012 4:35:29 PM EDT> <Error> <oracle.soa.bpel.engine.cluster> <BEA-000000> <Failed to execute heartbeat update
      java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'CLUSTER_Master'.
      at weblogic.jdbc.sqlserverbase.dda4.b(Unknown Source)
      at weblogic.jdbc.sqlserverbase.dda4.a(Unknown Source)
      at weblogic.jdbc.sqlserverbase.dda3.b(Unknown Source)
      at weblogic.jdbc.sqlserverbase.dda3.a(Unknown Source)
      at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
      at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
      at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
      at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
      at weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
      at weblogic.jdbc.sqlserverbase.ddde.e(Unknown Source)
      at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
      at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
      at weblogic.jdbc.sqlserverbase.ddde.v(Unknown Source)
      at weblogic.jdbc.sqlserverbase.ddde.u(Unknown Source)
      at weblogic.jdbc.sqlserverbase.ddb9.executeQuery(Unknown Source)
      at weblogic.jdbcx.sqlserverbase.ddl.executeQuery(Unknown Source)
      at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:888)
      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:598)
      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
      at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
      at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
      at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
      at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
      at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:644)
      at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2537)
      at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2496)
      at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:407)
      at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1076)
      at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
      at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1036)
      at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:380)
      at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1122)
      at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2910)
      at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
      at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
      at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1247)
      at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:479)
      at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:714)
      at com.collaxa.cube.persistence.dao.impl.jpa.JpaClusterMasterDaoImpl.getWithLock(JpaClusterMasterDaoImpl.java:25)
      at com.collaxa.cube.admin.data.ClusterDataManager.getMasterNodeId(ClusterDataManager.java:225)
      at com.collaxa.cube.admin.data.ClusterDataManager.claimMasterRole(ClusterDataManager.java:132)
      at com.collaxa.cube.cluster.ClusterService.claimMasterRole(ClusterService.java:509)
      at com.collaxa.cube.admin.ejb.impl.CubeClusterBean.claimMasterRole(CubeClusterBean.java:108)
      at com.collaxa.cube.admin.ejb.impl.CubeClusterBean.doClusterNodeUpdate(CubeClusterBean.java:68)
      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 com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
      at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      at com.bea.core.repackaged.springframework.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)

      thanks,
      vinay