Question

5
Replies
169
Views
Close popover
Arindam Biswas (biswa1)
PEGA
Principal Solutions Consultant
Pegasystems Inc.
US
biswa1 Member since 2014 7 posts
PEGA
Posted: April 2, 2019
Last activity: April 17, 2019
Closed
Solved

Unable to Start WAS/Orcale Deployment

After configuring WAS for Oracle. Pega will not start, and has the following errors:

Any ideas? I think it has to do with the data source set up in WAS. Pega is trying to hit up against the rules schema for tables that are only present in the data schema.

2019-03-13 07:48:07,866 [ server.startup : 1] [ ] [ ] [ ] (ervlet.WebAppLifeCycleListener) INFO - System Start Date: Wed Mar 13 07:48:07 EDT 2019
2019-03-13 07:48:07,882 [ server.startup : 1] [ ] [ ] [ ] (ervlet.WebAppLifeCycleListener) INFO - PegaRULES Web Tier 8.1.2
2019-03-13 07:48:07,882 [ server.startup : 1] [ ] [ ] [ ] (ervlet.WebAppLifeCycleListener) INFO - PRPC-8.1.2-340: 2018-12-05 00.33 EST
2019-03-13 07:48:07,882 [ server.startup : 1] [ ] [ ] [ ] (ervlet.WebAppLifeCycleListener) INFO - unknown (5717950d0b7711bb472d4d59f93f5057dd5422de)
2019-03-13 07:48:07,882 [ server.startup : 1] [ ] [ ] [ ] (ervlet.WebAppLifeCycleListener) INFO - Now starting the PegaRULES Web Tier...
2019-03-13 07:48:07,968 [ server.startup : 1] [ ] [ ] [ ] ( context.web.WebEnvironment) INFO - Web tier using local JNDI context
factory = com.ibm.websphere.naming.WsnInitialContextFactory
url = corbaloc:rir:/NameServiceServerRoot
path = cloudappCell/clusters/cloudappCluster
2019-03-13 07:48:07,968 [ server.startup : 1] [ ] [ ] [ ] ( priv.context.JNDIEnvironment) INFO - Web-tier default Engine bean name is EngineBMT
2019-03-13 07:48:08,880 [ server.startup : 1] [ ] [ ] [ ] (les.internal.ModulesBridgeImpl) INFO - Initializing engine modules.
2019-03-13 07:48:09,957 [ server.startup : 1] [ ] [ ] [ ] (nternal.NodeClassificationImpl) INFO - Node is started without applicableNodeTypes or invalid applicableNodeTypes. Hence applicableNodeTypes will be the default list: [Search, WebUser, BIX, BackgroundProcessing, Custom1, Custom2, Custom3, Custom4, Custom5, DDS, ADM, Batch, RealTime, RTDG, Stream]
2019-03-13 07:48:09,957 [ server.startup : 1] [ ] [ ] [ ] (nternal.NodeClassificationImpl) INFO - Node classification is not enabled on current node
2019-03-13 07:48:10,021 [ server.startup : 1] [ ] [ ] [ ] (AdminSystemConfigurationSource) ERROR - Unable to connect to database. Will only use properties from file.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502) ~[ojdbc7.jar:12.1.0.1.0]
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1220) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:738) ~[com.ibm.ws.runtime.jar:?]
at com.pega.pegarules.internal.bootstrap.SettingReaderDB.getAllClassificationSettingsDB(SettingReaderDB.java:87) ~[prbootstrap-8.1.2-340.jar:8.1.2-340]
at com.pega.pegarules.internal.bootstrap.SettingReaderDB.getSettingsDB(SettingReaderDB.java:154) ~[prbootstrap-8.1.2-340.jar:8.1.2-340]
at com.pega.platform.environment.configuration.internal.bridge.SettingReaderDB.getConfig(SettingReaderDB.java:39) ~[environment.jar:?]
at com.pega.platform.environment.configuration.internal.sources.DataAdminSystemConfigurationSource.readConfiguration(DataAdminSystemConfigurationSource.java:59) ~[environment.jar:?]
at com.pega.platform.environment.configuration.internal.sources.DataAdminSystemConfigurationSource.<init>(DataAdminSystemConfigurationSource.java:51) ~[environment.jar:?]
at com.pega.platform.environment.configuration.internal.DefaultConfigurationSource.getDatabaseConfigurationSource(DefaultConfigurationSource.java:134) ~[environment.jar:?]
at com.pega.platform.environment.configuration.internal.DefaultConfigurationSource.<init>(DefaultConfigurationSource.java:97) ~[environment.jar:?]
at com.pega.platform.environment.configuration.internal.DefaultConfigurationSource.<init>(DefaultConfigurationSource.java:87) ~[environment.jar:?]
at com.pega.platform.environment.configuration.internal.ConfigurationImpl.<init>(ConfigurationImpl.java:68) ~[environment.jar:?]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83) ~[?:1.8.0]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57) ~[?:1.8.0]
at java.lang.reflect.Constructor.newInstance(Constructor.java:437) ~[?:1.8.0]
at com.google.inject.internal.DefaultConstructionProxyFactory$2.newInstance(DefaultConstructionProxyFactory.java:86) ~[guice-4.0.jar:?]
at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:105) ~[guice-4.0.jar:?]
at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85) ~[guice-4.0.jar:?]
at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267) ~[guice-4.0.jar:?]
at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46) ~[guice-4.0.jar:?]
at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1103) ~[guice-4.0.jar:?]
at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40) ~[guice-4.0.jar:?]
at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:145) ~[guice-4.0.jar:?]
at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41) ~[guice-4.0.jar:?]
at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:56) ~[guice-4.0.jar:?]
at com.google.inject.internal.InjectorImpl$2$1.call(InjectorImpl.java:1016) ~[guice-4.0.jar:?]
at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092) ~[guice-4.0.jar:?]
at com.google.inject.internal.InjectorImpl$2.get(InjectorImpl.java:1012) ~[guice-4.0.jar:?]
at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1051) ~[guice-4.0.jar:?]
at com.pega.platform.modules.internal.ModulesBridgeImpl.getModules(ModulesBridgeImpl.java:108) ~[modules-bridge.jar:?]
at com.pega.platform.modules.internal.ModulesBridgeImpl.<init>(ModulesBridgeImpl.java:97) ~[modules-bridge.jar:?]
at java.lang.J9VMInternals.newInstanceImpl(Native Method) ~[?:2.9 (02-08-2018)]
at java.lang.Class.newInstance(Class.java:1773) ~[?:2.9 (02-08-2018)]
at com.pega.platform.modules.PRModulesProvider.initialize(PRModulesProvider.java:36) ~[modules-bridge.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0]
at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]
at com.pega.pegarules.common.PREngineProvider.<clinit>(PREngineProvider.java:202) ~[prenginext.jar:?]
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineStartup.initEngine(EngineStartup.java:398) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:172) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.doStartup(EngineImpl.java:145) ~[prprivate.jar:?]
at com.pega.pegarules.web.servlet.WebAppLifeCycleListener._contextInitialized_privact(WebAppLifeCycleListener.java:216) ~[prwebj2ee.jar:?]
at com.pega.pegarules.web.servlet.AbstractLifeCycleListener._contextInitialized_privact(AbstractLifeCycleListener.java:159) ~[prwebj2ee.jar:?]
at com.pega.pegarules.web.servlet.AbstractLifeCycleListener.contextInitialized(AbstractLifeCycleListener.java:73) ~[prwebj2ee.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0]
at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370) ~[prbootstrap-8.1.2-340.jar:8.1.2-340]
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411) ~[prbootstrap-8.1.2-340.jar:8.1.2-340]
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224) ~[prbootstrap-api-8.1.2-340.jar:8.1.2-340]
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273) ~[prbootstrap-api-8.1.2-340.jar:8.1.2-340]
at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:92) ~[prbootstrap-api-8.1.2-340.jar:8.1.2-340]
at com.ibm.ws.webcontainer.webapp.WebApp.notifyServletContextCreated(WebApp.java:1734) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:415) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:88) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:171) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:904) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:789) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:427) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:719) ~[com.ibm.ws.webcontainer.jar:?]
at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1211) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1390) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:639) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:979) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:795) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.ApplicationMgrImpl$5.run(ApplicationMgrImpl.java:2279) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5554) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5680) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2284) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:436) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:379) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$500(CompositionUnitMgrImpl.java:127) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:985) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:524) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892) ~[com.ibm.ws.runtime.jar:?]
System Administration Installation and Deployment
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.