Question

5
Replies
143
Views
biswa1 Member since 2014 7 posts
PEGA
Posted: 1 year ago
Last activity: 1 year 6 months ago
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:?]
Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn