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?
invalid table name
Steps to Reproduce
Simply run the startweblogic command file.
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’.
- Create or edit a Deployment Plan.
- Configure a specific directory structure for the Deployment Plan and the EAR/WAR archive.
- 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:
- Make a copy (backup) of the sample plan, in case you need to back out your changes.
- 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:
- Save Plan.xml.1
0% found this useful