Version: 16.0.0-dev-11
Build #: 40709
Build Date: 2014-Oct-22 03:14:37 PM
Teradata 15 : Function Properties gives java.lang.exception
Once a UDF is created in Teradata 15, then Script-> Create, Drop, Alter, Properties generates an Exception Column index value 0 is outside the valid range of 1 through 10
To reproduce:
1. Navigate to Teradata 15.1 at 10.168.2.139
2. Use Server properties login name: sahil/*****
3. Expand the database named retail and expand the User Defined Functions node
4. You can see 2 functions that are created
5. Select a function, right click and take the Function properties :: You get java.lang.Exception: Function not found
6. Script Object to Window -> Create, Drop, Alter gives java.lang.Exception: Function not found
Exception:
A)
java.lang.Exception: Function 'APLUSB' is not found.
at \\...\\ .\\हिñçêČάй語简�?한\\.eꌊ̥̮ꑛ$1.dX(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Oꂣꏇ⠃ꊄ.process(Unknown Source)
at com.common.ui.util.BackgroundThread.run(Unknown Source)
B)
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1244] [SQLState HY000] Column index value 0 is outside the valid range of 1 through 10
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:74)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:102)
at com.teradata.jdbc.jdbc_4.ResultSetRow.getValue(ResultSetRow.java:54)
at com.teradata.jdbc.jdbc_4.TDResultSet.getObjectFromCurrentRow(TDResultSet.java:195)
at com.teradata.jdbc.jdbc_4.TDResultSet.internalGetObject(TDResultSet.java:2046)
at com.teradata.jdbc.jdbc_4.TDResultSet.getObject(TDResultSet.java:2031)
at com.teradata.jdbc.jdbc_4.TDResultSet.getString(TDResultSet.java:1764)
at \\...\\ .\\हिñçêČάй語简�?한\\.Rꌳꏨꁶ⠏ extends.d(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Rꌳꏨꁶ⠏ extends.n(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.eꌊ̥̮ꑛ$1.dX(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Oꂣꏇ⠃ꊄ.process(Unknown Source)
at com.common.ui.util.BackgroundThread.run(Unknown Source)
resolved by issue 12598