IS 7.1 not getting started

Hi Guys,
I have installed webmethod 7.1 as per installation guide and looking out to execute one workflow but I am not able to start Integration Server 7.1.
I have pasted the server log below for reference.

2009-06-09 00:17:58 GMT+05:30 [ISS.0095.0003C] AuditLogManager Runtime Exception: java.sql.SQLException:[wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
processing log entry >>>BasicData:RootContextID=e25e2a40545c11de8403953ab277f0ec,AuditTimestamp=1244486877924,ContextID=e25e2a40545c11de8403953ab277f0ec,AuditSchemaName=wMError,AuditSchemaVersion=1,ServerID:5555=iasserver.igglobal.com,ErrStackTrace=java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.wm.dd.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at com.wm.app.b2b.server.dispatcher.JoinDBUtil.deleteExpiredAndFinishedTriggers(JoinDBUtil.java:396)
at com.wm.app.b2b.server.dispatcher.JoinManager$JoinManagerTimeoutThread.run(JoinManager.java:200)
at com.wm.util.pool.PooledThread.run(PooledThread.java:118)
at java.lang.Thread.run(Thread.java:595)

,ErrorMsg=java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
<<<2009>>>BasicData:RootContextID=e25e2a40545c11de8403953ab277f0ec,AuditTimestamp=1244486877924,ContextID=e25e2a40545c11de8403953ab277f0ec,AuditSchemaName=wMError,AuditSchemaVersion=1,ServerID:5555=iasserver.igglobal.com,ErrStackTrace=java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.wm.dd.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at com.wm.app.b2b.server.dispatcher.JoinDBUtil.deleteExpiredAndFinishedTriggers(JoinDBUtil.java:396)
at com.wm.app.b2b.server.dispatcher.JoinManager$JoinManagerTimeoutThread.run(JoinManager.java:200)
at com.wm.util.pool.PooledThread.run(PooledThread.java:118)
at java.lang.Thread.run(Thread.java:595)

Can any one help at it?

Thanks,
Sanjay

Hi,

did you run the Database Component Configurator tool after the installation? It looks as if the database files are not created correctly.

regards,

Timm

I think a table is missing in JDBC pool db, try re-install the scripts using DB configurator tool by webmethods. it will install all the scripts necessary for webmethods.

Thanks Timm…
I am able to run after executing DB Script using Database Component Configurator tool .
Yet I get an exception at IS console as given here…

D:\WM\IntegrationServer\bin>server.bat
Jul 15, 2009 5:42:22 PM com.webmethods.sc.config.ConfigurationLogger log
INFO: Out-of-band file changes will be monitored every ‘60000’ milliseconds

Tangosol Coherence Version 3.2.2/371

2009-07-15 17:42:23.386 Tangosol Coherence 3.2.2/371 (thread=webMethods Integration Server, member=n/a): Loaded
perational configuration from resource “file:/D:/WM/IntegrationServer/config/Caching/tangosol-coherence.xml”
2009-07-15 17:42:23.386 Tangosol Coherence 3.2.2/371 (thread=webMethods Integration Server, member=n/a): Loaded
icense data from “jar:file:D/WM/common/lib/ext/tangosol.jar!/tangosol-license.xml”


  • Tangosol Coherence is licensed by Tangosol, Inc.
  • Licensed for OEM production use to webMethods, Inc. in accordance with
  • the terms of the Tangosol Software License and Distribution Agreement:
  • Tangosol Coherence: Caching Edition
  • 30A800D50000010EF867CCAD62DD1026  Unlimited use in application
    
  •                                   "webMethods Fabric"
    
  • Copyright © 2000-2006 Tangosol, Inc.

2009-07-15 17:42:23.651 Tangosol Coherence CE 3.2.2/371 (thread=webMethods Integration Server, member=n/a): Load
d operational overrides from resource “jar:file:D:/WM/common/lib/ext/coherence.jar!/tangosol-coherence-override-pro
.xml”
2009-07-15 17:42:23.651 Tangosol Coherence CE 3.2.2/371 (thread=webMethods Integration Server, member=n/a): Load
d operational overrides from resource "file:/D:/WM/IntegrationServer/config/Caching/tangosol-coherence-override.xml

2009-07-15 17:42:23.729 Tangosol Coherence CE 3.2.2/371 (thread=webMethods Integration Server, member=n/a): Load
d cache configuration from resource “file:/D:/WM/IntegrationServer/config/Caching/coherence-cache-config.xml”
[STARTUP] Glue 6.5.1 Fix 4 build 5540 © 2001-2009 webMethods, Inc.
DEBUG : com.webmethods.caf.portalclient.PortalClient : Portal Client initialized
java.lang.Exception: Error in retrieving connection
at com.wm.pkg.mc.database.DBUtils.getConnection(DBUtils.java:147)
at com.wm.pkg.mc.database.DBRepo.contextExists(DBRepo.java:23)
at wm.ariba.supplier.admin.startup.startResources(startup.java:53)
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:585)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:413)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:631)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:189)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:581)
at com.wm.lang.flow.FlowState.step(FlowState.java:441)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:406)
at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1040)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:631)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:91)
at com.wm.app.b2b.server.SessionInvoke.run(Session.java:837)
at com.wm.util.pool.PooledThread.run(PooledThread.java:118)
at java.lang.Thread.run(Thread.java:595).

Can any one help at this issue?

Thanks,
Sanjay

I’m assuming this is a clustered environment since I see Tangosol in the log…

Make sure you have all the JDBC pools required for clustering:

ISInternal
DocumentHistory
Xref
ISCoreAudit

The installation manual only listed two of the required four. webMethods support told me to add the additional two.

Also, you’ll need this line:
watt.server.cluster.aliasList=remote_alias_server_1,remote_alias_server_2, etc.

Along with the corresponding remote aliases. Without these, the triggers will not be clustered properly.

The problem is because of tables not created in the database.Run database configurator and create tables for audit log.

Thanks,
RavI