Discussion

V5.4 Tomcat install fails - "missing database"

I am trying to install 54sp1 on Tomcat. I have followed the PRPC5-4SP1_J2EE Install Guide_Tomcat.pdf instruction as it is but finding following error message and not able to load rules.

1. The prdbutil is deployed and able to verify connection. However, its showing following warning message while loading the server

2008-06-13 23:29:01,531 [ main] [ ] [ ] (ine.database.ConnectionManager) WARN - The database pegarules is only defined in the bootstrap configuration; create a Data-Admin-DB-Name definition

2. I continued loading prweb.war file and then I getting following error message.

2008-06-13 23:29:01,531 [ main] [ ] [ ] ( etier.engine.EngineStartup) ERROR - PegaRULES cannot initialize due to a bad or missing database configuration.
2008-06-13 23:29:01,531 [ main] [ ] [ ] ( etier.engine.EngineStartup) ERROR - Reason:com.pega.pegarules.pub.database.ConfigurationException: Database-General Base table is empty
From: (unknown)
at com.pega.pegarules.engine.database.ConnectionManager.<init>(ConnectionManager.java:504)
at com.pega.pegarules.engine.database.ConnectionManager.getInstance(ConnectionManager.java:615)
at com.pega.pegarules.etier.engine.EngineStartup.initEngine(EngineStartup.java:395)
at com.pega.pegarules.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:134)
.
.
.
.
13 23:29:01,531 [ main] [ ] [ ] ( etier.engine.EngineStartup) WARN - PegaRULES has NOT initialized.
13 23:29:01,906 [ main] [ ] [ ] (ervlet.WebAppLifeCycleListener) ERROR - Enterprise tier failed to initialize pr
PegaRULES not available
13 23:29:01,921 [ main] [ ] [ ] (ervlet.WebAppLifeCycleListener) INFO - Web Tier initialization is complete.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

December 2, 2009 - 1:28pm

Guys thanks alot for ur valuable suggestions. i am getting the below error message while i was loging as new user it was showing
No such Rule -Application instance exist Pegarules_Direct Capture.

when i tried to change PegaRules Direct Capture version to 05.04.01..it was throwing below error.

ELEMENT ERROR MESSAGE
>>General Error>> The page contains an undefined property: .pySortDateCircumWithinRSMajor

Validation failed: Errors Detected.

November 19, 2009 - 10:29am

Did you deploy the prweb before loading the application jar through prdbutil?

November 19, 2009 - 11:01am

what happens when you access the prdbutil servlet? what message do you get?

November 19, 2009 - 11:28pm

Hi frnds.Thanks for response.
First i deployed prdbutil.war file from deploy section.At that time in the console i am not getting any error message.
But when im deploying the prweb.war file i am getting the below error

2008-06-13 23:29:01,531 [ main] [ ] [ ] (ine.database.ConnectionManager) WARN - The database pegarules is only defined in the bootstrap configuration; create a Data-Admin-DB-Name definition
2008-06-13 23:29:01,531 [ main] [ ] [ ] ( etier.engine.EngineStartup) ERROR - PegaRULES cannot initialize due to a bad or missing database configuration.
2008-06-13 23:29:01,531 [ main] [ ] [ ] ( etier.engine.EngineStartup) ERROR - Reason:com.pega.pegarules.pub.database.ConfigurationException: Database-General Base table is empty
From: (unknown)
at com.pega.pegarules.engine.database.ConnectionManager.<init>(ConnectionManager.java:504)
at com.pega.pegarules.engine.database.ConnectionManager.getInstance(ConnectionManager.java:615)
at com.pega.pegarules.etier.engine.EngineStartup.initEngine(EngineStartup.java:395)
at com.pega.pegarules.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:134)
.
.
.
.
[blue]WARN - PegaRULES has NOT initialized.
13 23:29:01,906 [ main] [ ] [ ] (ervlet.WebAppLifeCycleListener)
ERROR - Enterprise tier failed to initialize properly PegaRULES not available
13 23:29:01,921 [ main] [ ] [ ] (ervlet.WebAppLifeCycleListener)
INFO - Web Tier initialization is complete.

November 20, 2009 - 12:47am

You cannot deploy PRPC just like any other web application. You should not deploy prweb.war before completing ten steps in prdbutil deployment. Once you successfully complete all ten steps, the prconfig.xml of prweb.war should be the same of prdbutil.war and reboot server.

-Ganesh

November 20, 2009 - 2:35am

Guys, Thanks alot for valuable responses.

when i deployed PRPCV5.Jar file i was getting the following error. please help me out guys.

Operation Status: Bootstrapping Base Instances
Database-General Problem saving instance RULE-OBJ-CLASS @BASECLASS in bootstrap mode 1460 72000 ORA-01460: unimplemented or unreasonable conversion requested.

Below is the screen info i 'm getting.

FileName: PRPCv5_v54_sp1_0005.jar
--------------------------------------------------------------------------------
***** Begin Application Definition *****
Name: PegaRULES ProcessCommander V5
Description: PRPC RuleBase
Application Steps:
1: Pega-RULES.jar
Type: PARFILE
Bootstrap Only: true
Install Only: false
RuleSetSpec: Pega-RULES:05
2: Pega-WB.jar
Type: PARFILE
Bootstrap Only: false
Install Only: false
RuleSetSpec: Pega-WB:05
3: Pega-IntSvcs.jar
Type: PARFILE
Bootstrap Only: false
Install Only: false
RuleSetSpec: Pega-IntSvcs:05
4: Pega-ProCom.jar
Type: PARFILE
Bootstrap Only: false
Install Only: false
RuleSetSpec: Pega-ProCom:05
5: Pega-AppDefinition.jar
Type: PARFILE
Bootstrap Only: false
Install Only: false
RuleSetSpec: Pega-AppDefinition:05
6: CheckInCandidates.jar
Type: PARFILE
Bootstrap Only: false
Install Only: false
RuleSetSpec: CheckInCandidates:01-01
7: PegaForecaster.jar
Type: PARFILE
Bootstrap Only: false
Install Only: false
RuleSetSpec: PegaForecaster:05
8: PegaWAI.jar
Type: PARFILE
Bootstrap Only: false
Install Only: false
RuleSetSpec: PegaWAI:05
9: IndexReference.jar
Type: PARFILE
Bootstrap Only: false
Install Only: true
10: SystemDeclareChanges.jar
Type: PARFILE
Bootstrap Only: false
Install Only: true
****** End Application Definition ******
Installing Application on new database
Importing Pega-RULES.jar (Bootstrap Mode)
Operation Status: Bootstrapping Base Instances
Database-General Problem saving instance RULE-OBJ-CLASS @BASECLASS in bootstrap mode 1460 72000 ORA-01460: unimplemented or unreasonable conversion requested

November 20, 2009 - 6:36am

my answer to your first post .

"2008-06-13 23:29:01,531 [ main] [ ] [ ] ( etier.engine.EngineStartup) ERROR - Reason:com.pega.pegarules.pub.database.ConfigurationException: Database-General Base table is empty"

its means its not able to identify the base rule table pr4_base to load the rules .so the mistakes you may done is you haven't run the DB script before importing or else you have run the table script in a wrong schema and import rules in different schema.

by

karthick

November 20, 2009 - 9:23am

ORA-01460

this appears to be an Oracle Bug, and is referenced on the Oracle OTN. What version of the drivers and server are you running? You may want to try updating them and seeing if the problem goes away. Once this issue is resolved you should be able to load.