Version: 17.0.0-ga-10
Build #: 47925
Build Date: 2015-Dec-21 05:16:10 PM
Operating Environment: Mac OS X (10.8.5, x86_64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b27
Memory: Max=5,637,144,576; Total=961,544,192; Free=638,266,128; CPUs=8
RedShift: Detail View for System Functions gives Invalid type for data exception
Connect to RedShift Database in AWS
1. Click on Detail view
2. Expand any database, navigate to public Schema and Expand
3. Click on System Functions
4. You get below Exception
Note: works fine in ADS v16 and in 17.0.0-dev-12, Build #: 43409 and Build Date: 2015-Apr-06
Started with 17.0.0-dev-13
Build #: 43444
Build Date: 2015-Apr-08 02:15:10 PM
java.sql.SQLDataException: [Amazon][JDBC](10400) Invalid type for data - column: 7, type: String.
at com.amazon.exceptions.ExceptionConverter.toSQLException(Unknown Source)
at com.amazon.jdbc.common.SForwardResultSet.getString(Unknown Source)
at com.amazon.redshift.core.jdbc4.PGJDBCS4ForwardResultSet.getString(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Iꁄꃶ⠣ꃟ5.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Iꁄꃶ⠣ꃟ5.m(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.kꉼꎰꅝ⢬continuestatic.H(Unknown Source)
at com.common.ui.tree.X⡟⢝ꂡꀾ$1.aSz(Unknown Source)
at com.aquafold.datastudio.mainframe.Uᛟᠴᛑꎇtransient$12.process(Unknown Source)
at com.common.ui.util.BackgroundThread.run(Unknown Source)
This issue was introduced with the redshift driver. The proargnames column in pg_catalog.pg_proc table now returns a PGJDBCS4ForwardResultSet type that can be null. We normally retrieve the string value of the object with the rs.getString() method. This method throws an exception attempting to get the string value from the null object. This column is extracted but never used, so we no longer extract it, solving the issue. no regression testing needed.