Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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
 
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us