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
ADS build 8.0.0 Beta 2.2
Teradata Server
10.168.11.40
Ivan User
selecr Tools - ER Diagram Generator
select tables and select only the tables CHILD_1_0, CHILD_1,CHILD_2,CHILD_3 and PARENT_1,PARENT_2,PARENT_3
These tables are created with relationship each - but when the diagram is generated, there are no relationships
|
|
41 KB
|
6 KB
Trying to extract the constraint gives the error message ...
Failed to expand: [Teradata Database] [TeraJDBC 13.00.00.06] [Error 2646] [SQLState HY000] No more spool space in utest1.
EDiagram.java,
line# 341 tableID(x) sets name to schema +"." + tablename ; there is no schema for this table in the xtraction object here
line# 342 tableID(x) sets name to schema + "." + tablename ; the foreign key constraint has a schema in the extraction object set to the database... ExtractConstraint.java Line 3559: you notice db is sent as the tables schema, I do not think this is correct since ExtractTable.java line# 38 sets the table schema to schema which is null for teradata, but not sure if we are setting it right here.
line# 344 Using the table name without schema the <hash> function finds the table and its column
line# 345 Using the table name with db as the schema set in the fkconstraint table object does not allow the <hash> function to find the table and its column since the table object has no schema set.
would need to look into why we are setting database as schema for fk constraints in ExtractConstraint.java line 3559 and if its actually used ...
EDiagram.java,
line# 341 tableID(x) sets name to schema +"." + tablename ; there is no schema for this table in the xtraction object here
line# 342 tableID(x) sets name to schema + "." + tablename ; the foreign key constraint has a schema in the extraction object set to the database... ExtractConstraint.java Line 3559: you notice db is sent as the tables schema, I do not think this is correct since ExtractTable.java line# 38 sets the table schema to schema which is null for teradata, but not sure if we are setting it right here.
line# 344 Using the table name without schema the <hash> function finds the table and its column
line# 345 Using the table name with db as the schema set in the fkconstraint table object does not allow the <hash> function to find the table and its column since the table object has no schema set.
would need to look into why we are setting database as schema for fk constraints in ExtractConstraint.java line 3559 and if its actually used ...
I changed line #3559 in ExtractConstraint.java
from
constraint._refTable = new AFTable(currentDatabaseName, parentDB, parentTable);
to
String schemaName = "";
constraint._refTable = new AFTable(parentDB, schemaName, parentTable);
I also made changes in TDConstraintsModel.java which is to show detail view for constraint nodes. TDConstraintsModel.java was referencing Table._schema before my change, now it is showing Table._database. Hope TDConstraintsModel.java is the only place that uses Table._schema.
Changes were saved as revision 10131 of ADS trunk.
I changed line #3559 in ExtractConstraint.java
from
constraint._refTable = new AFTable(currentDatabaseName, parentDB, parentTable);
to
String schemaName = "";
constraint._refTable = new AFTable(parentDB, schemaName, parentTable);
I also made changes in TDConstraintsModel.java which is to show detail view for constraint nodes. TDConstraintsModel.java was referencing Table._schema before my change, now it is showing Table._database. Hope TDConstraintsModel.java is the only place that uses Table._schema.
Changes were saved as revision 10131 of ADS trunk.
Issue #3106 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Trying to extract the constraint gives the error message ...
Failed to expand: [Teradata Database] [TeraJDBC 13.00.00.06] [Error 2646] [SQLState HY000] No more spool space in utest1.