Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Emin Cavli (cavle) Lead Technical Architect
Pegasystems Inc.
TR
cavle Member since 2014 7 posts
Posted: Mar 12, 2015
Last activity: Mar 14, 2015
Posted: 12 Mar 2015 5:43 EDT
Last activity: 14 Mar 2015 7:59 EDT
Closed

NonexistentTableException during the split schema insallation of PRPC 7.1.7

Hi All,

I've faced the exception below during a split schema installation of PRPC 7.1.7 on a Windows-Tomcat-Oracle stack. Tried both manual installation and automatic insallation but both failed with the same exception.

Anyone faced the same exception before or know the solution?

 

Kind Regards,

Emin

 

com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable                APP_PEGA_COLL_DATA.pr_assign         PegaDATA

To see attachments, please log in.
Installation and Deployment

Posted: 9 years ago
Posted: 12 Mar 2015 6:04 EDT
Amit kumar (Amitk058)
infosys
IN

PDN says : This exception is thrown when PegaRULES configuration points to a database table that does not exist.

Can you do a select of the table and check if the user id of the installation has access to it. Alternatively you can grant access (from sys user) to the pr_assign table for the current user and then re-try.

To see attachments, please log in.
Posted: 9 years ago
Posted: 12 Mar 2015 6:27 EDT
Emin Cavli (cavle) Lead Technical Architect
Pegasystems Inc.
TR

Hello Amit,

Thanks for the reply, I've checked that and the table APP_PEGA_COLL_DATA.pr_assign exists and the user APP_PEGA_COLL_DATA has access to it. I can select and desc the table without any issues but still facing the exception com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable APP_PEGA_COLL_DATA.pr_assign

Kind Regards,

Emin

 

To see attachments, please log in.
Posted: 9 years ago
Posted: 12 Mar 2015 8:31 EDT
Amit kumar (Amitk058)
infosys
IN

You can check if the table is "well-formed"

 

 

This exception direcly inherits from ConfigurationException for which details are as below :- 

This exception is thrown if there is bad configuration. This might be due to a database table with missing columns, or invalid information in a Rule used by the database (such as Rule-Obj-Class, Data-Admin-DB-Name, or Data-Admin-DB-Table).

 

 

 

 

 

Show More

You can check if the table is "well-formed"

 

 

This exception direcly inherits from ConfigurationException for which details are as below :- 

This exception is thrown if there is bad configuration. This might be due to a database table with missing columns, or invalid information in a Rule used by the database (such as Rule-Obj-Class, Data-Admin-DB-Name, or Data-Admin-DB-Table).

 

 

 

 

 

 


Show Less
To see attachments, please log in.
Posted: 9 years ago
Posted: 12 Mar 2015 9:13 EDT
Emin Cavli (cavle) Lead Technical Architect
Pegasystems Inc.
TR

Hi All,

I've another PRPC 7.17 instance. I've compared the pr_assign table with APP_PEGA_COLL_DATA.pr_assign and they are identical. I've dropped the data and rules user and re-created the schemas and tried again with both automatic and manual installations but faced the same exception each time :(

Kind Regards,

Emin

To see attachments, please log in.
Posted: 9 years ago
Posted: 12 Mar 2015 14:18 EDT
John Peterson (JohnPeterson)
PEGA
Senior Director of Cloud Engineering
Pegasystems Inc.
US

Hi Emin, is the deployment using a user that has the select_catalog_role role? It grants the ability to perform meta-data queries about the database structure such as column names and their size & type.  Also, please review all privileges and roles required on pages 21 & 22 of the guide, and verify.

  https://pdn.pega.com/documents/pega-717-installation-guide-for-apache-tomcat-on-oracle

 

If this doesn't solve your problem, can you provide the full stacktrace?

To see attachments, please log in.
Posted: 9 years ago
Posted: 13 Mar 2015 11:10 EDT
Emin Cavli (cavle) Lead Technical Architect
Pegasystems Inc.
TR

Hello John,

The deployment user has dba rights so no privilege issues. You can see the full stacktrace below.

Kind Regards,

Emin

 

java] 2015-03-11 10:59:18,675 [                main] [          ] [                    ] (rnal.access.CacheContainerImpl) INFO    - Using the Dynamic Cache Probation Policy - cache after 2 accesses AND with a blob increment of 102400.

     [java] 11.Mar.2015 10:59:18 com.pega.pegarules.internal.bootstrap.PRBootstrap

     [java] SEVERE: Problem during method invocation (main)

     [java] com.pega.pegarules.pub.PRException: A problem occurred.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:464)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at java.lang.reflect.Method.invoke(Method.java:597)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

Show More

Hello John,

The deployment user has dba rights so no privilege issues. You can see the full stacktrace below.

Kind Regards,

Emin

 

java] 2015-03-11 10:59:18,675 [                main] [          ] [                    ] (rnal.access.CacheContainerImpl) INFO    - Using the Dynamic Cache Probation Policy - cache after 2 accesses AND with a blob increment of 102400.

     [java] 11.Mar.2015 10:59:18 com.pega.pegarules.internal.bootstrap.PRBootstrap

     [java] SEVERE: Problem during method invocation (main)

     [java] com.pega.pegarules.pub.PRException: A problem occurred.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:464)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at java.lang.reflect.Method.invoke(Method.java:597)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

     [java]               at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

     [java] Caused by: com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1538)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:645)

     [java]               at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:278)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:459)

     [java]               ... 9 more

     [java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable                APP_PEGA_COLL_DATA.pr_assign         PegaDATA

     [java] From: (unknown)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.figureOutSchema(TableInformationMapImpl.java:821)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:473)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)

     [java]               at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2506)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:2767)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:559)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1338)

     [java]               ... 12 more

     [java] 11.Mar.2015 10:59:18 com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega

     [java] SEVERE: Problem during method invocation (main)

     [java] com.pega.pegarules.pub.PRException: A problem occurred.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:464)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at java.lang.reflect.Method.invoke(Method.java:597)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

     [java]               at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

     [java] Caused by: com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1538)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:645)

     [java]               at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:278)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:459)

     [java]               ... 9 more

     [java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable                APP_PEGA_COLL_DATA.pr_assign         PegaDATA

     [java] From: (unknown)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.figureOutSchema(TableInformationMapImpl.java:821)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:473)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)

     [java]               at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2506)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:2767)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:559)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1338)

     [java]               ... 12 more

     [java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:271)

     [java]               at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

     [java] Caused by: com.pega.pegarules.pub.PRException: A problem occurred.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:464)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at java.lang.reflect.Method.invoke(Method.java:597)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

     [java]               ... 1 more

     [java] Caused by: com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1538)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:645)

     [java]               at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:278)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:459)

     [java]               ... 9 more

     [java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable                APP_PEGA_COLL_DATA.pr_assign         PegaDATA

     [java] From: (unknown)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.figureOutSchema(TableInformationMapImpl.java:821)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:473)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)

     [java]               at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2506)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:2767)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:559)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1338)

     [java]               ... 12 more

     [java] 2015-03-11 10:59:18,725 [                main] [          ] [                    ] (pcentric.RACacheAppCentricImpl) INFO    - Cache Serialization to database enabled

     [java] 2015-03-11 10:59:18,734 [                main] [          ] [                    ] (     external.util.Application) ERROR   - A problem occurred.

     [java] com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.

     [java] From: (unknown)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1538)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:645)

     [java]               at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:278)

     [java]               at com.pega.pegarules.deploy.external.util.Application.main(Application.java:459)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at java.lang.reflect.Method.invoke(Method.java:597)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

     [java]               at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

     [java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable                APP_PEGA_COLL_DATA.pr_assign         PegaDATA

     [java] From: (unknown)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.figureOutSchema(TableInformationMapImpl.java:821)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:473)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)

     [java]               at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)

     [java]               at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2506)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:2767)

     [java]               at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:559)

     [java]               at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1338)

     [java]               ... 12 more


Show Less
To see attachments, please log in.
Posted: 9 years ago
Posted: 14 Mar 2015 7:59 EDT
John Peterson (JohnPeterson)
PEGA
Senior Director of Cloud Engineering
Pegasystems Inc.
US

The root cause was a mismatch of the character encoding between the server performing the deployment and the database configuration.  Please refer to the deployment guides for proper environment configuration.

To see attachments, please log in.

Related content:

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

Pega Collaboration Center 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