Support Article
FSIF 7.22 - post installation errors are observed
SA-33516
Summary
Post installation of FSIF 7.22 and upon testing the application errors are observed in the logs.
Error Messages
com.pega.pegarules.pub.database.NonexistentTableException: Database-TableWithNoColumns PEGA_RULES_OWNER.paf_rule PegaRULES
From: (B955BDA7D389CACEC1C7EC17A4AB23B76)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:638)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:476)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:360)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:322)
at com.pega.pegarules.search.internal.es.AbstractIndexerUtils.isClassMappedToExternalTable(AbstractIndexerUtils.java:503)
at com.pega.pegarules.search.internal.es.AbstractIndexerUtils.getEstimatedCount(AbstractIndexerUtils.java:309)
at com.pega.pegarules.search.internal.es.AbstractIndexer.processClassInstSkipAndEstimate(AbstractIndexer.java:844)
at com.pega.pegarules.search.internal.es.AbstractIndexer.skipClassesAndEstimateInstCount(AbstractIndexer.java:794)
at com.pega.pegarules.search.internal.es.AbstractIndexer.performDriverTask(AbstractIndexer.java:612)
at com.pega.pegarules.search.internal.es.AbstractIndexer._buildIndex(AbstractIndexer.java:500)
at com.pega.pegarules.search.internal.es.AbstractIndexer.buildIndex(AbstractIndexer.java:449)
at com.pega.pegarules.search.internal.es.AbstractIndexer.buildIndex(AbstractIndexer.java:192)
at com.pega.pegarules.search.internal.es.AbstractIndexer.buildIndex(AbstractIndexer.java:187)
at
2017-02-08 22:45:43,287 [ Timer-9] (ternal.es.AbstractIndexerUtils) WARN - Instance retrieval failed for class: PegaAcct-Party-InternalAccount
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable PEGA_DATA_OWNER.paf_party PegaDATA
From: (B955BDA7D389CACEC1C7EC17A4AB23B76)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.figureOutSchema(TableInformationMapImpl.java:768)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:449)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:360)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:322)
at com.pega.pegarules.data.internal.access.ConditionListSpecificationImpl.generateSQL(ConditionListSpecificationImpl.java:444)
at com.pega.pegarules.data.internal.access.ConditionListSpecificationImpl.getQueryInserts(ConditionListSpecificationImpl.java:363)
at com.pega.pegarules.data.internal.access.BasicListSpecificationImpl.getQueryInserts(BasicListSpecificationImpl.java:112)
at com.pega.pegarules.data.internal.access.ListSpec.list(ListSpec.java:267)
Steps to Reproduce
1. Try to login into the application using username / password as per the installation guide ( https://pdn.pega.com/documents/financial-services-industry-foundation-722-installation-guide )
2. Check the logs for errors
Root Cause
A defect or configuration issue in the operating environment:
From the logs looks like synonyms are missing for the paf_rule table.
Resolution
- Perform the following local-change:
- Recreate the synonyms in the database.
- Recycle the server
- Test the application
Published February 19, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.