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-TableWithNoColumnsPEGA_RULES_OWNER.paf_rulePegaRULES
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-NonexistentTablePEGA_DATA_OWNER.paf_partyPegaDATA
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


  1. Perform the following local-change:
  2. Recreate the synonyms in the database.
  3. Recycle the server
  4. Test the application

Published February 9, 2017 - Updated February 18, 2017

Have a question? Get answers now.

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