October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3747) Deploying a .vdb where a dynamic vdb has already been deployed, fails due to duplicates

by Van Halbert (JIRA)

Van Halbert created TEIID-3747: ---------------------------------- Summary: Deploying a .vdb where a dynamic vdb has already been deployed, fails due to duplicates Key: TEIID-3747 URL: https://issues.jboss.org/browse/TEIID-3747 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.7.1.6_2 Reporter: Van Halbert Assignee: Steven Hawkins deployed a dynamic vdb using CLI: deploy teiidfiles/vdb/portfolio-vdb.xml then in Designer, tried to deploy the same named VDB, but as a .vdb and the deployment fails with errors indicating duplicate service: 11:26:31,301 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC000001: Failed to start service jboss.deployment.unit."Portfolio.vdb".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."Portfolio.vdb".INSTALL: JBAS018733: Failed to process phase INSTALL of deployment "Portfolio.vdb" at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:166) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55] Caused by: org.jboss.msc.service.DuplicateServiceException: Service jboss.teiid.ds-listener.Portfolio.1./accounts-ds is already registered at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1] -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3746) Add ETL functionality to Teiid

by Jérôme Fenal (JIRA)

[ https://issues.jboss.org/browse/TEIID-3746?page=com.atlassian.jira.plugin... ] Jérôme Fenal updated TEIID-3746: -------------------------------- Description: Teeid can offer schema discovery, schema creation, data massaging from one format to another, and handle writes. ETL is all about that: - Extract - Tranform - Load in batch mode. With the dawn of batch mode in JEE7, it could be interesting to add ETL functionality, possibly in the form of a continuous datamover, or a batch datamover, which could also be used in a complete database migration scenario. > Add ETL functionality to Teiid > ------------------------------ > > Key: TEIID-3746 > URL: https://issues.jboss.org/browse/TEIID-3746 > Project: Teiid > Issue Type: Feature Request > Reporter: Jérôme Fenal > Assignee: Steven Hawkins > > Teeid can offer schema discovery, schema creation, data massaging from one format to another, and handle writes. > ETL is all about that: > - Extract > - Tranform > - Load > in batch mode. > With the dawn of batch mode in JEE7, it could be interesting to add ETL functionality, possibly in the form of a continuous datamover, or a batch datamover, which could also be used in a complete database migration scenario. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3746) Add ETL functionality to Teiid

by Jérôme Fenal (JIRA)

Jérôme Fenal created TEIID-3746: ----------------------------------- Summary: Add ETL functionality to Teiid Key: TEIID-3746 URL: https://issues.jboss.org/browse/TEIID-3746 Project: Teiid Issue Type: Feature Request Reporter: Jérôme Fenal Assignee: Steven Hawkins -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3412) Change MS Access to use another client, since ODBC-JDBC bridge is removed in JDK 1.8

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3412. --------------------------------- > Change MS Access to use another client, since ODBC-JDBC bridge is removed in JDK 1.8 > ------------------------------------------------------------------------------------ > > Key: TEIID-3412 > URL: https://issues.jboss.org/browse/TEIID-3412 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Kylin Soong > Fix For: 8.7.1.6_2, 8.11 > > > In JDK 1.8, the ODBC-JDBC bridge is removed, so accessing MS Access using this method will not be available. > This may require a new translator, but won't be know until a deeper look is done. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3073) Tableau Connection Issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3073?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3073. --------------------------------- > Tableau Connection Issues > ------------------------- > > Key: TEIID-3073 > URL: https://issues.jboss.org/browse/TEIID-3073 > Project: Teiid > Issue Type: Bug > Components: ODBC, Server > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 8.10 > > Attachments: server.log, server.log, tablue-wireshark.pcapng > > > It has been reported that using Tableu with Teiid ODBC port show the following errors. These need to be investigated and fixed > {code} > This ODBC driver does not support important capabilities used by Tableau. > This unsupported function is required for relative date filters: The date part named 'week' for the date function: DATETRUNC(date_part, date, [start_of_week]) > ----- > Tableau identified the following warnings for the ODBC data source named 'streamyx_sales (streamyx_sales.streamyx_sales) (TMJDV)': > This aggregation is unsupported: Attribute > This aggregation is unsupported: Std. Dev > This aggregation is unsupported: Std. Dev (Pop.) > This aggregation is unsupported: Trunc Week Number > This aggregation is unsupported: Variance > This aggregation is unsupported: Variance (Pop.) > This function is unsupported: % with parameter types 'integer, integer' > This function is unsupported: ABS(number) with parameter types 'float' > This function is unsupported: ABS(number) with parameter types 'integer' > This function is unsupported: ACOS(number) with parameter types 'float' > This function is unsupported: ASCII(string) with parameter types 'string' > This function is unsupported: ASIN(number) with parameter types 'float' > This function is unsupported: ATAN(number) with parameter types 'float' > This function is unsupported: ATAN2(y number, x number) with parameter types 'float, float' > This function is unsupported: CHAR(integer) with parameter types 'float' > This function is unsupported: CHAR(integer) with parameter types 'integer' > This function is unsupported: COS(angle) with parameter types 'float' > This function is unsupported: COT(angle) with parameter types 'float' > This function is unsupported: DATEPART_DAYOFWEEK_INTERNAL with parameter types 'date' > This function is unsupported: DATEPART_WEEK_INTERNAL with parameter types 'date' > This function is unsupported: DATETIME with parameter types 'integer' > This function is unsupported: DEGREES(number) with parameter types 'float' > This function is unsupported: EXP(number) with parameter types 'float' > This function is unsupported: LN with parameter types 'float' > This function is unsupported: LN(number) with parameter types 'float' > This function is unsupported: LOG with parameter types 'float' > This function is unsupported: LOG(number, [base]) with parameter types 'float' > This function is unsupported: PI() > This function is unsupported: POWER with parameter types 'float, integer' > This function is unsupported: POWER with parameter types 'integer, integer' > This function is unsupported: POWER(number,power) with parameter types 'float, integer' > This function is unsupported: POWER(number,power) with parameter types 'integer, integer' > This function is unsupported: RADIANS(number) with parameter types 'float' > This function is unsupported: ROUND(number, [decimals]) with parameter types 'float' > This function is unsupported: ROUND(number, [decimals]) with parameter types 'float, integer' > This function is unsupported: SIGN(number) with parameter types 'float' > This function is unsupported: SIN(angle) with parameter types 'float' > This function is unsupported: SPACE with parameter types 'float' > This function is unsupported: SPACE(number) with parameter types 'integer' > This function is unsupported: SQRT(number) with parameter types 'float' > This function is unsupported: SQUARE with parameter types 'float' > This function is unsupported: TAN(angle) with parameter types 'float' > This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week]) > This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week]) > This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week]) > This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week]) > This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week]) > This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week]) > This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week]) > This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week]) > This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week]) > This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week]) > This is unsupported: SELECT ... INTO > This is unsupported: Temporary tables > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3434) Ability to enable/disable caching by table and/or source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3434?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3434. --------------------------------- > Ability to enable/disable caching by table and/or source > -------------------------------------------------------- > > Key: TEIID-3434 > URL: https://issues.jboss.org/browse/TEIID-3434 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Burak Serdar > Assignee: Steven Hawkins > Fix For: 8.11 > > > We need to be able to enable/disable caching by table and/or source. Some of our tables have real-time data, and we do not want to cache those, and some other tables can use cached data. It is not sufficient to use SQL options to turn caching on or off, because we're using 3rd party tools, and we don't have control over the SQL they generate. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3455) Improve salesforce importing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3455?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3455. --------------------------------- > Improve salesforce importing > ---------------------------- > > Key: TEIID-3455 > URL: https://issues.jboss.org/browse/TEIID-3455 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > In working TEIID-3429 we should improve the saleforce logic to not pull table metadata a single table at a time. The sf api can describe up to 100 objects at a time. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3392) cached result set with lobs reports incorrect row number

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3392?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3392. --------------------------------- > cached result set with lobs reports incorrect row number > -------------------------------------------------------- > > Key: TEIID-3392 > URL: https://issues.jboss.org/browse/TEIID-3392 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.11 > > > Using the cached result when a lob is part of the result will only report rows up to the beginning of the last batch. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3364) Teiid Embedded generic-soap run failed

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3364?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3364. --------------------------------- > Teiid Embedded generic-soap run failed > -------------------------------------- > > Key: TEIID-3364 > URL: https://issues.jboss.org/browse/TEIID-3364 > Project: Teiid > Issue Type: Enhancement > Components: Embedded > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.11 > > > I test the 8.10 embedded-dist zip download, the generic-soap run failed with Connection reset exception. > On the other sides, can we add more samples for teiid embedded mode? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3456) NPE with excluded tables and the salesforce importer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3456?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3456. --------------------------------- > NPE with excluded tables and the salesforce importer > ---------------------------------------------------- > > Key: TEIID-3456 > URL: https://issues.jboss.org/browse/TEIID-3456 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.10 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > If a child table is excluded from import a null pointer exception will occur when we process the relationship information. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2015