IS 7.1 not getting started

Sanjay1 · June 9, 2009, 6:33pm

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

Timm · June 26, 2009, 5:35pm

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

hmohammad.11325 · July 1, 2009, 11:25pm

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.

Sanjay1 · July 15, 2009, 5:56pm

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 (c) 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 (c) 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

wrightbp.43724 · November 25, 2009, 8:09pm

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.

bravi86 · December 18, 2009, 4:10pm

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

Thanks,
RavI