Messages and limitations of the Amazon Redshift connector

Message code list of AMAZONREDSHIFT category
Exception messages of AMAZONREDSHIFT category

Message code list of AMAZONREDSHIFT category

The following message codes correspond to errors that occur in Amazon Redshift Connector.

This message code is output when an undefined error occurs.

Cause	Solution
An undefined error occurred.	Check the error message or the help of the operation in which the error has occurred.

Corresponding error

None

AMAZONREDSHIFT0001E

This message code corresponds to errors that occur during connection to Amazon Redshift and during execution of the COPY command.

Cause	Solution
The cause differs according to each error message.	Check the error message and perform the following: Check whether the cause/solution of the error is described in "Exception messages" below. Check whether information on the error exists in the Amazon Redshift documents.

Cause

Solution

The cause differs according to each error message.

Check the error message and perform the following:

Check whether the cause/solution of the error is described in "Exception messages" below.
Check whether information on the error exists in the Amazon Redshift documents.

Corresponding error

java.sql.SQLException

AMAZONREDSHIFT0002E

This message code corresponds to errors that occur during execution of the COPY command to Amazon Redshift.

Cause	Solution
The cause differs according to each error message.	Check whether the cause/solution of the error is described in "Exception messages" below.

Corresponding error

AmazonRedshiftIllegalStateException

Exception messages of AMAZONREDSHIFT category

Exception name	Cause	Solution
AmazonRedshiftIllegalStateException The number of error data items that exists is [<Number of error data items>]. Check the data.	A loading error has occurred during COPY command execution.	Check the error data.
InvalidPropertyConfigurationException <Property name> is not specified.	<Property name> isn't specified.	Specify <property name>.
InvalidPropertyConfigurationException COPY command does not start from 'COPY’ [<COPY command>]	The COPY command specified in COPY command doesn't start with "COPY".	Enter the COPY command starting with "COPY".
InvalidPropertyConfigurationException <Property name> is required.	A required property isn't entered.	Specify <property name>.
java.sql.SQLException Connection is denied. Check that host name and port number are correct, and post master allows TCP/IP connection.	Can't connect to Amazon Redshift.	Check URL of the connection resource or the security group settings for Amazon Redshift.
java.sql.SQLException Failed to connect.	Failed to connect to Amazon Redshift.	Check URL of the connection resource.
java.sql.SQLException [Amazon](500310) Invalid operation: Invalid credentials. Must be of the format: credentials 'aws_iam_role=...' or 'aws_access_key_id=...;aws_secret_access_key=...[;token=...]'	The format of CREDENTIALS is incorrect.	Check CREDENTIALS specified in the COPY command.
java.sql.SQLException SSL Error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target	Failed in SSL communication.	Check whether the certificate is imported to the keystore. Contact support when you import the certificate.
java.sql.SQLException Access Denied	Access is denied.	Check the access authorization to Amazon Redshift and to the data source specified for FROM of the COPY command.
java.sql.SQLException The AWS Access Key Id you provided does not exist in our records.	The access key ID is incorrect.	Check the access key ID specified in CREDENTIALS of the COPY command.
java.sql.SQLException The request signature we calculated does not match the signature you provided.	The secret access key is incorrect.	Check the secret access key specified in CREDENTIALS of the COPY command.
java.sql.SQLException [Amazon](500310) Invalid operation: Cannot COPY into nonexistent table <Table name>	The table doesn't exist.	Check the table name specified in the COPY command.
ResourceNotFoundException Resource definition could not be found. Name: []	Destination isn't specified.	Specify Destination.
ResourceNotFoundException Resource definition could not be found. Name: [<connection resource name>]	The resource definition selected in Destination isn't found.	Check the connection resource specified in Destination.