Assistance Needed: Resolving PostgreSQL TimeZone Error in SailPoint IIQ Integration

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Hi All,

We are in the process of integrating our PostgreSQL JDBC application into SailPoint IdentityIQ (IIQ). While we are able to successfully connect from the SailPoint server to Host.amazonaws.com using the command line telnet(the database is hosted on the cloud), we are encountering an error when performing a test connection through the SailPoint IIQ interface.

The error message is as follows:

[ConnectorException] [Error details] The server encountered an unexpected error while contacting the target system during the test configuration operation. Please check the logs. FATAL: invalid value for parameter "TimeZone": "CST"

To address this issue, we attempted to update the database URL by appending ?options=-c%20TimeZone=UTC (e.g., jdbc:postgresql://HostName.amazonaws.com:port/DBName?options=-c%20TimeZone=UTC), but the error persists.

For reference, the Telnet connection test from the command line was successful:

asadmin@c366xnmiiq:~> telnet a206583-jewf-qa-pg-cluster-us-east-1-inst.cknrhwxiarxd.us-east-1.rds.amazonaws.com 5432
Trying 10.210.48.113...
Connected to a206583-jewf-qa-pg-cluster-us-east-1-inst.cknrhwxiarxd.us-east-1.rds.amazonaws.com.

Could anyone provide guidance on resolving this issue? Your assistance would be greatly appreciated.

2

hI @Venu1010 ,

I tried to debug the issue found that.
PostgreSQL does NOT recognize CST as a valid timezone.

3

Hi @Venu1010
The SailPoint IIQ application server is sending its local system timezone CST to PostgreSQL during the JDBC handshake. PostgreSQL on RDS is strict about timezone values and rejects ambiguous abbreviations like CST.

Your version:

?options=-c%20TimeZone=UTC

The = sign also needs to be encoded. Try:

jdbc:postgresql://HostName.amazonaws.com:port/DBName?options=-c%20TimeZone%3DUTC

The only difference is = is encoded as %3D. This may be the reson reason why the options parameter silently fails.
Please try this and let us know.

4

still the same error : [ ConnectorException ] [ Error details ] The server encountered an unexpected error while contacting target system during test configuration operation. Please check the logs. FATAL: invalid value for parameter "TimeZone": "CST"

5

@Venu1010 Seems your IIQ server is in a different timezone. Could you please which timezone it is being currently set to? Pinging you over chat for quick connect.