Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Product: Aqua Data Studio
Version: 12.0.0-beta-52
Build #: 29354
Build Date: 2012-Sep-20 02:04:42 PM
Oracle 11g OE schema
Multi Select the 2 tables PRODUCT_REF_LIST_NESTEDTAB and SUBCATEGORY_REF_LIST_NESTEDTAB and Script to New Window
Under View Log --> Console tab, you will find the NPE
I tried to script the same table in different versions of Oracle like 11g and get the same results. From the website, I got the schema for the table
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10771/scripts004.htm
PRODUCT_REF_LIST_NESTEDTAB Name Null? Type ----------------------------------------- -------- ---------------------------- COLUMN_VALUE NUMBER(6)
Table SUBCATEGORY_REF_LIST_NESTEDTAB Name Null? Type ----------------------------------------- -------- ---------------------------- COLUMN_VALUE REF OF CATEGORY_TYP
Notes
The NPE exist in earlier versions of ADS. Dont know why the colums are not getting displayed for the 2 tables
java.lang.NullPointerException
at \\...\\ .\\हिñçêČάй語简�?í•œ\\.eâ¢’ê…¾á¢¢êŒ interface.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.h̪ꋄ⠈ꊀ catch transient.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.h̪ꋄ⠈ꊀ catch transient.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?í•œ\\.Sͫᛪꇑê‚.c(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.sꌒꌨ̖ꅲ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?í•œ\\.Sͫᛪꇑê‚.yc(Unknown Source)
at com.common.ui.util.VêŒ ÍœÌ•êˆ½ interface.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
java.lang.NullPointerException
at \\...\\ .\\हिñçêČάй語简�?í•œ\\.eâ¢’ê…¾á¢¢êŒ interface.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.h̪ꋄ⠈ꊀ catch transient.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.h̪ꋄ⠈ꊀ catch transient.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?í•œ\\.Sͫᛪꇑê‚.c(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.sꌒꌨ̖ꅲ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?í•œ\\.Sͫᛪꇑê‚.yc(Unknown Source)
at com.common.ui.util.VêŒ ÍœÌ•êˆ½ interface.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
|
|
74 KB
These tables are in the OE databases but they have no column information in the SYS.ALL_TAB_COLUMNS catalog table. This is the main table we use to extract table information. If this table has no columns we have no table object and when we try to extract index information on a null object we get the exception. I will add code to throw our own exceptions if no table is found during extraction. There is nothing much we can do about the data if its not in the catalog tables. You will also notice you can not select from these tables as they are system usage only.
added error logging but can not script the tables as there catalog data does not exist.
added error logging but can not script the tables as there catalog data does not exist.
Issue #7627 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| Fixed Build 12.0.0-beta-54 |
| No time estimate |
These tables are in the OE databases but they have no column information in the SYS.ALL_TAB_COLUMNS catalog table. This is the main table we use to extract table information. If this table has no columns we have no table object and when we try to extract index information on a null object we get the exception. I will add code to throw our own exceptions if no table is found during extraction. There is nothing much we can do about the data if its not in the catalog tables. You will also notice you can not select from these tables as they are system usage only.