[JBoss JIRA] (TEIIDDES-2904) If server isn't configured before trying importing it causes issues
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2904?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2904.
----------------------------------
In this case (for flat file), create data source before preview works fine but when I have datasource for JDBC connection, a password isn't set. I closed this issue and I have created another issue [TEIIDDES-2951|https://issues.jboss.org/browse/TEIIDDES-2951] for JDBC case.
> If server isn't configured before trying importing it causes issues
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2904
> URL: https://issues.jboss.org/browse/TEIIDDES-2904
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Import/Export
> Affects Versions: 10.0.1
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Critical
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: preview-data-missing-datasources-dialog.png
>
>
> If the server isn't configured before doing a file import of a csv files issues will occur.
> In this case, sever was not configured upon start up. During the steps to import of the CSV file, it had the option to automatically create the data source enabled (but visually disabled). The JNDI name was filled. Finished importing and the source and view models were created.
> Started server and then tried previewing. This errors because the data source hasn't been created yet.
> I then created the data source.
> Then tried to do a data preview. But that failed. I then realized, if you do menu option "Set JNDI Name" it is blank. After retesting different scenarios, the JNDI name is set to blank if you use the Create Datasource option. So that how the JNDI got wiped clean. Once the JNDI name was reset, could then do a data preview.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2951:
--------------------------------------
Summary: Designer haven't set password to datasource which is created before preview.
Key: TEIIDDES-2951
URL: https://issues.jboss.org/browse/TEIIDDES-2951
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 10.0.2
Environment: Fedora 24
Reporter: Matej Kralik
Priority: Critical
Attachments: screenshot1.png, screenshot2.png
I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error:
{code:java}
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly.
{code}
I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource.
I deleted datasource.
When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine.
So I notice that datasource haven't set a password when DS is created before the preview.
I looked to standalone.xml
Datasource which is created before preview:
{code:java}
datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
<connection-url>connection url</connection-url>
<driver>sqljdbc4.jar</driver>
<security>
<user-name>books</user-name>
</security>
</datasource>
{code}
Datasource which is created in the import wizard:
{code:java}
<datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
<connection-url>connection url</connection-url>
<driver>sqljdbc4.jar</driver>
<security>
<user-name>books</user-name>
<password>**</password>
</security>
</datasource>
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2950) Exist data source is not overridden
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2950:
--------------------------------------
Summary: Exist data source is not overridden
Key: TEIIDDES-2950
URL: https://issues.jboss.org/browse/TEIIDDES-2950
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0.2
Environment: Fedora 24
Reporter: Matej Kralik
Attachments: screenshot.png
When a user creates datasource with a name which already exists, a user can click OK but this datasource won't be overridden. In the wizard is warning (screenshot) that "A Data Source with the name SQL_Server_2008_Books_DS already exists." but a user can click OK. A user can think that datasource was overridden.
This is confusing so I think that designer should show some warning that datasource will not be overridden or the OK button should be disabled.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2904) If server isn't configured before trying importing it causes issues
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2904?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2904:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.3 (was: )
> If server isn't configured before trying importing it causes issues
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2904
> URL: https://issues.jboss.org/browse/TEIIDDES-2904
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Import/Export
> Affects Versions: 10.0.1
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Critical
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: preview-data-missing-datasources-dialog.png
>
>
> If the server isn't configured before doing a file import of a csv files issues will occur.
> In this case, sever was not configured upon start up. During the steps to import of the CSV file, it had the option to automatically create the data source enabled (but visually disabled). The JNDI name was filled. Finished importing and the source and view models were created.
> Started server and then tried previewing. This errors because the data source hasn't been created yet.
> I then created the data source.
> Then tried to do a data preview. But that failed. I then realized, if you do menu option "Set JNDI Name" it is blank. After retesting different scenarios, the JNDI name is set to blank if you use the Create Datasource option. So that how the JNDI got wiped clean. Once the JNDI name was reset, could then do a data preview.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2913:
-----------------------------------
Labels: QueryParserException TEIID30386 TEIID31100 csv designer import jbds preview release_notes teiid verified_jbdsis-9.0.3 wildfly (was: QueryParserException TEIID30386 TEIID31100 csv designer import jbds preview teiid wildfly)
> 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, release_notes, teiid, verified_jbdsis-9.0.3, 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)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2913.
----------------------------------
> 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, release_notes, teiid, verified_jbdsis-9.0.3, 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)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2930) Dynamic VDB should contain full path to the materialized table
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2930?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2930:
----------------------------------------
I imported the attached project and had some issues with it. Re-set the project to start Materialization from the top View (deleted jdg-module, cache and vdb).
1) The materialized View is required to have a PK in order to create the POJO, I think
2) I've attached screen caps of the properties for the View's mat table and the primary table property on the generated ST_Customer table.
- both properties contain: 'CustomerMatCache.Customer'
> Dynamic VDB should contain full path to the materialized table
> --------------------------------------------------------------
>
> Key: TEIIDDES-2930
> URL: https://issues.jboss.org/browse/TEIIDDES-2930
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: customer-cache-table-info.png, customer-view-info.png, jdgCustomer.zip, screenshot1.png, screenshotProp.png
>
>
> I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error:
> TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model.
> I noticed that in the dynamicVDB in the CustomerViewMat model is:
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ...
> {code}
> I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache)
> When I set full path, vdb was deployed sucessfully
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ...
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2930) Dynamic VDB should contain full path to the materialized table
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2930?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2930:
-----------------------------------
Attachment: customer-view-info.png
customer-cache-table-info.png
> Dynamic VDB should contain full path to the materialized table
> --------------------------------------------------------------
>
> Key: TEIIDDES-2930
> URL: https://issues.jboss.org/browse/TEIIDDES-2930
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: customer-cache-table-info.png, customer-view-info.png, jdgCustomer.zip, screenshot1.png, screenshotProp.png
>
>
> I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error:
> TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model.
> I noticed that in the dynamicVDB in the CustomerViewMat model is:
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ...
> {code}
> I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache)
> When I set full path, vdb was deployed sucessfully
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ...
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months