Details
-
Bug
-
Status: closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
All
-
Small
Description
1. d&d a redshift sso connection from repository to job
2.d&d a tRedshiftInput into the job, select use existing connection, and input schema and select correct table, click Guess Query
3.right click on tRedshiftInput, and select Data viewer (can use the attached job)
Expect result: can do data viewer successfully
Actual result: failed to do data viewer
Preview Error!
Exception in component tDBInput_1 (Preview_Data)
java.sql.SQLException: [Amazon](500310) Invalid operation: no PostgreSQL user name specified in startup packet;
at com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException(Unknown Source)
at com.amazon.redshift.client.InboundDataHandler.read(Unknown Source)
at com.amazon.support.channels.AbstractSocketChannel.readCallback(Unknown Source)
at com.amazon.support.channels.TLSSocketChannel.read(Unknown Source)
Caused by: com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: no PostgreSQL user name specified in startup packet;
... 4 more