[JBoss JIRA] (TEIIDDES-1010) Indexes are not qualified when imported with Teiid Designer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1010?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1010:
-----------------------------------
Attachment: org.teiid.designer.jdbc.relational.patch
> Indexes are not qualified when imported with Teiid Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-1010
> URL: https://issues.jboss.org/browse/TEIIDDES-1010
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 7.4
> Reporter: Marc Shirley
> Assignee: Barry LaFond
> Fix For: 8.1
>
> Attachments: org.teiid.designer.jdbc.relational.patch
>
>
> Having multiple indexes with the same name (for example, 'PrimaryKey') imported results in a conflict or merging of the indexes. This generates messages complaining of an index referring to multiple tables in the Teiid Designer perspective. The indexes should be qualified in order to remain unique or generated as a child of the associated table in order to avoid these messages.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIIDDES-1587) Cannot import relational tables described in the wizard
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1587?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-1587.
------------------------------------
Fix Version/s: 8.1
Resolution: Out of Date
The fix for TEIIDDES-1586 removed support for importing SCHEMA and CATALOG objects and also removed the "path" value for table entries.
The sample CSV file in the importer now displays:
TABLE, Table_1, "Table_1 Description"
COLUMN, Column_1, VARCHAR, 255, "Column_1 Description"
COLUMN, Column_2, VARCHAR, 255, "Column_2 Description"
COLUMN, Column_3, NUMBER, 25, "Column_3 Description"
COLUMN, Column_4, DATE, 20, "Column_4 Description"
INDEX, TestIndex1, NORMAL, UNIQUE, Table_1, Column_2
TABLE, Table_2, "Table_2 Description"
COLUMN, Column_5, VARCHAR, 255, "Column_5 Description"
COLUMN, Column_6, VARCHAR, 255, "Column_6 Description"
INDEX, TestIndex2, NORMAL, UNIQUE, Table_2, Column_5
If you re-run your test using this info if should work.
Marking this as Out Of Date
> Cannot import relational tables described in the wizard
> -------------------------------------------------------
>
> Key: TEIIDDES-1587
> URL: https://issues.jboss.org/browse/TEIIDDES-1587
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.0
> Reporter: Andrej Podhradsky
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 8.1
>
> Attachments: sampleRelationalTables.csv
>
>
> In the wizard for importing relational tables is a simple example which is not working. After importing you can see only Table_2 in the model. When you close and reopen the model the following error occurs
> Input Error: Model Editor is unable to obtain a Model Resource
> So the question is: Is wrong the example or the model creation?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIIDDES-1587) Cannot import relational tables described in the wizard
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1587?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-1587:
--------------------------------------
Assignee: Barry LaFond
> Cannot import relational tables described in the wizard
> -------------------------------------------------------
>
> Key: TEIIDDES-1587
> URL: https://issues.jboss.org/browse/TEIIDDES-1587
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.0
> Reporter: Andrej Podhradsky
> Assignee: Barry LaFond
> Priority: Critical
> Attachments: sampleRelationalTables.csv
>
>
> In the wizard for importing relational tables is a simple example which is not working. After importing you can see only Table_2 in the model. When you close and reopen the model the following error occurs
> Input Error: Model Editor is unable to obtain a Model Resource
> So the question is: Is wrong the example or the model creation?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIIDDES-417) Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled
by Andrej Podhradsky (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-417?page=com.atlassian.jira.plug... ]
Andrej Podhradsky commented on TEIIDDES-417:
--------------------------------------------
And as Paul mentioned, this cannot be automated using swt bot
> Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled
> ---------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-417
> URL: https://issues.jboss.org/browse/TEIIDDES-417
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 6.3, 8.0
> Environment: Iced Tea, Teiid Designer 6.3
> Reporter: Paul Nittel
> Fix For: Future
>
> Attachments: IMFTF.jpg
>
>
> I was writing a SWTBot test to create a view model's tables when I ran into this.
> Knowing SWTBot can't handle the File Chooser, I was delighted to see I could enter the text file's path and name directly into the importer dialog. It wasn't until some time later that I realized merely typing in the name does nothing; you MUST enter the name using the File Chooser. (Once that's been done, it appears you can use the drop-down to re-select that file, but you need that first time entry.)
> What's really bad/confusing is manually entering the file and target location enables the Finish button. Clicking it appears to work, but no tables were added to the model.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIIDDES-417) Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled
by Andrej Podhradsky (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-417?page=com.atlassian.jira.plug... ]
Andrej Podhradsky commented on TEIIDDES-417:
--------------------------------------------
I agree with Paul, this is really confusing. User is able to finish the wizard but the result is an empty model.
Still present in TD 8.0.
> Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled
> ---------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-417
> URL: https://issues.jboss.org/browse/TEIIDDES-417
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 6.3, 8.0
> Environment: Iced Tea, Teiid Designer 6.3
> Reporter: Paul Nittel
> Fix For: Future
>
> Attachments: IMFTF.jpg
>
>
> I was writing a SWTBot test to create a view model's tables when I ran into this.
> Knowing SWTBot can't handle the File Chooser, I was delighted to see I could enter the text file's path and name directly into the importer dialog. It wasn't until some time later that I realized merely typing in the name does nothing; you MUST enter the name using the File Chooser. (Once that's been done, it appears you can use the drop-down to re-select that file, but you need that first time entry.)
> What's really bad/confusing is manually entering the file and target location enables the Finish button. Clicking it appears to work, but no tables were added to the model.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIIDDES-417) Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled
by Andrej Podhradsky (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-417?page=com.atlassian.jira.plug... ]
Andrej Podhradsky updated TEIIDDES-417:
---------------------------------------
Affects Version/s: 8.0
> Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled
> ---------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-417
> URL: https://issues.jboss.org/browse/TEIIDDES-417
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 6.3, 8.0
> Environment: Iced Tea, Teiid Designer 6.3
> Reporter: Paul Nittel
> Fix For: Future
>
> Attachments: IMFTF.jpg
>
>
> I was writing a SWTBot test to create a view model's tables when I ran into this.
> Knowing SWTBot can't handle the File Chooser, I was delighted to see I could enter the text file's path and name directly into the importer dialog. It wasn't until some time later that I realized merely typing in the name does nothing; you MUST enter the name using the File Chooser. (Once that's been done, it appears you can use the drop-down to re-select that file, but you need that first time entry.)
> What's really bad/confusing is manually entering the file and target location enables the Finish button. Clicking it appears to work, but no tables were added to the model.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIIDDES-1587) Cannot import relational tables described in the wizard
by Andrej Podhradsky (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1587?page=com.atlassian.jira.plu... ]
Andrej Podhradsky updated TEIIDDES-1587:
----------------------------------------
Affects Version/s: 8.0
> Cannot import relational tables described in the wizard
> -------------------------------------------------------
>
> Key: TEIIDDES-1587
> URL: https://issues.jboss.org/browse/TEIIDDES-1587
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.0
> Reporter: Andrej Podhradsky
> Priority: Critical
> Attachments: sampleRelationalTables.csv
>
>
> In the wizard for importing relational tables is a simple example which is not working. After importing you can see only Table_2 in the model. When you close and reopen the model the following error occurs
> Input Error: Model Editor is unable to obtain a Model Resource
> So the question is: Is wrong the example or the model creation?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months