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

PRPC v7.1.7 Weblogic/Ear deployment



I have taken delivery of the PRPC v7.1.7 bundle and configured this as an EAR deployment within Weblogic over Oracle RDBMS in a windows7 environment.

When I start the Weblogic service it encounters a problem almost immediately in the form of a SQL syntax error exception

"select pzPVstream from .pr4_base where pxObjClass = 'Data-Admin-DB-Name
ORA-00905: invalid table name'"

--> NOTE the DOT in front of the pr4_base table name (I do have a pr4_base table in my Rules schema).

There is nothing that I can do to overcome this problem in the configuration.

I have used the prpc_wls_jee4.ear dated 26/11/2014 size 519KB as found in the bundle - is there a later version available that you can send to me?

Error Messages

invalid table name

Steps to Reproduce

Simply run the startweblogic command file.

Root Cause

The root cause of this problem is software use/operation error.


This issue is resolved through the following local change:

If you are using this WebLogic specific EAR file (prpc_wls_jee4.ear), you will have to use the Deployment Plan to configure the JNDI setting in the application archive. A Deployment Plan is the user Configurable XML file that captures environment-specific configuration properties.

NOTE: Below steps should be followed when you are either using SPLIT or NON-SPLIT Schema. The ‘7.1.*-installation-guide-for-weblogic’ document may confusing to point that below configuration is required only while ‘Configuring a Split Schema’.

  1. Create or edit a Deployment Plan.
  2. Configure a specific directory structure for the Deployment Plan and the EAR/WAR archive.
  3. Deploy (or redeploy) the application archive and Deployment Plan using the WebLogic

Step 1 — Edit the Deployment Plan

Your PRPC 7.1.* distribution is packaged with a sample deployment plan that you can use for your environment. The deployment plan is located in the following directory:

EAR: <PRPC_MEDIA_HOME>\archives\prpc\weblogic\ear\plan\Plan.xml

WAR: <PRPC_MEDIA_HOME>\archives\prpc\weblogic\war\plan\Plan.xml

  1. Make a copy (backup) of the sample plan, in case you need to back out your changes.
  2. Open Plan.xml in a text editor, and locate the elements named defaultDataSchema and defaultRulesSchema. Add the values for your schema in the <value> element. For example:


SPLIT Schema

















  1. Save Plan.xml.1

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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