JDBC Test Connection issue

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

Hi,

we have developed JDBC Application in Dev environment and added postgresql jar file in web-inf/lib location. there(DEV) it is working fine and when we deploy into the QA environment then we are getting the below mentioned error.we are using same credentials , which we have used in DEV environment.

With the same credentials we have connected to Database also , the test connection is also working good.

Error:

ConnectorException ] [ Error details ] The server encountered an unexpected error while contacting target system. Please check the logs. Failure trying to get a pooled connection to [jdbc:postgresql://server001:1880/aeon] org.postgresql.util.PSQLException: FATAL: password authentication failed for user “user_001”

please provide your inputs on this.

Thanks,
Akash

Hi Akash,

Thank you for your message. Is the test connection working on QA or do you get the error when you try to aggregate? Are you using the same application object as in DEV? I would try to enter again the password using the UI and save just to discard any problem related to the encrypted password.

Best regards,

Miguel

Hi @miguelgomez3 ,
Thankyou for reply,

  1. when we are checking the test connection in QA , then we are getting the above mentioned error.

  2. I am using the same Application Object as in DEV and deployed using SSB.

  3. I have tried by entering password using UI and saved the Application, but the same error message is coming.

Thanks,
Akash

1 Like

Hi @AkashRaavi131 ,

Have you applied the encrypted password ?

1 Like

Hi @kavindar_sharma ,

Thanks for the reply.
Through UI changed password checked and tried by applying the encrypted password also. Both the ways i have tried , but getting the same above mentioned error.

If we import the application.xml file manually from DEV to QA , then it is working fine.
when we deployed on QA again we are getting above mentioned error.

Thanks,
Akash

How are you deploying the file into QA - manual import or build?

Compare both the working XML from development (dev) and the non-working XML from QA of the application. You will find what’s causing the issue. Beyond Compare is a free software that I keep handy for comparing files.

1 Like

HI Everyone,

Thanks for the Reply ,
Issue is resolved by changing the password, now the test connection got success in both DEV and QA Environment.

Thanks,
Akash

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.