Support Article

IIF721 app bundle import fails with NonexistentTable error

SA-31309

Summary



Importing Insurance Industry Framework fails with the below error.

Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable PEGA7_RULES.insproduct_rules PegaRULES
From: (B5212777BD7F75ED8298AFDC5D834E88C)

User were upgraded from PRPC62SP1 + CPMi 4.3
to Pega 721 + IIF721 + CSi721

Error Messages


22016-11-15 19:42:29,375 [ PegaRULES-Batch-3] [ STANDARD] [ ] [ PegaRULES:07.10] (ga_importexport_pximportexport) ERROR Administrator@pega.com - ImportArchive: Encountered the following error: A problem occurred.
com.pega.pegarules.pub.PRException: A problem occurred.
From: (B5212777BD7F75ED8298AFDC5D834E88C)
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:486)
at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:933)
at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:757)
at com.pega.pegarules.deploy.internal.util.ImportImpl.importArchive(ImportImpl.java:714)
at com.pega.pegarules.deploy.internal.util.ImportImpl.importPegaArchive(ImportImpl.java:720)
at com.pega.pegarules.deploy.internal.archive.PegaArchiveAbstract.doImport(PegaArchiveAbstract.java:358)
at com.pegarules.generated.pxImportArchive_071021_tI_7qJ4OCdFAaj__QDX3Eg.pxImportArchive07_10_21(pxImportArchive_071021_tI_7qJ4OCdFAaj__QDX3Eg.java:147)
at com.pegarules.generated.pxImportArchive_071021_tI_7qJ4OCdFAaj__QDX3Eg.invoke(pxImportArchive_071021_tI_7qJ4OCdFAaj__QDX3Eg.java:82)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:221)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9073)
at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:275)
at com.pegarules.generated.activity.ra_action_pegarulesmove_zip_to_db_fa763a62f2d55b14ea181e279dd254e8.step8_circum0(ra_action_pegarulesmove_zip_to_db_fa763a62f2d55b14ea181e279dd254e8.java:923)
at com.pegarules.generated.activity.ra_action_pegarulesmove_zip_to_db_fa763a62f2d55b14ea181e279dd254e8.perform(ra_action_pegarulesmove_zip_to_db_fa763a62f2d55b14ea181e279dd254e8.java:207)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:572)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:459)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:257)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:321)
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:980)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1290)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1038)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:920)
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:697)
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991)
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.pega.pegarules.pub.PRException: Table PEGA7_RULES.insproduct_rules does not exist in database PegaRULES
From: (B5212777BD7F75ED8298AFDC5D834E88C)
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:415)
... 27 more
Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable PEGA7_RULES.insproduct_rules PegaRULES
From: (B5212777BD7F75ED8298AFDC5D834E88C)
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.dictionary.ClassDefinitionImpl.isMappedToExternalTable(ClassDefinitionImpl.java:1407)
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:308)
... 27 more


Steps to Reproduce



Import the IIF IIFv721_Install_Bundle.jar file.

Root Cause



The root cause of this issue could be defect or configuration issue in the operating environment: Database synonyms were preventing Pega engine access to the correct schema objects.

Resolution



Make bellow changes to the operating environment:
  1. Stop the server.
  2. Drop all synonyms.
  3. Start the server.
  4. Re import IIF application bundle.
  5. Stop the server.
  6. Reapply the synonyms privately.
  7. Restart the server.

Published December 12, 2016 - Updated May 28, 2018

Have a question? Get answers now.

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