SA-5183

Summary

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.

Resolution

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:

NON-SPLIT Schema	SPLIT Schema
<variable> <name>defaultDataSchema</name> <value>%YourDefaultSchema%</value> </variable> <variable> <name>defaultRulesSchema</name> <value>%YourDefaultSchema%</</value> </variable>	<variable> <name>defaultDataSchema</name> <value>%YourDataSchema%</value> </variable> <variable> <name>defaultRulesSchema</name> <value>%YourRulesSchema%</</value> </variable>

1. Save Plan.xml.1