October 2012 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1525) TeiidSQLException during preview data action

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-1525: -------------------------------------- Summary: TeiidSQLException during preview data action Key: TEIIDDES-1525 URL: https://issues.jboss.org/browse/TEIIDDES-1525 Project: Teiid Designer Issue Type: Feature Request Components: VDB & Execution Affects Versions: 8.0 Reporter: Barry LaFond Assignee: Barry LaFond Fix For: 8.0 Paul Nittel received a TeiidSQLException previewing a PartsSupplier DB -- 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, 6 months

1
2
0 / 0

[JBoss JIRA] (TEIIDDES-1509) Update Designer Source web pages

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-1509: -------------------------------------- Summary: Update Designer Source web pages Key: TEIIDDES-1509 URL: https://issues.jboss.org/browse/TEIIDDES-1509 Project: Teiid Designer Issue Type: Task Components: Documentation Affects Versions: 8.0 Reporter: Barry LaFond Priority: Critical Fix For: 8.0 Current Designer Source link reflects SVN repository. Needs to be converted to point to GIT HUB: https://github.com/Teiid-Designer/teiid-designer -- 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, 6 months

1
1
0 / 0

[JBoss JIRA] Created: (TEIIDDES-216) Designer removes parentheses around criteria in ansi join when using compound ON

by Marc Shirley (JIRA)

Designer removes parentheses around criteria in ansi join when using compound ON -------------------------------------------------------------------------------- Key: TEIIDDES-216 URL: https://jira.jboss.org/jira/browse/TEIIDDES-216 Project: Teiid Designer Issue Type: Bug Affects Versions: 6.1.0 Reporter: Marc Shirley In Designer, when validating a transformation that has compound criteria in an ansi join statement's ON, the parentheses are removed and the order of operations is modified as a result. This does not appear to occur when using the same parentheses structure in WHERE criteria. Before validation: SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON (a.INTKEY = b.INTKEY) AND (a.INTNUM IS NULL OR a.INTNUM = 11) After validation: SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON a.INTKEY = b.INTKEY AND (a.INTNUM IS NULL) OR (a.INTNUM = 11) After validating a second time: SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON ((a.INTKEY = b.INTKEY) AND (a.INTNUM IS NULL)) OR (a.INTNUM = 11) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 6 months

5
9
0 / 0

[JBoss JIRA] (TEIIDDES-1519) NPE In Preview Manager When Empty Model Project And No Teiid Server Defined

by Dan Florian (JIRA)

Dan Florian created TEIIDDES-1519: ------------------------------------- Summary: NPE In Preview Manager When Empty Model Project And No Teiid Server Defined Key: TEIIDDES-1519 URL: https://issues.jboss.org/browse/TEIIDDES-1519 Project: Teiid Designer Issue Type: Bug Components: Data Preview Affects Versions: 8.0 Environment: Eclipse 3.2.1, JBoss Tools 4.0.0.Alpha1, Designer 8.x-upgrade build 108, OS X 10.8.2, JBoss AS 7.1.1.Final, Teiid 8.2.0.Beta2 Reporter: Dan Florian Fix For: 8.0 I have a fresh Eclipse workspace with Designer perspective open. I have created a model project. The project is empty. Must've got the following error when I created the project. java.lang.NullPointerException at org.teiid.designer.runtime.preview.PreviewManager$1.done(PreviewManager.java:932) at org.eclipse.core.internal.jobs.JobListeners$3.notify(JobListeners.java:39) at org.eclipse.core.internal.jobs.JobListeners.doNotify(JobListeners.java:112) at org.eclipse.core.internal.jobs.JobListeners.done(JobListeners.java:152) at org.eclipse.core.internal.jobs.JobManager.endJob(JobManager.java:647) at org.eclipse.core.internal.jobs.WorkerPool.endJob(WorkerPool.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:70) -- 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, 6 months

2
2
0 / 0

[JBoss JIRA] (TEIIDDES-1483) Flat File importer unable to import files without extensions

by Marc Shirley (JIRA)

Marc Shirley created TEIIDDES-1483: -------------------------------------- Summary: Flat File importer unable to import files without extensions Key: TEIIDDES-1483 URL: https://issues.jboss.org/browse/TEIIDDES-1483 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.7.1 Reporter: Marc Shirley Assuming a data directory with two files, "mydata1" and "mydata2.csv", when attempting to import files with the flat file importer, only "mydata2.csv" will be discovered and selectable in the import process. It is not possible to discover/select files without extensions in the flat file importer. -- 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, 6 months

4
6
0 / 0

[JBoss JIRA] (TEIIDDES-1466) url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1466?page=com.atlassian.jira.plu... ] Johnathon Lee resolved TEIIDDES-1466. ------------------------------------- Fix Version/s: 7.7.2 Resolution: Done > url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0 > ------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1466 > URL: https://issues.jboss.org/browse/TEIIDDES-1466 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 7.7 > Environment: JBDS 5.0.1 with SOA-Tooling/EDS 5.3 > Reporter: Johnathon Lee > Assignee: Johnathon Lee > Fix For: 7.7.2 > > Attachments: sfdcTest.zip > > > The URL specified in the Salesforce connection profile in JBDS is not being written to the datasource when it is created from a JBDS action (either through preview functionality or Model->Create Datasource). > Data sources created from Teiid Designer perspective do not include the SFDC URL input by the user. In some cases this results in the user being unable to authenticate and run queries against the datasource (preview or standard VDB queries) if their user id does not authenticate against the default login.salesforce.com site URLs. Need to correct the datasource creation behavior to push down the URL into the datasource as well. > When creating the datasource using the Modelling->Create Data Source with the "Use Model Connection Info", the end result is the sfdcTest-ds.xml below: > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <connection-factories> > <no-tx-connection-factory> > <jndi-name>sfdcTest</jndi-name> > <rar-name>teiid-connector-salesforce.rar</rar-name> > <use-java-context>true</use-java-context> > <connection-definition>javax.resource.cci.ConnectionFactory</connection-definition> > <jmx-invoker-name>jboss:service=invoker,type=jrmp</jmx-invoker-name> > <min-pool-size>0</min-pool-size> > <max-pool-size>10</max-pool-size> > <blocking-timeout-millis>3000</blocking-timeout-millis> > <idle-timeout-minutes>30</idle-timeout-minutes> > <prefill>false</prefill> > <background-validation>false</background-validation> > <background-validation-millis>0</background-validation-millis> > <validate-on-match>true</validate-on-match> > <use-fast-fail>false</use-fast-fail> > <statistics-formatter>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter</statistics-formatter> > <isSameRM-override-value>false</isSameRM-override-value> > <allocation-retry>0</allocation-retry> > <allocation-retry-wait-millis>5000</allocation-retry-wait-millis> > <config-property type="java.lang.String" name="password">blahblahblah</config-property> > <config-property type="java.lang.String" name="template-name">connector-salesforce</config-property> > <config-property type="java.lang.String" name="username">mshirley.dev(a)redhat.com</config-property> > </no-tx-connection-factory> > </connection-factories> > We should see an additional property of the URL (probably should look like the below example) stating the URL value from the model. > <config-property type="java.lang.String" name="url">https://login.salesforce.com/services/Soap/u/25.0</config-property> > Same behavior occurs when creating a data source using the connection profile option instead of the model connection info. -- 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, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1466) url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1466?page=com.atlassian.jira.plu... ] Work on TEIIDDES-1466 started by Johnathon Lee. > url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0 > ------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1466 > URL: https://issues.jboss.org/browse/TEIIDDES-1466 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 7.7 > Environment: JBDS 5.0.1 with SOA-Tooling/EDS 5.3 > Reporter: Johnathon Lee > Assignee: Johnathon Lee > Attachments: sfdcTest.zip > > > The URL specified in the Salesforce connection profile in JBDS is not being written to the datasource when it is created from a JBDS action (either through preview functionality or Model->Create Datasource). > Data sources created from Teiid Designer perspective do not include the SFDC URL input by the user. In some cases this results in the user being unable to authenticate and run queries against the datasource (preview or standard VDB queries) if their user id does not authenticate against the default login.salesforce.com site URLs. Need to correct the datasource creation behavior to push down the URL into the datasource as well. > When creating the datasource using the Modelling->Create Data Source with the "Use Model Connection Info", the end result is the sfdcTest-ds.xml below: > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <connection-factories> > <no-tx-connection-factory> > <jndi-name>sfdcTest</jndi-name> > <rar-name>teiid-connector-salesforce.rar</rar-name> > <use-java-context>true</use-java-context> > <connection-definition>javax.resource.cci.ConnectionFactory</connection-definition> > <jmx-invoker-name>jboss:service=invoker,type=jrmp</jmx-invoker-name> > <min-pool-size>0</min-pool-size> > <max-pool-size>10</max-pool-size> > <blocking-timeout-millis>3000</blocking-timeout-millis> > <idle-timeout-minutes>30</idle-timeout-minutes> > <prefill>false</prefill> > <background-validation>false</background-validation> > <background-validation-millis>0</background-validation-millis> > <validate-on-match>true</validate-on-match> > <use-fast-fail>false</use-fast-fail> > <statistics-formatter>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter</statistics-formatter> > <isSameRM-override-value>false</isSameRM-override-value> > <allocation-retry>0</allocation-retry> > <allocation-retry-wait-millis>5000</allocation-retry-wait-millis> > <config-property type="java.lang.String" name="password">blahblahblah</config-property> > <config-property type="java.lang.String" name="template-name">connector-salesforce</config-property> > <config-property type="java.lang.String" name="username">mshirley.dev(a)redhat.com</config-property> > </no-tx-connection-factory> > </connection-factories> > We should see an additional property of the URL (probably should look like the below example) stating the URL value from the model. > <config-property type="java.lang.String" name="url">https://login.salesforce.com/services/Soap/u/25.0</config-property> > Same behavior occurs when creating a data source using the connection profile option instead of the model connection info. -- 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, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1511) Preview and VDB Deployment issues with Salesforce

by Mark Drilling (JIRA)

Mark Drilling created TEIIDDES-1511: --------------------------------------- Summary: Preview and VDB Deployment issues with Salesforce Key: TEIIDDES-1511 URL: https://issues.jboss.org/browse/TEIIDDES-1511 Project: Teiid Designer Issue Type: Bug Components: VDB & Execution Affects Versions: 8.0 Reporter: Mark Drilling Assignee: Mark Drilling Fix For: 8.0 Attempted to import and preview Salesforce data, then deploy a VDB with the Salesforce model. See steps to reproduce for errors encountered. -- 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, 6 months

1
2
0 / 0

[JBoss JIRA] (TEIIDDES-1517) WS procedure metadata should be updated

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1517?page=com.atlassian.jira.plu... ] Ted Jones updated TEIIDDES-1517: -------------------------------- Git Pull Request: https://github.com/Teiid-Designer/teiid-designer/pull/52 > WS procedure metadata should be updated > --------------------------------------- > > Key: TEIIDDES-1517 > URL: https://issues.jboss.org/browse/TEIIDDES-1517 > Project: Teiid Designer > Issue Type: Task > Components: Teiid Integration > Affects Versions: 8.0 > Reporter: Paul Richardson > Assignee: Ted Jones > Priority: Critical > Fix For: 8.0 > > > Using designer 8, I deploy the state service example models (found [here|https://github.com/phantomjinx/teiid-soap-example]) to an 8.2 beta1 teiid server. The models deploy successfully and the teiid connection in designer displays the catalog and stateService/stateServiceView schemas. > However, running the following query > {{exec stateServiceView.getAllStateInfo();}} > results in a generic TeiidException in designer's status view. > This exception comes from a NullPointerException that is displayed in the jboss server log. > The NPE has been fixed on the server side, but the Designer metadata for the ws procedures (invoke/invokeHttp) should be updated to include the optional streaming parameter. See also https://issues.jboss.org/browse/TEIID-2148 which introduced the initial regression on the Teiid side. -- 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, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1461) Elapsed Time in the JBoss developer studio shows incorrect timestamps

by Hisanobu Okuda (JIRA)

Hisanobu Okuda created TEIIDDES-1461: ---------------------------------------- Summary: Elapsed Time in the JBoss developer studio shows incorrect timestamps Key: TEIIDDES-1461 URL: https://issues.jboss.org/browse/TEIIDDES-1461 Project: Teiid Designer Issue Type: Bug Components: Data Preview Affects Versions: 7.4.2 Environment: JBDS 4.1.2 Reporter: Hisanobu Okuda When you run the query in the JBoss developer studio, it is NOT showing correct elapsed timestamp. For example, I know that it is taking more than 55 seconds for the below query when I run in the SQL Scrapbook window in the designer against VDB but it is showing as 0 hr, 0 min, 0 sec, 0 ms as shown below. select * from "Salesforce_Source"."salesforce"."RecordType" Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 7 months

6
7
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2012