Support Article
Database-NonexistentTable pr4_base PegaRULES during start-up
SA-2991
Summary
PRPC fails to start with following ERROR/Exception
2014-10-09 13:09:52,739 [ nj09mhf5331.mhf.mhc] [ ] [ ] ( internal.access.DatabaseImpl) ERROR - Problem reading class definitions: Database-NonexistentTable pr4_base PegaRULES
2014-10-09 13:09:52,745 [ nj09mhf5331.mhf.mhc] [ ] [ ] ( mgmt.base.ThreadPassivation) FATAL - There was a problem initializing the Database Interface: Database-NonexistentTable pr4_base PegaRULES
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable pr4_base PegaRULES
From: (unknown)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:522)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:385)
Error Messages
2014-10-09 13:09:52,739 [ nj09mhf5331.mhf.mhc] [ ] [ ] ( internal.access.DatabaseImpl) ERROR - Problem reading class definitions: Database-NonexistentTable pr4_base PegaRULES
2014-10-09 13:09:52,745 [ nj09mhf5331.mhf.mhc] [ ] [ ] ( mgmt.base.ThreadPassivation) FATAL - There was a problem initializing the Database Interface: Database-NonexistentTable pr4_base PegaRULES
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable pr4_base PegaRULES
From: (unknown)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:522)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:385)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.getWithConnection(TableInformationMapImpl.java:352)
at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.init(ClassMapImpl.java:1737)
at com.pega.pegarules.data.internal.access.DatabaseImpl.<init>(DatabaseImpl.java:1597)
at com.pega.pegarules.data.internal.access.DatabaseImpl.newDatabaseImpl(DatabaseImpl.java:1530)
at com.pega.pegarules.data.internal.PRDataProviderImpl.ctorDatabaseImpl(PRDataProviderImpl.java:576)
at com.pega.pegarules.session.internal.mgmt.base.ThreadPassivation.configureThreadImpl(ThreadPassivation.java:264)
at com.pega.pegarules.session.internal.mgmt.PRThreadBase.configureThread(PRThreadBase.java:432)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.<init>(PRThreadImpl.java:301)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.acquire(PRThreadImpl.java:312)
at com.pega.pegarules.session.internal.mgmt.base.RequestorThreadSync.getOrCreateThread(RequestorThreadSync.java:166)
at com.pega.pegarules.session.internal.mgmt.base.RequestorThreadSync.getOrCreateThread(RequestorThreadSync.java:154)
at com.pega.pegarules.session.internal.mgmt.base.RequestorPassivation.configureRequestorImpl(RequestorPassivation.java:403)
at com.pega.pegarules.session.internal.mgmt.PRRequestorBase.configureRequestor(PRRequestorBase.java:469)
at com.pega.pegarules.session.internal.mgmt.PRRequestorImpl.<init>(PRRequestorImpl.java:258)
at com.pega.pegarules.session.internal.mgmt.PRRequestorImpl.acquire(PRRequestorImpl.java:271)
at com.pega.pegarules.session.internal.mgmt.base.NodeRequestorMgt.createRequestorImpl(NodeRequestorMgt.java:1164)
at com.pega.pegarules.session.internal.mgmt.PRNodeImpl.initializeSystem(PRNodeImpl.java:1195)
at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:368)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.getThreadAndInitialize(PRSessionProviderImpl.java:1533)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineStartup.initEngine(EngineStartup.java:606)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:165)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.doStartup(EngineImpl.java:138)
at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.doStartup(EngineBean.java:135)
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:597)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:349)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:390)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingException(PRBootstrap.java:412)
at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.doStartup(EngineBeanBoot.java:130)
at com.pega.pegarules.internal.etier.ejb.EngineBMT_h449u3_ELOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
at com.pega.pegarules.internal.etier.ejb.EngineBMT_h449u3_ELOImpl.doStartup(Unknown Source)
at com.pega.pegarules.web.servlet.WebAppLifeCycleListener._contextInitialized_privact(WebAppLifeCycleListener.java:259)
at com.pega.pegarules.web.servlet.WebAppLifeCycleListener.contextInitialized(WebAppLifeCycleListener.java:167)
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:597)
Steps to Reproduce
Restart server.
Root Cause
The following DEBUG highlighted in RED along with the PDN article (link below) explains the root cause of this issue –
2014-10-09 17:39:28,363 [ nj09mhf5331.mhf.mhc] [ ] [ ] ( internal.access.TableInformationMapImpl) DEBUG - More than one synonyms with the same name qualify for search resulting in an ambiguous choice we have to make hence throwing an error.
2014-10-09 17:39:28,364 [ nj09mhf5331.mhf.mhc] [ ] [ ] ( internal.access.DatabaseImpl) ERROR - Problem reading class definitions: Database-NonexistentTable pr4_base PegaRULES
2014-10-09 17:39:28,369 [ nj09mhf5331.mhf.mhc] [ ] [ ] ( mgmt.base.ThreadPassivation) FATAL - There was a problem initializing the Database Interface: Database-NonexistentTable pr4_base PegaRULES
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable pr4_base PegaRULES
The following PDN article clearly explains the issue in detail and the next step resolution - https://pdn.pega.com/pegarules-database/troubleshooting-obj-save-is-trying-to-write-to-a-non-existent-column
Resolution
Apply the resolution described in detail under PDN article https://pdn.pega.com/pegarules-database/troubleshooting-obj-save-is-trying-to-write-to-a-non-existent-column
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.