Closed
Unable to extract data from table
Hi, all
I am required to use "pc_assign_worklist" table to create use report definition and I would like to know the all column of the table.
so I tried to use Query Runner, but it was failed. May I have any advice why the error appears?
and how do I get the all column from pc_assign_worklist ??
Posted: 4 years ago
Pegasystems Inc.
IN
Hello, The PegaRULES and PegaDATAdatasource is not configured in read-only to use the Query Runner feature. Perform the following local-change:
Show More
Hello, The PegaRULES and PegaDATAdatasource is not configured in read-only to use the Query Runner feature. Perform the following local-change:
- Add the following datasource in the context.xml file after the PegaRULESdatasource: <Resource name="jdbc/PegaRULESReadOnly" auth="Container" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" type="javax.sql.DataSource" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5433/pega_811" username="postgres" password="------" maxActive="10" maxIdle="10" /> Note : This is an additional source that is added as s read-only user from the Pega application. All configurations can be same except the JNDI name which is PegaRULESReadOnly.
- In the prconfig.xml, add the following JNDI entry for PegaRULES and PegaDATA: <env name="database/databases/PegaRULES/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly"/> <env name="database/databases/PegaDATA/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly"/>
- Restart the server and execute the query
Hope it helps,
-Rakshith.
Show Less