[JBoss JIRA] (TEIIDDES-2681) Cannot export Teiid DDL
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2681?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2681.
----------------------------------
Teiid DDL export works in TD 10.0.2.Alpha1. Closing
TD JIRA clean up
> Cannot export Teiid DDL
> -----------------------
>
> Key: TEIIDDES-2681
> URL: https://issues.jboss.org/browse/TEIIDDES-2681
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.4
> Environment: MAC OS
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 9.2
>
> Attachments: Screen Shot 2015-10-08 at 15.14.38.png
>
>
> I can not export any model to Teiid DDL.
> See steps to reproduce and attached screenshot of the last page of export wizard.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIIDDES-2428) Import -> JDBC Database -> Select Database Metadata >> Unhandled event loop exception
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2428?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2428.
----------------------------------
> Import -> JDBC Database -> Select Database Metadata >> Unhandled event loop exception
> -------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2428
> URL: https://issues.jboss.org/browse/TEIIDDES-2428
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.1
> Reporter: Leslie Mann
> Assignee: Barry LaFond
> Fix For: 9.1, 9.0.3
>
> Attachments: JdbcImportObjectsPage.java.patch
>
>
> I'm receiving an "Unhandled event loop exception - java.lang.StackOverflowError" when attempting to import a SQLServer 2008 database via JDBC when creating a source model using the Wizard. Error is occurring during the 'Select Database Metadata' step.
> If I elect to not close Eclipse I can click the 'Next' button but the Wizard then complains with the error 'Specifiy the folder in which to create the new file'.
> Interestingly enough I can proceed without issue on a separate SQL Server 2012 database. I'm using the MS 2012 JDBC driver with password authentication on the 2012 database while the 2008 database uses integrated authentication. The 2008 JDBC connection works fine when 'Testing Connection' and in the 'Database Development' view. I see that the password field is accessible while the username field is not, I would have expected both to be not available when using integrated authentication. Tried using jTDS driver but same issue, can browse catalogs in Database Development view, execute queries, etc without issue but can't get beyond the 'Select Database Metadata' step.
> Last week I was able to import the 2008 database using Designer 9.0 without issue.
> System is Win 7, eclipse.buildId=4.4.1.M20140925-0400, Teiid Designer = 9.0.1.
> Stack trace
> java.lang.StackOverflowError
> at org.eclipse.swt.internal.win32.OS.SendMessageW(Native Method)
> at org.eclipse.swt.internal.win32.OS.SendMessage(OS.java:3302)
> at org.eclipse.swt.widgets.Button.getSelection(Button.java:722)
> at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:510)
> at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:513)
> at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:513)
> with "at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:513)" repeated many many times to end of trace...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIIDDES-2254) rename View Model causes issues
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2254?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2254.
----------------------------------
> rename View Model causes issues
> -------------------------------
>
> Key: TEIIDDES-2254
> URL: https://issues.jboss.org/browse/TEIIDDES-2254
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 8.5, 8.3.3
> Reporter: Tom Johnston
> Assignee: Barry LaFond
> Fix For: 8.5.1, 8.5
>
> Attachments: rename-resource-wrong-extension.png
>
>
> I renamed a view model.
> I got an error directly after.
> I noticed the original model was but there was also a new model with all same contents that had the 'new' name of the model i gave to rename.
> Now I cannot delete the 'old model' I get the following "Internal error"
> org.eclipse.core.internal.resources.ResourceException: Problems encountered while deleting resources.
> at org.eclipse.core.internal.resources.Resource.delete(Resource.java:816)
> at org.eclipse.ltk.core.refactoring.resource.DeleteResourceChange.perform(DeleteResourceChange.java:168)
> at org.eclipse.ltk.core.refactoring.CompositeChange.perform(CompositeChange.java:278)
> at org.teiid.designer.ui.refactor.AbstractResourcesCompositeChange.perform(AbstractResourcesCompositeChange.java:64)
> at org.eclipse.ltk.core.refactoring.PerformChangeOperation$1.run(PerformChangeOperation.java:258)
> at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2345)
> at org.eclipse.ltk.core.refactoring.PerformChangeOperation.executeChange(PerformChangeOperation.java:306)
> at org.eclipse.ltk.internal.ui.refactoring.UIPerformChangeOperation.executeChange(UIPerformChangeOperation.java:92)
> at org.eclipse.ltk.core.refactoring.PerformChangeOperation.run(PerformChangeOperation.java:218)
> at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2345)
> at org.eclipse.ltk.internal.ui.refactoring.WorkbenchRunnableAdapter.run(WorkbenchRunnableAdapter.java:87)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
> Contains: Could not delete 'D:\tljohnst\workspace_JulyPOC\JulyPOC_AnnotationDB\views\test2.xmi'.
> org.eclipse.core.runtime.CoreException: Problems encountered while deleting files.
> at org.eclipse.core.internal.filesystem.local.LocalFile.delete(LocalFile.java:131)
> at org.eclipse.core.internal.resources.ResourceTree.internalDeleteFile(ResourceTree.java:304)
> at org.eclipse.core.internal.resources.ResourceTree.standardDeleteFile(ResourceTree.java:785)
> at org.eclipse.core.internal.resources.Resource.unprotectedDelete(Resource.java:1973)
> at org.eclipse.core.internal.resources.Resource.delete(Resource.java:803)
> at org.eclipse.ltk.core.refactoring.resource.DeleteResourceChange.perform(DeleteResourceChange.java:168)
> at org.eclipse.ltk.core.refactoring.CompositeChange.perform(CompositeChange.java:278)
> at org.teiid.designer.ui.refactor.AbstractResourcesCompositeChange.perform(AbstractResourcesCompositeChange.java:64)
> at org.eclipse.ltk.core.refactoring.PerformChangeOperation$1.run(PerformChangeOperation.java:258)
> at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2345)
> at org.eclipse.ltk.core.refactoring.PerformChangeOperation.executeChange(PerformChangeOperation.java:306)
> at org.eclipse.ltk.internal.ui.refactoring.UIPerformChangeOperation.executeChange(UIPerformChangeOperation.java:92)
> at org.eclipse.ltk.core.refactoring.PerformChangeOperation.run(PerformChangeOperation.java:218)
> at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2345)
> at org.eclipse.ltk.internal.ui.refactoring.WorkbenchRunnableAdapter.run(WorkbenchRunnableAdapter.java:87)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
> Contains: Could not delete: D:\tljohnst\workspace_JulyPOC\JulyPOC_AnnotationDB\views\test2.xmi.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIIDDES-2222) Verify Teiid version discovery with remote servers
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2222?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2222.
----------------------------------
> Verify Teiid version discovery with remote servers
> --------------------------------------------------
>
> Key: TEIIDDES-2222
> URL: https://issues.jboss.org/browse/TEIIDDES-2222
> Project: Teiid Designer
> Issue Type: Task
> Components: Teiid Integration
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Assignee: Paul Richardson
> Fix For: 9.0, 8.6.1, 9.0.1
>
>
> Description of problem from Jason Stokes below. Need to test teiid version discovery with remote servers.
> We had a problem connecting to a TEIID/DV 6.0 instance on Amazon AWS via Jboss Dev Studio. (Never fully figured out why.) So we FTP'd our VDB we created in Teiid designer 8.5 and deployed it via the Jboss console. I
> forget the error, but something about incompatible versions.
> For whatever reason, JB Dev studio 7.1.1 (with 8.5 teiid designer) was
> reporting that the TEIID version of the AWS server was 8.6, even though it
> was 8.4. (As far as I know, they didn't do anything different but install
> it.) So the consensus was there was a mismatch between the fact we created a TEIID 8.4 version VDB and were trying to deploy it on the AWS server. (The local server I was testing with reported the correct version of TEIID 8.4 in dev studio.) Technically both installs should have been the same version though (8.4) so not sure what was going on.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIIDDES-1979) Changes to a table's columns can result in role being reset for the entire model - 7.7.x
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1979?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-1979.
----------------------------------
This works in TD 10.0.2.Alpha1, so I am closing this (TD JIRA clean up)
> Changes to a table's columns can result in role being reset for the entire model - 7.7.x
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1979
> URL: https://issues.jboss.org/browse/TEIIDDES-1979
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 7.7, 8.2
> Reporter: Marc Shirley
> Assignee: Johnathon Lee
> Fix For: 8.3
>
>
> I have a model like below with a role defined to remove read privileges on 'column1a2' only.
> model1
> -> table1a
> ---> column1a1
> ---> column1a2
> -> table1b
> ---> column1b1
> ---> column1b2
> I adjust the model to rename 'column1b2' to 'uselessColumn':
> model1
> -> table1a
> ---> column1a1
> ---> column1a2
> -> table1b
> ---> column1b1
> ---> uselessColumn
> The role is reset and now has default read privileges defined across the entire model. I have to manually edit the role to reset it to the prior defined permissions.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2913.
------------------------------------
Resolution: Done
10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/22aef3e60f5caf14c...
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Assignee: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2913:
-----------------------------------
Fix Version/s: 10.0.2
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Assignee: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2913:
--------------------------------------
Assignee: Barry LaFond
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Assignee: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months