Exception name |
Cause |
Solution |
org.postgresql.util.PSQLException |
Connection has been denied. Check whether the host name and the port number are correct and the post master accepts TCP/IP connection or not. |
Unable to connect to the database. |
Check [Port number] of the global resource. |
FATAL: database "<database name>" does not exist |
The database is not found. |
Specify an existing database in [Database name] of global resource. |
FATAL: password authentication failed for user "<user name>" |
The user name or the password is incorrect. |
Check [User name] and [Password] of the global resource. |
ERROR: syntax error at or near "<table name>" |
The table name is invalid. |
Check the table name specified in [Table name]. |
ERROR: relation "<table name>" does not exist |
The table does not exist. |
Specify an existing table in [Table name]. |
ERROR: permission denied for relation <table name> |
The user has no permission to read the table. |
Check the read permission for the table specified in [Table name]. |
Connection test failed. |
Cannot connect to the database server. |
Check [Host name] of the global resource. |
SSL error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
|
The certificate is not imported to the keystore referred by DataSpiderServer. |
Import a certificate to the keystore referred by DataSpiderServer.
For more details on how to import a certificate, refer to “Import Certificate”. |