Question

3
Replies
245
Views
CHRISHUG Member since 2013 9 posts
Sopra Steria AG
Posted: 2 years ago
Last activity: 2 years 10 months ago
Closed
Solved

Error while deployment of prweb.war

Hello Community

I'm on an insallation of Pega 7.3.1 with Tomcat and Postgresql with split schema.

While the deployment of the prweb.war, I'm getting the following error:

SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database.  Will only use properties from file.
 org.postgresql.util.PSQLException: ERROR: permission denied for schema prpc_data
  Position: 34
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)

I granted the user on the DB-Schema.

The context.xml (<Tomcat>/conf/context.xml) is the follow:

<Context>

    <Resource name="jdbc/PegaRULES"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://localhost:5432/prpc"
        username="prpc_base"
        password="xxxxxxx"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />

    <Resource name="jdbc/AdminPegaRULES"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://localhost:5432/prpc"
        username="prpc_adm"
        password="xxxxx"
        maxTotal="10"
        maxIdle="5"
        maxWaitMillis="5000"
    />

    <Environment
        name="prconfig/database/databases/PegaRULES/dataSourceAdmin"
        value="java:comp/env/jdbc/AdminPegaRULES"
        type="java.lang.String"
    />

    <Environment
        name="prconfig/database/databases/PegaDATA/dataSourceAdmin"
        value="java:comp/env/jdbc/AdminPegaRULES"
        type="java.lang.String"
    />

    <Environment
        name="prconfig/database/databases/PegaRULES/defaultSchema"
        value="prpc_rules"
        type="java.lang.String"
    />

    <Environment
        name="prconfig/database/databases/PegaDATA/defaultSchema"
        value="prpc_data"
        type="java.lang.String"
    />



    <!-- Default set of monitored resources. If one of these changes, the    -->
    <!-- web application will be reloaded.                                   -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>

    <!-- Uncomment this to disable session persistence across Tomcat restarts -->

    <Manager pathname="" />

    <Environment name="url/initialization/explicittempdir"
        value="/opt/pega/tomcat/temp"
        type="java.lang.String"
    />

</Context>


Any ideas or hints what is not working correct or config issue?

Thanks for support,
Chris

Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn