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

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 [email protected] - 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.
Suggest Edit

Published December 2, 2021

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