Support Article
Pega installation fails
SA-64776
Summary
Pega application is installed on Microsoft SQL Server, however, the engine does not launch after deploying prweb.war on JBoss.
Error Messages
[com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource] (ServerService Thread Pool -- 18) Bootstrap datatables schema: pegadata.dbo
SEVERE [com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource] (ServerService Thread Pool -- 18) Unable to connect to database. Will only use properties from file.: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'pegadata.dbo.pr_data_admin'.
Steps to Reproduce
- Run install.sh without specifying any information for Rule and Data schemas.
- Deploy Pega application on JBoss with data source configuration.
Root Cause
A software use or operation error.
According to the Pega install logs, rules.schema.name and data.schema.name were blank.
This was because,
[echo] No schema provided, defaulting to user default of dbo
[echo]
[echo] Rules schema has been set to 'dbo'
Resolution
Make the following change to the operating environment:
Pega is installed in the default DBO schema.
Change the below script in JBoss standalone.xml,
<simple name="java:/prconfig/database/databases/PegaRULES/defaultSchema" value="pegarules.dbo"/>
<simple name="java:/prconfig/database/databases/PegaDATA/defaultSchema" value="pegadata.dbo"/>
and set them to,
<simple name="java:/prconfig/database/databases/PegaRULES/defaultSchema" value="dbo"/>
<simple name="java:/prconfig/database/databases/PegaDATA/defaultSchema" value="dbo"/>
Published September 21, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.