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

Topic		Replies	Views
Log4j initialization error while starting my IS webMethods , Integration-Server-and-ESB , webMethods-Archive	1	1394	September 3, 2021
start IS encounter errors webMethods , webMethods-General , Integration-Server-and-ESB	11	2698	April 2, 2021
7.1 IS Restart Problem webMethods , Integration-Server-and-ESB , Flow-and-Java-services	2	2389	April 2, 2021
IS not starting up webMethods , Integration-Server-and-ESB , webMethods-Archive	9	4519	September 3, 2021
installation problem : AuditLogManager Initialization Except webMethods , Integration-Server-and-ESB	11	7072	April 2, 2021

IS 7.1 not getting started

Related topics