Question
Accenture Services Pvt Ltd
IN
Last activity: 5 Jul 2017 2:58 EDT
Issue in PRPC7.2.2 installation on DB2 11.1 and Tomcat8
Hi,
I have installed PRPC7.2.2 on DB2 11.1 and Tomcat 8. But while starting the tomcat application server I ma getting below error. Also application is not starting up. Cloud you please suggest.
04-Jul-2017 11:50:39.526 1050 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: PRPCDATA
04-Jul-2017 11:50:42.611 SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database. Will only use properties from file.
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=PRPCDATA.PR_DATA_ADMIN, DRIVER=4.11.77
Accepted Solution
Accenture Services Pvt Ltd
IN
Hi Arun,
I am able to solve the issue. By mistake while installing the rulebase I used rules schema name in place of data schema and data schema name in place of rules schema. And in context.xml I was using just the opposite one.
Thanks.
Pegasystems Inc.
IN
Hello Animesh,
Your server is not able to communicate with database which results in above exception .
check your database properties in context.xml and do a test connection to database if it's success .
Can you please provide your context.xml by removing password fields .
Thanks,
Arun
Accenture Services Pvt Ltd
IN
Hi Arun,
Please find the attached context.xml file. Kindly suggest as soon as possible.
Also could you please let me know how I can do a test connect? I am able to login to the DB using the PRPCDATA user using data studio.
Accepted Solution
Accenture Services Pvt Ltd
IN
Hi Arun,
I am able to solve the issue. By mistake while installing the rulebase I used rules schema name in place of data schema and data schema name in place of rules schema. And in context.xml I was using just the opposite one.
Thanks.