How to configure access for a connectSQL in producton
Hi All,
I have a connectSQL to update a database table and it's called by an activity. It works fine in development environment but when I deploy it production environment, it's not working and get error complains table does not exist. However when I check instances in Data-Admin-DB-Table, it's there as well as when I try to locate it via Schema tools.
Other things I noticed are:
1. Query inspector when evaluate query, the following error showed:
2. Query runner when run "select count(*) from theTable", I saw the following error:
There was a problem performing a database query: Database-General Problem encountered when getting connection for database pegadata 0 Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "ALCYON_RO")
DatabaseException caused by prior exception: java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "ALCYON_RO")
| SQL Code: 0 | SQL State: null
Hi All,
I have a connectSQL to update a database table and it's called by an activity. It works fine in development environment but when I deploy it production environment, it's not working and get error complains table does not exist. However when I check instances in Data-Admin-DB-Table, it's there as well as when I try to locate it via Schema tools.
Other things I noticed are:
1. Query inspector when evaluate query, the following error showed:
2. Query runner when run "select count(*) from theTable", I saw the following error:
There was a problem performing a database query: Database-General Problem encountered when getting connection for database pegadata 0 Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "ALCYON_RO")
DatabaseException caused by prior exception: java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "ALCYON_RO")
| SQL Code: 0 | SQL State: null
Can anyone explain the reason and how to configure to make the activity to call the connectSQL?
***Edited by Moderator Marissa to update categories***
Thanks and regards
Accepted Solution
Accenture
AU
Thanks, I should check your reply earlier. Anyway, the issue was solved by giving the ALCYON_RO user access.
Pegasystems Inc.
IN
Hi,
Could you please let us know which application server and database you are using? Also, please attach the complete stack trace. Normally, this error comes up due to network/configuration issues at application level.
Thank you,
Shreshta
Accenture
AU
Hi Shreshta,
Thanks for the reply.
The application is built on PRPC7.3.1 and database is postgreSQL. I have attached the trace logs. Please direct me the right place to fix it, thank you.
Regards,
Haiming
Pegasystems Inc.
US
The error shows "Problem encountered when getting connection for database pegadata". The OOTB database should be PegaDATA instead of pegadata. You may try to click 'test connection' on the database definition page.
Swedbank AB
SE
Verify the data source connectivity at application server level if that works fine then check current user has premission to access that table.
Accenture
AU
Connection is fine, the system is able to connect to database. It's just not able to query from Design Studio->System->Database-Query Runner.
Can you please point to the right place that I can check whether the user has permission to access table?
Thanks.