Question

9
Replies
103
Views
haimingz Member since 2016 3 posts
Redflex
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed
Solved

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:

Database-GeneralProblem encountered when getting connection for database pegadata0Cannot 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

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

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