Question
Marsh
GB
Last activity: 6 Apr 2018 19:26 EDT
Cannot find datasources after deploying the WAR
Hello all,
We have an issue in starting the pega 7 application post deploying the WAR. The errors says
"com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
SEVERE: Unable to connect to database. Will only use properties from file.java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist"
We have 2 schemas(Rules and Data), we are using data schema as data source and given all the access to its own schema and Rules schema. however, when we start the pega7 application we are getting the error as mentioned above.
Hello all,
We have an issue in starting the pega 7 application post deploying the WAR. The errors says
"com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
SEVERE: Unable to connect to database. Will only use properties from file.java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist"
We have 2 schemas(Rules and Data), we are using data schema as data source and given all the access to its own schema and Rules schema. however, when we start the pega7 application we are getting the error as mentioned above.
Could you please advise what all are missed as part of configuration setting.
**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.
Pegasystems Inc.
IN
Which app server you are deplpoying your war files. If you are using tomcat could you pls share your context.xml file on how you have configured the datasource.
Marsh
GB
Thanks Dhevendra,We are using WAS 8.5.5....This issue has been resolved aftre givnig all the access to the schema user.
Now we are facing some new issue when trying to start the application. Appreciate anyone advise on this, Thanks.
Logs as below:
Caused by:
com.pega.pegarules.pub.PRRuntimeError: PRRuntimeError
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3515)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
... 63 more
Caused by:
com.pega.pegarules.pub.generator.FirstUseAssemblerException: Unexpected exception during assembly
- Error occurred during assembly of: page "<unnamed>" of class "Rule-Obj-Activity", 0/76 props expanded
expanded properties:
java.lang.NullPointerException
at com.pega.pegarules.exec.internal.basic.DependentRuleSetListPoolImpl.getDependentRulesetList(DependentRuleSetListPoolImpl.java:333)
at com.pega.pegarules.exec.internal.basic.DependentRuleSetListPoolImpl.get(DependentRuleSetListPoolImpl.java:161)
at com.pega.pegarules.data.internal.access.RuleResolver.getDependentRuleSetList(RuleResolver.java:3636)
at com.pega.pegarules.data.internal.access.RulesetContextImpl.<init>(RulesetContextImpl.java:397)......
...........
Pegasystems Inc.
IN
looks like some porblem with First Use Assembly. Could you please truncate the following cache tables and restart the server.
truncate table pr_assembledclasses;
truncate table pr4_rule_sysgen;
truncate table pr_sys_appcache_entry;
truncate table pr_sys_appcache_dep;
truncate table pr_sys_appcache_shortcut;
truncate table pr_sys_rule_impl;
If you still have an issue please upload the full log file.
