Question

3
Replies
259
Views
Close popover
Christoph Hug (CHRISHUG)
Sopra Steria AG

Sopra Steria AG
CH
CHRISHUG Member since 2013 9 posts
Sopra Steria AG
Posted: December 13, 2017
Last activity: December 13, 2017
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

System Administration Installation and Deployment Data Integration
Moderation Team has archived post